PSHUP_IN_ST_LG

(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 , B.LANGUAGE_CD , B.XLATLONGNAME FROM PSXLATITEM A , PSXLATITEMLANG B WHERE A.FIELDVALUE = B.FIELDVALUE AND A.FIELDNAME = B.FIELDNAME AND 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(C.EFFDT) FROM PSXLATITEM C WHERE C.FIELDNAME = A.FIELDNAME AND C.FIELDVALUE = A.FIELDVALUE AND C.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record for PSHUP_IN_ST_VW

  • Parent record: PSXLATITEMLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name