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_QRY(SQL View) |
Index Back |
|---|---|
Current Announcements by Oprid |
| ( SELECT A.LM_OPRID , A.LM_NOTIF_TRANS_ID , B.LM_DATE_POSTED , B.LM_DELIVERY_METHOD , B.LM_MSG_ABBREVIATED , B.LM_MSG_TXT ,B.LM_NOTIFY_HIDE , A.LM_NOTIFY_HIDE FROM PS_LM_ANNOUNCEMENT A , PS_LM_NOTIF B WHERE A.LM_NOTIF_TRANS_ID = B.LM_NOTIF_TRANS_ID AND A.LM_NOTIFY_HIDE = 'N' AND ( B.LM_DATE_POSTED = %CurrentDateIn OR B.LM_DATE_POSTED < %CurrentDateIn) AND ( B.LM_EXPR_DT > %CurrentDateIn OR B.LM_EXPR_DT IS NULL)) UNION ALL ( SELECT C.LM_OPRID , C.LM_NOTIF_TRANS_ID , C.LM_DATE_POSTED , C.LM_DELIVERY_METHOD , C.LM_MSG_ABBREVIATED , C.LM_MSG_TXT , C.LM_NOTIFY_HIDE , C.LM_NOTIFY_HIDE FROM PS_LM_ANNCMNT_PGL C) |
| # | 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 |