ZZ_PAY_ACCT_CAN

(SQL View)
 Index Back

CAN Payroll Acct Cd Vw- Secuty

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 ,B.OPRID ,A.EMPLID ,A.ACCT_CD ,A.NAME ,A.SINGLE_CHECK_USE FROM PS_PAY_ACCT_WCAN A ,PS_PERS_SRCH_GBL B WHERE A.EMPLID = B.EMPLID

  • 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    9 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
    10 NAME Character(50) VARCHAR2(50) NOT NULL Name
    11 SINGLE_CHECK_USE Character(1) VARCHAR2(1) NOT NULL How is Single Check Used
    C=Check Only
    N=Not Applicable
    P=Paysheet Only