Device to Transformer Mismap Adj Voltage
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_MSRMT_TM | NUMBER | 38 | 0 | Measurement Time | |||
| D1_DEVICE_ID | VARCHAR2 | 50 | Device | DW_EWB_X_EWDI_BASE_D1_DVC_D | D1_DEVICE_ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | Source Record Id | ||||
| A1_ACTUAL_TX_ADJ_VOL | NUMBER | 35 | 12 | ||||
| A1_ACTUAL_TX_ID | VARCHAR2 | 50 | Actual Transformer | DW_EWG_X_EWDI_GRID_A1_TRANSFORMER_D | A1_TRANSFORMER_ID | ||
| A1_DVC_VOL | NUMBER | 35 | 12 | ||||
| A1_MISMAP_IND | VARCHAR2 | 1 | Mismap Ind | ||||
| A1_RECOMMENDED_TX_ADJ_VOL | NUMBER | 35 | 12 | ||||
| A1_RECOMMENDED_TX_ID | VARCHAR2 | 50 | Recommended Transformer | DW_EWG_X_EWDI_GRID_A1_TRANSFORMER_D | A1_TRANSFORMER_ID | ||
| A1_TGT_UPD_DTTM | TIMESTAMP | 0 | 6 | Target Update Date Time | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |