LM_OPRIDLM_NOTIF_TRANS_IDDefault Value: %DATE
A=Announcement
B=Both Email and Announcement
E=Email Notification
Default Value: A
Y/N Table Edit
Default Value: N
LM_ANNCMNT_QRY2(SQL View) |
Index Back |
|---|---|
Announcment DetailAnnouncement Detail information displayed in a pagelet extension. |
| SELECT LM_OPRID , LM_NOTIF_TRANS_ID , LM_DATE_POSTED , LM_DELIVERY_METHOD , LM_MSG_ABBREVIATED , LM_MSG_TXT , LM_NOTIFY_HIDE , LM_NOTIFY_HIDE FROM PS_LM_ANNCMNT_QRY |
| # | 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.
Default Value: %DATE |
| 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 Default Value: A |
| 5 | LM_MSG_ABBREVIATED | Character(100) | VARCHAR2(100) NOT NULL | Message |
| 6 | LM_MSG_TXT | Long Character | CLOB NOT NULL | 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.
Y/N Table Edit Default Value: N |