LM_NOTIF_TRANS_IDDefault Value: 9999999999
LM_DATE_POSTEDDefault Value: %DATE
LM_DESCRLM_MSG_ABBREVIATEDLM_NOTF_ADDSRCH(SQL View) |
Index Back |
|---|---|
Search Record for AdHoc NotifySearch record used by the Ad Hoc Notify and Announce component. SELECT A.LM_DATE_POSTED , B.XLATLONGNAME , A.LM_MSG_ABBREVIATED FROM PS_LM_NOTIF A , PSXLATITEM B WHERE B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PSXLATITEM B_ED WHERE B.FIELDNAME = B_ED.FIELDNAME AND B.FIELDVALUE = B_ED.FIELDVALUE AND B_ED.EFFDT <= %CurrentDateIn) AND B.FIELDNAME = 'LM_DELIVERY_METHOD' AND A.LM_DELIVERY_METHOD = B.FIELDVALUE |
| SELECT A.LM_NOTIF_TRANS_ID , A.LM_DATE_POSTED , B.XLATLONGNAME , A.LM_MSG_ABBREVIATED FROM PS_LM_NOTIF A , PSXLATITEM B WHERE B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PSXLATITEM B_ED WHERE B.FIELDNAME = B_ED.FIELDNAME AND B.FIELDVALUE = B_ED.FIELDVALUE AND B_ED.EFFDT <= %CurrentDateIn) AND B.FIELDNAME = 'LM_DELIVERY_METHOD' AND A.LM_DELIVERY_METHOD = B.FIELDVALUE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_NOTIF_TRANS_ID |
Number(10,0) | DECIMAL(10) NOT NULL |
Notification ID
Default Value: 9999999999 |
| 2 | LM_DATE_POSTED |
Date(10) | DATE |
Date Announcment posted and/or email notifications sent.
Default Value: %DATE |
| 3 | LM_DESCR |
Character(50) | VARCHAR2(50) NOT NULL | Description |
| 4 | LM_MSG_ABBREVIATED |
Character(100) | VARCHAR2(100) NOT NULL | Message |