HVDC Line Entity - POSOCO/wrldc_warehouse_data_migration_python GitHub Wiki
HVDC_LINE_MASTER
select ID,LINE_NAME,FROM_SUB_ID,TO_SUB_ID,FROM_VOLTAGE,FROM_LOCATION_ID,TO_LOCATION_ID from REPORTING_WEB_UI_UAT.HVDC_LINE_MASTER
| name |
type |
nullable |
| ID |
NUMBER |
Yes |
| LINE_NAME |
VARCHAR2(200 BYTE) |
Yes |
| FROM_SUB_ID |
NUMBER(38,0) |
Yes |
| TO_SUB_ID |
NUMBER(38,0) |
Yes |
| FROM_VOLTAGE |
NUMBER(38,0) |
Yes |
| FROM_LOCATION_ID |
NUMBER(38,0) |
Yes |
| TO_LOCATION_ID |
NUMBER(38,0) |
Yes |
| CREATED_DATE |
TIMESTAMP(6) |
Yes |
| CREATED_BY |
VARCHAR2(100 BYTE) |
Yes |
| MODIFIED_DATE |
TIMESTAMP(6) |
Yes |
| MODIFIED_BY |
VARCHAR2(100 BYTE) |
Yes |
HVDC_LINE_CIRCUIT
select ID, LINE_CIRCUIT_NAME, HVDC_LINE_ID, CIRCUIT_NO, FROM_SUBSTATION_ID, TO_SUBSTATION_ID, FROM_BUS_ID, TO_BUS_ID, LENGTH_KM, DATETIME_OF_TRAIL_OPERATION, DATETIME_OF_FIRST_CHARGING, DATETIME_OF_COMMISSIONING, DATETIME_OF_COD, DATETIME_OF_DECOMMISSIONING, THERMAL_LIMIT_MVA, NO_OF_CONDUCTORS_PER_CKT from REPORTING_WEB_UI_UAT.HVDC_LINE_CIRCUIT
| name |
type |
nullable |
| ID |
NUMBER(38,0) |
Yes |
| HVDC_LINE_ID |
NUMBER(38,0) |
Yes |
| FROM_SUBSTATION_ID |
NUMBER(38,0) |
Yes |
| TO_SUBSTATION_ID |
NUMBER(38,0) |
Yes |
| FROM_BUS_ID |
NUMBER(38,0) |
Yes |
| TO_BUS_ID |
NUMBER(38,0) |
Yes |
| CIRCUIT_NO |
NUMBER(38,0) |
Yes |
| LENGTH_KM |
NUMBER(20,2) |
Yes |
| CONDUCTOR_TYPE |
VARCHAR2(50 BYTE) |
Yes |
| NO_OF_CONDUCTORS_PER_CKT |
NUMBER(38,0) |
Yes |
| EMANATING_END_BAY_NO |
NUMBER(38,0) |
Yes |
| RECEIVING_END_BAY_NO |
NUMBER(38,0) |
Yes |
| EMANATING_END_BAY_OWNER |
VARCHAR2(50 BYTE) |
Yes |
| RECEIVING_END_BAY_OWNER |
VARCHAR2(50 BYTE) |
Yes |
| EMANATING_END_BAY_MAINTAINEDBY |
VARCHAR2(50 BYTE) |
Yes |
| RECEIVING_END_BAY_MAINTAINEDBY |
VARCHAR2(50 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 |
| DATETIME_CLOSING_LINE_DETAILS |
TIMESTAMP(6) |
Yes |
| THERMAL_LIMIT_MVA |
NUMBER(20,2) |
Yes |
| RDC_OHMS |
NUMBER(20,2) |
Yes |
| RCMP_OHMS |
NUMBER(20,2) |
Yes |
| VSCHED_KV |
NUMBER(20,2) |
Yes |
| DCVMIN_KV |
NUMBER(20,2) |
Yes |
| VCMODE_KV |
NUMBER(20,2) |
Yes |
| PSSE_MAPPING_LINE_ID |
NUMBER(38,0) |
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_ID |
NUMBER(38,0) |
Yes |
| SE_SEM_FEEDER_NAME |
VARCHAR2(50 BYTE) |
Yes |
| SE_SEM_CT_RATIO |
VARCHAR2(50 BYTE) |
Yes |
| SE_SEM_PT_CVT_RATIO |
VARCHAR2(50 BYTE) |
Yes |
| RE_SEM_METER_NO |
NUMBER(38,0) |
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 |
VARCHAR2(50 BYTE) |
Yes |
| RE_SEM_PT_CVT_RATIO |
VARCHAR2(50 BYTE) |
Yes |
| DATA_AVAILABILITY_AT_RLDC_FLAG |
VARCHAR2(10 BYTE) |
Yes |
| BIPOLE_NEUTRAL_DIFF_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| BIPOLE_NEUTRAL_DIFF_PROT_SET |
VARCHAR2(50 BYTE) |
Yes |
| SG_OVERCURRENT_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| SG_OVERCURRENT_PROT_SET |
VARCHAR2(50 BYTE) |
Yes |
| AUTO_RECLOSE_SCHEME_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| AUTO_RECLOSE_SCHEME_SET |
VARCHAR2(50 BYTE) |
Yes |
| AUTO_RECLOSE_SCHEME_ENABLED |
VARCHAR2(50 BYTE) |
Yes |
| LINE_BREAKER_LBB_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| LINE_BREAKER_LBB_PROT_SET |
VARCHAR2(50 BYTE) |
Yes |
| UNBALANCE_SUPER_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| UNBALANCE_SUPER_PROT_SET |
VARCHAR2(50 BYTE) |
Yes |
| PLCC_AVAILABLE_FLAG |
VARCHAR2(10 BYTE) |
Yes |
| DR_ENABLED_FLAG |
VARCHAR2(10 BYTE) |
Yes |
| TIME_SYNCHRONIZED_WITH_GPS |
VARCHAR2(10 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 |
| LINE_CIRCUIT_NAME |
VARCHAR2(200 BYTE) |
Yes |
| VOLTAGE_LEVEL |
NUMBER(38,0) |
Yes |
| RE_SCADA_DATA_REPORTING |
VARCHAR2(50 BYTE) |
Yes |
| SE_SCADA_DATA_REPORTING |
VARCHAR2(50 BYTE) |
Yes |
| IS_IT_INTERSTATE_LINE |
VARCHAR2(50 BYTE) |
Yes |
Owners
Owners of HVDC Line Circuit can be found by the following sql
SELECT ID, PARENT_ENTITY_ATTRIBUTE_ID, CHILD_ENTITY_ATTRIBUTE_ID from REPORTING_WEB_UI_UAT.ENTITY_ENTITY_RELN WHERE PARENT_ENTITY='HVDC_LINE' and PARENT_ENTITY_ATTRIBUTE='Owner' and CHILD_ENTITY='OWNER' and CHILD_ENTITY_ATTRIBUTE='OwnerId'