Brief Description | This app provides Trust Fund data (funds 161 and 162) for the current and prior 10 fiscal yearsindirect cost data that serves as a basis for allocating indirect costs per SMPH department for the upcoming fiscal year. | |
Data Classification | Internal | |
Developer | Melissa Chan | |
Primary Audience | SMPH Fiscal Affairs Accountant. This app is available to SMPH division administrators, SMPH directors, department and administrative employees, SMPH finance jobs, and SMPH research and sponsored groups. | |
Data Sources | Data comes from WISDM, ADW, and an Excel docWISER: | |
Data Load Schedule | Fourth business day after of each quarter: 11/04/2022.....07/07/2023 | |
Definitions | Definitions | Estimated Annual Income - Equals 4.0% of the Fund Balance in Fund 162. |
Plans for Future Development | Add charts that embed data manipulation done by Fiscal Affairs in Excel | |
Additional Notes | Data defaults to the most recently completed fiscal year. Data includes: Descriptions of each sheet: Trust Balances: Raw data export App dependent on adding new Trust projects to ADW |
Page History
Overview
Content Tools