DW_TA_JOB_REQ_EVENT_F

This is a derived fact based on DW_TA_JOB_REQ_HISTORY_EVENT_F with all dimension references

Details

Module: Recruiting

Key Columns

REQ_EVENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
REQ_EVENT_ID NUMBER 38 0 True Requisistion Event Identifier    
SOURCE_RECORD_ID VARCHAR2 64     Primary Key    
REQ_EVENT_DATE TIMESTAMP       Event creation Date in Timestamp    
REQUISITION_ID NUMBER 38 0   The identifier of the Requisition. DW_TA_JOB_REQUISITION_D REQUISITION_ID
REQ_EVENT_TYPE_ID NUMBER 38 0   The identifier of the event type. DW_TA_HISTORY_EVENT_TYPE_D EVENT_TYPE_ID
REQ_PHASE_ID NUMBER 38 0   The identifier of the phase at the time of the event. DW_TA_PHASE_D PHASE_ID
REQ_STATE_ID NUMBER 38 0   The identifier of the state at the time of the event. DW_TA_STATE_D STATE_ID
REQ_ROUTING_STEP_ID NUMBER 38 0   The identifier of the routing step that triggered the event. DW_TA_ROUTING_STEPS_D ROUTING_STEP_ID
REQ_BUSINESS_UNIT_ID NUMBER 38 0   Business Unit Identifier 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 Identifier DW_DEPARTMENT_D DEPARTMENT_ID
REQ_LOCATION_ID NUMBER 38 0   Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
REQ_GEOGRAPHY_NODE_ID NUMBER 38 0   Geography Node Identifier DW_TA_GEO_HIERARICHAL_NODES_D GEOGRAPHY_NODE_ID
REQ_PROFILE_ID NUMBER 38 0   Profile Identifier DW_WORK_REQUIREMENT_D PROFILE_ID
REQ_JOB_ID NUMBER 38 0   Job Identifier DW_JOB_D JOB_ID
REQ_JOB_FAMILY_ID NUMBER 38 0   Job Family Identifier DW_JOB_FAMILY_D JOB_FAMILY_ID
REQ_GRADE_ID NUMBER 38 0   Grade Identifier DW_PAY_GRADE_D GRADE_ID
REQ_POSITION_ID NUMBER 38 0   Position Identifier DW_POSITION_D POSITION_ID
REQ_LEGAL_EMPLOYER_ID NUMBER 38 0   Legal Employer Identifier DW_LEGAL_EMPLOYER_D LEGAL_EMPLOYER_ID
REQ_HIRING_MANAGER_ID NUMBER 38 0   Hiring Manager Identifier DW_PERSON_D PERSON_ID
REQ_MANAGER_ASSIGNMENT_ID NUMBER 38 0   Manager Assignment Identifier    
REQ_RECRUITER_ID NUMBER 38 0   Recruiter Identifier DW_PERSON_D PERSON_ID
REQ_RECRUITER_ASSIGNMENT_ID NUMBER 38 0   Recruiter Assignment Identifier    
REQ_PHASE_SEQUENCE_NUMBER NUMBER 38 0   Requisition Phase Sequence Number    
REQ_STATE_SEQUENCE_NUMBER NUMBER 38 0   Requisition State Sequence Number    
REQ_EVENT_COUNT NUMBER 38 0   Requisistion Event Count    
REQ_PHASE_COUNT NUMBER 38 0   Requisistion Phase Count    
REQ_STATE_COUNT NUMBER 38 0   Requisistion state Count    
REQ_EVENT_CALENDAR_DATE DATE       Event creation Date in date format