Finance AFQ -- Fund 131 for Tuition Analysis

https://dataviz.med.wisc.edu/sense/app/274f4d8e-2456-47cb-a656-1be8280b28ea/overview

Date Published:

Published In:

 

Finance AFQ

Brief Description

This app provides fund 131 data for the Annual AAMC survey. When combined with campus data, this data serves to reconcile tuition expenses.

Data Classification

Internal

Developer

Melissa Chan

Primary Audience

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

Data Sources

WISDM tables:
FINANCE_QVDs_WISDM/GL_STAR_FACT.QVD
FINANCE_QVDs_WISDM/CHARTFIELD_DIMENSION.QVD
FINANCE_QVDs_WISDM/ACCOUNT_DIMENSION.QVD
FINANCE_QVDs_WISDM/SPONSORS.QVD
FINANCE_QVDs_WISDM/DEPARTMENT_DIMENSION.QVD
FINANCE_QVDs_WISDM/PROJECTS.QVD

Data Load Schedule

Annually at fiscal year close

Definitions

Account 3930: Indicates 3930 accounts.
Account Type Mod: Indicates 'R' for accounts beginning with 9 except for Sales Credits beginning with 905 or 906 ('E'). Indicates 'E' for all else.
Adjusted Amount: Equals the transaction amount except for DeptID 5349 where it equals 60% of the transaction amount.
Ctl Dept: Provides the DeptID for fund-orgs.
UW0: Equals the project fund code. For fund-orgs, this equals the Chartfield Dimension fund code.
See WISER Glossary

Plans for Future Development


Additional Notes

This app includes data for:
- Fund 131 Academic Student Fees (tuition)
- SMPH Divisions 53 & 55, and Div of Continuing Studies 9353
- Two most recently completed fiscal years

  • No labels