Line Reactor Entity - POSOCO/wrldc_warehouse_data_migration_python GitHub Wiki
LINE_REACTOR
SELECT ID, FK_LINE_ID, FK_SUBSTATION, MVAR_CAPACITY, DATETIME_OF_COMMISSIONING, DATETIME_OF_COD, DATETIME_OF_DECOMMISSIONING, LOCATION_ID, REACTOR_NAME, ISCONVERTIBLE, ISSWITCHABLE FROM REPORTING_WEB_UI_UAT.LINE_REACTOR WHERE LINE_TYPE_ID=2
FK_SUBSTATION is foreign key to ASSOCIATE_SUBSTATION
FK_LINE_ID is foreign key to AC_TRANSMISSION_LINE_CIRCUIT
| column | type | nullable |
|---|---|---|
| ID | NUMBER(38,0) | Yes |
| REACTOR_NO | NUMBER(38,0) | Yes |
| FK_LINE_ID | 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 |
| NOMINAL_VOLTAGE_KV | NUMBER(38,0) | Yes |
| SWITCHABLE_TYPE | VARCHAR2(10 BYTE) | Yes |
| CONVERTIBLE_TO_BUS_REACTOR | VARCHAR2(10 BYTE) | Yes |
| DATETIME_OF_FIRST_CHARGING | TIMESTAMP(6) | Yes |
| DATETIME_OF_TRAIL_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(20,0) | Yes |
| DATA_AVAILABILITY_AT_RLDC | VARCHAR2(10 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 |
| BACK_UP_IMP_PROT_HV_SIDE_MAKE | VARCHAR2(50 BYTE) | Yes |
| BACK_UP_IMP_PROT_HV_SIDE_MODEL | VARCHAR2(50 BYTE) | Yes |
| BACK_UP_IMP_PROT_HV_SIDE_SET | 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 | 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 | NUMBER(38,0) | Yes |
| PSSE_MAPPING_NAME | VARCHAR2(50 BYTE) | 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 |
| LINE_TYPE_ID | NUMBER(38,0) | Yes |
| REACTOR_NAME | VARCHAR2(100 BYTE) | Yes |
| ISCONVERTIBLE | NUMBER(1,0) | Yes |
| ISSWITCHABLE | NUMBER(1,0) | Yes |
| ELEMENT_TYPE | VARCHAR2(200 BYTE) | Yes |
Owners
SELECT ID, PARENT_ENTITY_ATTRIBUTE_ID, CHILD_ENTITY_ATTRIBUTE_ID from REPORTING_WEB_UI_UAT.ENTITY_ENTITY_RELN WHERE PARENT_ENTITY='LINE_REACTOR' and PARENT_ENTITY_ATTRIBUTE='Owner' and CHILD_ENTITY='OWNER' and CHILD_ENTITY_ATTRIBUTE='OwnerId'