Module: Work Asset Analytics
Type: Dimension
CREW_SHIFT_TYPE_CD
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CREW_SHIFT_TYPE_CD | VARCHAR2 | 30 | True | Crew Shift Type | |||
| SOURCE_RECORD_ID | VARCHAR2 | 30 | Source Record Id | ||||
| CREW_SHIFT_DIFF | NUMBER | 8 | 5 | Crew Shift Differential | |||
| DIFF_CALC_TYPE_FLG | VARCHAR2 | 38 | Differential Calculation Type | ||||
| SCHEDULE_PERIOD_FLG | VARCHAR2 | 4 | Schedule Period | ||||
| START_TM | TIMESTAMP | 0 | 6 | Start Time | |||
| W1_END_TM | TIMESTAMP | 0 | 6 | End Time | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |