PYGRP_EMPTYP_VW

(SQL View)
 Index Back

Paygroup Employee Types

The view identifies the valid employee types for each paygroup.

SELECT A.COMPANY ,A.PAYGROUP ,A.EFFDT ,A.EMPL_TYPE ,B.XLATLONGNAME FROM PS_PAYGRP_EMPLTYPE A , PS_EMPL_TYPE_VW B WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_PAYGRP_EMPLTYPE A1 WHERE A1.COMPANY = A.COMPANY AND A1.PAYGROUP = A.PAYGROUP AND A1.EFFDT <= A.EFFDT AND A1.EMPL_TYPE = A.EMPL_TYPE) AND B.FIELDVALUE = A.EMPL_TYPE AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_EMPL_TYPE_VW B1 WHERE B1.FIELDVALUE = B.FIELDVALUE AND B1.EFFDT <= A.EFFDT)

  • Related Language Record: PYGRP_EMPTYPLNG

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

    Prompt Table: COMPANY_TBL

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

    Prompt Table: PAYGROUP_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried

    Prompt Table: EMPL_TYPE_VW

    5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name