Owners Information - POSOCO/wrldc_warehouse_data_migration_python GitHub Wiki
OWNER
| column_name | column_type | nullable |
|---|---|---|
| ID | NUMBER(38,0) | No |
| OWNER_NAME | 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 |
| FK_CONSTITUENTID | NUMBER(38,0) | Yes |
Mapping of owners to elements
ENTITY_ENTITY_RELN is the table used to store the elements owner information
If the element is a Transmission line, then we should search for PARENT_ENTITY='AC_TRANSMISSION_LINE' and PARENT_ENTITY_ATTRIBUTE_ID = , PARENT_ENTITY_ATTRIBUTE='Owner', CHILD_ENTITY='OWNER', CHILD_ENTITY_ATTRIBUTE='OwnerId', and then get the CHILD_ENTITY_ATTRIBUTE_ID, which is the owner id
| column_name | column_type | nullable |
|---|---|---|
| ID | NUMBER(38,0) | No |
| PARENT_ENTITY | VARCHAR2(50 BYTE) | Yes |
| PARENT_ENTITY_ATTRIBUTE | VARCHAR2(50 BYTE) | Yes |
| PARENT_ENTITY_ATTRIBUTE_ID | NUMBER(38,0) | Yes |
| CHILD_ENTITY | VARCHAR2(50 BYTE) | Yes |
| CHILD_ENTITY_ATTRIBUTE | VARCHAR2(50 BYTE) | Yes |
| CHILD_ENTITY_ATTRIBUTE_ID | 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 |
| PARENT_ENTITY_ID | NUMBER | Yes |
possible values for PARENT_ENTITY attribute are MSR, ASSOCIATE_SUBSTATION, FSC, HVDC_LINE, TCSC, AC_TRANSMISSION_LINE, LINE_REACTOR, TRANSFORMER, BUS_REACTOR, HVDC_POLE, GENERATING_STATION, BAY, FILTER_BANK, SVC, STATCOM, MSC