HRS_NOTIF_BATCH_IDHRS_NOTIF_TRANS_IDHRS_NOTIF_PARM_ID10=Notify To
20=Notify Cc
30=Notify Bcc
40=Variable for Email Template
50=File Name
60=File Title
HRS_NOTIF_PARMS(SQL Table) |
Index Back |
|---|---|
Notification ParametersBatch Notification Parameters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_NOTIF_BATCH_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Batch Notification Id |
| 2 | HRS_NOTIF_TRANS_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Notification Transaction Id |
| 3 | HRS_NOTIF_PARM_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Notification Parameter Id |
| 4 | HRS_NOTIF_PARMTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Notification Parameter Type
10=Notify To 20=Notify Cc 30=Notify Bcc 40=Variable for Email Template 50=File Name 60=File Title |
| 5 | HRS_PARM_VAL | Long Character | CLOB | Notification Parameter Value |