Facilities
Module: Device Analytics
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| D1_SP_ID | VARCHAR2 | 12 | MDM Service Point | DW_EWB_X_EWDI_BASE_D1_SP_D | D1_SP_ID | ||
| FACILITY_ID | VARCHAR2 | 14 | Facility | DW_EWB_X_EWDI_BASE_D1_FACILITY_D | FACILITY_ID | ||
| MEASR_COMP_ID | VARCHAR2 | 12 | Measuring Component | DW_EWB_X_EWDI_BASE_D1_MEASR_COMP_D | MEASR_COMP_ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 40 | Source Record Id | ||||
| D1_DEVICE_ID | VARCHAR2 | 12 | Device | DW_EWB_X_EWDI_BASE_D1_DVC_D | D1_DEVICE_ID | ||
| D1_SVC_TYPE_CD | VARCHAR2 | 38 | Service Type | ||||
| D1_UOM_CD | VARCHAR2 | 30 | Unit of Measure | ||||
| ID_VALUE | VARCHAR2 | 120 | External ID | ||||
| MEASR_COMP_TYPE_CD | VARCHAR2 | 30 | Measuring Component Type | D1_MEASR_COMP_TYPE_D | MEASR_COMP_TYPE_CD | ||
| OVTOL | NUMBER | Over Tolerance | |||||
| UNTOL | NUMBER | Under Tolerance | |||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |