Brief Description | This app provides Trust Fund data (funds 161 and 162) for the current and prior 10 fiscal years. |
Data Classification | |
Developer | |
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 doc Excel doc: Trust Rev Acct Rollups FINANCE_QVDs_WISDM/PERIOD_SUMMARY_STAR_FACT.QVD FINANCE_QVDs_WISDM/PROJECTS_DIMENSION.QVD FINANCE_QVDs_WISDM/FUND_DIMENSION.QVD FINANCE_QVDs_WISDM/ACCOUNT_DIMENSION.QVD FINANCE_QVDs_WISDM/ACCOUNTING_PERIOD_DIMENSION.QVD FINANCE_QVDs_AADW/trust_erc.QVD |
Data Load Schedule | Fourth business day after each quarter: July 7, 2022 October 6, 2022 January 6, 2023 April 6, 2023 July 7, 2023 October 5, 2023 January 5, 2024 |
Definitions | Estimated Annual Income - Equals 4.0% of the Fund Balance in Fund 162. See WISER Glossary |
Plans for Future Development | |
Additional Notes | Descriptions of each sheet: Trust Balances: Raw data export Net Assets for SMPH AFQ: Used by Fiscal Affairs for Annual AFQ Survey Trust Balances and Availability: Trust projects balances by endowment type and cash available. Permanently restricted endowments cannot be spent, Temporary Endowments could be spent and Available is cash that can be spent. Project Funds: Fund balances by Project. Estimated Annual Income: 4.0% estimated annual income in Fund 162. App dependent on adding new Trust projects to ADW Includes funds 161 Endowment Trust Fund Income and 162 Endowment Trust Fund Operation for Division 53 Excludes reserves for encumbrances (account 8120) Be mindful of the Fiscal Year filter which resets to the most current FY when navigating to the Trust Balances sheet Data may lag behind WISDM by 1-2 days depending on database refresh times |