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