| Brief Description | This app provides expense transaction details for Principal Investigators that have had a project in a subset of Financial Shared Services departments. |
| Data Classification | Internal |
| Developer | Melissa Chan |
| Primary Audience | The SMPH Fiscal Affairs Accountant pulls data from the app for Department Administrators, Financial Specialists, and PIs. Those with access to the Finance Stream can view the app. |
| Data Sources | FINANCE_QVDs_WISDM: GL_STAR_FACT (non payroll), PAYROLL_STAR_FACT (payroll), ACCOUNT_DIMENSION, DATE_DIMENSION, DEPARTMENT_DIMENSION, EMPLOYEE_HISTORY_DIMENSION, JOURNAL_REFERENCE_DIMENSION, PROJECTS FINANCE_QVDs_AADW: WAWR_SFS_PROJECTS_TB |
| Data Load Schedule | Sundays |
| Definitions | PI Department - One of the 5 Financial Shared Services departments. This is the department where a Principal Investigators has had at least one project. Account Category - This is WISER's Account Description originating from ACCOUNT_TREE_ANC_VW.ANCESTOR_DESCR. |
| Plans for Future Development | |
| Additional Notes | This app includes current and previous fiscal year data. For year-end processes this app continues to show these fiscal years until August 15th, at which time the app switches to the next set of fiscal years. |
Overview
Content Tools