AC Transmission Line Entity - POSOCO/wrldc_warehouse_data_migration_python GitHub Wiki
AC_TRANS_LINE_MASTER
We get the line info but not the circuit info
Columns of interest - ID, LINE_NAME, FROM_SUB_ID, TO_SUB_ID, VOLTAGE_LEVEL
| name | type | nullable |
|---|---|---|
| ID | NUMBER | No |
| LINE_NAME | VARCHAR2(200 BYTE) | Yes |
| FROM_SUB_ID | NUMBER(38,0) | Yes |
| TO_SUB_ID | NUMBER(38,0) | Yes |
| FROM_LOCATION_ID | NUMBER(38,0) | Yes |
| TO_LOCATION_ID | NUMBER(38,0) | Yes |
| VOLTAGE_LEVEL | 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 |
| IS_CONFIG_FROM_STATE | NUMBER(1,0) | Yes |
| IS_CONFIG_TO_STATE | NUMBER(1,0) | Yes |
| IS_CONFIG_STATE | NUMBER(1,0) | Yes |
| WRT | NUMBER(38,0) | Yes |
| READ_FROM_SF_FOR_FROM_STATE | NUMBER(38,0) | Yes |
| READ_FROM_SF_FOR_TO_STATE | NUMBER(38,0) | Yes |
| ISAUTORECLOSURE | NUMBER(1,0) | Yes |
AC_TRANSMISSION_LINE_CIRCUIT
We get the line circuit info. Owner, Conductor type can found in the ENTITY_ENTITY_RELN table
Columns of interest - ID, FROM_BUS_ID, TO_BUS_ID, LINE_ID, CIRCUIT_NUMBER, LENGTH, FIRST_CHARGING_DATETIME, TRAIL_OPERATION_DATETIME, COMMISSIONING_DATETIME, COD_DATETIME, DECOMMISSIONING_DATETIME, THERMAL_LIMIT_MVA, SIL_MW, VOLTAGE_LEVEL
| name | type | nullable |
|---|---|---|
| ID | NUMBER(38,0) | No |
| FROM_BUS_ID | NUMBER(38,0) | Yes |
| TO_BUS_ID | NUMBER(38,0) | Yes |
| LINE_ID | NUMBER(38,0) | Yes |
| LINE_TYPE_ID | NUMBER(38,0) | Yes |
| CIRCUIT_NUMBER | NUMBER(38,0) | Yes |
| LENGTH | NUMBER(38,6) | Yes |
| INTERSTATE_LINE_FLAG | VARCHAR2(10 BYTE) | Yes |
| NO_OF_CONDUCTORS_PER_CIRCUIT | 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 |
| AUFR_INSTALLED_FLAG | VARCHAR2(10 BYTE) | Yes |
| AUFR_INSTALLED_SUB_ID | NUMBER(38,0) | Yes |
| AUFR_INSTALLED_NEAREST_SUB_ID | NUMBER(38,0) | Yes |
| FIRST_CHARGING_DATETIME | TIMESTAMP(6) | Yes |
| TRAIL_OPERATION_DATETIME | TIMESTAMP(6) | Yes |
| COMMISSIONING_DATETIME | TIMESTAMP(6) | Yes |
| COD_DATETIME | TIMESTAMP(6) | Yes |
| DECOMMISSIONING_DATETIME | TIMESTAMP(6) | Yes |
| THERMAL_LIMIT_MVA | NUMBER(20,4) | Yes |
| SIL_MW | NUMBER(20,4) | Yes |
| R_PU | NUMBER(20,4) | Yes |
| X_PU | NUMBER(20,4) | Yes |
| B_PU | NUMBER(20,4) | Yes |
| R0_PU | NUMBER(20,4) | Yes |
| X0_PU | NUMBER(20,4) | Yes |
| B0_PU | NUMBER(20,4) | Yes |
| PSSE_MAPPING_LINE_ID | NUMBER(38,0) | Yes |
| PSSE_MAPPING_NAME | VARCHAR2(50 BYTE) | Yes |
| SE_METER_NO | NUMBER(38,0) | Yes |
| SE_METER_MAKE | VARCHAR2(50 BYTE) | Yes |
| SE_METER_LOCATION_ID | NUMBER(38,0) | Yes |
| SE_FEEDER_NAME | VARCHAR2(50 BYTE) | Yes |
| SE_CT_RATIO | VARCHAR2(50 BYTE) | Yes |
| SE_PT_CVT_RATIO | VARCHAR2(50 BYTE) | Yes |
| RE_METER_NO | NUMBER(38,0) | Yes |
| RE_METER_MAKE | VARCHAR2(50 BYTE) | Yes |
| RE_METER_LOCATION_ID | NUMBER(38,0) | Yes |
| RE_FEEDER_NAME | VARCHAR2(50 BYTE) | Yes |
| RE_CT_RATIO | VARCHAR2(50 BYTE) | Yes |
| RE_PT_CVT_RATIO | VARCHAR2(50 BYTE) | Yes |
| SE_DATA_AVAILABILITY_AT_RLDC | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_RELAY | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_CT_PRIMARY | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_ZONE1_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_ZONE1_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_ZONE1_SET_X | NUMBER(20,2) | Yes |
| SE_MAIN1_ZONE1_SET_PERC | NUMBER(20,2) | Yes |
| SE_MAIN1_ZONE1_TIME_SET_S | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_ZONE2_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_ZONE2_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_ZONE2_SET_X | NUMBER(20,2) | Yes |
| SE_MAIN1_ZONE2_SET_PERC | NUMBER(20,2) | Yes |
| SE_MAIN1_ZONE2_TIME_SET_S | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_ZONE3_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_ZONE3_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_ZONE3_SET_RLOAD | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_ZONE3_SET_X | NUMBER(20,2) | Yes |
| SE_MAIN1_ZONE3_SET_PERC | NUMBER(20,2) | Yes |
| SE_MAIN1_ZONE3_TIME_SET | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_REV_ZONE_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_REV_ZONE_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_REV_ZONE_SET_X | NUMBER(20,2) | Yes |
| SE_MAIN1_REV_ZONE_SET_PERC | NUMBER(20,2) | Yes |
| SE_MAIN1_REV_ZONE_TIME_SET | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_PERMISSIVE_SCHEME | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_PSB_SET | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_RELAY | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_CT_PRIMARY | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_ZONE1_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN1_PSB_UNBLOCK_TIMEDELAY | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_ZONE1_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_ZONE1_SET_X | NUMBER(20,2) | Yes |
| SE_MAIN2_ZONE1_SET_PERC | NUMBER(20,2) | Yes |
| SE_MAIN2_ZONE1_TIME_SET | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_ZONE2_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_ZONE2_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_ZONE2_SET_X | NUMBER(20,2) | Yes |
| SE_MAIN2_ZONE2_SET_PERC | NUMBER(20,2) | Yes |
| SE_MAIN2_ZONE2_TIME_SET | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_ZONE3_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_ZONE3_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_ZONE3_SET_X | NUMBER(20,2) | Yes |
| SE_MAIN2_ZONE3_SET_PERC | NUMBER(20,2) | Yes |
| SE_MAIN2_ZONE3_TIME_SET | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_REV_ZONE_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_REV_ZONE_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_REV_ZONE_SET_X | NUMBER(20,2) | Yes |
| SE_MAIN2_REV_ZONE_SET_PERC | NUMBER(20,2) | Yes |
| SE_MAIN2_REV_ZONE_TIME_SET | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_PERMISSIVE_SCHEME | VARCHAR2(50 BYTE) | Yes |
| SE_MAIN2_PSB_SET | VARCHAR2(50 BYTE) | Yes |
| SE_OVERVOLTAGE_STAGE1_MAKE | VARCHAR2(50 BYTE) | Yes |
| SE_OVER_VOLTAGE_STAGE1_SET | VARCHAR2(50 BYTE) | Yes |
| SE_BACK_UP_FAULT_RELAY_MAKE | VARCHAR2(50 BYTE) | Yes |
| SE_BACK_UP_FAULT_RELAY_SET | VARCHAR2(50 BYTE) | Yes |
| SE_SOTF_SET | VARCHAR2(50 BYTE) | Yes |
| SE_BROKEN_CONDUCTOR_SET | VARCHAR2(50 BYTE) | Yes |
| SE_STUB_SET | VARCHAR2(50 BYTE) | Yes |
| SE_FUSE_FAIL_SET | VARCHAR2(50 BYTE) | Yes |
| SE_ARC_MAKE | VARCHAR2(50 BYTE) | Yes |
| SE_ARC_RECLAIM_TIME | TIMESTAMP(6) | Yes |
| SE_ARC_DEAD_TIME | TIMESTAMP(6) | Yes |
| SE_ARC_SINGLE_THREE_PHASE | VARCHAR2(50 BYTE) | Yes |
| SE_ARC_ENABLED_FLAG | VARCHAR2(50 BYTE) | Yes |
| SE_LBB_PROTECTION_MAKE | VARCHAR2(50 BYTE) | Yes |
| SE_LBB_PROTECTION_SET | VARCHAR2(50 BYTE) | Yes |
| SE_PLCC_AVAILABLE_FLAG | VARCHAR2(50 BYTE) | Yes |
| SE_EVENTLOGGER_ENABLED_FLAG | VARCHAR2(50 BYTE) | Yes |
| SE_DR_ENABLED_FLAG | VARCHAR2(50 BYTE) | Yes |
| SE_TIME_SYNC_WITH_GPS_FLAG | VARCHAR2(50 BYTE) | Yes |
| SE_SCADA_DATA_REPORTING | VARCHAR2(50 BYTE) | Yes |
| SE_OV_STAGE2_MAKE | VARCHAR2(50 BYTE) | Yes |
| SE_OV_STAGE2_SETTING | VARCHAR2(50 BYTE) | Yes |
| RE_DATA_AVAILABILITY_AT_RLDC | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_RELAY | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_CT_PRIMARY | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_ZONE1_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_ZONE1_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_ZONE1_SET_X | NUMBER(20,2) | Yes |
| RE_MAIN1_ZONE1_SET_PERC | NUMBER(20,2) | Yes |
| RE_MAIN1_ZONE1_TIME_SET_S | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_ZONE2_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_ZONE2_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_ZONE2_SET_X | NUMBER(20,2) | Yes |
| RE_MAIN1_ZONE2_SET_PERC | NUMBER(20,2) | Yes |
| RE_MAIN1_ZONE2_TIME_SET_S | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_ZONE3_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_ZONE3_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_ZONE3_SET_RLOAD | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_ZONE3_SET_X | NUMBER(20,2) | Yes |
| RE_MAIN1_ZONE3_SET_PERC | NUMBER(20,2) | Yes |
| RE_MAIN1_ZONE3_TIME_SET | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_REV_ZONE_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_REV_ZONE_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_REV_ZONE_SET_X | NUMBER(20,2) | Yes |
| RE_MAIN1_REV_ZONE_SET_PERC | NUMBER(20,2) | Yes |
| RE_MAIN1_REV_ZONE_TIME_SET | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_PERMISSIVE_SCHEME | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_PSB_SET | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_RELAY | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_CT_PRIMARY | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_ZONE1_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN1_PSB_UNBLOCK_TIMEDELAY | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_ZONE1_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_ZONE1_SET_X | NUMBER(20,2) | Yes |
| RE_MAIN2_ZONE1_SET_PERC | NUMBER(20,2) | Yes |
| RE_MAIN2_ZONE1_TIME_SET | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_ZONE2_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_ZONE2_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_ZONE2_SET_X | NUMBER(20,2) | Yes |
| RE_MAIN2_ZONE2_SET_PERC | NUMBER(20,2) | Yes |
| RE_MAIN2_ZONE2_TIME_SET | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_ZONE3_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_ZONE3_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_ZONE3_SET_X | NUMBER(20,2) | Yes |
| RE_MAIN2_ZONE3_SET_PERC | NUMBER(20,2) | Yes |
| RE_MAIN2_ZONE3_TIME_SET | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_REV_ZONE_SET_R_PHPH | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_REV_ZONE_SET_R_PHE | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_REV_ZONE_SET_X | NUMBER(20,2) | Yes |
| RE_MAIN2_REV_ZONE_SET_PERC | NUMBER(20,2) | Yes |
| RE_MAIN2_REV_ZONE_TIME_SET | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_PERMISSIVE_SCHEME | VARCHAR2(50 BYTE) | Yes |
| RE_MAIN2_PSB_SET | VARCHAR2(50 BYTE) | Yes |
| RE_OVERVOLTAGE_STAGE1_MAKE | VARCHAR2(50 BYTE) | Yes |
| RE_OVER_VOLTAGE_STAGE1_SET | VARCHAR2(50 BYTE) | Yes |
| RE_BACK_UP_FAULT_RELAY_MAKE | VARCHAR2(50 BYTE) | Yes |
| RE_BACK_UP_FAULT_RELAY_SET | VARCHAR2(50 BYTE) | Yes |
| RE_SOTF_SET | VARCHAR2(50 BYTE) | Yes |
| RE_BROKEN_CONDUCTOR_SET | VARCHAR2(50 BYTE) | Yes |
| RE_FUSE_FAIL_SET | VARCHAR2(50 BYTE) | Yes |
| RE_ARC_MAKE | VARCHAR2(50 BYTE) | Yes |
| RE_ARC_RECLAIM_TIME | TIMESTAMP(6) | Yes |
| RE_ARC_DEAD_TIME | TIMESTAMP(6) | Yes |
| RE_ARC_SINGLE_THREE_PHASE | VARCHAR2(50 BYTE) | Yes |
| RE_ARC_ENABLED_FLAG | VARCHAR2(50 BYTE) | Yes |
| RE_LBB_PROTECTION_MAKE | VARCHAR2(50 BYTE) | Yes |
| RE_LBB_PROTECTION_SET | VARCHAR2(50 BYTE) | Yes |
| RE_PLCC_AVAILABLE_FLAG | VARCHAR2(50 BYTE) | Yes |
| RE_EVENTLOGGER_ENABLED | VARCHAR2(50 BYTE) | Yes |
| RE_DR_ENABLED | VARCHAR2(50 BYTE) | Yes |
| RE_TIME_SYNC_WITH_GPS_FLAG | VARCHAR2(50 BYTE) | Yes |
| RE_SCADA_DATA_REPORTING | VARCHAR2(50 BYTE) | Yes |
| RE_DIFF_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| RE_DIFF_PROT_SETTINGS | VARCHAR2(50 BYTE) | Yes |
| IS_IT_INTERSTATE_LINE | 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 |
| LINE_CIRCUIT_NAME | VARCHAR2(200 BYTE) | Yes |
| DEDICATED_GEN_STN_ID | NUMBER(38,0) | Yes |
| VOLTAGE_LEVEL | NUMBER(38,0) | Yes |
| IS_CONFIG_FROM_STATE | NUMBER(1,0) | Yes |
| IS_CONFIG_TO_STATE | NUMBER(1,0) | Yes |
| IS_CONFIG_STATE | NUMBER(1,0) | Yes |
| IS_READABLE_FROM_STATE_FILE | NUMBER(38,0) | Yes |