HRS_SOURCE_VNDR(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HRS_SOURCE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Source ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | HRS_VENDOR_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Integration Vendor ID
Prompt Table: HRS_SVENDOR_PT |
| 4 | HRS_AUTOREJECT_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Used as a reference to an autoscreen id. Based on the results of the autoscreening the candidate may be automatically rejected
Prompt Table: HRS_AREJECT_PT |
| 5 | HRS_REVIEWREQ_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Links to an autoscreening ID. Depending on the results of the screening A review is required.
Prompt Table: HRS_RRDEF_PT |
| 6 | HRS_SOURCE_NOTIFY | Character(1) | VARCHAR2(1) NOT NULL |
Used by Source. A Yes/No as to wheter applicant validation should be required on every resume processed through that source.
Y/N Table Edit |
| 7 | HRS_RETAIN_POS | Character(1) | VARCHAR2(1) NOT NULL |
Specifies if the Resume that passes thorugh this source should be associated with the job they applied for or just dumped into a general pool.
Y/N Table Edit |
| 8 | HRS_EXTRACTOR_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Used to store the extractor in Source.
Prompt Table: HRS_EXTRCTR_PT |
| 9 | HRS_RESUME_FAIL | Character(3) | VARCHAR2(3) NOT NULL |
used by Source. Specifies Default behavior in case of Errors on Resume Extraction
10=Reject 30=Unresolved Default Value: 10 |
| 10 | HRS_ADDQUEUE | Number(15,0) | DECIMAL(15) NOT NULL |
Located in Record HRS_SOURCE_VNDR. This is a reference to an autoscreen object. Based on the results of the autoscreen a resume passed through the source may be added to the resume queue.
Prompt Table: HRS_ADDQUEUE_PT |
| 11 | HRS_SITE_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Site ID
Prompt Table: HRS_SITE_ID_PT |
| 12 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 13 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 14 | HRS_SRC_DRAFT_TMP | Character(30) | VARCHAR2(30) NOT NULL |
Draft Template
Prompt Table: HRS_SRC_NOTI_VW |
| 15 | HRS_SRC_REJECT_TMP | Character(30) | VARCHAR2(30) NOT NULL |
Rejected Template
Prompt Table: HRS_SRC_NOTI_VW |
| 16 | HRS_SRC_UNRSLV_TMP | Character(30) | VARCHAR2(30) NOT NULL |
Unresolved Template
Prompt Table: HRS_SRC_NOTI_VW |
| 17 | HRS_SRC_SUCCES_TMP | Character(30) | VARCHAR2(30) NOT NULL |
Success Template
Prompt Table: HRS_SRC_NOTI_VW |
| 18 | HRS_INFO_URL | Long Character(2000) | VARCHAR2(2000) | Used to store the URL to go to for information on a source. |