EONC_NOTIF_NAME0=Medium
1=High
2=Low
A=Active
D=Draft
I=Inactive
EONC_NOTFY_P_VW(SQL View) |
Index Back |
|---|---|
EONC Search View |
| SELECT EONC_NOTIF_NAME , DESCR100 , EONC_PTNOTIF_NAME , OBJECTOWNERID , EONC_PRIORITY , EONC_NOTIF_STATUS FROM PS_EONC_NOTFY_HDR WHERE eonc_draft_status <> 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EONC_NOTIF_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Notification Name |
| 2 | EONC_NOTIF_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Notification Event Description |
| 3 | EONC_PTNOTIF_NAME | Character(50) | VARCHAR2(50) NOT NULL | PeopleTools Notification Name |
| 4 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 5 | EONC_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Notification priority.
0=Medium 1=High 2=Low |
| 6 | EONC_NOTIF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Notification Status: A - Active, I - Inactive, D - Draft.
A=Active D=Draft I=Inactive |