Activity Cost
Module: Work Asset Analytics
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ACT_ID | VARCHAR2 | 14 | Asset Activity | DW_EWWA_X_EWDI_WACS_W1_ACTIVITY_D | ACT_ID | ||
| ASSET_ID | VARCHAR2 | 12 | 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 | ||
| W1_FT_ID | VARCHAR2 | 38 | Financial Transaction | DW_EWWA_X_EWDI_WACS_W1_FT_D | W1_FT_ID | ||
| W1_RESRC_CLASS_FLG | VARCHAR2 | 38 | Resource Class | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 214 | Source Record Id | ||||
| A1_USER_ID | VARCHAR2 | 8 | Work and Asset User | DW_EWWA_X_EWDI_WACS_SC_USER_D | USER_ID | ||
| ACQUISITION_DT | NUMBER | 38 | 0 | Acquisition Date | |||
| ACTVN_DT | NUMBER | 38 | 0 | Activation Date | |||
| ACTVN_TM | NUMBER | 38 | 0 | Activation Time | |||
| ACT_CRE_DT | NUMBER | 38 | 0 | Activity Creation Date | |||
| ACT_CRE_TM | NUMBER | 38 | 0 | Activity Creation Time | |||
| ACT_TYPE_CD | VARCHAR2 | 30 | 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 | ||
| ASSET_ACT_COUNT | NUMBER | 38 | 0 | # Asset/Activity Cost Transactions | |||
| ASSET_LOC_HIERARCHY_NODE_ID | VARCHAR2 | 12 | Asset Location Hierarchy | DW_EWWA_X_EWDI_WACS_W1_BI_NODE_HIERARCHY_D | LOC_ORG_NODE_ID | ||
| COMPL_ACTUAL_COST | NUMBER | 38 | 3 | Actual Cost of Completed Activities | |||
| COMPL_ACTUAL_EQUIP_COST | NUMBER | 38 | 3 | Actual Equip Costs of Completed Activities | |||
| COMPL_ACTUAL_LABOR_COST | NUMBER | 38 | 3 | Actual Labor Costs of Completed Activities | |||
| COMPL_ACTUAL_MATL_COST | NUMBER | 38 | 3 | Actual Material Costs of Completed Activities | |||
| COMPL_ACTUAL_ODC_COST | NUMBER | 38 | 3 | Actual Misc Costs of Completed Activities | |||
| COMPL_EST_COST | NUMBER | 38 | 3 | Est Cost of Completed Activities | |||
| COMPL_EST_EQUIP_COST | NUMBER | 38 | 3 | Est Equip Costs of Completed Activities | |||
| COMPL_EST_LABOR_COST | NUMBER | 38 | 3 | Est Labor Costs of Completed Activities | |||
| COMPL_EST_MATL_COST | NUMBER | 38 | 3 | Est Material Costs of Completed Activities | |||
| COMPL_EST_ODC_COST | NUMBER | 38 | 3 | Est Misc. Costs of Completed Activities | |||
| COST_CATEGORY_CD | VARCHAR2 | 30 | Cost Category | DW_EWWA_X_EWDI_WACS_W1_COST_CATEGORY_D | COST_CATEGORY_CD | ||
| EST_EQUIPMENT_COST | NUMBER | 38 | 3 | Est Equip Cost of Activities | |||
| EST_LABOR_COST | NUMBER | 38 | 3 | Est Labor Cost of Activities | |||
| EST_MATERIAL_COST | NUMBER | 38 | 3 | Est Material Cost of Activities | |||
| EST_ODC_COST | NUMBER | 38 | 3 | Est Misc Cost of Activities | |||
| FAILURE_COUNT | NUMBER | 38 | 5 | Failure Count | |||
| FAILURE_REPAIR_COST | NUMBER | 38 | 2 | Failure Repair Cost | |||
| FT_CRE_DT | NUMBER | 38 | 0 | Financial Transaction Date | |||
| FT_CRE_TM | NUMBER | 38 | 0 | Financial Transaction Time | |||
| IN_SERVICE_DT | NUMBER | 38 | 0 | In Service Date | |||
| MAINTENANCE_CM_COST | NUMBER | 38 | 3 | Corrective Maintenance Cost Charged | |||
| MAINTENANCE_CM_EQUIP_COST | NUMBER | 38 | 3 | Corrective Maintenance Equip Cost Charged | |||
| MAINTENANCE_CM_LABOR_COST | NUMBER | 38 | 3 | Corrective Maintenance Labor Cost Charged | |||
| MAINTENANCE_CM_MATL_COST | NUMBER | 38 | 3 | Corrective Maintenance Material Cost Charged | |||
| MAINTENANCE_CM_ODC_COST | NUMBER | 38 | 3 | Corrective Maintenance ODC Cost Charged | |||
| MAINTENANCE_COST | NUMBER | 38 | 2 | Maintenance Cost | |||
| MAINTENANCE_EM_COST | NUMBER | 38 | 3 | Emergency Maintenance Cost Charged | |||
| MAINTENANCE_EM_EQUIP_COST | NUMBER | 38 | 3 | Emergency Maintenance Equip Cost Charged | |||
| MAINTENANCE_EM_LABOR_COST | NUMBER | 38 | 3 | Emergency Maintenance Labor Cost Charged | |||
| MAINTENANCE_EM_MATL_COST | NUMBER | 38 | 3 | Emergency Maintenance Material Cost Charged | |||
| MAINTENANCE_EM_ODC_COST | NUMBER | 38 | 3 | Emergency Maintenance ODC Cost Charged | |||
| MAINTENANCE_EQUIP_COST | NUMBER | 38 | 3 | Maintenance Equip Cost Charged | |||
| MAINTENANCE_LABOR_COST | NUMBER | 38 | 3 | Maintenance Labor Cost Charged | |||
| MAINTENANCE_MATL_COST | NUMBER | 38 | 3 | Maintenance Material Cost Charged | |||
| MAINTENANCE_ODC_COST | NUMBER | 38 | 3 | Maintenance ODC Cost Charged | |||
| MAINTENANCE_PM_COST | NUMBER | 38 | 3 | Preventive Maintenance Cost Charged | |||
| MAINTENANCE_PM_EQUIP_COST | NUMBER | 38 | 3 | Preventive Maintenance Equip Cost Charged | |||
| MAINTENANCE_PM_LABOR_COST | NUMBER | 38 | 3 | Preventive Maintenance Labor Cost Charged | |||
| MAINTENANCE_PM_MATL_COST | NUMBER | 38 | 3 | Preventive Maintenance Material Cost Charge | |||
| MAINTENANCE_PM_ODC_COST | NUMBER | 38 | 3 | Preventive Maintenance ODC Cost Charged | |||
| NODE_ID | VARCHAR2 | 12 | Asset Location | DW_EWWA_X_EWDI_WACS_W1_NODE_D | ASSET_ORG_NODE_ID | ||
| OPEN_ACTUAL_COST | NUMBER | 38 | 3 | Actual Cost of Open Activities | |||
| OPEN_ACTUAL_EQUIP_COST | NUMBER | 38 | 3 | Actual Equip Costs of Open Activities | |||
| OPEN_ACTUAL_LABOR_COST | NUMBER | 38 | 3 | Actual Labor Costs of Open Activities | |||
| OPEN_ACTUAL_MATL_COST | NUMBER | 38 | 3 | Actual Material Costs of Open Activities | |||
| OPEN_ACTUAL_ODC_COST | NUMBER | 38 | 3 | Actual Misc Costs of Open Activities | |||
| ORIGINAL_WORK_DT | NUMBER | 38 | 0 | Original Work Date | |||
| OWNING_ACCESS_GRP_CD | VARCHAR2 | 38 | Owning Organization | ||||
| PLANNED_EST_COST | NUMBER | 38 | 3 | Est Cost of Planned Activities | |||
| PLANNED_EST_EQUIP_COST | NUMBER | 38 | 3 | Est Equip Cost of Planned Activities | |||
| PLANNED_EST_LABOR_COST | NUMBER | 38 | 3 | Est Labor Cost of Planned Activities | |||
| PLANNED_EST_MATL_COST | NUMBER | 38 | 3 | Est Material Cost of Planned Activities | |||
| PLANNED_EST_ODC_COST | NUMBER | 38 | 3 | Est Misc Cost of Planned Activities | |||
| PLANNER_CD | VARCHAR2 | 38 | Planner | DW_EWWA_X_EWDI_WACS_W1_PLANNER_D | PLANNER_CD | ||
| PREDCTD_WEAR_OUT_DT | NUMBER | 38 | 0 | Predicted Wear Out Date | |||
| PRJ_ID | VARCHAR2 | 38 | Project | DW_EWWA_X_EWDI_WACS_W1_PROJECT_D | PRJ_ID | ||
| RENEWAL_COST | NUMBER | 38 | 2 | Renewal Cost | |||
| RENEWAL_FLG | VARCHAR2 | 4 | Service Class Type | ||||
| 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 | ||
| TOTAL_EST_COST | NUMBER | 38 | 3 | Est Cost of Activities | |||
| W1_BI_TOTAL_COST | NUMBER | 38 | 3 | Total Cost | |||
| W1_CREW_ID | VARCHAR2 | 38 | Crew | DW_EWWA_X_EWDI_WACS_W1_CREW_D | W1_CREW_ID | ||
| WORK_FINISH_DT | NUMBER | 38 | 0 | Work Finished Date | |||
| WORK_FINISH_TM | NUMBER | 38 | 0 | Work Finished Time | |||
| 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 |