LM_ANNOUNC_HST (SQL Table)	Index Back
Announcements by Oprid This record is used to retrieve announcement information by oprid. It is populated when an announcement is saved in the Ad-Hoc Notify and Announce component.

LM_ANNOUNC_HST

(SQL Table)

Announcements by Oprid

This record is used to retrieve announcement information by oprid. It is populated when an announcement is saved in the Ad-Hoc Notify and Announce component.

Parent record: LM_NOTIF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

3 LM_NOTIF_TRANS_ID Number(10,0) DECIMAL(10) NOT NULL Notification ID

4 LM_OPRID Character(30) VARCHAR2(30) NOT NULL Operator ID Used for Announcements

5 LM_NOTIFY_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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	LM_NOTIF_TRANS_ID	Number(10,0)	DECIMAL(10) NOT NULL	Notification ID
4	LM_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Operator ID Used for Announcements
5	LM_NOTIFY_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