HRS_CRSP_IDHRS_PERSON_IDHRS_RCMNT_IDHRS_GACT_RCMNT(SQL Table) |
Index Back |
|---|---|
Staging table for HRS_ACT_MAILThis record is used to temporarily store recruitment data to be processed by the Application Engine program HRS_ACT_MAIL. It is used when a letter is being generated by Send Correspondence and there is one or more job openings to be mentioned in the letter. |
| # | 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_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 3 | HRS_RCMNT_ID |
Number(15,0) | DECIMAL(15) NOT NULL | App Tracking Recruitment ID |