EONC_NOTIF_CATAGC=Activity Guide Composer
APPL=Applications Notification
AWE=Approval Workflow
EOEN=EO Events & Notifications
EOQF=Questionnaire Framework
EONC_NOTIF_NAMEPrompt Table: EONC_PROC_TBL
Prompt Table: PTPN_FUNCAT_DVW
EONC_NOTIF_VW1(SQL View) |
Index Back |
|---|---|
Notification ID PromptNotification ID Prompt for the Notification Cross-reference table. |
| SELECT A.EONC_NOTIF_CAT , A.EONC_NOTIF_NAME , A.DESCR100 , A.EONC_PROCESS_NAME , B.PTPN_FUNC_CATEGORY FROM PS_EONC_NOTFY_HDR A , PS_PTPN_CAT_REG B WHERE B.PTPN_CATEGORY_NAME = A.EONC_PTNOTIF_NAME AND A.EONC_DRAFT_STATUS <> 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 2 | EONC_NOTIF_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Notification Name |
| 3 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 4 | EONC_PROCESS_NAME | Character(50) | VARCHAR2(50) NOT NULL |
Business Process Name
Prompt Table: EONC_PROC_TBL |
| 5 | PTPN_FUNC_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL |
Functional Category
Prompt Table: PTPN_FUNCAT_DVW |