Substation Entity - POSOCO/wrldc_warehouse_data_migration_python GitHub Wiki
Major Substation (MAJOR_SUBSTATION)
ID, NAME, STATE_ID, CREATED_AT, UPDATED_AT
| column_name | column_type | nullable |
|---|---|---|
| ID | NUMBER(38,0) | No |
| NAME | VARCHAR2(100 BYTE) | Yes |
| STATE_ID | NUMBER(38,0) | Yes |
| CREATED_DATE | TIMESTAMP(6) | Yes |
| CREATED_BY | VARCHAR2(200 BYTE) | Yes |
| MODIFIED_DATE | TIMESTAMP(6) | Yes |
| MODIFIED_BY | VARCHAR2(200 BYTE) | Yes |
Associated Substation (ASSOCIATE_SUBSTATION)
ID, SUBSTATION_NAME, TYPE_AC_DC, TYPE_CONVENTIONAL_SAS, LATITUDE, LONGITUDE, LOCATION_ID, BUS_BAR_SCHEME, VOLTAGE_LEVEL, DATE_OF_COMMISSIONING, DATE_OF_DECOMMISSIONING, DATE_OF_COD, CONTROL_ROOM_CONTACT_NUMBER, CONTROL_ROOM_EMAIL_ID, CREATED_BY, CREATED_DATE, MODIFED_DATE, SUB_ID, NO_OF_BUS, PSPFLAG, NLDCFLAG, NLDC_ORD, NO_OF_AUX_BUS, NO_OF_TRANS_BUS
For getting the voltage information, see the Element Type and Voltage Information page
| column_name | column_type | nullable |
|---|---|---|
| ID | NUMBER(38,0) | No |
| SUBSTATION_NAME | VARCHAR2(50 BYTE) | Yes |
| TYPE_AC_DC | VARCHAR2(10 BYTE) | Yes |
| TYPE_CONVENTIONAL_SAS | VARCHAR2(50 BYTE) | Yes |
| LATITUDE | VARCHAR2(10 BYTE) | Yes |
| LONGITUDE | VARCHAR2(10 BYTE) | Yes |
| LOCATION_ID | VARCHAR2(50 BYTE) | Yes |
| REMOTE_CONTROLLED_FLAG | VARCHAR2(10 BYTE) | Yes |
| REMOTE_CONTROLLED_SUB_ID | NUMBER(38,0) | Yes |
| BUS_BAR_SCHEME | VARCHAR2(50 BYTE) | Yes |
| VOLTAGE_LEVEL | NUMBER(20,2) | Yes |
| DATE_OF_COMMISSIONING | TIMESTAMP(6) | Yes |
| DATE_OF_DECOMMISSIONING | TIMESTAMP(6) | Yes |
| DATE_OF_COD | TIMESTAMP(6) | Yes |
| DATA_AVAILABILITY_AT_RLDC | VARCHAR2(10 BYTE) | Yes |
| SCADA_DATA_REPORTING | VARCHAR2(10 BYTE) | Yes |
| SLD_AVAILABILITY_FLAG | VARCHAR2(10 BYTE) | Yes |
| SLD_AVAILIBILITY_IN_DEPTS | VARCHAR2(500 BYTE) | Yes |
| SYNC_FACILITY_AVAILABLE_FLAG | VARCHAR2(10 BYTE) | Yes |
| SYNC_FACILITY_MAKE | VARCHAR2(100 BYTE) | Yes |
| SYNC_FACILITY_MODEL | VARCHAR2(100 BYTE) | Yes |
| BS_FACILITY_AVAILABILITY_FLAG | VARCHAR2(10 BYTE) | Yes |
| BS_FACILITY_TYPE_OF_SOURCE | VARCHAR2(500 BYTE) | Yes |
| BS_FACILITY_DETAILS | VARCHAR2(500 BYTE) | Yes |
| EVENT_LOGGER_AVAILABILITY_FLAG | VARCHAR2(10 BYTE) | Yes |
| EVENT_LOGGER_MAKE | VARCHAR2(100 BYTE) | Yes |
| EVENT_LOGGER_MODEL | VARCHAR2(100 BYTE) | Yes |
| DIST_REC_AVAILABILITY_FLAG | VARCHAR2(10 BYTE) | Yes |
| DIST_REC_MAKE | VARCHAR2(100 BYTE) | Yes |
| DIST_REC_MODEL | VARCHAR2(100 BYTE) | Yes |
| TS_EQUIPMENT_AVAILIBILITY_FLAG | VARCHAR2(10 BYTE) | Yes |
| TS_EQUIPMENT_MAKE | VARCHAR2(100 BYTE) | Yes |
| TS_EQUIPMENT_MODEL | VARCHAR2(100 BYTE) | Yes |
| PMU_AVAILABILITY_FLAG | VARCHAR2(10 BYTE) | Yes |
| NEAREST_PMU | VARCHAR2(100 BYTE) | Yes |
| CONTROL_ROOM_CONTACT_NUMBER | VARCHAR2(20 BYTE) | Yes |
| CONTROL_ROOM_EMAIL_ID | VARCHAR2(100 BYTE) | Yes |
| HVDC_AC_BYPASS_HEALTHINESS | VARCHAR2(10 BYTE) | Yes |
| HVDC_AC_BYPASS_AVAILABILITY | VARCHAR2(10 BYTE) | Yes |
| BUS_COUPLER_AVAILIBILITY | VARCHAR2(10 BYTE) | Yes |
| BUS_COUPLER_HEALTHINESS | VARCHAR2(100 BYTE) | Yes |
| CAPACITOR_BANK_AVAILABILITY | VARCHAR2(10 BYTE) | Yes |
| CAPACITOR_BANK_NUMBER | NUMBER(38,0) | Yes |
| CAPACITOR_BANK_RATING | NUMBER(20,2) | Yes |
| CAPACITOR_BANK_CONFIGURATION | VARCHAR2(100 BYTE) | Yes |
| CAPACITOR_SWITCHING_FLAG | VARCHAR2(10 BYTE) | Yes |
| CAPACITOR_SWITCHING_SETTING | VARCHAR2(100 BYTE) | Yes |
| FREQUENCY_CONTROL_FLAG | VARCHAR2(10 BYTE) | Yes |
| POD_CONTROLLER_FLAG | VARCHAR2(10 BYTE) | Yes |
| FREQUENCY_BAND_CONTROL_FLAG | VARCHAR2(10 BYTE) | Yes |
| BUS_BAR_PROTECTION_AVAILABILE | VARCHAR2(10 BYTE) | Yes |
| BUS_BAR_PROTECTION_MAKE | VARCHAR2(100 BYTE) | Yes |
| BUS_BAR_PROTECTION_MODEL | VARCHAR2(100 BYTE) | Yes |
| NO_OF_TR_LINES_EMANATING | NUMBER(38,0) | Yes |
| NO_OF_BUS_REACTORS | NUMBER(38,0) | Yes |
| NO_OF_TERTIARY_REACTORS | NUMBER(38,0) | Yes |
| NO_OF_LINE_REACTORS | NUMBER(38,0) | Yes |
| NO_OF_TRANSFORMERS | NUMBER(38,0) | Yes |
| CREATED_BY | VARCHAR2(100 BYTE) | Yes |
| CREATED_DATE | TIMESTAMP(6) | Yes |
| MODIFED_BY | VARCHAR2(100 BYTE) | Yes |
| MODIFED_DATE | TIMESTAMP(6) | Yes |
| SUB_ID | NUMBER(38,0) | Yes |
| NO_OF_BUS | NUMBER | Yes |
| PSPFLAG | NUMBER(38,0) | Yes |
| NLDCFLAG | NUMBER | Yes |
| NLDC_ORD | NUMBER | Yes |