Page Comparison

GEMS_PS_CURRENT_PRIMARY_JOB 

hcm.GlobalPersonPVOViewAll

select * from [hcm].[GlobalPersonPVOViewAll]
where ASSIGNMENTPEOPRIMARYASSIGNMENTFLAG = 'Y'
and ASSIGNMENTPEOEFFECTIVEENDDATE = '4712-12-31'
and POSITIONPEOPOSITIONCODE is not null

GEMS_PS_HR_ACCTG_LINE 

Pending mapping in crosswalk

GEMS_PS_PER_ORG_ASGN

Pending mapping in crosswalk

GEMS_PS_SUPVSR_LVL_TBL 

hcm.FlexBIPositionCustomerFlexVI

select distinct DESC_SUPERVISORY_LEVEL_, SUPERVISORY_LEVEL_
FROM [hcm].[FlexBIPositionCustomerFlexVI]
order by SUPERVISORY_LEVEL_

GEMS_PS_U_PAYPERIOD_TBL

hcm.TimePeriodPVO

select TIMEPERIODPEOPERIODNAME, TIMEPERIODPEOSTARTDATE, TIMEPERIODPEOENDDATE, TIMEPERIODPEODEFAULTPAYDATE, PROCESSSUBDATE
FROM [hcm].[TimePeriodPVO]
where PROCESSSUBDATE IS NOT NULL
order by TIMEPERIODPEOSTARTDATE