Service History
Module: Work Asset Analytics
Type: Fact
SVC_HIST_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SVC_HIST_ID | VARCHAR2 | 12 | True | Service History | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| A1_USER_ID | VARCHAR2 | 38 | Work and Asset User | DW_EWWA_X_EWDI_WACS_SC_USER_D | USER_ID | ||
| ACQUISITION_DT | NUMBER | 38 | 0 | Acquisition Date | |||
| ACT_ID | VARCHAR2 | 38 | Asset Activity | DW_EWWA_X_EWDI_WACS_W1_ACTIVITY_D | ACT_ID | ||
| ANNIVERSARY_DT | NUMBER | 38 | 0 | Anniversary Date | |||
| ANNIVERSARY_VALUE | NUMBER | 18 | 7 | Anniversary Value | |||
| ASSET_ID | VARCHAR2 | 38 | Asset | DW_EWWA_X_EWDI_WACS_W1_ASSET_D | ASSET_ID | ||
| ASSET_LOC_HIERARCHY_NODE_ID | VARCHAR2 | 38 | Asset Location Hierarchy | DW_EWWA_X_EWDI_WACS_W1_BI_NODE_HIERARCHY_D | LOC_ORG_NODE_ID | ||
| ASSET_SCORE_FLG | VARCHAR2 | 38 | Score | ||||
| BO_STATUS_REASON_CD | VARCHAR2 | 38 | Status Reason | ||||
| EFF_DT | NUMBER | 38 | 0 | Effective Date | |||
| EFF_TM | NUMBER | 38 | 0 | Effective Time | |||
| END_DT | NUMBER | 38 | 0 | End Date | |||
| END_TM | NUMBER | 38 | 0 | End Time | |||
| FAILURE_COMP_CD | VARCHAR2 | 38 | Failure Component | DW_EWWA_X_EWDI_WACS_W1_FAILURE_COMP_D | FAILURE_COMP_CD | ||
| FAILURE_MODE_CD | VARCHAR2 | 38 | Failure Mode | DW_EWWA_X_EWDI_WACS_W1_FAILURE_MODE_D | FAILURE_MODE_CD | ||
| FAILURE_REPAIR_CD | VARCHAR2 | 38 | Failure Repair | DW_EWWA_X_EWDI_WACS_W1_FAILURE_REPAIR_D | FAILURE_REPAIR_CD | ||
| FAILURE_TYPE_CD | VARCHAR2 | 38 | Failure Cause | DW_EWWA_X_EWDI_WACS_W1_FAILURE_TYPE_D | FAILURE_TYPE_CD | ||
| INSPECTED_BY_USER | VARCHAR2 | 38 | Inspected by User | DW_EWWA_X_EWDI_WACS_SC_USER_D | USER_ID | ||
| IN_SERVICE_DT | NUMBER | 38 | 0 | In Service Date | |||
| MAINT_SCHED_ID | VARCHAR2 | 38 | Maintenance Schedule | DW_EWWA_X_EWDI_WACS_W1_MAINT_SCHEDULE_D | MAINT_SCHED_ID | ||
| MAINT_TRIGGER_ID | VARCHAR2 | 38 | Maintenance Trigger | DW_EWWA_X_EWDI_WACS_W1_MAINT_TRIGGER_D | MAINT_TRIGGER_ID | ||
| NODE_ID | VARCHAR2 | 38 | Asset Location | DW_EWWA_X_EWDI_WACS_W1_NODE_D | ASSET_ORG_NODE_ID | ||
| OWNING_ACCESS_GRP_CD | VARCHAR2 | 38 | Owning Organization | ||||
| PERMIT_ID | VARCHAR2 | 38 | Permit | DW_EWWA_X_EWDI_WACS_W1_PERMIT_D | PERMIT_ID | ||
| PREDCTD_WEAR_OUT_DT | NUMBER | 38 | 0 | Predicted Wear Out Date | |||
| SVC_HIST_CATEGORY_FLG | VARCHAR2 | 4 | Category | ||||
| SVC_HIST_CNT | NUMBER | 38 | 0 | # Service Histories | |||
| SVC_HIST_CRE_DT | NUMBER | 38 | 0 | Creation Date | |||
| SVC_HIST_CRE_TM | NUMBER | 38 | 0 | Creation Time | |||
| SVC_HIST_STATUS_CD | VARCHAR2 | 38 | Service History Status | ||||
| SVC_HIST_STATUS_UPD_DT | NUMBER | 38 | 0 | Status Date | |||
| SVC_HIST_STATUS_UPD_TM | NUMBER | 38 | 0 | Status Time | |||
| SVC_HIST_TYPE_CD | VARCHAR2 | 30 | Service History Type | DW_EWWA_X_EWDI_WACS_W1_SVC_HIST_TYPE_D | SVC_HIST_TYPE_CD | ||
| 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 |