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. Please list briefly, and include a note about who else has access to the app. If the content is filtered depending on who is viewing it, include that also. |
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. |