PAY_PAGE_WORKC

(SQL View)
 Index Back

Pay Page View

This view is used to access payroll page information.

SELECT A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.SINGLE_CHECK_USE FROM PS_PAY_PAGE A ,PS_PAYGROUP_TBL C WHERE A.CONFIRMED='N' AND A.COMPANY=C.COMPANY AND A.PAYGROUP=C.PAYGROUP AND C.EFFDT = ( SELECT MAX(P.EFFDT) FROM PS_PAYGROUP_TBL P WHERE P.COMPANY = A.COMPANY AND P.PAYGROUP = A.PAYGROUP ) AND EXISTS ( SELECT 'X' FROM PS_PAY_LINE B , PS_PAY_EARNINGS D 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 D.COMPANY = B.COMPANY AND D.PAYGROUP = B.PAYGROUP AND D.PAY_END_DT = B.PAY_END_DT AND D.OFF_CYCLE = B.OFF_CYCLE AND D.PAGE_NUM = B.PAGE_NUM AND D.LINE_NUM = B.LINE_NUM AND (B.SINGLE_CHECK_USE = 'N' OR B.SINGLE_CHECK_USE = 'C'))

  • Parent record: PAY_CALENDAR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    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

    Default Value: N

    5 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
    6 SINGLE_CHECK_USE Character(1) VARCHAR2(1) NOT NULL How is Single Check Used
    C=Check Only
    N=Not Applicable
    P=Paysheet Only