Forecasted Activity Hours
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 | ||
| RESRC_TYPE_ID | VARCHAR2 | 38 | Resource Type | DW_EWWA_X_EWDI_WACS_W1_RESRC_TYPE_D | RESRC_TYPE_ID | ||
| RN | NUMBER | ||||||
| SOURCE_RECORD_ID | VARCHAR2 | 92 | Source Record Id | ||||
| A1_USER_ID | VARCHAR2 | 8 | Work and Asset User | DW_EWWA_X_EWDI_WACS_SC_USER_D | USER_ID | ||
| ACTIVITY_DESCR100 | VARCHAR2 | 100 | Activity Description | ||||
| ACTVN_DT | NUMBER | 38 | 0 | Activation Date | |||
| ACTVN_TM | NUMBER | 38 | 0 | Activation Time | |||
| ACT_RESRC_CNT | NUMBER | 38 | 0 | # Activities / Resource Type | |||
| ACT_STATUS_CD | VARCHAR2 | 38 | Activity Status | ||||
| ACT_TYPE_CD | VARCHAR2 | 30 | Asset Activity Type | ||||
| ACT_WORK_CATEGORY_CD | VARCHAR2 | 38 | Work Category - Activity | ||||
| ACT_WORK_CLASS_CD | VARCHAR2 | 38 | Work Class - Activity | ||||
| ASSET_ID | VARCHAR2 | 38 | Asset | DW_EWWA_X_EWDI_WACS_W1_ASSET_D | ASSET_ID | ||
| BACK_LOG_GRP_FLG | VARCHAR2 | 38 | Backlog Group | ||||
| BO_STATUS_REASON_CD | VARCHAR2 | 38 | Status Reason | ||||
| CONSTR_ACT_FC_LABOR_HRS | NUMBER | 38 | 5 | Forecasted Construction Hours for Planned WO Activities | |||
| EMERGENCY_FLG | VARCHAR2 | 4 | Emergency | ||||
| HELD_FOR_PARTS_FLG | VARCHAR2 | 38 | Held For Parts | ||||
| 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_FC_LABOR_HRS | NUMBER | 38 | 5 | Forecasted Maintenance Hours for Planned WO Activities | |||
| OPEN_ACT_FC_LABOR_HRS | NUMBER | 38 | 5 | Forecasted Hours on All Open WO Activities | |||
| ORIGINAL_WORK_DT | NUMBER | 38 | 0 | Original Work Date | |||
| OUTAGE_TYPE_FLG | VARCHAR2 | 38 | Outage Type | ||||
| OWNING_ACCESS_GRP_CD | VARCHAR2 | 38 | Owning Organization | ||||
| PLANNER_CD | VARCHAR2 | 38 | Planner | DW_EWWA_X_EWDI_WACS_W1_PLANNER_D | PLANNER_CD | ||
| REQUIRED_BY_DT | NUMBER | 38 | 0 | Required By Date | |||
| SERVICE_CLASS_CD | VARCHAR2 | 38 | Service Class | ||||
| TMPL_ACT_ID | VARCHAR2 | 38 | Template Activity | DW_EWWA_X_EWDI_WACS_W1_TMPL_ACT_D | TMPL_ACT_ID | ||
| TOTAL_PRIORITY | NUMBER | 2 | 0 | Total Risk Priority | |||
| UNSCHED_MAINT_FC_LABOR_HRS | NUMBER | 38 | 5 | Unscheduled Planned Maintenance Labor Hours | |||
| W1_CREW_ID | VARCHAR2 | 38 | Crew | DW_EWWA_X_EWDI_WACS_W1_CREW_D | W1_CREW_ID | ||
| WORK_PRIORITY_FLG | VARCHAR2 | 38 | Work Priority | ||||
| 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 |