You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
Version 1
Next »
Brief Description | This app compares Period Summary Star Fact data between WISER and ADW for the Annual AAMC survey. |
Data Classification | |
Developer | |
Primary Audience | SMPH Fiscal Affairs Accountant. This app is open to employees in 530230. |
Data Sources | 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 |
Data Load Schedule | Annually at fiscal year close |
Definitions | 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 |
Plans for Future Development | |
Additional Notes | 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 WISER Data Excludes: - Asset and Liability account types - Reserves for Encumbrances account 8120 - Period 0 (if applicable) |