EONC_SRC_DFT_VW(SQL View) |
Index Back |
|---|---|
EONC Draft Result View |
| SELECT A.EONC_NOTIF_NAME ,A.DESCR100 ,A.EONC_NOTIF_CAT ,A.EONC_AGC_CATEGORY ,A.LASTUPDOPRID ,A.LASTUPDDTTM ,A.EONC_ITEM_ID ,B.EONC_PREF1 ,B.EONC_PREF2 ,B.EONC_PREF3 ,B.EONC_PREF4 ,B.EONC_PREF5 FROM PS_EONC_NOTFY_HDR A ,PS_EONC_NOTFY_PREF B WHERE EONC_DRAFT_STATUS = 'Y' AND A.EONC_NOTIF_NAME = B.EONC_NOTIF_NAME |
| # | 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 |
| 5 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 6 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 7 | EONC_ITEM_ID | Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item ID |
| 8 | EONC_PREF1 | Character(1) | VARCHAR2(1) NOT NULL | URL Configuration |
| 9 | EONC_PREF2 | Character(1) | VARCHAR2(1) NOT NULL | Use Event Mapping |
| 10 | EONC_PREF3 | Character(1) | VARCHAR2(1) NOT NULL | Define Recipients List |
| 11 | EONC_PREF4 | Character(1) | VARCHAR2(1) NOT NULL | Define Notification Name |
| 12 | EONC_PREF5 | Character(1) | VARCHAR2(1) NOT NULL | Override Default Handler |