Asset Availability Based on Work Order
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 | ||
| NODE_ID | VARCHAR2 | 12 | Asset Location | DW_EWWA_X_EWDI_WACS_W1_NODE_D | ASSET_ORG_NODE_ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 40 | Source Record Id | ||||
| ACQUISITION_DT | NUMBER | 38 | 0 | Acquisition Date | |||
| ASSET_LOC_HIERARCHY_NODE_ID | VARCHAR2 | 12 | Asset Location Hierarchy | DW_EWWA_X_EWDI_WACS_W1_BI_NODE_HIERARCHY_D | LOC_ORG_NODE_ID | ||
| ASTVALWO_WO_CRE_DT | NUMBER | 38 | 0 | ||||
| ASTVALWO_WO_CRE_DTTM | TIMESTAMP | 0 | 6 | Activity Creation Date/Time | |||
| ASTVALWO_WO_CRE_TM | NUMBER | 38 | 0 | ||||
| ECONOMIC_LIFE | NUMBER | 38 | 1 | ||||
| IN_SERVICE_DT | NUMBER | 38 | 0 | In Service Date | |||
| IN_SERVICE_DT_DATE_ | DATE | 0 | |||||
| OWNING_ACCESS_GRP_CD | VARCHAR2 | 38 | Owning Organization | ||||
| PREDICT_WEAR_OUT_DT | NUMBER | 38 | 0 | Predicted Wear Out Date | |||
| TOT_DOWNTIME_SEC | NUMBER | 38 | 0 | Total Downtime in Seconds | |||
| USEFUL_LIFE | NUMBER | 38 | 1 | Useful Life (Years) | |||
| 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_DTTM | TIMESTAMP | 0 | 6 | Work Finished Date/Time | |||
| WORK_FINISH_TM | NUMBER | 38 | 0 | Work Finished Time | |||
| WO_FAILURE_COUNT | NUMBER | 38 | 0 | # Failures - WO Based | |||
| WO_ID | VARCHAR2 | 14 | Work Order | DW_EWWA_X_EWDI_WACS_W1_WO_D | WO_ID | ||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |