EONC_NOTIF_CATAGC=Activity Guide Composer
APPL=Applications Notification
AWE=Approval Workflow
EOEN=EO Events & Notifications
EOQF=Questionnaire Framework
EONC_NOTIF_NAMELANGUAGE_CDEONC_NOTIF_LW1(SQL View) |
Index Back |
|---|---|
Rel Lang for EONC_NOTIF_VW1Related Language record for EONC_NOTIF_VW1 |
| SELECT B.EONC_NOTIF_CAT , BL.EONC_NOTIF_NAME , BL.LANGUAGE_CD , BL.DESCR100 FROM PS_EONC_NOTFY_HDR B , PS_EONC_NOTFY_HDRL BL WHERE BL.EONC_NOTIF_NAME = B.EONC_NOTIF_NAME |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |