DW_TA_JOB_REQUISITION_D
Job Requisition Dimension
Details
Module: Recruiting
Key Columns
REQUISITION_ID
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. |