Hvdc Pole Entity - POSOCO/wrldc_warehouse_data_migration_python GitHub Wiki
HVDC_POLE
select ID, POLE_NAME, POLE_ID, FK_SUBSTATION, LOCATION_ID, POLE_TYPE, VOLTAGE_LEVEL, MAX_FIRING_ANGLE_DEG, MIN_FIRING_ANGLE_DEG, DATETIME_OF_COMMISSIONING, DATETIME_OF_COD, DATETIME_OF_DECOMMISSIONING from REPORTING_WEB_UI_UAT.HVDC_POLE
| name |
type |
nullable |
| ID |
NUMBER(38,0) |
Yes |
| POLE_TYPE |
VARCHAR2(50 BYTE) |
Yes |
| FK_SUBSTATION |
NUMBER(38,0) |
Yes |
| FK_HVDC_LINE |
NUMBER(38,0) |
Yes |
| MAX_FIRING_ANGLE_DEG |
NUMBER(20,2) |
Yes |
| MIN_FIRING_ANGLE_DEG |
NUMBER(20,2) |
Yes |
| BRIDGES_IN_SERIES |
NUMBER(20,2) |
Yes |
| PRIMARY_BASE_VOLTAGE_KV |
NUMBER(20,2) |
Yes |
| COMMUTATING_RESISTANCE_OHMS |
NUMBER(20,2) |
Yes |
| COMMUTATING_REACTANCE_OHMS |
NUMBER(20,2) |
Yes |
| CONVERTER_TRANS_RATIO_PU |
NUMBER(20,2) |
Yes |
| TAP_SET_PU |
NUMBER(20,2) |
Yes |
| MAX_TAP_SET_PU |
NUMBER(20,2) |
Yes |
| MIN_TAP_SET_PU |
NUMBER(20,2) |
Yes |
| TAP_STEP_PU |
NUMBER(20,2) |
Yes |
| REACTANCE_OF_CCC_OHMS |
NUMBER(20,2) |
Yes |
| VALVE_SHORT_CIRCUIT_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| VALVE_SHORT_CIRCUIT_PROT_SET |
VARCHAR2(50 BYTE) |
Yes |
| COMMUTATION_FAILURE_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| COMMUTATION_FAILURE_PROT_SET |
VARCHAR2(50 BYTE) |
Yes |
| VOLTAGE_STRESS_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| VOLTAGE_STRESS_PROT_SET |
VARCHAR2(50 BYTE) |
Yes |
| BACK_UP_UD_SUPERVISION_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| BACK_UP_UD_SUPERVISION_SET |
VARCHAR2(50 BYTE) |
Yes |
| VALVE_MISFIRE_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| VALVE_MISFIRE_PROT_SET |
VARCHAR2(50 BYTE) |
Yes |
| DC_OVER_CURRENT_PROECTION_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| DC_OVER_CURRENT_PROECTION_SET |
VARCHAR2(50 BYTE) |
Yes |
| POLE_ID |
NUMBER |
Yes |
| DC_ABNORMAL_VOLTAGE_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| DC_ABNORMAL_VOLTAGE_SET |
VARCHAR2(50 BYTE) |
Yes |
| DC_HARMONIC_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| DC_HARMONIC_PROT_SET |
VARCHAR2(50 BYTE) |
Yes |
| DC_DIFFERENTIAL_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| DC_DIFFERENTIAL_PROT_SET |
VARCHAR2(50 BYTE) |
Yes |
| DC_LINE_GROUND_FAULT_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| DC_LINE_GROUND_FAULT_PROT_SET |
VARCHAR2(50 BYTE) |
Yes |
| DC_FILTER_OVER_LOAD_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| DC_FILTER_OVER_LOAD_PROT_SET |
VARCHAR2(50 BYTE) |
Yes |
| ELECTRODE_LINE_OC_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| ELECTRODE_LINE_OC_PROT_SET |
VARCHAR2(50 BYTE) |
Yes |
| AC_FILTER_ID |
NUMBER(38,0) |
Yes |
| UNBALANCE_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| UNBALANCE_PROT_SETTINGS |
VARCHAR2(50 BYTE) |
Yes |
| OVER_CURRENT_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| OVER_CURRENT_PROT_SETTINGS |
VARCHAR2(50 BYTE) |
Yes |
| SHUNT_REAC_DIFF_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| SHUNT_REAC_DIFF_PROT_SETTINGS |
VARCHAR2(50 BYTE) |
Yes |
| OVER_LOAD_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| OVER_LOAD_PROT_SET |
VARCHAR2(50 BYTE) |
Yes |
| AC_FILTER_SUPERVISION_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| AC_FILTER_SUPERVISION_SETTINGS |
VARCHAR2(50 BYTE) |
Yes |
| GROUND_FAULT_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| GROUND_FAULT_PROT_SETTINGS |
VARCHAR2(50 BYTE) |
Yes |
| LBB_PROTECTION_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| LBB_PROTECTION_SET |
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 |
Yes |
| DATETIME_OF_COMMISSIONING |
TIMESTAMP(6) |
Yes |
| DATETIME_OF_COD |
TIMESTAMP(6) |
Yes |
| DATETIME_OF_DECOMMISSIONING |
TIMESTAMP(6) |
Yes |
| VOLTAGE_LEVEL |
NUMBER(38,0) |
Yes |
| POLE_NAME |
VARCHAR2(250 BYTE) |
Yes |
Owners
SELECT ID, PARENT_ENTITY_ATTRIBUTE_ID, CHILD_ENTITY_ATTRIBUTE_ID from REPORTING_WEB_UI_UAT.ENTITY_ENTITY_RELN WHERE PARENT_ENTITY='HVDC_POLE' and PARENT_ENTITY_ATTRIBUTE='Owner' and CHILD_ENTITY='OWNER' and CHILD_ENTITY_ATTRIBUTE='OwnerId'