Module: Grid Insights
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| A1_MSRMT_DT | NUMBER | 38 | 0 | Measurement Date | |||
| A1_TRANSFORMER_ID | VARCHAR2 | 30 | Transformer | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 69 | Source Record Id | ||||
| A1_FEEDER_ID | VARCHAR2 | 30 | Feeder | ||||
| A1_MSRMT_VAL_AVG | NUMBER | 35 | 6 | ||||
| A1_MSRMT_VAL_MAX | NUMBER | 35 | 6 | ||||
| A1_MSRMT_VAL_MIN | NUMBER | 35 | 6 | ||||
| A1_MSRMT_VAL_SUM | NUMBER | 35 | 6 | ||||
| A1_RANGE_BKT1_CNT | NUMBER | 3 | 0 | ||||
| A1_RANGE_BKT2_CNT | NUMBER | 3 | 0 | ||||
| A1_RANGE_BKT3_CNT | NUMBER | 3 | 0 | ||||
| A1_RANGE_BKT4_CNT | NUMBER | 3 | 0 | ||||
| A1_RANGE_BKT5_CNT | NUMBER | 3 | 0 | ||||
| A1_RANGE_BKT6_CNT | NUMBER | 3 | 0 | ||||
| A1_RANGE_BKT7_CNT | NUMBER | 3 | 0 | ||||
| A1_RANGE_BKT8_CNT | NUMBER | 3 | 0 | ||||
| A1_RATING | NUMBER | 35 | 6 | Rating | |||
| A1_TGT_UPD_DTTM | TIMESTAMP | 0 | 6 | Target Update Date Time | |||
| D1_UOM_CD | VARCHAR2 | 30 | Unit of Measure | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |