DW_TA_JOB_REQ_HISTORY_EVENT_F

Stores Talent Requisition history Event details

Details

Module: Recruiting

Key Columns

EVENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
EVENT_ID NUMBER 38 0 True Primary key of the table
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Primary Key
EVENT_DATE TIMESTAMP Event creation Date
REQUISITION_ID NUMBER 38 0 The identifier of the Requisition. DW_TA_JOB_REQUISITION_D REQUISITION_ID
EVENT_TYPE_ID NUMBER 38 0 The identifier of the event type. DW_TA_HISTORY_EVENT_TYPE_D EVENT_TYPE_ID
PHASE_ID NUMBER 38 0 The identifier of the phase at the time of the event. DW_TA_PHASE_D PHASE_ID
STATE_ID NUMBER 38 0 The identifier of the state at the time of the event. DW_TA_STATE_D STATE_ID
ROUTING_STEP_ID NUMBER 38 0 The identifier of the routing step that triggered the event. DW_TA_ROUTING_STEPS_D ROUTING_STEP_ID
EVENT_PERSON_ID NUMBER 38 0 The identifier of the person who triggered the event. DW_PERSON_D PERSON_ID
STEP_DURATION NUMBER 38 0 Duration of the step
CREATION_DATE TIMESTAMP Source Creation Date of the Job Requisition Event