Transformer Entity - POSOCO/wrldc_warehouse_data_migration_python GitHub Wiki
Transformer Type can be found by attribute at TRANS_ELEMENT_TYPE_MASTER
SELECT TRANS_ELEMENT_TYPE_ID, TRANS_ELEMENT_TYPE, ELEMENT_CATEGORY FROM TRANS_ELEMENT_TYPE_MASTER where ELEMENT_CATEGORY = 'Transformer'
| column | type | nullable |
|---|---|---|
| TRANS_ELEMENT_TYPE_ID | NUMBER(38,0) | No |
| TRANS_ELEMENT_TYPE | VARCHAR2(200 BYTE) | No |
| ELEMENT_CATEGORY | VARCHAR2(500 BYTE) | Yes |
| ENTITY_MASTER_ID | NUMBER | Yes |
| MODIFIED_DATE | TIMESTAMP(6) | Yes |
| MODIFIED_BY | VARCHAR2(80 BYTE) | Yes |
| CREATED_DATE | TIMESTAMP(6) | Yes |
| CREATED_BY | VARCHAR2(80 BYTE) | Yes |
TRANSFORMER
if stationtype is Substation, substation linked is major_substation and if stationtype is Generating Station the substation is linked to Generating Station. Transformer type can be found at TRANS_ELEMENT_TYPE_MASTER using TYPE_GT_ICT.
select ID, TRANSFORMER_NAME, HV_STATION_ID, CIRCUIT_NUMBER, TYPE_GT_ICT, MVA_CAPACITY, DATETIME_OF_COMMISSIONING, DATETIME_OF_DECOMMISSIONING, DATETIME_OF_COD, LOCATION_ID, STATIONTYPE, HV_VOLTAGE_LEVEL, LV_VOLTAGE_LEVEL from TRANSFORMER where TRANSFORMER_NAME IS NOT NULL
| column | type | nullable |
|---|---|---|
| ID | NUMBER(38,0) | Yes |
| TRANSFORMER_NAME | VARCHAR2(50 BYTE) | Yes |
| HV_BUS_ID | NUMBER(38,0) | Yes |
| LV_BUS_ID | NUMBER(38,0) | Yes |
| HV_STATION_ID | NUMBER(38,0) | Yes |
| LV_STATION_ID | NUMBER(38,0) | Yes |
| CIRCUIT_NUMBER | NUMBER(38,0) | Yes |
| TYPE_GT_ICT | NUMBER(38,0) | Yes |
| MAKE | VARCHAR2(50 BYTE) | Yes |
| SPARE_TRANSFORMER_FLAG | VARCHAR2(50 BYTE) | Yes |
| MVA_CAPACITY | NUMBER(20,2) | Yes |
| NOMINAL_HV_KV_RATING | NUMBER(20,2) | Yes |
| NOMINAL_LV_KV_RATING | NUMBER(20,2) | Yes |
| TERTIARY_KV_RATING | NUMBER(20,2) | Yes |
| CONFIGURATION_1_PHASE_3_PHASE | VARCHAR2(50 BYTE) | Yes |
| HV_VECTOR_GROUP | VARCHAR2(50 BYTE) | Yes |
| LV_VECTOR_GROUP | VARCHAR2(50 BYTE) | Yes |
| TERTIARY_VECTOR_GROUP | VARCHAR2(50 BYTE) | Yes |
| TRANSFORMER_TAP_CHANGER_MAKE | VARCHAR2(50 BYTE) | Yes |
| TAP_CHANGER_TYPE | VARCHAR2(50 BYTE) | Yes |
| NO_OF_TAP_POSITIONS | NUMBER(38,0) | Yes |
| MAX_TAP | NUMBER(38,0) | Yes |
| VOLTAGE_AT_MAX_TAP_KV | NUMBER(20,2) | Yes |
| MIN_TAP | NUMBER(38,0) | Yes |
| VOLTAGE_AT_MIN_TAP_KV | NUMBER(20,2) | Yes |
| NOMINAL_TAP | NUMBER(38,0) | Yes |
| NOMINAL_VOLTAGE_KV | NUMBER(20,2) | Yes |
| PRESENT_TAP | NUMBER(38,0) | Yes |
| AVR_AVAILABLE_FLAG | VARCHAR2(10 BYTE) | Yes |
| AVR_INSERVICE_FLAG | VARCHAR2(10 BYTE) | Yes |
| AVR_SETTINGS | VARCHAR2(50 BYTE) | Yes |
| DATETIME_OF_FIRST_CHARGING | TIMESTAMP(6) | Yes |
| DATETIME_OF_TRIAL_OPERATION | TIMESTAMP(6) | Yes |
| DATETIME_OF_COMMISSIONING | TIMESTAMP(6) | Yes |
| DATETIME_OF_COD | TIMESTAMP(6) | Yes |
| DATETIME_OF_DECOMMISSIONING | TIMESTAMP(6) | Yes |
| SWITCH_YARD_CONTACT_NUMBER | VARCHAR2(50 BYTE) | Yes |
| DATA_AVAILABILITY_AT_RLDC_FLAG | VARCHAR2(10 BYTE) | Yes |
| MAGNETISING_G_PU | NUMBER(20,2) | Yes |
| MAGNETISING_B_PU | NUMBER(20,2) | Yes |
| R_PU | NUMBER(20,2) | Yes |
| X_PU | NUMBER(20,2) | Yes |
| R_GROUNDING_HV_PU | NUMBER(20,2) | Yes |
| X_GROUNDING_HV_PU | NUMBER(20,2) | Yes |
| R_GROUNDING_LV_PU | NUMBER(20,2) | Yes |
| X_GROUNDING_LV_PU | NUMBER(20,2) | Yes |
| R_GROUNDING_TV_PU | NUMBER(20,2) | Yes |
| X_GROUNDING_TV_PU | NUMBER(20,2) | Yes |
| R0_HV_PU | NUMBER(20,2) | Yes |
| X0_HV_PU | NUMBER(20,2) | Yes |
| R0_LV_PU | NUMBER(20,2) | Yes |
| X0_LV_PU | NUMBER(20,2) | Yes |
| R0_TV_PU | NUMBER(20,2) | Yes |
| X0_TV_PU | NUMBER(20,2) | Yes |
| DIFFERENTIAL_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| DIFFERENTIAL_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| REF_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| REF_PROT_MODEL | VARCHAR2(50 BYTE) | Yes |
| REF_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| OVER_FLUX_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| OVER_FLUX_PROT_MODEL | VARCHAR2(50 BYTE) | Yes |
| OVER_FLUX_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| HV_BU_PROT_EARTH_FAULT_MAKE | VARCHAR2(50 BYTE) | Yes |
| HV_BU_PROT_EARTH_FAULT_MODEL | VARCHAR2(50 BYTE) | Yes |
| HV_BU_PROT_EARTH_FAULT_SETTING | VARCHAR2(50 BYTE) | Yes |
| HV_BU_PROT_OVER_CURR_MAKE | VARCHAR2(50 BYTE) | Yes |
| HV_BU_PROT_OVER_CURR_MODEL | VARCHAR2(50 BYTE) | Yes |
| HV_BU_PROT_OVER_CURR_SETTING | VARCHAR2(50 BYTE) | Yes |
| ICT_BREAKER_LBB_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| ICT_BREAKER_LBB_PROT_MODEL | VARCHAR2(50 BYTE) | Yes |
| ICT_BREAKER_LBB_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| WTI_MAKE | VARCHAR2(50 BYTE) | Yes |
| WTI_MODEL | VARCHAR2(50 BYTE) | Yes |
| WTI_ALARM_SETTING | VARCHAR2(50 BYTE) | Yes |
| WTI_TRIP_SETTING | VARCHAR2(50 BYTE) | Yes |
| OTI_MAKE | VARCHAR2(50 BYTE) | Yes |
| OTI_MODEL | VARCHAR2(50 BYTE) | Yes |
| OTI_ALARM_SETTING | VARCHAR2(50 BYTE) | Yes |
| OTI_TRIP_SETTING | VARCHAR2(50 BYTE) | Yes |
| ADDITIONAL_PROT | VARCHAR2(50 BYTE) | Yes |
| PSSE_MAPPING_TRANSFORMER_ID | VARCHAR2(50 BYTE) | Yes |
| PSSE_MAPPING_NAME | VARCHAR2(50 BYTE) | Yes |
| SE_SEM_METER_NO | NUMBER(38,0) | Yes |
| SE_SEM_MAKE | VARCHAR2(50 BYTE) | Yes |
| SE_SEM_LOCATION | VARCHAR2(50 BYTE) | Yes |
| SE_SEM_FEEDER_NAME | VARCHAR2(50 BYTE) | Yes |
| SE_SEM_CT_RATIO | NUMBER(20,2) | Yes |
| SE_SEM_PT_CVT_RATIO | NUMBER(20,2) | Yes |
| RE_SEM_METER_NO | NUMBER(38,0) | Yes |
| RE_SEM_MAKE | VARCHAR2(50 BYTE) | Yes |
| RE_SEM_LOCATION | VARCHAR2(50 BYTE) | Yes |
| RE_SEM_FEEDER_NAME | NUMBER(20,2) | Yes |
| RE_SEM_CT_RATIO | NUMBER(20,2) | Yes |
| RE_SEM_PT_CVT_RATIO | NUMBER(20,2) | Yes |
| SCADA_DATA_REPORTING_FLAG | VARCHAR2(50 BYTE) | Yes |
| LV_BU_PROT_EARTH_FAULT_MAKE | VARCHAR2(50 BYTE) | Yes |
| LV_BU_PROT_EARTH_FAULT_MODEL | VARCHAR2(50 BYTE) | Yes |
| LV_BU_PROT_EARTH_FAULT_SETTING | VARCHAR2(50 BYTE) | Yes |
| LV_BU_PROT_OVER_CURR_MAKE | VARCHAR2(50 BYTE) | Yes |
| LV_BU_PROT_OVER_CURR_MODEL | VARCHAR2(50 BYTE) | Yes |
| LV_BU_PROT_OVER_CURR_SETTING | VARCHAR2(50 BYTE) | Yes |
| OVER_LOAD_RELAY_MAKE | VARCHAR2(50 BYTE) | Yes |
| OVER_LOAD_RELAY_MODEL | VARCHAR2(50 BYTE) | Yes |
| OVER_LOAD_RELAY_SETTING | VARCHAR2(50 BYTE) | Yes |
| CREATED_BY | VARCHAR2(100 BYTE) | Yes |
| CREATED_DATE | TIMESTAMP(6) | Yes |
| MODIFED_BY | VARCHAR2(100 BYTE) | Yes |
| MODIFED_DATE | TIMESTAMP(6) | Yes |
| LOCATION_ID | NUMBER(38,0) | Yes |
| STATIONTYPE | VARCHAR2(20 BYTE) | Yes |
| HV_VOLTAGE_LEVEL | NUMBER | Yes |
| LV_VOLTAGE_LEVEL | NUMBER | Yes |
| IS_CONFIGURABLE_SO | NUMBER(1,0) | Yes |
| IS_CONFIGURABLE_SCADA | NUMBER(1,0) | Yes |
| IS_READABLE_FROM_STATE_FILE | NUMBER(38,0) | Yes |
Owner
Owner can be found from ENTITY_ENTITY_RELN
SELECT ID, PARENT_ENTITY_ATTRIBUTE_ID, CHILD_ENTITY_ATTRIBUTE_ID from ENTITY_ENTITY_RELN WHERE PARENT_ENTITY='TRANSFORMER' and PARENT_ENTITY_ATTRIBUTE='Owner' and CHILD_ENTITY='OWNER' and CHILD_ENTITY_ATTRIBUTE='OwnerId'