Finance AFQ -- Medical School Annual UW Expenses

This app compares Period Summary Star Fact data between WISER and ADW for the Annual AAMC survey.

Internal

Melissa Chan

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

Data come from AADW and WISDM:

FINANCE_QVDs_AADW/MS_PERIOD_SUM_FACT_VW.QVD
FINANCE_QVDs_AADW/SFS_CHARTFIELDS_VW.QVD
FINANCE_QVDs_AADW/MS_ACCOUNT_VW.QVD
FINANCE_QVDs_AADW/MS_FUND_CHAR_VW.QVD
FINANCE_QVDs_AADW/MS_DEPT_ROLLUP_VW.QVD

FINANCE_QVDs_WISDM/PERIOD_SUMMARY_STAR_FACT.QVD
FINANCE_QVDs_WISDM/ACCOUNT_DIMENSION.QVD
FINANCE_QVDs_WISDM/ACCOUNTING_PERIOD_DIMENSION.QVD
FINANCE_QVDs_WISDM/DEPARTMENT_DIMENSION.QVD
FINANCE_QVDs_WISDM/FUND_DIMENSION.QVD
FINANCE_QVDs_WISDM/PROJECT_DIMENSION.QVD
FINANCE_QVDs_WISDM/PROJECT_DIM_KEY_0.QVD

Annually at fiscal year close

ADW Totals for AFQ:
uwhc sales cr: Displays 'UWHC SC' for Sales Credits and when Source of Funds Cd is 60.
fund 128 sales cr: Displays 'UWHC SC' for Fund 128 and Sales Credits.
school: Displays the following categories:
     '0. Regular funds 101' for Fund 101 with no project ID
     '1. Sch 233' for projects PRJ56JW and PRJ56SA
     '2. DFM 101' for PRJ61XH
See WISER Glossary

ADW Data Includes:
- Expense and sales credit accounts
- SMPH, VCRGE Medical School 3453 and Medical School Div of Continuing Studies 9353
- Most recently completed FY

WISER Data Includes:
- Expense and sales credit accounts
- SMPH, Medical School VCRGE 3453, Medical School Div of Continuing Studies 9353, and Medical School Continuing Med Univ Outreach 8653
- Most recently completed FY
- Project_Dimension.Project_Key=0

WISER Data Excludes:
- Asset and Liability account types
- Reserves for Encumbrances account 8120
- Period 0 (if applicable)