Downstream Service Points
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 | ||
| MEASR_COMP_ID | VARCHAR2 | 12 | Measuring Component | DW_EWB_X_EWDI_BASE_D1_MEASR_COMP_D | MEASR_COMP_ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 25 | Source Record Id | ||||
| CNT | NUMBER | 38 | 0 | Count | |||
| D1_SP_TYPE_CD | VARCHAR2 | 30 | Service Point Type | DW_EWB_X_EWDI_BASE_D1_SP_TYPE_D | D1_SP_TYPE_CD | ||
| D1_UOM_CD | VARCHAR2 | 30 | Unit of Measure | ||||
| FACILITY_ID | VARCHAR2 | 14 | Facility | DW_EWB_X_EWDI_BASE_D1_FACILITY_D | FACILITY_ID | ||
| MEASR_COMP_TYPE_CD | VARCHAR2 | 30 | Measuring Component Type | D1_MEASR_COMP_TYPE_D | MEASR_COMP_TYPE_CD | ||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |