EONC_APPL_NOTIF_IDHR_NC_XREF_VW(SQL View) |
Index Back |
|---|---|
Appl NC viewView to identify Appl NC |
| SELECT A.EONC_APPL_NOTIF_ID , A.EONC_APP_NOT_DESCR FROM PS_EONC_NOTIF_XREF A , PS_EONC_NOTFY_HDR B WHERE B.EONC_NOTIF_CAT='APPL' AND B.EONC_NOTIF_NAME = A.EONC_NOTIF_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_APP_NOT_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Application Notification Event Description |