PAY_INS_EARNS_V

(SQL View)
 Index Back

CAN UI Insurable Earnings View

This record contains detail unemployement insurable earnings information for Canadian Payroll.

SELECT DISTINCT A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.EARNS_END_DT ,B.EI_PRIOR_PD_CORR FROM PS_PAY_INS_EARNS A, PS_PAY_EARNINGS B WHERE A.COMPANY=B.COMPANY AND A.PAYGROUP=B.PAYGROUP AND A.PAY_END_DT=B.PAY_END_DT AND A.OFF_CYCLE=B.OFF_CYCLE AND A.PAGE_NUM=B.PAGE_NUM AND A.LINE_NUM=B.LINE_NUM AND A.SEPCHK=B.SEPCHK AND A.EARNS_END_DT<>A.PAY_END_DT AND B.EARNS_END_DT<=A.EARNS_END_DT AND B.EI_PRIOR_PD_CORR='Y'

  • Parent record: PAY_CHECK

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

    4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    5 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
    6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
    7 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
    8 EARNS_END_DT Date(10) DATE NOT NULL Earnings End Date
    9 EI_PRIOR_PD_CORR Character(1) VARCHAR2(1) NOT NULL EI Prior Period Correction

    Y/N Table Edit

    Default Value: N