LM_ANNCMNT_PGL(SQL Table) |
Index Back |
---|---|
Announcement PageletA 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. |