PAY_LN_CANCO_VW

(SQL View)
 Index Back

U.S. Pay Line View

This record is used by Payroll to view Pay Line data.

SELECT DISTINCT A.COMPANY FROM PS_PAY_LINE 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_PAGE

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