PAY_ACCT_WCAN

(SQL View)
 Index Back

CAN Payroll Acct Cd View

This view is used as a search record for Pay Line Earnings for Canadian payroll.

SELECT A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.EMPLID ,B.ACCT_CD ,A.NAME ,A.SINGLE_CHECK_USE ,B.BUSINESS_UNIT FROM PS_PAY_LINE A ,PS_PAY_EARNINGS B ,PS_PAYGROUP_TBL C WHERE A.CONFIRMED='N' AND A.SINGLE_CHECK_USE IN ('N', 'P') AND A.COMPANY=C.COMPANY AND A.PAYGROUP=C.PAYGROUP AND C.COUNTRY='CAN' AND 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

  • Parent record: PAY_PAGE

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

    Prompt Table: PAY_LN_CANCO_VW

    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
    4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    Default Value: N

    5 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
    6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    8 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
    9 NAME Character(50) VARCHAR2(50) NOT NULL Name
    10 SINGLE_CHECK_USE Character(1) VARCHAR2(1) NOT NULL How is Single Check Used
    C=Check Only
    N=Not Applicable
    P=Paysheet Only
    11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR