« HRMS Job and Position Tables | Main | FS_C_COA_MAP_TBL »

Data Warehouse Table Updates

Updates to the tables scheduled to convert over the weekend of June 14th and 15th within the Data Warehouse are complete.


Updates to the following tables have been completed:
PS_DWPY_VAC_SICK
PS_DWHR_COMP_PROP
PS_DWHR_DEMO_ADDR
PS_DWHR_JOB
PS_DWHR_JOB_HIST
PS_DWHR_POSITION_DATA
PS_DWHR_EMP_REVIEW
PS_DWHR_TRAINEE
DWPA_POSTING
PS_DWPY_DIST - this table contains rows starting with fiscal year 2009

Tables refreshed either for the last time or until fall:
PS_DWPY_FRNG_DETAIL_08 - new table for fiscal year 09 will be created on 6/30
PS_DWEO_PERSON_PRIM_JOB - Next refresh with updates scheduled for August
PS_DWEO_PERSON_SEC_JOB - Next refresh with updates scheduled for August
PS_DWEO_PERSON_PRIM_JOB_HS - Next refresh with updates scheduled for October
PS_DWEO_PERSON_SEC_JOB_HS - Next refresh with updates scheduled for October

New tables:
PS_DWPY_DIST_HS - contains rows for fiscal years through 2008
PS_DW_DEPTID_FISCAL_TREE - Financial roll-up information
PS_DW_DEPTID_REPORT_TREE - This table creates two levels (college_admin_unit, vp_admin_unit) for reporting across campuses
PS_UM_DEPT_TREE_HIST - Contains historical versions of the PS_UM_DEPT_TREE
PS_VALID_COMBO_TBL - PeopleSoft table

New Lookup Tables:
FS_PS_GL_ACCOUNT_TBL
FS_PS_FUND_TBL
FS_PS_DEPT_TBL
FS_PS_PROJECT
FS_PS_PROGRAM_TBL
FS_PS_CHARTFIELD1_TBL
FS_PS_CHARTFIELD2_TBL
FS_PS_CF_ATTRIB_TBL

Note on new lookup tables: Because tables with the same name exist in both the new financial system and the hr/payroll/student system, for example PS_DEPT_TBL, tables from the financial system have been given an extra prefix of 'FS_'. These lookup tables are available within the Data Warehouse for use as lookup tables.