DW_TA_JOB_APP_HISTORY_EVENT_F

Job Application History Event Fact

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 History Event Identifier    
SOURCE_RECORD_ID VARCHAR2 128     Source Record Identifier    
EVENT_DATE TIMESTAMP       Date and time of event    
JOB_APPLICATION_ID NUMBER 38 0   Application identifier DW_TA_JOB_APPLICATION_D JOB_APPLICATION_ID
EVENT_TYPE_ID NUMBER 38 0   Event type identifier DW_TA_HISTORY_EVENT_TYPE_D EVENT_TYPE_ID
PHASE_ID NUMBER 38 0   Phase identifier DW_TA_PHASE_D PHASE_ID
STATE_ID NUMBER 38 0   State identifier 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    

Copyright © 2019, 2022, Oracle and/or its affiliates.