PSHUP_IN_ST_VW

(SQL View)
 Index Back

Inactive employee status

This view retrieves all the inactive employee status used in the PSHUP Inactive Employee project

SELECT A.FIELDVALUE , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'EMPL_STATUS' AND A.FIELDVALUE <> 'A' AND A.FIELDVALUE <> 'P' AND A.FIELDVALUE <> 'Q' AND A.FIELDVALUE <> 'U' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE B.FIELDNAME = A.FIELDNAME AND B.FIELDVALUE = A.FIELDVALUE AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: PSHUP_IN_ST_LG

  • Parent record: PSXLATITEMLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Employee Status
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Pay
    Q=Retired With Pay
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Pay
    V=Terminated Pension Pay Out
    W=Short Work Break
    X=Retired-Pension Administration
    2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name