Generator Entity - POSOCO/wrldc_warehouse_data_migration_python GitHub Wiki
GENERATING_STATION
Generating station information can be found at GENERATING_STATION table.
Columns of interest are ID, GENERATING_STATION_NAME, CLASSIFICATION_ID, STATE_ID, STATION_TYPE, FUEL
SELECT ID, GENERATING_STATION_NAME, CLASSIFICATION_ID, STATE_ID, STATION_TYPE, FUEL from GENERATING_STATION
| name | type | nullable |
|---|---|---|
| ID | NUMBER(38,0) | No |
| GENERATING_STATION_NAME | VARCHAR2(100 BYTE) | Yes |
| NO_OF_UNITS | NUMBER(38,0) | Yes |
| MAX_CONTINUOUS_GEN_CAPACITY_MW | NUMBER(20,2) | Yes |
| MIN_CONTINUOUS_GEN_CAPACITY_MW | NUMBER(20,2) | Yes |
| EXPORT_CAPABILITY_TO_THE_GRID | NUMBER(20,2) | Yes |
| MVA_CAPACITY | NUMBER(20,2) | Yes |
| DERATED_CAPACITY | NUMBER(20,2) | Yes |
| NORMATIVE_AUXILARY_CONSUMPTION | NUMBER(20,2) | Yes |
| NORMATIVE_RAMP_UP | NUMBER(20,2) | Yes |
| NORMATIVE_RAMP_DOWN | NUMBER(20,2) | Yes |
| QMAX_MVAR | NUMBER(20,2) | Yes |
| QMAX_MVAR_LAGGING_AT_RATED_MW | NUMBER(20,2) | Yes |
| QMAX_MVAR_LEADING_AT_RATED_MW | NUMBER(20,2) | Yes |
| QMIN_MVAR | NUMBER(20,2) | Yes |
| NODES_OF_CONNECTIVITY_TO_GRID | NUMBER(38,0) | Yes |
| GPS_SYNC_FACILITY_AVAILABILITY | VARCHAR2(10 BYTE) | Yes |
| SLD_AVAILABILITY_FLAG | VARCHAR2(10 BYTE) | Yes |
| BS_FACILITY_AVAILABILITY_FLAG | VARCHAR2(10 BYTE) | Yes |
| BS_FACILITY_TYPE_OF_SOURCE | VARCHAR2(50 BYTE) | Yes |
| BS_FACILITY_DETAILS | VARCHAR2(50 BYTE) | Yes |
| SURVIVAL_POWER | NUMBER(20,2) | Yes |
| DATETIME_OF_COMMISSIONING | TIMESTAMP(6) | Yes |
| DATETIME_OF_COD | TIMESTAMP(6) | Yes |
| DATETIME_OF_DECOMMISSIONING | TIMESTAMP(6) | Yes |
| PSSE_MAPPING_ID | NUMBER(38,0) | Yes |
| PSSE_MAPPING_NAME | VARCHAR2(50 BYTE) | Yes |
| PMU_AVAILABILITY_FLAG | VARCHAR2(10 BYTE) | Yes |
| NEAREST_PMU | VARCHAR2(50 BYTE) | Yes |
| SCADA_DATA_REPORTING_FLAG | VARCHAR2(10 BYTE) | Yes |
| BUS_COUPLER_AVAILABILITY | VARCHAR2(10 BYTE) | Yes |
| BUS_COUPLER_HEALTHINESS | VARCHAR2(10 BYTE) | Yes |
| BUS_BAR_PROT_AVAILABILITY | VARCHAR2(10 BYTE) | Yes |
| BUS_BAR_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| BUS_BAR_PROT_MODEL | VARCHAR2(50 BYTE) | Yes |
| BUS_BAR_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| COMES_UNDER_JURISDICTION | VARCHAR2(50 BYTE) | Yes |
| TARIFF_ORDER_ISSUED_BY | VARCHAR2(50 BYTE) | Yes |
| LOCATION_ID | NUMBER(38,0) | Yes |
| BENEFICIARIE_ID | NUMBER(38,0) | Yes |
| INSTALLED_CAPACITY | NUMBER(20,2) | Yes |
| EFFECTIVE_CAPACITY | NUMBER(20,2) | Yes |
| NO_OF_TR_LINE_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 |
| LTA_AVAILABILITY_FLAG | VARCHAR2(10 BYTE) | Yes |
| MTOA_AVAILABILITY_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 |
| CLASSIFICATION_ID | NUMBER(38,0) | Yes |
| ENERGY_CHARGE_RATE | NUMBER(38,0) | Yes |
| LATTITUDE | VARCHAR2(25 BYTE) | Yes |
| LONGITUDE | VARCHAR2(25 BYTE) | Yes |
| STATE_ID | NUMBER(38,0) | Yes |
| INSTALLED_CAPACITY_MU | NUMBER(38,7) | Yes |
| STATION_TYPE | NUMBER(38,0) | Yes |
| FUEL | NUMBER(38,0) | Yes |
| OTHER_SECTION_FLAG | NUMBER(1,0) | Yes |
| CONFIGURE_FOR_SCADA | NUMBER(1,0) | Yes |
| CONFIGURE_FOR_STATE_OPERATION | NUMBER(1,0) | Yes |
| SCADA_DATA_AVAILIBILITY | VARCHAR2(20 BYTE) | Yes |
| PUMP_STATION_ID | NUMBER(38,0) | Yes |
| PUMP_FLAG | NUMBER(38,0) | Yes |
| OWNER_FLAG | NUMBER(38,0) | Yes |
| IS_READABLE_FROM_STATE_FILE | NUMBER(38,0) | Yes |
| CONSIDER_REPORT_VALUE_FROM | NUMBER(38,0) | Yes |
CLASSIFICATION_MASTER
Classification of generating station can be found here
select ID, CLASSIFICATION from CLASSIFICATION_MASTER
| name | type | nullable |
|---|---|---|
| ID | NUMBER(38,0) | No |
| CLASSIFICATION | VARCHAR2(50 BYTE) | Yes |
| CREATED_DATE | TIMESTAMP(6) | Yes |
| CREATED_BY | VARCHAR2(50 BYTE) | Yes |
| MODIFIED_DATE | TIMESTAMP(6) | Yes |
| MODIFIED_BY | VARCHAR2(50 BYTE) | Yes |
Owner Info
select ID, PARENT_ENTITY_ATTRIBUTE_ID, CHILD_ENTITY_ATTRIBUTE_ID from ENTITY_ENTITY_RELN WHERE PARENT_ENTITY = 'GENERATING_STATION' AND PARENT_ENTITY_ATTRIBUTE='Owner' and CHILD_ENTITY='Owner' and CHILD_ENTITY_ATTRIBUTE = 'OwnerId'
STAGE
Generating stages can be found at STAGE table
select ID, STAGE_NAME, FK_GENERATING_STATION from STAGE
| name | type | nullable |
|---|---|---|
| ID | NUMBER(38,0) | No |
| STAGE_NAME | VARCHAR2(50 BYTE) | Yes |
| ALTERNATE_NAME | VARCHAR2(500 BYTE) | Yes |
| FK_GENERATING_STATION | 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 |
| LOCATION_ID | NUMBER(38,0) | Yes |
| CONFIGURE_FOR_SCADA | NUMBER(1,0) | Yes |
| CONFIGURE_FOR_STATE_OPERATION | NUMBER(1,0) | Yes |
| INCLUDED_IN_GROUP | VARCHAR2(20 BYTE) | Yes |
| PARENTID | VARCHAR2(100 BYTE) | Yes |
| IS_READABLE_FROM_STATE_FILE | NUMBER(38,0) | Yes |
| CONSIDER_REPORT_VALUE_FROM | NUMBER(38,0) | Yes |
GENERATING_UNIT
Generating unit information can be found at GENERATING_UNIT table
select ID, FK_GENERATING_STATION, FK_STAGE, UNIT_NUMBER, UNIT_NAME, GENERATING_VOLTAGE_KV, GENERATION_HIGH_VOLTAGE_KV, MVA_CAPACITY, INSTALLED_CAPACITY, DATETIME_OF_COMMISSIONING, DATETIME_OF_COD, DATETIME_OF_DECOMMISSIONING from GENERATING_UNIT
| name | type | nullable |
|---|---|---|
| AUXILARY_CONSUMPTION | NUMBER(38,0) | Yes |
| CONFIGURE_FOR_SCADA | NUMBER(1,0) | Yes |
| CONFIGURE_FOR_STATE_OPERATION | NUMBER(1,0) | Yes |
| CONSIDER_REPORT_VALUE_FROM | NUMBER(38,0) | Yes |
| CREATED_BY | VARCHAR2(100 BYTE) | Yes |
| CREATED_DATE | TIMESTAMP(6) | Yes |
| DATETIME_OF_COD | TIMESTAMP(6) | Yes |
| DATETIME_OF_COMMISSIONING | TIMESTAMP(6) | Yes |
| DATETIME_OF_DECOMMISSIONING | TIMESTAMP(6) | Yes |
| DERATED_CAPACITY | NUMBER(20,2) | Yes |
| DIFFERENTIAL_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| DIFFERENTIAL_PROT_SET | VARCHAR2(50 BYTE) | Yes |
| EARTH_FAULT_OC_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| EARTH_FAULT_OC_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| EFFECTIVE_CAPACITY | NUMBER(38,0) | Yes |
| FK_GENERATING_STATION | NUMBER(38,0) | Yes |
| FK_STAGE | NUMBER(38,0) | Yes |
| FREQUENCY_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| FREQUENCY_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| FRL_DATE_OF_INSTALLATION | VARCHAR2(50 BYTE) | Yes |
| FRL_STATUS | NUMBER | Yes |
| FRL_TYPE | VARCHAR2(50 BYTE) | Yes |
| FUEL | NUMBER(38,0) | Yes |
| FUEL_TYPE | NUMBER(38,0) | Yes |
| GENERATING_VOLTAGE_KV | NUMBER(20,2) | Yes |
| GENERATION_HIGH_VOLTAGE_KV | NUMBER(20,2) | Yes |
| GEN_GT_BREAKER_LBB_MAKE | VARCHAR2(50 BYTE) | Yes |
| GEN_GT_BREAKER_LBB_SETTING | VARCHAR2(50 BYTE) | Yes |
| GROUNDING_R_PU | NUMBER(20,2) | Yes |
| GROUNDING_X_PU | NUMBER(20,2) | Yes |
| ID | NUMBER(38,0) | No |
| INSTALLED_CAPACITY | NUMBER(20,2) | Yes |
| INSTALLED_CAPACITY_MU | NUMBER(38,7) | Yes |
| IS_IN_FIRM | NUMBER | Yes |
| IS_READABLE_FROM_STATE_FILE | NUMBER(38,0) | Yes |
| LOCATION_ID | NUMBER(38,0) | Yes |
| MAX_CONTINUOUS_GEN_CAPACITY_MW | NUMBER(20,2) | Yes |
| MIN_CONTINUOUS_GEN_CAPACITY_MW | NUMBER(20,2) | Yes |
| MODE_OF_AVAILING_STARTUP_POWER | VARCHAR2(50 BYTE) | Yes |
| MODIFED_BY | VARCHAR2(100 BYTE) | Yes |
| MODIFED_DATE | TIMESTAMP(6) | Yes |
| MVA_CAPACITY | NUMBER(20,2) | Yes |
| NEGATIVE_R_PU | NUMBER(20,2) | Yes |
| NEGATIVE_X_PU | NUMBER(20,2) | Yes |
| NEG_PHASE_SEQ_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| NEG_PHASE_SEQ_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| NORMATIVE_AUXILARY_CONSUMPTION | NUMBER(20,2) | Yes |
| NORMATIVE_RAMP_DOWN | NUMBER(20,2) | Yes |
| NORMATIVE_RAMP_UP | NUMBER(20,2) | Yes |
| OA_DIFFERENTIAL_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| OA_DIFFERENTIAL_PROT_SET | VARCHAR2(50 BYTE) | Yes |
| OVER_FLUX_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| OVER_FLUX_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| OVER_VOLTAGE_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| OVER_VOLTAGE_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| POSITIVE_R_PU | NUMBER(20,2) | Yes |
| POSITIVE_X_PU | NUMBER(20,2) | Yes |
| PSSE_MAPPING_ID | NUMBER(38,0) | Yes |
| PSSE_MAPPING_NAME | VARCHAR2(50 BYTE) | Yes |
| QMAX_MVAR | NUMBER(20,2) | Yes |
| QMAX_MVAR_LAGGING_AT_RATED_MW | NUMBER(20,2) | Yes |
| QMAX_MVAR_LEADING_AT_RATED_MW | NUMBER(20,2) | Yes |
| QMIN_MVAR | NUMBER(20,2) | Yes |
| REST_EARTH_FAULT_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| REST_EARTH_FAULT_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| REV_LOW_FWD_POWER_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| REV_LOW_FWD_POWER_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| SEF_PROT_100_PERC_MAKE | VARCHAR2(50 BYTE) | Yes |
| SEF_PROT_100_PERC_SETTING | VARCHAR2(50 BYTE) | Yes |
| SEF_PROT_95_PERC_MAKE | VARCHAR2(50 BYTE) | Yes |
| SEF_PROT_95_PERC_SETTING | VARCHAR2(50 BYTE) | Yes |
| SPS | VARCHAR2(50 CHAR) | Yes |
| STARTUP_POWER_APPROVAL_DATE | TIMESTAMP(6) | Yes |
| STARTUP_POWER_APPROVAL_NUMBER | NUMBER(20,2) | Yes |
| STARTUP_POWER_EXTENDED_PERIOD1 | TIMESTAMP(6) | Yes |
| STARTUP_POWER_EXTENDED_PERIOD2 | TIMESTAMP(6) | Yes |
| STARTUP_POWER_EXTENDED_PERIOD3 | TIMESTAMP(6) | Yes |
| STARTUP_POWER_FROM_PERIOD | TIMESTAMP(6) | Yes |
| STARTUP_POWER_GRANTED | NUMBER(20,2) | Yes |
| STARTUP_POWER_MAX_MW | NUMBER(20,2) | Yes |
| STARTUP_POWER_REQUIREMENT | NUMBER(20,2) | Yes |
| STARTUP_POWER_TO_PERIOD | TIMESTAMP(6) | Yes |
| STATION_TYPE | NUMBER(38,0) | Yes |
| T00_DO_SEC | NUMBER(38,0) | Yes |
| T00_QO_SEC | NUMBER(38,0) | Yes |
| T0_DO_SEC | NUMBER(38,0) | Yes |
| T0_QO_SEC | NUMBER(38,0) | Yes |
| UAT_EARTH_FAULT_OC_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| UAT_EARTH_FAULT_OC_PROT_SET | VARCHAR2(50 BYTE) | Yes |
| UNDER_EXCITATION_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| UNDER_EXCITATION_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| UNDER_IMPEDENCE_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| UNDER_IMPEDENCE_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| UNDER_VOLTAGE_PROT_MAKE | VARCHAR2(50 BYTE) | Yes |
| UNDER_VOLTAGE_PROT_SETTING | VARCHAR2(50 BYTE) | Yes |
| UNIQUE_CODE | VARCHAR2(50 BYTE) | Yes |
| UNIT_ID | VARCHAR2(50 BYTE) | Yes |
| UNIT_NAME | VARCHAR2(100 BYTE) | Yes |
| UNIT_NUMBER | NUMBER(38,0) | Yes |
| VARIABLE_COST | NUMBER(38,0) | Yes |
| VERNOR_DROOP | VARCHAR2(50 BYTE) | Yes |
| VERNOR_TIME_CONSTANT | VARCHAR2(50 BYTE) | Yes |
| VERNOR_TYPE | VARCHAR2(50 BYTE) | Yes |
| VOLT_BALANCE_FUNCTION_MAKE | VARCHAR2(50 BYTE) | Yes |
| VOLT_BALANCE_FUNCTION_SETTING | VARCHAR2(50 BYTE) | Yes |
| X00D_PU | NUMBER(20,2) | Yes |
| X00Q_PU | NUMBER(20,2) | Yes |
| X0D_PU | NUMBER(20,2) | Yes |
| X0Q_PU | NUMBER(20,2) | Yes |
| XD_PU | NUMBER(20,2) | Yes |
| XL_PU | NUMBER(20,2) | Yes |
| XQ_PU | NUMBER(20,2) | Yes |
| ZERO_R_PU | NUMBER(20,2) | Yes |
| ZERO_X_PU | NUMBER(20,2) | Yes |
Fuel information can be found at FUEL, GENERATING_STATION_TYPE, TYPE_FUEL_RELATION table