PAY_OL_PG_CN_VW

(SQL View)
 Index Back

SrchRec Online Cheque-Canada

This is the search record for the online cheque panels for Canada. The user is presented with a different search record- PAY_OL_CAN_SRCH. Peoplecode processing within PAY_OL_CAN_SRCH causes a transfer to this search record.

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.SINGLE_CHECK_USE IN ('N','P') and A.COMPANY=C.COMPANY and A.PAYGROUP=C.PAYGROUP and C.COUNTRY='CAN'

  • 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: Y

    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