EONC_SRC_RES_VW(SQL View) |
Index Back |
|---|---|
EONC Search Result ViewNotification Composer Search Result View |
| SELECT A.EONC_NOTIF_NAME , A.DESCR100 , A.EONC_NOTIF_CAT , A.EONC_AGC_CATEGORY , A.EONC_PTNOTIF_NAME , C.DESCR100 , A.EONC_PROCESS_NAME , D.EONC_PROC_DESCR , A.OBJECTOWNERID , A.EONC_PRIORITY , A.EONC_NOTIF_STATUS , B.EONC_PREF1 , B.EONC_PREF2 , B.EONC_PREF3 , B.EONC_PREF4 , B.EONC_PREF5 FROM ( ( PS_EONC_NOTFY_HDR A LEFT OUTER JOIN PS_PTPN_CAT_REG C ON C.PTPN_CATEGORY_NAME = A.EONC_PTNOTIF_NAME ) LEFT OUTER JOIN PS_EONC_PROC_TBL D ON D.EONC_PROCESS_NAME = A.EONC_PROCESS_NAME ) , PS_EONC_NOTFY_PREF B WHERE ( A.EONC_NOTIF_NAME = B.EONC_NOTIF_NAME AND A.EONC_DRAFT_STATUS <> 'Y' ) |
| # | 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 | EONC_NOTIF_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Notification Event Description |
| 3 | EONC_NOTIF_CAT | Character(4) | VARCHAR2(4) NOT NULL |
Notification Event Source (source of the notification):
APPL - Application Code (default)
AWE - Approvals Framework
EOEN - Enterprise Objects Events and Notifications Framework
AGC - Activity Guide Composer
EOQF - Questionnaire Framework
AGC=Activity Guide Composer APPL=Applications Notification AWE=Approval Workflow EOEN=EO Events & Notifications EOQF=Questionnaire Framework |
| 4 | EONC_AGC_CATEGORY | Character(15) | VARCHAR2(15) NOT NULL |
Activity Guide Category
Prompt Table: AGC_CAT_SRCH_VW |
| 5 | PTPN_NOTIF_NAME | Character(50) | VARCHAR2(50) NOT NULL |
Notification Name
Prompt Table: EONC_CAT_REG_VW |
| 6 | EONC_PTNOTIF_DESCR | Character(100) | VARCHAR2(100) NOT NULL | PTPN Notification description |
| 7 | EONC_PROCESS_NAME | Character(50) | VARCHAR2(50) NOT NULL | Business Process Name |
| 8 | EONC_PROC_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Business Process Description |
| 9 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 10 | EONC_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Notification priority.
0=Medium 1=High 2=Low |
| 11 | EONC_NOTIF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Notification Status: A - Active, I - Inactive, D - Draft.
A=Active D=Draft I=Inactive |
| 12 | EONC_PREF1 | Character(1) | VARCHAR2(1) NOT NULL | URL Configuration |
| 13 | EONC_PREF2 | Character(1) | VARCHAR2(1) NOT NULL | Use Event Mapping |
| 14 | EONC_PREF3 | Character(1) | VARCHAR2(1) NOT NULL | Define Recipients List |
| 15 | EONC_PREF4 | Character(1) | VARCHAR2(1) NOT NULL | Define Notification Name |
| 16 | EONC_PREF5 | Character(1) | VARCHAR2(1) NOT NULL | Override Default Handler |