HRS_JO_TMPLS_LN

(SQL View)
 Index Back

Job Opening Tmpl Sctn RL Vw

Job opening template section related language view excluding job information section

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

  • Related Language Record for HRS_JO_TMPLS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JO_TMPL_SCTN12 Character(12) VARCHAR2(12) NOT NULL Job Opening Template Sections

    Prompt Table: HRS_JO_TMPLS_VW

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description