HRS_LOCATION_IDPrompt Table: HRS_LOCATION
SETIDLANGUAGE_CDHRS_RLOC_MJP_LN(SQL Table) |
Index Back |
|---|---|
Job Opening Recruiting LocRelated Language Record for HRS_RLOC_MAP_JP. |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 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 |