Generic Entity - LEI Model Data Map Table
- Natalie Gesin (Deactivated)
- Dmitry Donosiyan (Unlicensed)
Element | Optional/ Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | DB Required | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|---|
legalId | Optional | string | 5089 | in_lei | S | RULESDBO | ENTITY | LEI | VARCHAR2(20) | N | EagleML/entityTransaction/genericEntity/legalEntityId/legalId |
SECURITYDBO | LEI_DETAILS | LEI | VARCHAR2(20) | Y | |||||||
legalName | Optional | string | 5090 | in_lei_legal_name | S | RULESDBO | ENTITY | LEGAL_NAME | VARCHAR2(200) | N | EagleML/entityTransaction/genericEntity/legalEntityId/legalName |
SECURITYDBO | LEI_DETAILS | LEGAL_NAME | NVARCHAR2(255) | N | |||||||
entityStatus | Optional | string | 5192 | in_lei_entity_status | S | SECURITYDBO | LEI_DETAILS | ENTITY_STATUS | NVARCHAR2(30) | N | EagleML/entityTransaction/genericEntity/legalEntityId/entityStatus |
legalForm | Optional | string | 5193 | in_lei_legal_form | S | SECURITYDBO | LEI_DETAILS | LEGAL_FORM | NVARCHAR2(30) | N | EagleML/entityTransaction/genericEntity/legalEntityId/legalForm |
idAssignedDate | Optional | date | 5093 | in_lei_id_assigned_date | S | SECURITYDBO | LEI_DETAILS | ID_ASSIGNED_DATE | DATE | N | EagleML/entityTransaction/genericEntity/legalEntityId/idAssignedDate |
idLastUpdateDate | Optional | date | 5094 | in_lei_id_last_update_date | S | SECURITYDBO | LEI_DETAILS | ID_LAST_UPDATE_DATE | DATE | N | EagleML/entityTransaction/genericEntity/legalEntityId/idLastUpdateDate |
idDisabledDate | Optional | date | 5095 | in_lei_id_disabled_date | S | SECURITYDBO | LEI_DETAILS | ID_DISABLED_DATE | DATE | N | EagleML/entityTransaction/genericEntity/legalEntityId/idDisabledDate |
idRecordState | Optional | string | 5096 | in_lei_id_record_state | S | SECURITYDBO | LEI_DETAILS | ID_RECORD_STATE | NVARCHAR2(30) | N | EagleML/entityTransaction/genericEntity/legalEntityId/idRecordState |
idCertificationState | Optional | string | 5097 | in_lei_id_certification_state | S | SECURITYDBO | LEI_DETAILS | ID_CERTIFICATION_STATE | NVARCHAR2(30) | N | EagleML/entityTransaction/genericEntity/legalEntityId/idCertificationState |
street | Optional | string | 5098 | in_lei_street | S | SECURITYDBO | LEI_DETAILS | STREET | NVARCHAR2(255) | N | EagleML/entityTransaction/genericEntity/legalEntityId/street |
city | Optional | string | 5099 | in_lei_city | S | SECURITYDBO | LEI_DETAILS | CITY | NVARCHAR2(255) | N | EagleML/entityTransaction/genericEntity/legalEntityId/city |
state | Optional | string | 5100 | in_lei_state | S | SECURITYDBO | LEI_DETAILS | STATE | NVARCHAR2(255) | N | EagleML/entityTransaction/genericEntity/legalEntityId/state |
zip | Optional | string | 5180 | in_lei_zip | S | SECURITYDBO | LEI_DETAILS | ZIP | NVARCHAR2(255) | N | EagleML/entityTransaction/genericEntity/legalEntityId/zip |
countryCode | Optional | string | 5181 | in_lei_country_code | S | SECURITYDBO | LEI_DETAILS | COUNTRY_CODE | NVARCHAR2(30) | N | EagleML/entityTransaction/genericEntity/legalEntityId/countryCode |