PY_MOD_PGRDS_VW

(SQL View)
 Index Back

Paygroup

Paygroup descriptions

SELECT DISTINCT A.COMPANY , B.PAYGROUP , B.DESCR FROM PS_PY_MOD_COMPNY A , PS_PAYGROUP_TBL B WHERE B.COMPANY = A.COMPANY AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_PAYGROUP_TBL B_ED WHERE B.COMPANY = B_ED.COMPANY AND B.PAYGROUP = B_ED.PAYGROUP AND B_ED.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A'

  • Related Language Record: PY_MOD_PGRDSLVW

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description