PY_WC_PYGRP_VW

(SQL View)
 Index Back

Paygroup

Paygroup descriptions. Search record for WorkCenter paygroup setup.

SELECT DISTINCT A.COMPANY , A.PAYGROUP , B.DESCR FROM PS_PY_WC_PAYGRP A , PS_PAYGROUP_TBL B WHERE B.COMPANY = A.COMPANY AND B.PAYGROUP = A.PAYGROUP 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)

  • Related Language Record: PY_WC_PYGRP_VWL

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

    Prompt Table: COMP_WC_VW

    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PY_PAYGROUP_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description