Facility Customer Classification
Module: Device Analytics
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CUST_CL_CD | VARCHAR2 | 8 | Customer Class | DW_EWB_X_EWDI_BASE_CI_CUST_CL_D | CUST_CL_CD | ||
| 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 | ||
| INTERVAL_SCALAR_FLG | VARCHAR2 | 4 | Interval /Scalar | ||||
| MSRMT_DT | NUMBER | 38 | 0 | Measurement Date | |||
| MSRMT_TM | NUMBER | 38 | 0 | Measurement Time | |||
| SEC_PER_INTRVL | NUMBER | 5 | 0 | Interval Size | |||
| US_TYPE_CD | VARCHAR2 | 30 | Usage Subscription Type | DW_EWA_X_EWDI_AMI_D1_US_TYPE_D | US_TYPE_CD | ||
| SOURCE_RECORD_ID | VARCHAR2 | 220 | Source Record Id | ||||
| A1_EST_LOAD | NUMBER | 16 | 6 | Estimated Load | |||
| A1_EST_USAGE | NUMBER | 16 | 6 | Estimated Usage | |||
| A1_LOAD | NUMBER | 16 | 6 | Load | |||
| A1_USAGE | NUMBER | 16 | 6 | Usage | |||
| ID_VALUE | VARCHAR2 | 120 | External ID | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |