EONC_NOTIF_NAMELANGUAGE_CDPrompt Table: PTPN_FUNCAT_DVW
EONC_NOTIF_LW2(SQL View) |
Index Back |
|---|---|
Rel Lang for EONC_NOTIF_VW2Related Language record for EONC_NOTIF_VW2 |
| 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 XL.XLATLONGNAME FROM PSXLATITEMLANG XL WHERE XL.FIELDNAME = 'EONC_NOTIF_CAT' AND XL.FIELDVALUE = A.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 = A.EONC_NOTIF_CAT AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn)), ' '), COALESCE(( SELECT BL.EONC_PROC_DESCR FROM PS_EONC_PROC_LNG BL WHERE BL.EONC_PROCESS_NAME = A.EONC_PROCESS_NAME AND BL.LANGUAGE_CD = L.LANGUAGE_CD), ( SELECT B.EONC_PROC_DESCR FROM PS_EONC_PROC_TBL B WHERE B.EONC_PROCESS_NAME = A.EONC_PROCESS_NAME), ' '), COALESCE(( SELECT CL.PTPN_FUNC_CATEGORY FROM PS_PTPN_CAT_REGLNG CL WHERE CL.PTPN_CATEGORY_NAME = A.EONC_PTNOTIF_NAME AND CL.LANGUAGE_CD = L.LANGUAGE_CD) , ( SELECT C.PTPN_FUNC_CATEGORY FROM PS_PTPN_CAT_REG C WHERE C.PTPN_CATEGORY_NAME = A.EONC_PTNOTIF_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 |
| 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_CAT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Notification Category Description |
| 5 | EONC_PROC_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Business Process Description |
| 6 | PTPN_FUNC_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL |
Functional Category
Prompt Table: PTPN_FUNCAT_DVW |