Bus Reactor Entity - POSOCO/wrldc_warehouse_data_migration_python GitHub Wiki
BUS_REACTOR
select ID, REACTOR_NO, FK_BUS, FK_SUBSTATION, MVAR_CAPACITY, DATETIME_OF_COMMISSIONING, DATETIME_OF_COD, DATETIME_OF_DECOMMISSIONING, LOCATION_ID, REACTOR_NAME from REPORTING_WEB_UI_UAT.BUS_REACTOR
- FK_SUBSTATION is mapped to ID of ASSOCIATE_SUBSTATION
- FK_BUS is mapped to ID of BUS
| column | type | nullable |
|---|---|---|
| ID | NUMBER(38,0) | Yes |
| REACTOR_NO | NUMBER(38,0) | Yes |
| FK_BUS | NUMBER(38,0) | Yes |
| FK_SUBSTATION | NUMBER(38,0) | Yes |
| MAKE | VARCHAR2(50 BYTE) | Yes |
| MVAR_CAPACITY | NUMBER(38,0) | Yes |
| CONFIGURATION_1_PHASE_3_PHASE | VARCHAR2(20 BYTE) | Yes |
| SWITCHABLE_TYPE | VARCHAR2(20 BYTE) | Yes |
| NOMINAL_VOLTAGE_KV | NUMBER(38,0) | Yes |
| DATETIME_OF_FIRST_CHARGING | TIMESTAMP(6) | Yes |
| DATETIME_OF_FIRST_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 | NUMBER(38,0) | Yes |
| DATA_AVAILABILITY_AT_RLDC | VARCHAR2(20 BYTE) | Yes |
| G_SHUNT_MW | NUMBER(38,0) | Yes |
| B_SHUNT_MVAR_B_SHUNT_MVAR | NUMBER(38,0) | Yes |
| G_ZERO_MW_G_ZERO_MW | NUMBER(38,0) | Yes |
| B_ZERO_MVAR_B_ZERO_MVAR | NUMBER(38,0) | 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 |
| BACK_UP_PROT_HV_SIDE_MAKE | VARCHAR2(50 BYTE) | Yes |
| BACK_UP_PROT_HV_SIDE_MODEL | VARCHAR2(50 BYTE) | Yes |
| BACK_UP_PROT_HV_SIDE_SETTING | VARCHAR2(50 BYTE) | Yes |
| REACTOR_BREAKER_LBB_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| REACTOR_BREAKER_LBB_PROT_MODEL | VARCHAR2(50 BYTE) | Yes |
| REACTOR_BREAKER_LBB_PROT_SET | VARCHAR2(50 BYTE) | Yes |
| WTI_MAKE | VARCHAR2(50 BYTE) | Yes |
| WTI_MODEL | VARCHAR2(50 BYTE) | Yes |
| WTI_ALARM_SETTING | CHAR(10 BYTE) | Yes |
| WTI_TRIP_SETTING | CHAR(10 BYTE) | Yes |
| OTI_MAKE | VARCHAR2(50 BYTE) | Yes |
| OTI_MODEL | VARCHAR2(50 BYTE) | Yes |
| OTI_ALARM_SETTING | NUMBER(38,0) | Yes |
| OTI_TRIP_SETTING | NUMBER(38,0) | Yes |
| ADDITIONAL_PROT | VARCHAR2(50 BYTE) | Yes |
| PSSE_MAPPING_TRANSFORMER_ID | NUMBER(38,0) | Yes |
| PSSE_MAPPING_NAME | VARCHAR2(50 BYTE) | Yes |
| SE_SEM_METER_NO | VARCHAR2(50 BYTE) | Yes |
| SE_SEM_MAKE | VARCHAR2(50 BYTE) | Yes |
| SE_SEM_LOCATION_ID | NUMBER(38,0) | Yes |
| SE_SEM_FEEDER_NAME | VARCHAR2(50 BYTE) | Yes |
| SE_SEM_CT_RATIO | NUMBER(38,0) | Yes |
| SE_SEM_PT_CVT_RATIO | NUMBER(38,0) | Yes |
| RE_SEM_METER_NO | VARCHAR2(50 BYTE) | Yes |
| RE_SEM_MAKE | VARCHAR2(50 BYTE) | Yes |
| RE_SEM_LOCATION_ID | NUMBER(38,0) | Yes |
| RE_SEM_FEEDER_NAME | VARCHAR2(50 BYTE) | Yes |
| RE_SEM_CT_RATIO | NUMBER(38,0) | Yes |
| RE_SEM_PT_CVT_RATIO | NUMBER(38,0) | Yes |
| SCADA_DATA_REPORTING_FLAG | VARCHAR2(10 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 |
| REACTOR_NAME | VARCHAR2(100 BYTE) | Yes |
| ELEMENT_TYPE | VARCHAR2(200 BYTE) | Yes |
Owners
Owners can be found at REPORTING_WEB_UI_UAT.ENTITY_ENTITY_RELN
SELECT ID, PARENT_ENTITY_ATTRIBUTE_ID, CHILD_ENTITY_ATTRIBUTE_ID from REPORTING_WEB_UI_UAT.ENTITY_ENTITY_RELN WHERE PARENT_ENTITY='BUS_REACTOR' and PARENT_ENTITY_ATTRIBUTE='Owner' and CHILD_ENTITY='OWNER' and CHILD_ENTITY_ATTRIBUTE='OwnerId'