EV Detection
Module: Grid Insights
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| A1_APPLIANCE | VARCHAR2 | 30 | EV Charge Type | ||||
| A1_ISO_WEEK_START_DT | NUMBER | 38 | 0 | Week Start Date | |||
| D1_SP_ID | VARCHAR2 | 30 | MDM Service Point | DW_EWB_X_EWDI_BASE_D1_SP_D | D1_SP_ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 100 | Source Record Id | ||||
| A1_ERROR_CATEGORY | VARCHAR2 | 254 | Error Category | ||||
| A1_ERROR_MESSAGE | VARCHAR2 | 254 | Error Message | ||||
| A1_FEEDER_ID | VARCHAR2 | 30 | Feeder | DW_EWG_X_EWDI_GRID_A1_FEEDER_D | A1_FEEDER_ID | ||
| A1_ISO_WEEK_END_DT | NUMBER | 38 | 0 | Week End Date | |||
| A1_ISO_WEEK_START_DT_DATE_ | DATE | 0 | Week Start Date in Date format | ||||
| A1_L1_PRESENCE_IND | VARCHAR2 | 1 | L1 Presence Ind | ||||
| A1_L2_PRESENCE_IND | VARCHAR2 | 1 | L2 Presence Ind | ||||
| A1_SITE_CONFIDENCE | NUMBER | 35 | 6 | Site Confidence | |||
| A1_SITE_PRESENCE | VARCHAR2 | 30 | Site Presence | ||||
| A1_TGT_UPD_DTTM | TIMESTAMP | 0 | 6 | Target Update Date Time | |||
| A1_TRANSFORMER_ID | VARCHAR2 | 30 | Transformer | DW_EWG_X_EWDI_GRID_A1_TRANSFORMER_D | A1_TRANSFORMER_ID | ||
| ACCT_ID | VARCHAR2 | 30 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| D1_DEVICE_ID | VARCHAR2 | 30 | Device | DW_EWB_X_EWDI_BASE_D1_DVC_D | D1_DEVICE_ID | ||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |