PAY_CHECK_VCAN

(SQL View)
 Index Back

CAN Pay Check view

This view contains employee paycheck key information for Canadian payroll.

SELECT A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.FORM_ID ,A.PAYCHECK_NBR ,A.EMPLID ,A.NAME FROM PS_PAY_CHECK A ,PS_PAY_EARNINGS B ,PS_PAYGROUP_TBL C 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 B.PAY_LINE_STATUS IN ('C','F','V') AND A.COMPANY=C.COMPANY AND A.PAYGROUP=C.PAYGROUP AND C.COUNTRY='CAN'

  • Parent record: PAY_LINE

    • # 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(5,0) INTEGER NOT NULL Page Nbr

    Prompt Table: PAY_PAGE

    6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr

    Prompt Table: PAY_LINE

    7 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    8 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification
    9 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
    10 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    11 NAME Character(50) VARCHAR2(50) NOT NULL Name