OPRIDHCSC_NOTIF_TRNS_IDA=Announcement
B=Email and Announcement
E=Email
N=Notification
N=In-App
X=Email and Notification
X=Email and In-App
Y=Announcement and In-App
Y=Announcement and Notification
Z=All
Default Value: A
Default Value: %DATE
HCSC_NOT_WIN_VW(SQL View) |
Index Back |
|---|---|
Alert list Notification WindowList of alerts on notification window |
| SELECT A.OPRID , A.HCSC_NOTIF_TRNS_ID , B.HCSC_DELIVERY_METH , B.HCSC_DATE_POSTED , B.HCSC_TRUNCATED_MSG ,B.HCSC_NOTIF_SUBJECT , B.EMAIL_RTELONG ,B.HCSC_LAST_RUN_DATE FROM PS_HCSC_NOTIF_WIN A , PS_HCSC_NOTIF B WHERE A.HCSC_NOTIF_TRNS_ID = B.HCSC_NOTIF_TRNS_ID AND B.HCSC_DATE_POSTED <= %CurrentDateIn |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | HCSC_NOTIF_TRNS_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Transaction ID for AD-Hoc Notification. |
| 3 | HCSC_DELIVERY_METH | Character(1) | VARCHAR2(1) NOT NULL |
The delivery methods available for ad-hoc notifications and announcements.
A=Announcement B=Email and Announcement E=Email N=Notification N=In-App X=Email and Notification X=Email and In-App Y=Announcement and In-App Y=Announcement and Notification Z=All Default Value: A |
| 4 | HCSC_DATE_POSTED | Date(10) | DATE |
Posting date for Ad-Hoc notification
Default Value: %DATE |
| 5 | HCSC_TRUNCATED_MSG | Character(100) | VARCHAR2(100) NOT NULL | First 100 Character of Ad-Hoc notification message. |
| 6 | HCSC_NOTIF_SUBJECT | Character(240) | VARCHAR2(240) NOT NULL | Message Subject |
| 7 | EMAIL_RTELONG | Long Character | CLOB | Message Text |
| 8 | HCSC_LAST_RUN_DATE | Date(10) | DATE | Last run Date For Ad-Hoc Notification |