Module: Grid Insights
Type: Fact
A1_TRANSFORMER_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| A1_TRANSFORMER_ID | VARCHAR2 | 30 | True | Transformer | |||
| SOURCE_RECORD_ID | VARCHAR2 | 30 | Source Record Id | ||||
| A1_FACILITY_NAME | VARCHAR2 | 100 | Transformer Name | ||||
| A1_GEO_LAT | NUMBER | 35 | 6 | Geographic Latitude | |||
| A1_GEO_LONG | NUMBER | 35 | 6 | Geographic Longitude | |||
| A1_PHASE | VARCHAR2 | 30 | Phase | ||||
| A1_RATING | NUMBER | 35 | 6 | Rating | |||
| A1_TGT_UPD_DTTM | TIMESTAMP | 0 | 6 | Target Update Date Time | |||
| A1_TRANSFORMER_STATUS | VARCHAR2 | 30 | Transformer Status | ||||
| A1_TRANSFORMER_TYPE | VARCHAR2 | 100 | Transformer Type | ||||
| CITY | VARCHAR2 | 100 | City | ||||
| COUNTRY | VARCHAR2 | 3 | Country | ||||
| COUNTY | VARCHAR2 | 100 | County | ||||
| FACILITY_ID | VARCHAR2 | 30 | Facility | ||||
| POSTAL | VARCHAR2 | 12 | Postal | ||||
| STATE | VARCHAR2 | 30 | State | ||||
| STREET | VARCHAR2 | 254 | Street | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |