FSC Entity - POSOCO/wrldc_warehouse_data_migration_python GitHub Wiki
FSC
select ID, FSC_NAME, FK_LINE, FK_SUBSTATION, LOCATION_ID, PERC_COMPENSATION, LINE_REACTANCE_OHMS, CAPACITOR_REACTANCE_OHMS, RATED_MVAR_PHASE, RATED_CURRENT_AMPS, DATETIME_OF_COMMISSIONING, DATETIME_OF_COD, DATETIME_OF_DECOMMISSIONING from REPORTING_WEB_UI_UAT.FSC
| name |
type |
nullable |
| ID |
NUMBER(38,0) |
Yes |
| FK_LINE |
NUMBER(38,0) |
Yes |
| FK_SUBSTATION |
NUMBER(38,0) |
Yes |
| PERC_COMPENSATION |
NUMBER(38,0) |
Yes |
| LINE_REACTANCE_OHMS |
NUMBER(38,0) |
Yes |
| CAPACITOR_REACTANCE_OHMS |
NUMBER(38,0) |
Yes |
| RATED_MVAR_PHASE |
NUMBER(38,0) |
Yes |
| RATED_CURRENT_AMPS |
NUMBER(38,0) |
Yes |
| MAKE |
VARCHAR2(50 BYTE) |
Yes |
| CAP_OVER_LOAD_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| CAP_OVER_LOAD_PROT_SETTINGS |
VARCHAR2(50 BYTE) |
Yes |
| VAR_OVER_TEMP_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| VAR_OVER_TEMP_PROT_SETTINGS |
VARCHAR2(50 BYTE) |
Yes |
| CAP_UNBALANCE_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| CAP_UNBALANCE_PROT_SETTINGS |
VARCHAR2(50 BYTE) |
Yes |
| OVER_VOLTAGE_PROT_MAKE |
VARCHAR2(50 BYTE) |
Yes |
| OVER_VOLTAGE_PROT_SETTINGS |
VARCHAR2(50 BYTE) |
Yes |
| SCADA_DATA_REPORTING_FLAG |
VARCHAR2(10 BYTE) |
Yes |
| AUTOMATIC_BYPASS_FLAG |
VARCHAR2(10 BYTE) |
Yes |
| FSC_INTO_SERVICE_MIN_CUR |
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 |
| LOCATION_ID |
NUMBER(38,0) |
Yes |
| LINE_TYPE_ID |
NUMBER(38,0) |
Yes |
| FSC_NAME |
VARCHAR2(100 BYTE) |
Yes |
| DATETIME_OF_COMMISSIONING |
TIMESTAMP(6) |
Yes |
| DATETIME_OF_COD |
TIMESTAMP(6) |
Yes |
| DATETIME_OF_DECOMMISSIONING |
TIMESTAMP(6) |
Yes |
Owners
SELECT ID, PARENT_ENTITY_ATTRIBUTE_ID, CHILD_ENTITY_ATTRIBUTE_ID from REPORTING_WEB_UI_UAT.ENTITY_ENTITY_RELN WHERE PARENT_ENTITY='FSC' and PARENT_ENTITY_ATTRIBUTE='Owner' and CHILD_ENTITY='OWNER' and CHILD_ENTITY_ATTRIBUTE='OwnerId'