LM_ANNCMNT_PGL

(SQL Table)
Index Back

Announcement Pagelet

A record with one row of dummy data that will be returned in the search query to indicate that a 'No Current Announcement' message should be displayed to the user.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_OPRID Character(30) VARCHAR2(30) NOT NULL Operator ID Used for Announcements
2 LM_NOTIF_TRANS_ID Number(10,0) DECIMAL(10) NOT NULL Notification ID
3 LM_DATE_POSTED Date(10) DATE Date Announcment posted and/or email notifications sent.
4 LM_DELIVERY_METHOD Character(1) VARCHAR2(1) NOT NULL The delivery methods available for ad-hoc notifications and announcements.
A=Announcement
B=Both Email and Announcement
E=Email Notification
5 LM_MSG_ABBREVIATED Character(100) VARCHAR2(100) NOT NULL Message
6 LM_MSG_TXT Long Character CLOB Message Text
7 DISPLAYED_FLAG Character(1) VARCHAR2(1) NOT NULL Displayed Flag
8 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.