The following contains a list of GEMS tables from the data warehouse and their closest equivalent match to an Oracle HCM table. These can each be joined to other Oracle HCM tables as required for reporting purposes.
DWHOUSE table | Oracle HCM Table Mapping | SQL statement |
---|---|---|
GEMS_PS_CURRENT_PRIMARY_JOB | hcm.GlobalPersonPVOViewAll | select * from [hcm].[GlobalPersonPVOViewAll] |
GEMS_PS_HR_ACCTG_LINE | Pending mapping in crosswalk | |
GEMS_PS_PER_ORG_ASGN | Pending mapping in crosswalk | |
GEMS_PS_SUPVSR_LVL_TBL | select distinct DESC_SUPERVISORY_LEVEL_, SUPERVISORY_LEVEL_ | |
GEMS_PS_U_PAYPERIOD_TBL | select TIMEPERIODPEOPERIODNAME, TIMEPERIODPEOSTARTDATE, TIMEPERIODPEOENDDATE, TIMEPERIODPEODEFAULTPAYDATE, PROCESSSUBDATE |