This is a derived fact based on DW_TA_JOB_REQ_HISTORY_EVENT_F with all dimension references
Module: Recruiting
REQ_EVENT_ID
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 |