EONC_NOTIF_NAMEPrompt Table: EONC_NOTFY_HDR
LANGUAGE_CDEONC_SRC_RES_LW(SQL View) |
Index Back |
|---|---|
Rel Lang for EONC_SRC_RES_VWRelated Language record for EONC_SRC_RES_VW |
| SELECT A.EONC_NOTIF_NAME , L.LANGUAGE_CD , COALESCE(( SELECT AL.DESCR100 FROM PS_EONC_NOTFY_HDRL AL WHERE AL.EONC_NOTIF_NAME = A.EONC_NOTIF_NAME AND AL.LANGUAGE_CD = L.LANGUAGE_CD) , (A.DESCR100), ' '), COALESCE(( SELECT AL1.DESCR100 FROM PS_PTPN_CAT_REGLNG AL1 WHERE AL1.PTPN_CATEGORY_NAME = A.EONC_PTNOTIF_NAME AND AL1.LANGUAGE_CD = L.LANGUAGE_CD), ( SELECT A1.DESCR100 FROM PS_PTPN_CAT_REG A1 WHERE A1.PTPN_CATEGORY_NAME = A.EONC_PTNOTIF_NAME ), ' ') , COALESCE(( SELECT AL2.EONC_PROC_DESCR FROM PS_EONC_PROC_LNG AL2 WHERE AL2.EONC_PROCESS_NAME = A.EONC_PROCESS_NAME AND AL2.LANGUAGE_CD = L.LANGUAGE_CD), ( SELECT A2.EONC_PROC_DESCR FROM PS_EONC_PROC_TBL A2 WHERE A2.EONC_PROCESS_NAME = A.EONC_PROCESS_NAME), ' ') FROM PS_EONC_NOTFY_HDR A, PSLANGUAGES L WHERE 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_NOTIF_NAME |
Character(50) | VARCHAR2(50) NOT NULL |
Notification Name
Prompt Table: EONC_NOTFY_HDR |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EONC_NOTIF_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Notification Event Description |
| 4 | EONC_PTNOTIF_DESCR | Character(100) | VARCHAR2(100) NOT NULL | PTPN Notification description |
| 5 | EONC_PROC_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Business Process Description |