EONC_CNF_SCH_VW(SQL View) |
Index Back |
|---|---|
EONC Confirmation View |
| SELECT EONC_NOTIF_NAME , DESCR100 , EONC_NOTIF_CAT , EONC_PTNOTIF_NAME , EONC_PROCESS_NAME , EONC_PRIORITY , EONC_USER_LIST_ID , EONC_LOGGING_FLG , OBJECTOWNERID , EONC_NOTIF_STATUS FROM PS_EONC_NOTFY_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EONC_NOTIF_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Notification Name |
| 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_PTNOTIF_DESCR | Character(100) | VARCHAR2(100) NOT NULL |
PTPN Notification description
Prompt Table: EONC_CAT_REG_VW |
| 5 | EONC_PROCESS_NAME | Character(50) | VARCHAR2(50) NOT NULL |
Business Process Name
Prompt Table: EONC_PROC_TBL |
| 6 | EONC_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Notification priority.
0=Medium 1=High 2=Low |
| 7 | EONC_USER_LIST_ID | Character(30) | VARCHAR2(30) NOT NULL |
Identifies the user list to be used when creating the notification.
Prompt Table: EONC_ULST_PR_VW |
| 8 | EONC_LOGGING_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable notification logging flag.
Y/N Table Edit |
| 9 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 10 | EONC_NOTIF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Notification Status: A - Active, I - Inactive, D - Draft.
A=Active D=Draft I=Inactive |