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 This column is for Oracle Internal use only. 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
REASON_ID NUMBER 38 0 The identifier of the reason at the time of the event. DW_TA_REASON_D REASON_ID
ACTION_ID NUMBER 38 0 The identifier of the action at the time of the event. DW_TA_ACTION_D ACTION_ID
EVENT_PERSON_ID NUMBER 38 0 The identifier of the event person at the time of 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 Application Event