PSHUP_IN_PU_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 = 'PU_SOURCE' AND A.FIELDVALUE <> 'IM' AND A.FIELDVALUE <> 'SP' AND A.FIELDVALUE <> 'ST' AND A.FIELDVALUE <> 'WI' 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_PU_VW

  • Parent record: PSXLATITEMLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name