LM_NOTIF_TRANS_IDLM_DATE_POSTEDLM_DELIVERY_METHODA=Announcement
B=Both Email and Announcement
E=Email Notification
LM_MSG_ABBREVIATEDLM_ATTACH_IDLM_NOT_ANN_ATCH(SQL Table) |
Index Back |
|---|---|
Adhoc Notification AttachmentsTable used on adhoc notification pages for attachment processing. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_NOTIF_TRANS_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Notification ID |
| 2 | LM_DATE_POSTED |
Date(10) | DATE | Date Announcment posted and/or email notifications sent. |
| 3 | 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 |
| 4 | LM_MSG_ABBREVIATED |
Character(100) | VARCHAR2(100) NOT NULL | Message |
| 5 | LM_ATTACH_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Attachment ID - System generated unique ID created for each attachment. |
| 6 | LM_ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 7 | LM_ATTACHSYSFILE | Character(128) | VARCHAR2(128) NOT NULL | Unique System Filename |