EONC_APPL_NOTIF_IDBPW_EONC_NOT_VW(SQL View) |
Index Back |
|---|---|
EONC Notification NameEONC Notification Name |
| SELECT B.EONC_APPL_NOTIF_ID ,B.EONC_APP_NOT_DESCR ,A.EONC_NOTIF_NAME FROM PS_EONC_NOTFY_HDR A ,PS_EONC_NOTIF_XREF B WHERE A.EONC_NOTIF_NAME = B.EONC_NOTIF_NAME AND A.EONC_NOTIF_CAT = 'APPL' |
| # | 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_APP_NOT_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Application Notification Event Description |
| 3 | EONC_NOTIF_NAME | Character(50) | VARCHAR2(50) NOT NULL | Notification Name |