HCSC_ANN_QRY_VW(SQL View) |
Index Back |
|---|---|
Announcement listAnnouncement list |
| ( SELECT A.OPRID , A.HCSC_NOTIF_TRNS_ID , B.HCSC_DATE_POSTED , B.HCSC_DELIVERY_METH , B.HCSC_TRUNCATED_MSG , B.EMAIL_RTELONG ,B.HCSC_NOTIF_HIDE , A.HCSC_NOTIF_HIDE FROM PS_HCSC_ANNOUNCE A , PS_HCSC_NOTIF B WHERE A.HCSC_NOTIF_TRNS_ID = B.HCSC_NOTIF_TRNS_ID AND A.HCSC_NOTIF_HIDE = 'N' AND ( B.HCSC_DATE_POSTED = %CurrentDateIn OR B.HCSC_DATE_POSTED < %CurrentDateIn) AND ( B.HCSC_EXPIRE_DATE > %CurrentDateIn OR B.HCSC_EXPIRE_DATE IS NULL)) UNION ALL ( SELECT C.OPRID , C.HCSC_NOTIF_TRNS_ID , C.HCSC_DATE_POSTED , C.HCSC_DELIVERY_METH , C.HCSC_TRUNCATED_MSG , C.EMAIL_RTELONG , C.HCSC_NOTIF_HIDE , C.HCSC_NOTIF_HIDE FROM PS_HCSC_NOTIF_PGLT C) |
| # | 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 |