HRS_RESTMPLS_LN

(SQL View)
 Index Back

Job Opening Tmpl Sctn RL Vw

Job opening template section related language view excluding job information section

SELECT XLNG.FIELDVALUE , XLNG.LANGUAGE_CD , XLNG.XLATLONGNAME FROM PSXLATITEMLANG XLNG WHERE XLNG.FIELDNAME = 'HRS_RES_SEC_NAME' AND XLNG.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE XLNG.FIELDNAME = X1.FIELDNAME AND XLNG.FIELDVALUE = X1.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn ) UNION ALL SELECT CATLNG.JPM_CAT_TYPE , CATLNG.LANGUAGE_CD , CATLNG.DESCR FROM PS_JPM_PRI_P_CAT_I CAT , PS_JPM_CAT_TYP_LNG CATLNG WHERE CAT.JPM_CAT_TYPE = CATLNG.JPM_CAT_TYPE

  • Related Language Record for HRS_RESTMPLS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_RES_SEC_NAME12 Character(12) VARCHAR2(12) NOT NULL Resume Section Name
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description