This Dimension Stores the Routing details
Module: Recruiting
ROUTING_STEP_ID
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 | 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 |