HCSC_ANNOUNC_VW

(SQL View)
Index Back

Announcement list

Announcement 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