HR_EH_TYPE_VW

(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 , XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'E_ADDR_TYPE' AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn) UNION SELECT 'PHONE' , FIELDVALUE , XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'PHONE_TYPE' AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn) UNION SELECT 'JOBTITLE' ,FIELDVALUE , XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'HR_EH_TYPE' AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn) UNION SELECT 'ADDRESS' ,ADDRESS_TYPE , ADDR_TYPE_DESCR FROM PS_ADDRESS_TYP_TBL UNION SELECT 'MANAGER_ID' , FIELDVALUE , XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'HR_EH_MANAGER_TYPE' AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn)

  • Related Language Record: HR_EH_TYPE_LNG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description