Brief Description | This app summarizes budget, expense, and balances for the Graduate Consortium in the current fiscal year. |
Data Classification | Internal |
Developer | Melissa Chan |
Primary Audience | Individuals identified by Darlene Wood |
Data Sources | FINANCE_QVDs_WISDM: GL_STAR_FACT (for non payroll), PAYROLL_STAR_FACT (for payroll), ACCOUNT_DIMENSION,DATE_DIMENSION, DEPARTMENT_DIMENSION, EMPLOYEE_HISTORY_DIMENSION, JOURNAL_REFERENCE_DIMENSION, PROJECTS; FINANCE_QVDs_AADW: WAWR_SFS_PROJECTS_TB |
Data Load Schedule | Daily |
Definitions | Available Directs Balance: Equals the grant/contract direct cost budget estimated at the time of the grant award minus actual direct expenses. Does not include indirect budget or expenses. This will be different than the Balance amount if an award has both a direct and indirect budget. WISER can show the calculation details to support this amount. Balance: Equals total budget minus total expenses minus total encumbrances. Budget: Equals total budget loaded into Wiser for grants. The timing a budget is loaded is when the grant award notification is received by the Research and Programs Office. The amount may be different to the total expected award due to timing differences and contingencies that need to be met (IRB approval, etc.). Budgets for fund 136 projects include beginning fund balance, current revenue, and sales credits. Budgets for fund 233 projects include revenue and sales credits. Expenses: Equals total transactions posted to the periods selected. |
Plans for Future Development | |
Additional Notes | This app contains data for the following project departments: |
Overview
Content Tools