...
DWHOUSE table | Oracle HCM Table Mapping | SQL statement |
---|---|---|
GEMS_PS_CURRENT_PRIMARY_JOB | 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 |
...