LM_NOTIF_BATCH_IDLM_NOTIF_TRANS_IDLM_NOTIF_PARM_ID10=Notify To
20=Notify Cc
30=NotifyBcc
40=Variables for Email Template
LM_NOTIF_PARMS(SQL Table) |
Index Back |
|---|---|
Notif Bind Parms |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_NOTIF_BATCH_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Notification Batch ID |
| 2 | LM_NOTIF_TRANS_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Notification ID |
| 3 | LM_NOTIF_PARM_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Notification Parameter ID |
| 4 | LM_NOTIFY_PARMTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Notification Parameter Type
10=Notify To 20=Notify Cc 30=NotifyBcc 40=Variables for Email Template |
| 5 | LM_PARM_VAL | Long Character | CLOB | Notifications Param |