HRS_VNDR_SRC_VW(SQL View) |
Index Back |
|---|
| SELECT A.HRS_VENDOR_ID , A.HRS_SOURCE_ID , A.HRS_AUTOREJECT_ID , A.HRS_REVIEWREQ_ID , A.HRS_SOURCE_NOTIFY , A.HRS_RETAIN_POS , A.HRS_EXTRACTOR_ID , A.HRS_RESUME_FAIL , A.HRS_ADDQUEUE , A.HRS_SITE_ID , A.COUNTRY , A.LANGUAGE_CD , A.HRS_SRC_DRAFT_TMP , A.HRS_SRC_REJECT_TMP , A.HRS_SRC_UNRSLV_TMP , A.HRS_SRC_SUCCES_TMP FROM PS_HRS_SOURCE_VNDR A , PS_HRS_SOURCE B WHERE A.HRS_SOURCE_ID=B.HRS_SOURCE_ID AND A.EFFDT=B.EFFDT AND %CurrentDateIn BETWEEN B.EFFDT AND B.HRS_END_EFFDT AND B.HRS_SOURCE_STATUS='10' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HRS_VENDOR_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Integration Vendor ID
Prompt Table: HRS_VENDOR_PT |
| 2 | HRS_SOURCE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Source ID |
| 3 | 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 |
| 4 | 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 |
| 5 | 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 |
| 6 | 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 |
| 7 | HRS_EXTRACTOR_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Used to store the extractor in Source.
Prompt Table: HRS_EXTRCTR_PT |
| 8 | 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 |
| 9 | 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 |
| 10 | HRS_SITE_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Site ID
Prompt Table: HRS_SITE_ID_PT |
| 11 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 12 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 13 | HRS_SRC_DRAFT_TMP | Character(30) | VARCHAR2(30) NOT NULL |
Draft Template
Prompt Table: HRS_SRC_NOTI_VW |
| 14 | HRS_SRC_REJECT_TMP | Character(30) | VARCHAR2(30) NOT NULL |
Rejected Template
Prompt Table: HRS_SRC_NOTI_VW |
| 15 | HRS_SRC_UNRSLV_TMP | Character(30) | VARCHAR2(30) NOT NULL |
Unresolved Template
Prompt Table: HRS_SRC_NOTI_VW |
| 16 | HRS_SRC_SUCCES_TMP | Character(30) | VARCHAR2(30) NOT NULL |
Success Template
Prompt Table: HRS_SRC_NOTI_VW |