Finance AFQ -- Data for AFQ Rows Labeled Preliminary

https://dataviz.med.wisc.edu/sense/app/b734aaee-44dd-4a89-93b9-6888c03f1c3d/overview

Date Published:

Published In:

 

Finance AFQ

Brief Description

This app attaches AFQ variables to Project data from Netezza which other AFQ Qlik apps are dependent upon. Data includes a list of projects and their sponsors, funds, IF source of fund code, and revenue and expenses.

Data Classification

Internal

Developer

Melissa Chan

Primary Audience

SMPH Fiscal Affairs Accountant. This app is open to employees in 530230.

Data Sources

Data comes from the ADW:
FINANCE_QVDs_AADW/AFQ_UW_REV_EXP_TB1.QVD
FINANCE_QVDs_AADW/AFQ_SRC_OF_FUND_SUM_TB.QVD
FINANCE_QVDs_AADW/AFQ_CME_TB.QVD
FINANCE_QVDs_AADW/AFQ_SPONSOR_TYPE_SUM_TB.QVD
FINANCE_QVDs_AADW/AFQ_PROJ_UW_TYPE_SUM_TB.QVD
FINANCE_QVDs_AADW/AFQ_EXCLUDE_TB.QVD

Data Load Schedule

Annually at fiscal year close

Definitions

Src of Fund Sum: Summary source of fund used for AFQ
Include in AFQ: Indicates if a fund/project/control_dept should be in the AFQ. In a later step, afq_exclude_tb is reviewed and modified as necessary.
Project UW Type Sum: A summary code of the UW Project Type used for the AFQ
Sponsor Type Sum: A summary code of the Sponsor Type Code used for the AFQ
CME: Continuing Medical Education flag
See WISER Glossary

Plans for Future Development


Additional Notes

This app is dependent upon AFQ_UW_REV_EXP_TB1 which is updated by the developer.

  • No labels