# 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, 2026, Oracle and/or its affiliates.