PY_MOD_CNFRM_VW

(SQL View)
 Index Back

Pay Mod Empl Confirmed Checks

Paycheck Modeling employees with confirmed checks view

SELECT DISTINCT COMPANY , PAYGROUP , EMPLID , EMPL_RCD FROM PS_PAY_EARNINGS WHERE SINGLE_CHECK_USE IN ('N','C') AND PAY_LINE_STATUS = 'F'

  • Parent record: PAY_LINE

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record