Effort Reporting Tables in Human Resource Data Warhouse

You may have noticed many new tables have been added to the Human Resource Data Warehouse that begin with PS_ER or PS_ASU_ER. These tables contain Effort Reporting data. Following the standard table naming convention, the PS_ tables are delivered PeopleSoft tables and the tables beginning with PS_ASU are custom ASU developed tables.

EPM Release Notes: 9.0.30

New tables:

• PS_PERS_INST_REL


• PS_ASU_ADM_RES_TBL


• PS_ASU_AI0008_CTVW


• PS_ASU_AI0008_V1


• PS_ASU_AI0008_V2

Changed tables:

• PS_ASU_AI0008_REQ: added ASU_REQ_CRSE_ID to table and primary key