DW_TA_PHASE_STATE_DETAILS_D

This dimension captures the Linkage between a Routing Step, Phase Id and State Id

Details

Module: Recruiting

Key Columns

STATE_ID, PHASE_ID, PROCESS_ID, MASTER_PROCESS_ID, ROUTING_STEP_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ROUTING_STEP_ID NUMBER 38 0 True Routing State Identifier DW_TA_ROUTING_STEPS_D ROUTING_STEP_ID
PHASE_ID NUMBER 38 0 True Phase Identifier DW_TA_PHASE_D PHASE_ID
STATE_ID NUMBER 38 0 True State Identifier DW_TA_STATE_D STATE_ID
PROCESS_ID NUMBER 38 0 True Process Id of the Routing Step    
MASTER_PROCESS_ID NUMBER 38 0 True Parent Process Id. Will point to the phase process id    
SOURCE_RECORD_ID VARCHAR2 256     Unique Key    
PHASE_SEQUENCE_NUMBER NUMBER 38 0   Sequence Number of the Phase    
STATE_SEQUENCE_NUMBER NUMBER 38 0   Sequence Number of the State