DW_TA_ROUTING_STEPS_D

This Dimension Stores the Routing details

Details

Module: Recruiting

Key Columns

ROUTING_STEP_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ROUTING_STEP_ID NUMBER 38 0 True Primary key for the Routing Step.
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Unique Source Record Identifier
TYPE_CODE VARCHAR2 32 Stores the type of the routing
PROCESS_ID NUMBER 38 0 Process Identifier DW_TA_PROCESS_D PROCESS_ID
SEQUENCE_NUMBER NUMBER 38 0 Determine the sequence number of the step whitin the immediate parent process
SUB_PROCESS_ID NUMBER 38 0 Stores the reference to the sub process within a process. DW_TA_PROCESS_D PROCESS_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
LAST_ACTIVATION_DATE TIMESTAMP Date when the step has been activated
LAST_DEACTIVATION_DATE TIMESTAMP Date when a step has been deactivated
STEP_STATUS VARCHAR2 32 Determines the status of the step