EONC_APPL_NOTIF_IDPrompt Table: EONC_NOTIF_VW
AGC=Activity Guide Composer
APPL=Applications Notification
AWE=Approval Workflow
EOEN=EO Events & Notifications
EOQF=Questionnaire Framework
Prompt Table: EONC_PROC_TBL
Prompt Table: PTPN_FUNCAT_DVW
EONC_XREF_VW1(SQL View) |
Index Back |
|---|---|
Notification Events ViewNotification Events View |
| SELECT A.EONC_APPL_NOTIF_ID , B.EONC_NOTIF_NAME , B.DESCR100 , B.EONC_NOTIF_CAT , B.EONC_PROCESS_NAME , C.PTPN_CATEGORY_NAME , C.PTPN_FUNC_CATEGORY FROM PS_EONC_NOTIF_XREF A , PS_EONC_NOTFY_HDR B , PS_PTPN_CAT_REG C WHERE B.EONC_NOTIF_NAME = A.EONC_NOTIF_NAME AND C.PTPN_CATEGORY_NAME = B.EONC_PTNOTIF_NAME |
| # | 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 | EONC_NOTIF_NAME | Character(50) | VARCHAR2(50) NOT NULL |
Notification Name
Prompt Table: EONC_NOTIF_VW |
| 3 | EONC_DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 4 | 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 |
| 5 | EONC_PROCESS_NAME | Character(50) | VARCHAR2(50) NOT NULL |
Business Process Name
Prompt Table: EONC_PROC_TBL |
| 6 | EONC_PTNOTIF_NAME | Character(50) | VARCHAR2(50) NOT NULL | PeopleTools Notification Name |
| 7 | PTPN_FUNC_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL |
Functional Category
Prompt Table: PTPN_FUNCAT_DVW |