Labor Hours
Module: Work Asset Analytics
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ACT_ID | VARCHAR2 | 38 | Asset Activity | DW_EWWA_X_EWDI_WACS_W1_ACTIVITY_D | ACT_ID | ||
| ASSET_ID | VARCHAR2 | 38 | Asset | DW_EWWA_X_EWDI_WACS_W1_ASSET_D | ASSET_ID | ||
| COST_CENTER_CD | VARCHAR2 | 30 | Cost Center | DW_EWWA_X_EWDI_WACS_W1_COST_CENTER_D | COST_CENTER_CD | ||
| EXPENSE_CD | VARCHAR2 | 38 | Expense Code | DW_EWWA_X_EWDI_WACS_W1_EXPENSE_CD_D | EXPENSE_CD | ||
| RESRC_TYPE_ID | VARCHAR2 | 12 | Resource Type | DW_EWWA_X_EWDI_WACS_W1_RESRC_TYPE_D | RESRC_TYPE_ID | ||
| TIMESHEET_DETAIL_ID | VARCHAR2 | 14 | Timesheet Detail | DW_EWWA_X_EWDI_WACS_W1_TIMESHEET_DETAIL_D | TIMESHEET_DETAIL_ID | ||
| W1_FT_ID | VARCHAR2 | 14 | Financial Transaction | DW_EWWA_X_EWDI_WACS_W1_FT_D | W1_FT_ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 190 | Source Record Id | ||||
| A1_USER_ID | VARCHAR2 | 38 | Work and Asset User | DW_EWWA_X_EWDI_WACS_SC_USER_D | USER_ID | ||
| ACTVN_DT | NUMBER | 38 | 0 | Activation Date | |||
| ACTVN_TM | NUMBER | 38 | 0 | Activation Time | |||
| ACT_RESRC_FT_CNT | NUMBER | 38 | 0 | # Labor Hours Transaction | |||
| ACT_TYPE_CD | VARCHAR2 | 38 | Asset Activity Type | DW_EWWA_X_EWDI_WACS_W1_ACTIVITY_TYPE_D | ACT_TYPE_CD | ||
| ACT_WORK_CATEGORY_CD | VARCHAR2 | 38 | Work Category - Activity | DW_EWWA_X_EWDI_WACS_W1_WORK_CATEGORY_D | WORK_CATEGORY_CD | ||
| ACT_WORK_CLASS_CD | VARCHAR2 | 38 | Work Class - Activity | DW_EWWA_X_EWDI_WACS_W1_WORK_CLASS_D | WORK_CLASS_CD | ||
| AMT | NUMBER | 38 | 2 | Amount | |||
| CHARGED_LABOR_HRS | NUMBER | 38 | 2 | Total Labor Hours | |||
| CM_ACT_LABOR_HRS | NUMBER | 38 | 5 | Total Labor Hours - Corrective Maintenance | |||
| CONSTR_ACT_LABOR_HRS | NUMBER | 38 | 2 | Total Labor Hours - Construction Work | |||
| COST_CATEGORY_CD | VARCHAR2 | 30 | Cost Category | DW_EWWA_X_EWDI_WACS_W1_COST_CATEGORY_D | COST_CATEGORY_CD | ||
| EMERGENCY_LABOR_HRS | NUMBER | 38 | 2 | Labor Hours - Emergency Work | |||
| FT_CRE_DT | NUMBER | 38 | 0 | Financial Transaction Date | |||
| FT_CRE_TM | NUMBER | 38 | 0 | Financial Transaction Time | |||
| LOC_ORG_HIERARCHY_NODE_ID | VARCHAR2 | 38 | Location/Organization Hierarchy | DW_EWWA_X_EWDI_WACS_W1_BI_NODE_HIERARCHY_D | LOC_ORG_NODE_ID | ||
| LOC_ORG_NODE_ID | VARCHAR2 | 38 | Location/Organization | DW_EWWA_X_EWDI_WACS_W1_NODE_D | ASSET_ORG_NODE_ID | ||
| MAINT_ACT_LABOR_HRS | NUMBER | 38 | 2 | Total Labor Hours - Maintenance Work | |||
| ORIGINAL_WORK_DT | NUMBER | 38 | 0 | Original Work Date | |||
| OVERTIME_CM_ACT_LABOR_HRS | NUMBER | 38 | 5 | Overtime Labor Hours - Corrective Maintenance | |||
| OVERTIME_CONSTR_ACT_LABOR_HRS | NUMBER | 38 | 2 | Overtime Labor for Construction Work | |||
| OVERTIME_EMERGENCY_LABOR_HRS | NUMBER | 38 | 5 | Overtime Labor Hours - Emergency Work | |||
| OVERTIME_LABOR_HRS | NUMBER | 38 | 5 | Total Overtime Labor Hours | |||
| OVERTIME_PM_ACT_LABOR_HRS | NUMBER | 38 | 5 | Overtime Labor Hours - Preventive Maintenance | |||
| OWNING_ACCESS_GRP_CD | VARCHAR2 | 38 | Owning Organization | ||||
| PLANNER_CD | VARCHAR2 | 38 | Planner | DW_EWWA_X_EWDI_WACS_W1_PLANNER_D | PLANNER_CD | ||
| PM_ACT_LABOR_HRS | NUMBER | 38 | 2 | Total Labor Hours - Preventive Maintenance | |||
| PRJ_ID | VARCHAR2 | 38 | Project | DW_EWWA_X_EWDI_WACS_W1_PROJECT_D | PRJ_ID | ||
| REGULAR_CM_ACT_LABOR_HRS | NUMBER | 38 | 5 | Regular Labor Hours - Corrective Maintenance | |||
| REGULAR_CONSTR_ACT_LABOR_HRS | NUMBER | 38 | 2 | Regular Labor Hours Construction Work | |||
| REGULAR_EMERGENCY_LABOR_HRS | NUMBER | 38 | 5 | Regular Labor Hours - Emergency Work | |||
| REGULAR_LABOR_HRS | NUMBER | 38 | 2 | Total Regular Labor Hours | |||
| REGULAR_PM_ACT_LABOR_HRS | NUMBER | 38 | 2 | Regular Labor Hours - Preventive Maintenance | |||
| REQUIRED_BY_DT | NUMBER | 38 | 0 | Required By Date | |||
| SERVICE_CLASS_CD | VARCHAR2 | 38 | Service Class | DW_EWWA_X_EWDI_WACS_W1_SERVICE_CLASS_D | SERVICE_CLASS_CD | ||
| TMPL_ACT_ID | VARCHAR2 | 38 | Template Activity | DW_EWWA_X_EWDI_WACS_W1_TMPL_ACT_D | TMPL_ACT_ID | ||
| W1_CREW_ID | VARCHAR2 | 38 | Crew | DW_EWWA_X_EWDI_WACS_W1_CREW_D | W1_CREW_ID | ||
| WORK_WIN_END_DT | NUMBER | 38 | 0 | Work Window End Date | |||
| WORK_WIN_END_TM | NUMBER | 38 | 0 | Work Window End Time | |||
| WORK_WIN_START_DT | NUMBER | 38 | 0 | Work Window Start Date | |||
| WORK_WIN_START_TM | NUMBER | 38 | 0 | Work Window Start Time | |||
| WO_ID | VARCHAR2 | 38 | Work Order | DW_EWWA_X_EWDI_WACS_W1_WO_D | WO_ID | ||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |