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.