Module: Work Asset Analytics
Type: Dimension
TIMESHEET_DETAIL_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| TIMESHEET_DETAIL_ID | VARCHAR2 | 14 | True | Timesheet Detail | |||
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| ADDER | NUMBER | 8 | 5 | Adder | |||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| CHARGE_TYPE_FLG | VARCHAR2 | 4 | Charge Type | ||||
| CREW_SHIFT_DIFF | NUMBER | 8 | 5 | Crew Shift Differential | |||
| CREW_SHIFT_TYPE_CD | VARCHAR2 | 30 | Crew Shift Type | ||||
| CREW_TYPE_CD | VARCHAR2 | 30 | Crew Type | ||||
| DIFF_CALC_TYPE_FLG | VARCHAR2 | 4 | Differential Calculation Type | ||||
| END_DTTM | TIMESTAMP | 0 | 6 | End Date/Time | |||
| EU_CLASS_FLG | VARCHAR2 | 4 | Employee Unavailability Class | ||||
| EU_TYPE_CD | VARCHAR2 | 30 | Employee Unavailability Type | ||||
| HOURS | NUMBER | 13 | 2 | Hours | |||
| LABOR_EARNING_TYPE_CD | VARCHAR2 | 30 | Labor Earning Type | ||||
| MULTIPLIER | NUMBER | 8 | 5 | Multiplier | |||
| OVERTIME_TYPE_CD | VARCHAR2 | 30 | Overtime Type | ||||
| PLANNING_HORIZON | NUMBER | 5 | 0 | Planning Horizon Days | |||
| PREM_RATE_MULTIPLIER | NUMBER | 8 | 5 | Premium Rate Multiplier | |||
| REG_OVERTIME_FLG | VARCHAR2 | 4 | Regular/Overtime | ||||
| SCHEDULE_PERIOD_FLG | VARCHAR2 | 4 | Schedule Period | ||||
| START_DTTM | TIMESTAMP | 0 | 6 | Start Date/Time | |||
| START_TM | TIMESTAMP | 0 | 6 | Start Time | |||
| TIMESHEET_DTL_STATUS_CD | VARCHAR2 | 12 | Timesheet Detail Status | ||||
| TRAVEL_TIME | NUMBER | 9 | 0 | Travel Time | |||
| UNIT_PRICE | NUMBER | 18 | 7 | Unit Price | |||
| W1_CREW_ID | VARCHAR2 | 12 | Crew | ||||
| W1_CREW_NAME | VARCHAR2 | 254 | Crew Name | ||||
| W1_DT | DATE | 0 | Charge Date | ||||
| W1_END_TM | TIMESTAMP | 0 | 6 | End Time | |||
| W1_TOTAL_COST | NUMBER | 17 | 3 | Total Cost | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |