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    

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