EONC_APPL_NOTIF_IDLANGUAGE_CDPrompt Table: PTPN_FUNCAT_DVW
EONC_APPL_LW(SQL View) |
Index Back |
|---|---|
Rel Lang for EONC_APPL_VWRelated Language for EONC_APPL_VW and other notification category specific views. |
| SELECT A.EONC_APPL_NOTIF_ID , L.LANGUAGE_CD , COALESCE(( SELECT AL.EONC_APP_NOT_DESCR FROM PS_EONC_NOT_XREF_L AL WHERE AL.EONC_APPL_NOTIF_ID = A.EONC_APPL_NOTIF_ID AND AL.LANGUAGE_CD = L.LANGUAGE_CD) , (A.EONC_APP_NOT_DESCR), ' ') , COALESCE(( SELECT BL.DESCR100 FROM PS_EONC_NOTFY_HDRL BL WHERE BL.EONC_NOTIF_NAME = B.EONC_NOTIF_NAME AND BL.LANGUAGE_CD = L.LANGUAGE_CD) , (B.DESCR100), ' ') , COALESCE(( SELECT CL.EONC_PROC_DESCR FROM PS_EONC_PROC_LNG CL WHERE CL.EONC_PROCESS_NAME = B.EONC_PROCESS_NAME AND CL.LANGUAGE_CD = L.LANGUAGE_CD), ( SELECT C.EONC_PROC_DESCR FROM PS_EONC_PROC_TBL C WHERE C.EONC_PROCESS_NAME = B.EONC_PROCESS_NAME), ' ') , COALESCE(( SELECT DL.DESCR100 FROM PS_PTPN_CAT_REGLNG DL WHERE DL.PTPN_CATEGORY_NAME = B.EONC_PTNOTIF_NAME AND DL.LANGUAGE_CD = L.LANGUAGE_CD) , ( SELECT D.DESCR100 FROM PS_PTPN_CAT_REG D WHERE D.PTPN_CATEGORY_NAME = B.EONC_PTNOTIF_NAME), ' ') , COALESCE(( SELECT EL.PTPN_FUNC_CATEGORY FROM PS_PTPN_CAT_REGLNG EL WHERE EL.PTPN_CATEGORY_NAME = B.EONC_PTNOTIF_NAME AND EL.LANGUAGE_CD = L.LANGUAGE_CD) , ( SELECT E.PTPN_FUNC_CATEGORY FROM PS_PTPN_CAT_REG E WHERE E.PTPN_CATEGORY_NAME = B.EONC_PTNOTIF_NAME), ' ') FROM PS_EONC_NOTIF_XREF A , PS_EONC_NOTFY_HDR B, PSLANGUAGES L WHERE B.EONC_NOTIF_NAME = A.EONC_NOTIF_NAME AND L.INSTALLED = 1 AND L.LANGUAGE_CD <> ( SELECT O.LANGUAGE_CD FROM PSOPTIONS O) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EONC_APPL_NOTIF_ID |
Character(50) | VARCHAR2(50) NOT NULL | Application Notification ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EONC_APP_NOT_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Application Notification Event Description |
| 4 | EONC_DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 5 | EONC_PROC_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Business Process Description |
| 6 | EONC_PTNOTIF_DESCR | Character(100) | VARCHAR2(100) NOT NULL | PTPN Notification description |
| 7 | PTPN_FUNC_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL |
Functional Category
Prompt Table: PTPN_FUNCAT_DVW |