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     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    

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