PY_PE_PYCHK_VW

(SQL View)
 Index Back

Pay Check

This is the summary record that contains the result of the payroll confirmation process.

SELECT A.EMPLID ,A.PAY_END_DT ,A.COMPANY ,A.PAYGROUP ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.EMPL_RCD ,A.PAYCHECK_NBR ,A.NET_PAY ,A.CHECK_DT FROM PS_PAY_CHECK A WHERE A.PAYCHECK_STATUS = 'F' AND A.PAYCHECK_OPTION <> 'R'

  • Parent record: PAY_LINE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

    3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: PAYGROUP_TBL

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

    Y/N Table Edit

    6 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr

    Prompt Table: PAY_PAGE

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

    Prompt Table: PAY_LINE

    8 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    9 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    10 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
    11 NET_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Net Pay
    12 CHECK_DT Date(10) DATE Check date.