HRS_PRNAPP_LVW

(SQL View)
 Index Back

Print Applications - Rel Descr

Print Applications - Descr Related Lang view

SELECT A.JPM_CAT_TYPE , A.LANGUAGE_CD ,A.DESCR FROM PS_JPM_CAT_TYP_LNG A UNION SELECT '.01PRF' ,B.LANGUAGE_CD , B.DESCR FROM PS_HRS_RESTMPLS_LN B WHERE HRS_RES_SEC_NAME12 = 'PRF' UNION SELECT '.02REF' ,E.LANGUAGE_CD , COALESCE(E.MESSAGE_TEXT ,'Referral Sources') FROM PSMSGCATLANG E WHERE E.MESSAGE_SET_NBR=18177 AND E.MESSAGE_NBR=3063 UNION SELECT '.03PRI' ,B.LANGUAGE_CD , B.DESCR FROM PS_HRS_RESTMPLS_LN B WHERE HRS_RES_SEC_NAME12 = 'PRI' UNION SELECT '.04FPR' ,B.LANGUAGE_CD , B.DESCR FROM PS_HRS_RESTMPLS_LN B WHERE HRS_RES_SEC_NAME12 = 'FPR' UNION SELECT '.05WRK' ,B.LANGUAGE_CD , B.DESCR FROM PS_HRS_RESTMPLS_LN B WHERE HRS_RES_SEC_NAME12 = 'WRK' UNION SELECT '.06EDL' ,E.LANGUAGE_CD , COALESCE(E.MESSAGE_TEXT ,'Education Level') FROM PSMSGCATLANG E WHERE E.MESSAGE_SET_NBR=18177 AND E.MESSAGE_NBR=3058 UNION SELECT '.07TRA' ,E.LANGUAGE_CD , COALESCE(E.MESSAGE_TEXT ,'Training') FROM PSMSGCATLANG E WHERE E.MESSAGE_SET_NBR=18177 AND E.MESSAGE_NBR=3064 UNION SELECT '~01RFR' ,B.LANGUAGE_CD , B.DESCR FROM PS_HRS_RESTMPLS_LN B WHERE HRS_RES_SEC_NAME12 = 'RFR' UNION SELECT '~02RST' ,E.LANGUAGE_CD , COALESCE(E.MESSAGE_TEXT ,'Resume Text') FROM PSMSGCATLANG E WHERE E.MESSAGE_SET_NBR=18177 AND E.MESSAGE_NBR=3057

  • Related Language Record for HRS_PRNAPPLN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description