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     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
STEP_DURATION NUMBER 38 0   Duration of the step