HCSC_ANNOUN1_VW(SQL View) |
Index Back |
|---|---|
Announcment DetailAnnouncement Detail information displayed in a pagelet extension. |
| SELECT OPRID ,HCSC_NOTIF_TRNS_ID , HCSC_DATE_POSTED , HCSC_DELIVERY_METH , HCSC_TRUNCATED_MSG , EMAIL_RTELONG ,HCSC_NOTIF_HIDE , HCSC_NOTIF_HIDE ,HCSC_LAST_RUN_DATE FROM PS_HCSC_ANNOUNC_VW |
| # | 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
Default Value: %DATE |
| 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 Default Value: A |
| 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 Default Value: N |
| 9 | HCSC_LAST_RUN_DATE | Date(10) | DATE | Last run Date For Ad-Hoc Notification |