LEI Model Data Map
- 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 | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|
legalId | Optional | string | 5089 | in_lei | S | SECURITYDBO | LEI_DETAILS/ ISSUER_ORGANIZATION | LEI | VARCHAR2(20) | EagleML/referenceTransaction/issuerOrganization/legalEntityId/legalId |
legalName | Optional | string | 5090 | in_legal_name | S | SECURITYDBO | LEI_DETAILS | LEGAL_NAME | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/legalEntityId/legalName |
entityStatus | Optional | string | 5091 | in_entity_status | S | SECURITYDBO | LEI_DETAILS | ENTITY_STATUS | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/legalEntityId/entityStatus |
legalForm | Optional | string | 5092 | in_legal_form | S | SECURITYDBO | LEI_DETAILS | LEGAL_FORM | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/legalEntityId/legalForm |
idAssignedDate | Optional | date | 5093 | in_id_assigned_date | S | SECURITYDBO | LEI_DETAILS | ID_ASSIGNED_DATE | DATE | EagleML/referenceTransaction/issuerOrganization/legalEntityId/idAssignedDate |
idLastUpdateDate | Optional | date | 5094 | in_id_last_update_date | S | SECURITYDBO | LEI_DETAILS | ID_LAST_UPDATE_DATE | DATE | EagleML/referenceTransaction/issuerOrganization/legalEntityId/idLastUpdateDate |
idDisabledDate | Optional | date | 5095 | in_id_disabled_date | S | SECURITYDBO | LEI_DETAILS | ID_DISABLED_DATE | DATE | EagleML/referenceTransaction/issuerOrganization/legalEntityId/idDisabledDate |
idRecordState | Optional | string | 5096 | in_id_record_state | S | SECURITYDBO | LEI_DETAILS | ID_RECORD_STATE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/legalEntityId/idRecordState |
idCertificationState | Optional | string | 5097 | in_id_certification_state | S | SECURITYDBO | LEI_DETAILS | ID_CERTIFICATION_STATE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/legalEntityId/idCertificationState |
street | Optional | string | 5098 | in_street | S | SECURITYDBO | LEI_DETAILS | STREET | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/legalEntityId/street |
city | Optional | string | 5099 | in_city | S | SECURITYDBO | LEI_DETAILS | CITY | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/legalEntityId/city |
state | Optional | string | 5100 | in_state | S | SECURITYDBO | LEI_DETAILS | STATE | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/legalEntityId/state |
zip | Optional | string | 5180 | in_zip | S | SECURITYDBO | LEI_DETAILS | ZIP | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/legalEntityId/zip |
countryCode | Optional | string | 5181 | in_country_code | S | SECURITYDBO | LEI_DETAILS | COUNTRY_CODE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/legalEntityId/countryCode |