HR_MO_TYPE_VW

(SQL View)
 Index Back

HR Mouse Over Type Prompt vw

HR Mouse Over 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 'APP_EMAIL' ,FIELDVALUE , XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'HRS_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 'APP_EMAIL_PRF ' ,FIELDVALUE , XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'HRS_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 'APP_PHONE' , FIELDVALUE , XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'HRS_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 'APP_PHONE_PRF' , FIELDVALUE , XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'HRS_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_MO_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 'APP_ADDRESS' ,ADDRESS_TYPE , ADDR_TYPE_DESCR FROM PS_ADDRESS_TYP_TBL UNION SELECT 'MANAGER_ID' , FIELDVALUE , XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'HR_MO_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_MO_TYPE_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HR_MO_FLDNAME Character(18) VARCHAR2(18) NOT NULL Field Name
    2 HR_MO_TYPE Character(4) VARCHAR2(4) NOT NULL Mouse Over 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