HCSC_ANNOUNCE (SQL Table)	Index Back
Announcement list Announcement list stored per User ID.

HCSC_ANNOUNCE

(SQL Table)

Announcement list

Announcement list stored per User ID.

# 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