Job Requisition Dimension
Module: Recruiting
REQUISITION_ID
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 | |
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 |