EONC_APPL_NOTIF_IDLANGUAGE_CDPrompt Table: PTPN_FUNCAT_DVW
EONC_XREF_LW(SQL View) |
Index Back |
|---|---|
Notification Event Lang ViewNotification Event Language Record View |
| 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 XL.XLATLONGNAME FROM PSXLATITEMLANG XL WHERE XL.FIELDNAME = 'EONC_NOTIF_CAT' AND XL.FIELDVALUE = B.EONC_NOTIF_CAT AND XL.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(PSXLATITEMLANG XL1, XL, %CurrentDateIn)), ( SELECT X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'EONC_NOTIF_CAT' AND X.FIELDVALUE = B.EONC_NOTIF_CAT AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn)), ' '), 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_CAT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Notification Category Description |
| 6 | EONC_PROC_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Business Process Description |
| 7 | EONC_PTNOTIF_DESCR | Character(100) | VARCHAR2(100) NOT NULL | PTPN Notification description |
| 8 | PTPN_FUNC_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL |
Functional Category
Prompt Table: PTPN_FUNCAT_DVW |