HRS_LOCATION_IDPrompt Table: HRS_LOCATION
SETIDHRS_RLOC_MAP(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_LOCATION_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Recruiting location area
Prompt Table: HRS_LOCATION |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | HRS_RECR_LOC_ALL | Long Character | CLOB | Location |
| 4 | HRS_RECR_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |
| 5 | HRS_RECR_LOC_LVL01 | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |
| 6 | HRS_RECR_LOC_LVL02 | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |
| 7 | HRS_RECR_LOC_LVL03 | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |
| 8 | HRS_RECR_LOC_LVL04 | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |
| 9 | HRS_RECR_LOC_LVL05 | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |
| 10 | HRS_LOC_ID_LVL01 | Number(15,0) | DECIMAL(15) NOT NULL | Recruiting location area within a recruiting location area |
| 11 | HRS_LOC_ID_LVL02 | Number(15,0) | DECIMAL(15) NOT NULL | Recruiting location area within a recruiting location area |
| 12 | HRS_LOC_ID_LVL03 | Number(15,0) | DECIMAL(15) NOT NULL | Recruiting location area within a recruiting location area |
| 13 | HRS_LOC_ID_LVL04 | Number(15,0) | DECIMAL(15) NOT NULL | Recruiting location area within a recruiting location area |
| 14 | HRS_LOC_ID_LVL05 | Number(15,0) | DECIMAL(15) NOT NULL | Recruiting location area within a recruiting location area |