OPRIDA=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
Y/N Table Edit
HCSC_NOTIF_PGLT(SQL Table) |
Index Back |
|---|---|
Announcement PageletA record with one row of dummy data that will be returned in the search query to indicate that a 'No Current Announcement' message should be displayed to the user. |
| # | 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_DATE_POSTED | Date(10) | DATE | Posting date for Ad-Hoc notification |
| 4 | 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 |
| 5 | HCSC_TRUNCATED_MSG | Character(100) | VARCHAR2(100) NOT NULL | First 100 Character of Ad-Hoc notification message. |
| 6 | EMAIL_RTELONG | Long Character | CLOB | Message Text |
| 7 | DISPLAYED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Displayed Flag |
| 8 | HCSC_NOTIF_HIDE | Character(1) | VARCHAR2(1) NOT NULL |
Flag for announcements. If the flag is turned on, a user will be able to hide an announcement on their home page.
Y/N Table Edit |
| 9 | HCSC_LAST_RUN_DATE | Date(10) | DATE | Last run Date For Ad-Hoc Notification |