HCSC_ANNOUNC_VW(SQL View) |
Index Back |
---|---|
Announcement listAnnouncement list |
( 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_NOTIF_HIDE , A.HCSC_NOTIF_HIDE , A.HCSC_MSG_STATE , B.HCSC_LAST_RUN_DATE 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 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_DELIVERY_METH , C.HCSC_DATE_POSTED , C.HCSC_TRUNCATED_MSG , ' ' , C.EMAIL_RTELONG , C.HCSC_NOTIF_HIDE , C.HCSC_NOTIF_HIDE , ' ' , C.HCSC_LAST_RUN_DATE 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_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 | DISPLAYED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Displayed Flag |
9 | 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 |
10 | HCSC_MSG_STATE | Character(1) | VARCHAR2(1) NOT NULL |
Message State
R=Read U=Unread |
11 | HCSC_LAST_RUN_DATE | Date(10) | DATE | Last run Date For Ad-Hoc Notification |