About the Generic Entity Inbound Interface

Owned by Natalie Gesin (Deactivated)
Last updated: Oct 23, 2024 by Kinga Huszno
1 min read

Overview

Generic Entity inbound interface allows loading and updating the data in the following database tables:

RULESDBO.ENTITY
RULESDBO.ENTITY_EXTENSION
RULESDBO.ENTITY_STAR_PROCESSING
RULESDBO.ENTITY_EXTENSION_DETAIL
SECURITYDBO.LEI_DETAILS
RULESDBO.ENTITY_XREFERENCE

Relationship between DB tables ENTITY and ENTITY_EXTENSION (1:1):

RULESDBO.ENTITY_EXTENSION.ENTITY.ID = RULESDBO.ENTITY.ENTITY_ID

Relationship between DB tables ENTITY and ENTITY_STAR_PROCESSING (1:1):

RULESDBO.ENTITY_STAR_PROCESSING.ENTITY.ID = RULESDBO.ENTITY.ENTITY_ID

Relationship between DB tables ENTITY and ENTITY_EXTENSION (1:1):

RULESDBO.ENTITY_EXTENSION.ENTITY.ID = RULESDBO.ENTITY.ENTITY_ID

Relationship between DB tables ENTITY and ENTITY_EXTENSION_DETAIL (1:1):

RULESDBO.ENTITY_EXTENSION_DETAIL.ENTITY.ID = RULESDBO.ENTITY.ENTITY_ID

Relationship between DB tables ENTITY and LEI_DETAILS (1:1):

SECURITYDBO.LEI_DETAILS.LEI = RULESDBO.ENTITY.LEI

Relationship between DB tables ENTITY and ENTITY_XREFERENCE (1:N):

RULESDBO.ENTITY_XREFERENCE.ENTITY.ID = RULESDBO.ENTITY.ENTITY_ID

Format of incoming message is EagleML.

Stream Logic

For loading or updating data in ENTITY tables, send your EagleML message to the eagle_ml-2-0_default_in_xml_entity stream.

Header Element

Please note, that you should use 

<header> <objectType>GenericEntity</objectType> </header>

before your genericEntity section of the message. Otherwise you will be getting "No rule file selected" error

Entity Id Element

The element Entity Id (entityTransaction/genericEntity/entiyId) binds all DB tables in the main section. The Entity Id could be specified directly in the EagleML message or it could be calculated by Enttiy Xreference Identifiers used Entity Resolution Logic.

Main (Generic Entity) Section

The data from the main section of EagleML message (all elements from EagleML/entityTransaction/genericEntity complex node except legalEntityId complex element) are loaded into RULESDBO.ENTITY, RULESDBO. ENTITY_STAR_PROCESSING, RULESDBO.ENTITY_EXTENSION and RULESDBO.ENTITY_EXTENSION_DETAIL database tables.
See the additional information about Generic Entity section

Legal Entity Id Section

The data from the Legal Entity Id (LEI) section (complex node legalEntityId) of EagleML message are loaded into SECURITYDBO.LEI_DETAILS DB table.
See the additional information about Legal Entity Id section

Entity Xreference Section

The new entity xreference identifiers could be inserted into the RULESDBO.ENTITY_XREFERENCE DB table.
See the additional information about Legal Entity Xreference section

Also, see specific load cases for Generic Entity