HCSC_ANN_FL_VW (SQL View)	Index Back
Announcement list Announcement list stored per User ID.

HCSC_ANN_FL_VW

(SQL View)

Announcement list

Announcement list stored per User ID.

SELECT A.OPRID ,A.HCSC_NOTIF_TRNS_ID ,A.HCSC_NOTIF_HIDE ,A.HCSC_MSG_STATE ,A.HCSC_NOT_SENT_DTTM FROM PS_HCSC_ANNOUNCE A WHERE A.HCSC_NOTIF_HIDE = 'N' AND EXISTS ( SELECT 'X' FROM PS_HCSC_NOTIF B WHERE A.HCSC_NOTIF_TRNS_ID = B.HCSC_NOTIF_TRNS_ID AND B.HCSC_DATE_POSTED <= %CurrentDateIn AND %Coalesce(B.HCSC_EXPIRE_DATE, %DateAdd(%CurrentDateIn,1)) > %CurrentDateIn)

# 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_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

4 HCSC_MSG_STATE Character(1) VARCHAR2(1) NOT NULL Message State
R=Read
U=Unread
Default Value: R

5 HCSC_NOT_SENT_DTTM DateTime(26) TIMESTAMP Notification Sent on

#	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_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
4	HCSC_MSG_STATE	Character(1)	VARCHAR2(1) NOT NULL	Message State R=Read U=Unread Default Value: R
5	HCSC_NOT_SENT_DTTM	DateTime(26)	TIMESTAMP	Notification Sent on