HRS_JOB_OPENING_IDHRS_SRCH_APPLICACG=Candidate Gateway
TAM=Talent Aquisition Management
HRS_SEQ_NUMPrompt Table: HRS_LOCATION
HRS_RLOC_HIER(SQL Table) |
Index Back |
|---|---|
Job Opening Recruiting LocJob opening recruiting locations work table for Candidate Gateway |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 2 | HRS_SRCH_APPLICA |
Character(4) | VARCHAR2(4) NOT NULL |
application where the search location is used/
CG=Candidate Gateway TAM=Talent Aquisition Management |
| 3 | HRS_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | HRS_RECR_LOC_ALL | Long Character | CLOB | Location |
| 5 | HRS_RECR_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |
| 6 | HRS_RECR_LOC_LVL01 | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |
| 7 | HRS_RECR_LOC_LVL02 | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |
| 8 | HRS_RECR_LOC_LVL03 | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |
| 9 | HRS_RECR_LOC_LVL04 | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |
| 10 | HRS_RECR_LOC_LVL05 | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |
| 11 | HRS_LOCATION_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Recruiting location area
Prompt Table: HRS_LOCATION |
| 12 | HRS_LOC_ID_LVL01 | Number(15,0) | DECIMAL(15) NOT NULL | Recruiting location area within a recruiting location area |
| 13 | HRS_LOC_ID_LVL02 | Number(15,0) | DECIMAL(15) NOT NULL | Recruiting location area within a recruiting location area |
| 14 | HRS_LOC_ID_LVL03 | Number(15,0) | DECIMAL(15) NOT NULL | Recruiting location area within a recruiting location area |
| 15 | HRS_LOC_ID_LVL04 | Number(15,0) | DECIMAL(15) NOT NULL | Recruiting location area within a recruiting location area |
| 16 | HRS_LOC_ID_LVL05 | Number(15,0) | DECIMAL(15) NOT NULL | Recruiting location area within a recruiting location area |