Facility Distribution Nodes
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_EWA_X_EWDI_AMI_D1_SP_D | D1_SP_ID | ||
| D1_UOM_CD | VARCHAR2 | 30 | Unit of Measure | DW_EWA_X_EWDI_AMI_CI_UOM_D | UOM_CD | ||
| FACILITY_ID | VARCHAR2 | 14 | Facility | DW_EWB_X_EWDI_BASE_D1_FACILITY_D | FACILITY_ID | ||
| FEEDER | VARCHAR2 | 38 | Feeder | ||||
| MSRMT_DT | NUMBER | 38 | 0 | Measurement Date | |||
| MSRMT_TM | NUMBER | 38 | 0 | Measurement Time | |||
| SUBST | VARCHAR2 | 38 | Substation | ||||
| US_TYPE_CD | VARCHAR2 | 30 | Usage Subscription Type | DW_EWA_X_EWDI_AMI_D1_US_TYPE_D | US_TYPE_CD | ||
| SOURCE_RECORD_ID | VARCHAR2 | 245 | Source Record Id | ||||
| A1_EST_USAGE | NUMBER | 16 | 6 | Estimated Usage | |||
| A1_USAGE | NUMBER | 16 | 6 | Usage | |||
| ID_VALUE | VARCHAR2 | 120 | External ID | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |