HRS_CRSP_IDHRS_PARM_ID10=Notify To
20=Notify CC
30=Notify Bcc
HRS_CRSP_PARMS(SQL Table) |
Index Back |
|---|---|
Correspondence ParametersCorrespondence Parameters (CC, BCC, TO) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_CRSP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Correspondence ID |
| 2 | HRS_PARM_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Parameter ID |
| 3 | HRS_CRSP_PARM_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Correspondence Parameter Type
10=Notify To 20=Notify CC 30=Notify Bcc |
| 4 | HRS_PARM_VAL | Long Character | CLOB | Notification Parameter Value |