24 Hours Measurement Daily Summary
Module: Device Analytics
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| A1_MSRMT_DT | NUMBER | 38 | 0 | Measurement Date | |||
| 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 | ||
| RS_CD | VARCHAR2 | 38 | Rate | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 256 | Source Record Id | ||||
| A1_MSRMT_MAX_24HOURS_START_HOUR | VARCHAR2 | 6 | Max Interval Start Time | ||||
| A1_MSRMT_OFFSET_TM | VARCHAR2 | 5 | Measurement Time Offset | ||||
| A1_MSRMT_VAL_H00 | NUMBER | 17 | 6 | Hour 00 Measurement Value | |||
| A1_MSRMT_VAL_H01 | NUMBER | 17 | 6 | Hour 01 Measurement Value | |||
| A1_MSRMT_VAL_H02 | NUMBER | 17 | 6 | Hour 02 Measurement Value | |||
| A1_MSRMT_VAL_H03 | NUMBER | 17 | 6 | Hour 03 Measurement Value | |||
| A1_MSRMT_VAL_H04 | NUMBER | 17 | 6 | Hour 04 Measurement Value | |||
| A1_MSRMT_VAL_H05 | NUMBER | 17 | 6 | Hour 05 Measurement Value | |||
| A1_MSRMT_VAL_H06 | NUMBER | 17 | 6 | Hour 06 Measurement Value | |||
| A1_MSRMT_VAL_H07 | NUMBER | 17 | 6 | Hour 07 Measurement Value | |||
| A1_MSRMT_VAL_H08 | NUMBER | 17 | 6 | Hour 08 Measurement Value | |||
| A1_MSRMT_VAL_H09 | NUMBER | 17 | 6 | Hour 09 Measurement Value | |||
| A1_MSRMT_VAL_H10 | NUMBER | 17 | 6 | Hour 10 Measurement Value | |||
| A1_MSRMT_VAL_H11 | NUMBER | 17 | 6 | Hour 11 Measurement Value | |||
| A1_MSRMT_VAL_H12 | NUMBER | 17 | 6 | Hour 12 Measurement Value | |||
| A1_MSRMT_VAL_H13 | NUMBER | 17 | 6 | Hour 13 Measurement Value | |||
| A1_MSRMT_VAL_H14 | NUMBER | 17 | 6 | Hour 14 Measurement Value | |||
| A1_MSRMT_VAL_H15 | NUMBER | 17 | 6 | Hour 15 Measurement Value | |||
| A1_MSRMT_VAL_H16 | NUMBER | 17 | 6 | Hour 16 Measurement Value | |||
| A1_MSRMT_VAL_H17 | NUMBER | 17 | 6 | Hour 17 Measurement Value | |||
| A1_MSRMT_VAL_H18 | NUMBER | 17 | 6 | Hour 18 Measurement Value | |||
| A1_MSRMT_VAL_H19 | NUMBER | 17 | 6 | Hour 19 Measurement Value | |||
| A1_MSRMT_VAL_H20 | NUMBER | 17 | 6 | Hour 20 Measurement Value | |||
| A1_MSRMT_VAL_H21 | NUMBER | 17 | 6 | Hour 21 Measurement Value | |||
| A1_MSRMT_VAL_H22 | NUMBER | 17 | 6 | Hour 22 Measurement Value | |||
| A1_MSRMT_VAL_H23 | NUMBER | 17 | 6 | Hour 23 Measurement Value | |||
| A1_MSRMT_VAL_MAX_4HOURS | NUMBER | 17 | 6 | Maximum 4 Hour Measurement Value | |||
| A1_MSRMT_VAL_TOTAL | NUMBER | 18 | 6 | Total Measurement Value | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |