# DW_TA_JOB_REQUISITION_D

Job Requisition Dimension

## Details

Module: Recruiting

## Key Columns

REQUISITION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
REQUISITION_ID | NUMBER | 38 | 0 | True | Requisition identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Source record identifier |  |
REQUISITION_NUMBER | VARCHAR2 | 256 |  |  | Unique readable number for the Requistion. |  |
PIPELINE_REQUISITION_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates if the requisition is of type Pipeline |  |
RECRUITING_TYPE_CODE | VARCHAR2 | 32 |  |  | Stores the type of Recruiting as a lookup code.Values are from the table DW_HCM_CODE_VALUES_LKP_TL with CODE_TYPE=ORA_IRC_RECRUITING_TYPE. | DW_HCM_CODE_VALUES_LKP_TL | CODE
NUMBER_TO_HIRE | NUMBER | 38 | 0 |  | Stores the number of people to hire for this Requisition |  |
UNLIMITED_HIRE_FLAG | VARCHAR2 | 16 |  |  | Stores whether this Requisition can hire unlimited number of people |  |
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business Unit Indentifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
DEPARTMENT_ID | NUMBER | 38 | 0 |  | Department Identifier | DW_DEPARTMENT_D | DEPARTMENT_ID
LOCATION_ID | NUMBER | 38 | 0 |  | Location Identifier | DW_WORKER_LOCATION_D | LOCATION_ID
JOB_ID | NUMBER | 38 | 0 |  | Job Identifier | DW_JOB_D | JOB_ID
JOB_FAMILY_ID | NUMBER | 38 | 0 |  | Job Family Identifier | DW_JOB_FAMILY_D | JOB_FAMILY_ID
JOB_FUNCTION_CODE | VARCHAR2 | 32 |  |  | Stores the job function as a lookup code | DW_JOB_FUNCTION_D_TL | JOB_FUNCTION_CODE
GRADE_ID | NUMBER | 38 | 0 |  | Grade Identifier | DW_PAY_GRADE_D | GRADE_ID
POSITION_ID | NUMBER | 38 | 0 |  | Position Identifier | DW_POSITION_D | POSITION_ID
LEGAL_EMPLOYER_ID | NUMBER | 38 | 0 |  | legal employer identifier | DW_LEGAL_EMPLOYER_D | LEGAL_EMPLOYER_ID
HIRING_MANAGER_ID | NUMBER | 38 | 0 |  | Hiring Manager Identifier | DW_PERSON_D | PERSON_ID
RECRUITER_ID | NUMBER | 38 | 0 |  | Recruiter identifier | DW_PERSON_D | PERSON_ID
INT_PUBLISH_JOB_START_DATE | DATE |  |  |  | Internal published job start date |  |
INT_PUBLISH_JOB_END_DATE | DATE |  |  |  | Internal published job end date |  |
EXT_PUBLISH_JOB_START_DATE | DATE |  |  |  | External published job start date |  |
EXT_PUBLISH_JOB_END_DATE | DATE |  |  |  | External published job end date |  |
INTERNAL_PUBLISH_JOB_STATUS | VARCHAR2 | 32 |  |  | Stores the Internal published job status |  |
EXTERNAL_PUBLISH_JOB_STATUS | VARCHAR2 | 32 |  |  | Stores the external published job status |  |
PROFILE_ID | NUMBER | 38 | 0 |  | Stores the corresponding job profile ID | DW_WORK_REQUIREMENT_D | PROFILE_ID
GEOGRAPHY_NODE_ID | NUMBER | 38 | 0 |  | Stores the corresponding geography node ID | DW_TA_GEO_HIERARICHAL_NODES_D | GEOGRAPHY_NODE_ID
PROCESS_ID | NUMBER | 38 | 0 |  | Stores the Process Identifier | DW_TA_PROCESS_D | PROCESS_ID
CURRENT_PHASE_ID | NUMBER | 38 | 0 |  | phase identifier | DW_TA_PHASE_D | PHASE_ID
CURRENT_STATE_ID | NUMBER | 38 | 0 |  | state identifier | DW_TA_STATE_D | STATE_ID
RECRUITER_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Stores the ASSIGNMENT_ID of the recruiters assignment for this Requisition |  |
MANAGER_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Stores the ASSIGNMENT_ID of the hiring manager assignment for this Requisition |  |
SUBS_PROCESS_TEMPLATE_ID | NUMBER | 38 | 0 |  | Stores the process template ID that submissions on this requisition will follow |  |
ORGANIZATION_ID | NUMBER | 38 | 0 |  | Stores the organization identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
WORKER_TYPE_CODE | VARCHAR2 | 32 |  |  | Stores the worker type as a lookup code | DW_WORKER_TYPE_D_TL | WORKER_TYPE
FULL_PART_TIME | VARCHAR2 | 32 |  |  | Stores whether the opening is for a full or part time job.Values are from the table DW_HCM_CODE_VALUES_LKP_TL with CODE_TYPE=PART_FULL_TIME. | DW_HCM_CODE_VALUES_LKP_TL | CODE
REGULAR_TEMPORARY | VARCHAR2 | 32 |  |  | Stores whether the opening is for a regular or temporary job.Values are from the table DW_HCM_CODE_VALUES_LKP_TL with CODE_TYPE=REGULAR_TEMPORARY. | DW_HCM_CODE_VALUES_LKP_TL | CODE
STUDY_LEVEL_CODE | VARCHAR2 | 32 |  |  | Stores the study level for this Requisition as a lookup code.Values are from the table DW_HCM_CODE_VALUES_LKP_TL with CODE_TYPE=HRT_EDUCATION_LEVEL. | DW_HCM_CODE_VALUES_LKP_TL | CODE
OPEN_DATE | TIMESTAMP |  |  |  | requisition open date |  |
SRC_RECORD_CREATION_DATE | TIMESTAMP |  |  |  | creation date |  |
SRC_RECORD_CREATED_BY_ID | VARCHAR2 | 128 |  |  | who created this record |  |
SUSPENDED_DURATION | NUMBER | 38 | 0 |  | Suspended duration of the requisition in seconds |  |
FILLED_DATE | TIMESTAMP |  |  |  | Stores the date at which Job Requisition is Filled |  |
EXT_FIRST_POSTED_DATE | TIMESTAMP |  |  |  | First External Posted Date of Requisition |  |
INT_FIRST_POSTED_DATE | TIMESTAMP |  |  |  | First Internal Posted Date of Requisition |  |
APPROVED_DATE | TIMESTAMP |  |  |  | Approved date of the requisition |  |
HOT_JOB_FLAG | VARCHAR2 | 16 |  |  | Stores whether this Requisition should be considerate as a Hot Job or not |  |
JUSTIFICATION_CODE | VARCHAR2 | 32 |  |  | Stores the Justification for this Requisition as a lookup code. | DW_TA_REQ_JUSTIFICATION_D_TL | CODE
MANAGER_LEVEL | VARCHAR2 | 32 |  |  | Stores the manager level as a lookup code | DW_TA_MANAGER_LEVEL_D_TL | CODE
OBJECT_STATUS | VARCHAR2 | 32 |  |  | Stores the status of the Object | DW_TA_OBJECT_STATUS_D_TL | CODE
JOB_SHIFT_CODE | VARCHAR2 | 32 |  |  | Stores the job shift for this Requisition as a lookup code. | DW_TA_JOB_SHIFT_D_TL | CODE
JOB_TYPE_CODE | VARCHAR2 | 32 |  |  | Stores the job type for this Requisition as a lookup code. | DW_TA_JOB_TYPE_D_TL | CODE
EXTERNAL_APPLY_FLOW_ID | NUMBER | 38 | 0 |  | Apply Flow used for external candidates applying on this requisition | DW_TA_APPLICATION_FLOW_D | APPLY_FLOW_ID
AUTOMATIC_FILL_FLAG | VARCHAR2 | 16 |  |  | Stores whether the requisition can be auto-filled. |  |
APPLY_WHEN_NOT_POSTED_FLAG | VARCHAR2 | 16 |  |  | Stores whether the candidate can apply on a requisition when not posted. |  |
AUTO_OPEN | VARCHAR2 | 32 |  |  | Stores whether the requisition can be auto posted. | DW_TA_REQ_AUTO_POST_D_TL | CODE
AUTO_UNPOST | VARCHAR2 | 32 |  |  | Stores whether the requisition can be auto unposted | DW_TA_REQ_AUTO_UNPOST_D_TL | CODE
BUDGET_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Stores the currency code for the budget for this Requisition |  |
EMPLOYEE_REFERRAL_BONUS | NUMBER |  |  |  | Stores the amount for employee referral bonus. |  |
SOURCING_BUDGET | NUMBER |  |  |  | Stores the sourcing budget for this Requisition. |  |
TRAVEL_BUDGET | NUMBER |  |  |  | Stores the travel budget for this Requisition. |  |
RELOCATION_BUDGET | NUMBER |  |  |  | Stores the relocation budget allocated for this Requisition. |  |
WORK_START_DATE | TIMESTAMP |  |  |  | Stores the Work start date of the job requisition |  |
WORK_END_DATE | TIMESTAMP |  |  |  | Stores the Work end date of the job requisition |  |
SALARY_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Stores the salary currency information |  |
SALARY_FREQUENCY_CODE | VARCHAR2 | 32 |  |  | Stores the salary frequency as a lookup code. |  |
MAX_SALARY | NUMBER |  |  |  | Stores the maximum salary for this Requisition. |  |
MIN_SALARY | NUMBER |  |  |  | Stores the minimum salary for this Requisition. |  |
SALARY_PERIOD_CODE | VARCHAR2 | 32 |  |  | Stores the salary period as a lookup code. |  |
WORKPLACE_TYPE_CODE | VARCHAR2 | 32 |  |  | Workplace type code. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.