HRS_PRNAPPLN_VW

(SQL View)
 Index Back

Print Applications - Descr

To get the description for application section

SELECT A.JPM_CAT_TYPE ,A.DESCR FROM PS_JPM_CAT_TYPES A UNION SELECT '.01PRF' , B.DESCR FROM PS_HRS_RESTMPLS_VW B WHERE B.HRS_RES_SEC_NAME12 = 'PRF' UNION SELECT '.02REF' , COALESCE(E.MESSAGE_TEXT ,'Referral Sources') FROM PSMSGCATDEFN E WHERE E.MESSAGE_SET_NBR=18177 AND E.MESSAGE_NBR=3063 UNION SELECT '.03PRI' , B.DESCR FROM PS_HRS_RESTMPLS_VW B WHERE B.HRS_RES_SEC_NAME12 = 'PRI' UNION SELECT '.04FPR' , B.DESCR FROM PS_HRS_RESTMPLS_VW B WHERE B.HRS_RES_SEC_NAME12 = 'FPR' UNION SELECT '.05WRK' , B.DESCR FROM PS_HRS_RESTMPLS_VW B WHERE B.HRS_RES_SEC_NAME12 = 'WRK' UNION SELECT '.05WRL' ,COALESCE(E.MESSAGE_TEXT ,'Work Experience with details') FROM PSMSGCATDEFN E WHERE E.MESSAGE_SET_NBR=18177 AND E.MESSAGE_NBR=3116 UNION SELECT '.06EDL' , COALESCE(E.MESSAGE_TEXT ,'Education Level') FROM PSMSGCATDEFN E WHERE E.MESSAGE_SET_NBR=18177 AND E.MESSAGE_NBR=3058 UNION SELECT '.07TRA' , COALESCE(E.MESSAGE_TEXT ,'Training') FROM PSMSGCATDEFN E WHERE E.MESSAGE_SET_NBR=18177 AND E.MESSAGE_NBR=3064 UNION SELECT '~01RFR' , B.DESCR FROM PS_HRS_RESTMPLS_VW B WHERE B.HRS_RES_SEC_NAME12 = 'RFR' UNION SELECT '~02RST' , COALESCE(E.MESSAGE_TEXT ,'Resume Text') FROM PSMSGCATDEFN E WHERE E.MESSAGE_SET_NBR=18177 AND E.MESSAGE_NBR=3057

  • Related Language Record: HRS_PRNAPP_LVW

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