DW_TA_JOB_REQ_SNAPSHOT_F

Requisition Snapshot Fact

Details

Module: Recruiting

Key Columns

REQUISITION_ID, CALENDAR_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
REQUISITION_ID NUMBER 38 0 True Requisition Identifier DW_TA_JOB_REQUISITION_D REQUISITION_ID
CALENDAR_DATE DATE True Calendar Date DW_DAY_D CALENDAR_DATE
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Source Record Identifier
REQ_PHASE_ID NUMBER 38 0 Requisition Phase Identifier DW_TA_PHASE_D PHASE_ID
REQ_STATE_ID NUMBER 38 0 Requisition State Identifier DW_TA_STATE_D STATE_ID
REQ_BUSINESS_UNIT_ID NUMBER 38 0 Business Unit Identifier of the Requisition DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
REQ_ORGANIZATION_ID NUMBER 38 0 Stores the organization identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
REQ_DEPARTMENT_ID NUMBER 38 0 Department Id of the Requisition DW_DEPARTMENT_D DEPARTMENT_ID
REQ_LOCATION_ID NUMBER 38 0 Location Identifier of the Requisition DW_WORKER_LOCATION_D LOCATION_ID
REQ_GEOGRAPHY_NODE_ID NUMBER 38 0 Geography Node Identifier of the Requisition DW_TA_GEO_HIERARICHAL_NODES_D GEOGRAPHY_NODE_ID
REQ_PROFILE_ID NUMBER 38 0 Profile Identifier Identifier of the Requisition DW_WORK_REQUIREMENT_D PROFILE_ID
REQ_JOB_ID NUMBER 38 0 Job Identifier Identifier of the Requisition DW_JOB_D JOB_ID
REQ_JOB_FAMILY_ID NUMBER 38 0 Job Family Identifier of the Requisition DW_JOB_FAMILY_D JOB_FAMILY_ID
REQ_JOB_FUNCTION_CODE VARCHAR2 32 Stores the job function as a lookup code DW_JOB_FUNCTION_D_TL JOB_FUNCTION_CODE
REQ_GRADE_ID NUMBER 38 0 Grade Identifier of the Requisition DW_PAY_GRADE_D GRADE_ID
REQ_POSITION_ID NUMBER 38 0 Position Identifier of the Requisition DW_POSITION_D POSITION_ID
REQ_LEGAL_EMPLOYER_ID NUMBER 38 0 Legal Employer Identifier of the Requisition DW_LEGAL_EMPLOYER_D LEGAL_EMPLOYER_ID
REQ_HIRING_MANAGER_ID NUMBER 38 0 Hiring Manager Identifier of the Requisition DW_PERSON_D PERSON_ID
REQ_MANAGER_ASSIGNMENT_ID NUMBER 38 0 Manager Assignment Identifier of the Requisition
REQ_RECRUITER_ID NUMBER 38 0 Recruiter Identifier of the Requisition DW_PERSON_D PERSON_ID
REQ_RECRUITER_ASSIGNMENT_ID NUMBER 38 0 Recruiter Assignment Identifier of the Requisition
REQ_PHASE_SEQUENCE_NUMBER NUMBER 38 0 Requisition Phase Sequence Number
REQ_STATE_SEQUENCE_NUMBER NUMBER 38 0 Requisition State Sequence Number
REQ_COUNT NUMBER 38 0 Metric defaulted to 1
APPLICATION_COUNT_HR_PHASE NUMBER 38 0 Count of the No. of Job Applications that are in HR Phase excluding those that have been Rejected or Withdrawn
APPLICATION_COUNT_HR_PHASE_PROCESSED NUMBER 38 0 Count of the No. of Job Applications that are Hired i.e. in Hr Processed Phase and State
APPLICATION_COUNT_OFFER_PHASE NUMBER 38 0 Count of the No. of Job Applications that are in Offer Phase excluding those that have been Rejected by Employer or Withdrawn By Candidate or are in To Be Created or Offer Approval Rejected states