Timesheet Detail
Module: Work Asset Analytics
Type: Fact
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 | ||||
| A1_USER_ID | VARCHAR2 | 8 | Work and Asset User | DW_EWWA_X_EWDI_WACS_SC_USER_D | USER_ID | ||
| ACT_ID | VARCHAR2 | 38 | Asset Activity | DW_EWWA_X_EWDI_WACS_W1_ACTIVITY_D | ACT_ID | ||
| ACT_RESRC_REQMT_ID | VARCHAR2 | 38 | Activity Resource Requirement | ||||
| BO_STATUS_REASON_CD | VARCHAR2 | 38 | Status Reason | ||||
| BUS_OBJ_CD | VARCHAR2 | 30 | Business Object | ||||
| CHARGE_TYPE_FLG | VARCHAR2 | 4 | Charge Type | ||||
| CREW_SHIFT_TYPE_CD | VARCHAR2 | 38 | Crew Shift Type | DW_EWWA_X_EWDI_WACS_W1_CREW_SHIFT_TYPE_D | CREW_SHIFT_TYPE_CD | ||
| CRE_DT | NUMBER | 38 | 0 | Creation Date | |||
| CRE_TM | NUMBER | 38 | 0 | Creation Time | |||
| END_DT | NUMBER | 38 | 0 | End Date | |||
| END_TM | NUMBER | 38 | 0 | End Time | |||
| EU_ID | VARCHAR2 | 38 | Employee Unavailability ID | ||||
| EU_TYPE_CD | VARCHAR2 | 38 | Employee Unavailability Type | DW_EWWA_X_EWDI_WACS_W1_EU_TYPE_D | EU_TYPE_CD | ||
| EXPENSE_CD | VARCHAR2 | 38 | Expense Code | DW_EWWA_X_EWDI_WACS_W1_EXPENSE_CD_D | EXPENSE_CD | ||
| HOURS | NUMBER | 13 | 2 | Hours | |||
| LABOR_EARNING_TYPE_CD | VARCHAR2 | 38 | Labor Earning Type | DW_EWWA_X_EWDI_WACS_W1_LABOR_EARNING_TYPE_D | LABOR_EARNING_TYPE_CD | ||
| OVERTIME_TYPE_CD | VARCHAR2 | 38 | Overtime Type | DW_EWWA_X_EWDI_WACS_W1_OVERTIME_TYPE_D | OVERTIME_TYPE_CD | ||
| OWNING_ACCESS_GRP_CD | VARCHAR2 | 38 | Owning Organization | ||||
| PRJ_ID | VARCHAR2 | 38 | Project | DW_EWWA_X_EWDI_WACS_W1_PROJECT_D | PRJ_ID | ||
| REG_OVERTIME_FLG | VARCHAR2 | 4 | Regular/Overtime | ||||
| RESRC_TYPE_ID | VARCHAR2 | 12 | Resource Type | DW_EWWA_X_EWDI_WACS_W1_RESRC_TYPE_D | RESRC_TYPE_ID | ||
| START_DT | NUMBER | 38 | 0 | Start Date | |||
| START_TM | NUMBER | 38 | 0 | Start Time | |||
| STATUS_UPD_DT | NUMBER | 38 | 0 | Status Date | |||
| STATUS_UPD_TM | NUMBER | 38 | 0 | Status Time | |||
| TIMESHEET_DTL_STATUS_CD | VARCHAR2 | 38 | Timesheet Detail Status | ||||
| TRAVEL_TIME | NUMBER | 13 | 5 | Travel Time | |||
| UNIT_PRICE | NUMBER | 18 | 7 | Unit Price | |||
| VERSION | NUMBER | 5 | 0 | Version | |||
| W1_CREW_ID | VARCHAR2 | 38 | Crew | DW_EWWA_X_EWDI_WACS_W1_CREW_D | W1_CREW_ID | ||
| W1_DT | NUMBER | 38 | 0 | Charge Date | |||
| W1_TIMESHEET_ID | VARCHAR2 | 14 | Timesheet | DW_EWWA_X_EWDI_WACS_W1_TIMESHEET_D | W1_TIMESHEET_ID | ||
| W1_TOTAL_COST | NUMBER | 17 | 3 | Total Cost | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |