Aggregated AMI
Module: Device Analytics
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CUST_CL_CD | VARCHAR2 | 38 | Customer Class | DW_EWB_X_EWDI_BASE_CI_CUST_CL_D | CUST_CL_CD | ||
| D1_SP_TYPE_CD | VARCHAR2 | 30 | Service Point Type | DW_EWB_X_EWDI_BASE_D1_SP_TYPE_D | D1_SP_TYPE_CD | ||
| D1_SQI_CD | VARCHAR2 | 38 | Service Quantity Identifier | DW_EWA_X_EWDI_AMI_D1_SQI_D | D1_SQI_CD | ||
| D1_SVC_TYPE_CD | VARCHAR2 | 30 | Service Type | DW_EWA_X_EWDI_AMI_D1_SVC_TYPE_D | D1_SVC_TYPE_CD | ||
| D1_UOM_CD | VARCHAR2 | 38 | Unit of Measure | DW_EWA_X_EWDI_AMI_D1_UOM_D | D1_UOM_CD | ||
| MSRMT_DT | NUMBER | 38 | 0 | Measurement Date | |||
| MSRMT_TM | NUMBER | 38 | 0 | Measurement Time | |||
| RS_CD | VARCHAR2 | 38 | Rate | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 295 | Source Record Id | ||||
| CREATED_DT | NUMBER | 38 | 0 | Creation Date | |||
| CREATED_TM | NUMBER | 38 | 0 | Creation Time | |||
| MSRMT_VAL | NUMBER | 16 | 6 | Measurement | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |