HR_EH_TYPE_LNG

(SQL View)
 Index Back

HR Header Date Type Prompt VW

HR Header Data Prompt View for the different Types allowed on some Fields.

SELECT 'EMAIL' ,FIELDVALUE ,LANGUAGE_CD , XLATLONGNAME FROM PSXLATITEMLANG X WHERE X.FIELDNAME = 'E_ADDR_TYPE' AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEMLANG X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn) UNION SELECT 'PHONE' ,FIELDVALUE ,LANGUAGE_CD , XLATLONGNAME FROM PSXLATITEMLANG X WHERE X.FIELDNAME = 'PHONE_TYPE' AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEMLANG X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn) UNION SELECT 'JOBTITLE' ,FIELDVALUE ,LANGUAGE_CD , XLATLONGNAME FROM PSXLATITEMLANG X WHERE X.FIELDNAME = 'HR_EH_TYPE' AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEMLANG X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn) UNION SELECT 'ADDRESS' ,ADDRESS_TYPE ,LANGUAGE_CD , ADDR_TYPE_DESCR FROM PS_ADDRESS_TYP_LNG UNION SELECT 'MANAGER_ID' ,FIELDVALUE ,LANGUAGE_CD , XLATLONGNAME FROM PSXLATITEMLANG X WHERE X.FIELDNAME = 'HR_EH_MANAGER_TYPE' AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEMLANG X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn)

  • Related Language Record for HR_EH_TYPE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HR_EH_FLDNAME Character(18) VARCHAR2(18) NOT NULL Field Name
    2 HR_EH_TYPE Character(4) VARCHAR2(4) NOT NULL Header Data:Which Job Title to use. From Position or Job.
    JOB=Job Title
    PNJB=Position then Job Title
    POSN=Position Title
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description