...
| Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | Data Type | XPATH | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectType | Optional | ObjectTypeEnum | not stored in DB | EagleML/referenceTransaction/issuer/objectType | ||||||||||||
| objectId | Optional | ObjectId | not stored in DB | EagleML/referenceTransaction/issuer/objectId | ||||||||||||
| objectDescription | Optional | FeedTypeEnum | not stored in DB | EagleML/referenceTransaction/issuer/objectDescription | ||||||||||||
| updateTimestamp | Optional | dateTime | SECURITYDBO | ISSUER_ORGANIZATION | UPDATE_DATE | DATE | EagleML/referenceTransaction/issuer/updateTimestamp | |||||||||
| customElements | Optional | CustomElements | reserved for customizations | EagleML/referenceTransaction/issuer/customElements | ||||||||||||
| sourceName | Optional | string - involved in resolution logics | 1102 | in_short_desc | S | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/issuer/sourceName | ||||||
| updateSource | Optional | string | 944 | in_update_source | S | SECURITYDBO | ISSUER_ORGANIZATION | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/issuer/updateSource | ||||||
| effectiveDate | Optional | date | 1109 | in_effective_date | S | SECURITYDBO | ISSUER_ORGANIZATION | UPDATE_DATE | DATE | EagleML/referenceTransaction/issuer/effectiveDate | ||||||
| languageId | Optional | integer | not stored in DB | EagleML/referenceTransaction/issuer/languageId | ||||||||||||
| tagNochangecase | Optional | string | not stored in DB | EagleML/referenceTransaction/issuer/tagNochangecase | ||||||||||||
| preserveNull | Optional | string | not stored in DB | EagleML/referenceTransaction/issuer/preserveNull | ||||||||||||
| noLoadValidationFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/issuer/noLoadValidationFlag | ||||||||||||
| issuerId | Required | string | 1144 | in_issuer_id | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_ID | CHAR(20) | EagleML/referenceTransaction/issuer/issuerId | ||||||
| issuerName | Optional | string | 1173 | in_issuer_name | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_NAME | VARCHAR2(255) | EagleML/referenceTransaction/issuer/issuerName | ||||||
| issuerAlias | Optional | integer | 1147 | in_issuer_alias | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_ALIAS | NUMBER | EagleML/referenceTransaction/issuer/issuerAlias | ||||||
| issuerXrefIdentifiers | IssuerXrefIdentifiers - Complex type (see extra table) | EagleML/referenceTransaction/issuer/issuerXrefIdentifiers/ | ||||||||||||||
| organizationModel | OrganizationModel - complex type (see extra table below) | EagleML/referenceTransaction/issuer//organizationModel/ | ||||||||||||||
| roleModel | RoleModel - complex type (see extra table below) | EagleML/referenceTransaction/issuer/roleModel/ | ||||||||||||||
| relationshipModel | RelationshipModel - complex type (see extra table below) | EagleML/referenceTransaction/issuer/relationshipModel/ | ||||||||||||||
| ratingModel | RatingModel - complex type (see extra table below) | EagleML/referenceTransaction/issuer/ratingModel/ | ||||||||||||||
| xrefModel | XrefModel - complex type (see extra table below) | EagleML/referenceTransaction/issuer/xrefModel/ | ||||||||||||||
| legalEntityId | LEI - complex type (see extra table below) | EagleML/referenceTransaction/issuer/legalEntityId/ | ||||||||||||||
| ||||||||||||||||
| Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | Data Type | XPATH | ||||||
| address | Optional | string | 1145 | in_address | S | SECURITYDBO | ISSUER_ORGANIZATION | ADDRESS | VARCHAR2(255) | EagleML/referenceTransaction/issuer/organizationModel/address | ||||||
| city | Optional | string | 681 | in_city | S | SECURITYDBO | ISSUER_ORGANIZATION | CITY | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/city | ||||||
| state | Optional | string | 1153 | in_state | S | SECURITYDBO | ISSUER_ORGANIZATION | STATE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/state | ||||||
| userChar1 | Optional | string | not stored in DB | EagleML/referenceTransaction/issuer/organizationModel/userChar1 | ||||||||||||
| userChar2 | Optional | string | not stored in DB | EagleML/referenceTransaction/issuer/organizationModel/userChar2 | ||||||||||||
| userChar4 | Optional | string | not stored in DB | EagleML/referenceTransaction/issuer/organizationModel/userChar4 | ||||||||||||
| userChar5 | Optional | string | not stored in DB | EagleML/referenceTransaction/issuer/organizationModel/userChar5 | ||||||||||||
| userChar6 | Optional | string | not stored in DB | EagleML/referenceTransaction/issuer/organizationModel/userChar6 | ||||||||||||
| countryOfRiskCode | Optional | string | SECURITYDBO | ISSUER_ORGANIZATION | COUNTRY_OF_DOMICLE | CHAR(30) | EagleML/referenceTransaction/issuer/organizationModel/countryOfRiskCode | |||||||||
| countryOfIncorporationCode | Optional | string | 1174 | in_country_incorporation | S | SECURITYDBO | ISSUER_ORGANIZATION | COUNTRY_INCORPORATION | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/countryOfIncorporationCode | ||||||
| currency | Optional | CurrencyCode | 1172 | in_currency | S | SECURITYDBO | ISSUER_ORGANIZATION | CURRENCY | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/currency | ||||||
| industryCode | Optional | string | 1155 | in_industry_code | S | SECURITYDBO | ISSUER_ORGANIZATION | INDUSTRY_CODE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/industryCode | ||||||
| industrySector1 | Optional | string | 1156 | in_industry_sector1 | S | SECURITYDBO | ISSUER_ORGANIZATION | INDUSTRY_SECTOR1 | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/industrySector1 | ||||||
| industrySector2 | Optional | string | 1171 | in_industry_sector2 | S | SECURITYDBO | ISSUER_ORGANIZATION | INDUSTRY_SECTOR2 | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/industrySector2 | ||||||
| industrySector3 | Optional | string | 1154 | in_industry_sector3 | S | SECURITYDBO | ISSUER_ORGANIZATION | INDUSTRY_SECTOR3 | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/industrySector3 | ||||||
| classificationSector1 | Optional | string | 3418 | in_classification_sector1 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_SECTOR1 | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/classificationSector1 | ||||||
| classificationSector2 | Optional | string | 3419 | in_classification_sector2 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_SECTOR2 | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/classificationSector2 | ||||||
| classificationSector3 | Optional | string | 1170 | in_classification_sector3 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_SECTOR3 | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/classificationSector3 | ||||||
| primaryAnalyst | Optional | string | 3421 | in_primary_analyst | S | SECURITYDBO | ISSUER_ORGANIZATION | PRIMARY_ANALYST | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/primaryAnalyst | ||||||
| creditAnalyst | Optional | string | 3422 | in_credit_analyst | S | SECURITYDBO | ISSUER_ORGANIZATION | CREDIT_ANALYST | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/creditAnalyst | ||||||
| updateDate | Required | date | SECURITYDBO | ISSUER_ORGANIZATION | UPDATE_DATE | DATE | EagleML/referenceTransaction/issuer/organizationModel/updateDate | |||||||||
| shortDesc | Optional | string | 1102 | in_short_desc | S | not stored in DB | EagleML/referenceTransaction/issuer/organizationModel/shortDesc | |||||||||
| countryExposure | Optional | string | 1152 | in_country_exposure | S | SECURITYDBO | ISSUER_ORGANIZATION | COUNTRY_EXPOSURE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/countryExposure | ||||||
| issuerChar1 | Optional | string | 3423 | in_issuer_char1 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR1 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar1 | ||||||
| issuerChar2 | Optional | string | 3424 | in_issuer_char2 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR2 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar2 | ||||||
| issuerChar3 | Optional | string | 3425 | in_issuer_char3 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR3 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar3 | ||||||
| issuerChar4 | Optional | string | 3426 | in_issuer_char4 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR4 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar4 | ||||||
| issuerChar5 | Optional | string | 3427 | in_issuer_char5 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR5 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar5 | ||||||
| issuerChar6 | Optional | string | 3428 | in_issuer_char6 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR6 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar6 | ||||||
| issuerChar7 | Optional | string | 3429 | in_issuer_char7 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR7 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar7 | ||||||
| issuerChar8 | Optional | string | 8101 | in_issuer_char8 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR8 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar8 | ||||||
| issuerChar9 | Optional | string | 8102 | in_issuer_char9 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR9 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar9 | ||||||
| issuerChar10 | Optional | string | 8103 | in_issuer_char10 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR10 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar10 | ||||||
| issuerChar11 | Optional | string | 8104 | in_issuer_char11 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR11 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar11 | ||||||
| issuerChar12 | Optional | string | 8105 | in_issuer_char12 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR12 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar12 | ||||||
| issuerChar13 | Optional | string | 8106 | in_issuer_char13 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR13 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar13 | ||||||
| issuerChar14 | Optional | string | 8107 | in_issuer_char14 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR14 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar14 | ||||||
| issuerChar15 | Optional | string | 8108 | in_issuer_char15 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR15 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/issuerChar15 | ||||||
| issuerDate1 | Optional | date | 3435 | in_issuer_date1 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_DATE1 | DATE | EagleML/referenceTransaction/issuer/organizationModel/issuerDate1 | ||||||
| issuerDate2 | Optional | date | 3436 | in_issuer_date2 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_DATE2 | DATE | EagleML/referenceTransaction/issuer/organizationModel/issuerDate2 | ||||||
| issuerDate3 | Optional | date | 3437 | in_issuer_date3 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_DATE3 | DATE | EagleML/referenceTransaction/issuer/organizationModel/issuerDate3 | ||||||
| issuerDate4 | Optional | date | 3438 | in_issuer_date4 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_DATE4 | DATE | EagleML/referenceTransaction/issuer/organizationModel/issuerDate4 | ||||||
| issuerDate5 | Optional | date | 3439 | in_issuer_date5 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_DATE5 | DATE | EagleML/referenceTransaction/issuer/organizationModel/issuerDate5 | ||||||
| issuerFloat1 | Optional | decimal | 3430 | in_issuer_float1 | F | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/issuer/organizationModel/issuerFloat1 | ||||||
| issuerFloat2 | Optional | decimal | 3431 | in_issuer_float2 | F | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_FLOAT2 | NUMBER(28,12) | EagleML/referenceTransaction/issuer/organizationModel/issuerFloat2 | ||||||
| issuerFloat3 | Optional | decimal | 3432 | in_issuer_float3 | F | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_FLOAT3 | NUMBER(28,12) | EagleML/referenceTransaction/issuer/organizationModel/issuerFloat3 | ||||||
| issuerFloat4 | Optional | decimal | 3433 | in_issuer_float4 | F | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_FLOAT4 | NUMBER(28,12) | EagleML/referenceTransaction/issuer/organizationModel/issuerFloat4 | ||||||
| issuerFloat5 | Optional | decimal | 3434 | in_issuer_float5 | F | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_FLOAT5 | NUMBER(28,12) | EagleML/referenceTransaction/issuer/organizationModel/issuerFloat5 | ||||||
| countryDomicile | Optional | decimal | 4353 | in_country_domicile | S | SECURITYDBO | ISSUER_ORGANIZATION | COUNTRY_DOMICILE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/countryDomicile | ||||||
| counterparty | Optional | string | 213 | in_counterparty | S | SECURITYDBO | ISSUER_ORGANIZATION | COUNTERPARTY | VARCHAR2(1) | EagleML/referenceTransaction/issuer/organizationModel/counterparty | ||||||
| classification4 | Optional | string | 3491 | in_classification_4 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_4 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification4 | ||||||
| class4Source | Optional | string | 3458 | in_class_4_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_4_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class4Source | ||||||
| class4Level | Optional | integer | 1198 | in_class_4_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_4_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class4Level | ||||||
| classification5 | Optional | string | 3492 | in_classification_5 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_5 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification5 | ||||||
| class5Source | Optional | string | 3460 | in_class_5_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_5_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class5Source | ||||||
| class5Level | Optional | integer | 1148 | in_class_5_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_5_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class5Level | ||||||
| classification6 | Optional | string | 3461 | in_classification_6 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_6 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification6 | ||||||
| class6Source | Optional | string | 3462 | in_class_6_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_6_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class6Source | ||||||
| class6Level | Optional | integer | 1149 | in_class_6_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_6_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class6Level | ||||||
| classification7 | Optional | string | 3463 | in_classification_7 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_7 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification7 | ||||||
| class7Source | Optional | string | 3464 | in_class_7_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_7_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class7Source | ||||||
| class7Level | Optional | integer | 1150 | in_class_7_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_7_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class7Level | ||||||
| classification8 | Optional | string | 3465 | in_classification_8 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_8 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification8 | ||||||
| class8Source | Optional | string | 3466 | in_class_8_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_8_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class8Source | ||||||
| class8Level | Optional | integer | 1151 | in_class_8_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_8_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class8Level | ||||||
| classification9 | Optional | string | 3467 | in_classification_9 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_9 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification9 | ||||||
| class9Source | Optional | string | 3468 | in_class_9_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_9_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class9Source | ||||||
| class9Level | Optional | integer | 1158 | in_class_9_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_9_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class9Level | ||||||
| classification10 | Optional | string | 3469 | in_classification_10 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_10 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification10 | ||||||
| class10Source | Optional | string | 3470 | in_class_10_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_10_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class10Source | ||||||
| class10Level | Optional | integer | 1159 | in_class_10_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_10_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class10Level | ||||||
| classification11 | Optional | string | 3471 | in_classification_11 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_11 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification11 | ||||||
| class11Source | Optional | string | 3493 | in_class_11_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_11_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class11Source | ||||||
| class11Level | Optional | integer | 1160 | in_class_11_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_11_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class11Level | ||||||
| classification12 | Optional | string | 3473 | in_classification_12 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_12 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification12 | ||||||
| class12Source | Optional | string | 3474 | in_class_12_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_12_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class12Source | ||||||
| class12Level | Optional | integer | 1161 | in_class_12_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_12_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class12Level | ||||||
| classification13 | Optional | string | 3475 | in_classification_13 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_13 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification13 | ||||||
| class13Source | Optional | string | 3476 | in_class_13_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_13_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class13Source | ||||||
| class13Level | Optional | integer | 1162 | in_class_13_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_13_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class13Level | ||||||
| classification14 | Optional | string | 3477 | in_classification_14 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_14 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification14 | ||||||
| class14Source | Optional | string | 3494 | in_class_14_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_14_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class14Source | ||||||
| class14Level | Optional | integer | 1163 | in_class_14_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_14_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class14Level | ||||||
| classification15 | Optional | string | 3495 | in_classification_15 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_15 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification15 | ||||||
| class15Source | Optional | string | 3496 | in_class_15_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_15_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class15Source | ||||||
| class15Level | Optional | integer | 1164 | in_class_15_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_15_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class15Level | ||||||
| classification16 | Optional | string | 3481 | in_classification_16 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_16 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification16 | ||||||
| class16Source | Optional | string | 3482 | in_class_16_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_16_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class16Source | ||||||
| class16Level | Optional | integer | 1165 | in_class_16_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_16_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class16Level | ||||||
| classification17 | Optional | string | 3483 | in_classification_17 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_17 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification17 | ||||||
| class17Source | Optional | string | 3484 | in_class_17_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_17_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class17Source | ||||||
| class17Level | Optional | integer | 1166 | in_class_17_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_17_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class17Level | ||||||
| classification18 | Optional | string | 3485 | in_classification_18 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_18 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification18 | ||||||
| class18Source | Optional | string | 3486 | in_class_18_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_18_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class18Source | ||||||
| class18Level | Optional | integer | 1167 | in_class_18_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_18_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class18Level | ||||||
| classification19 | Optional | string | 3487 | in_classification_19 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_19 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification19 | ||||||
| class19Source | Optional | string | 3488 | in_class_19_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_19_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class19Source | ||||||
| class19Level | Optional | integer | 1169 | in_class_19_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_19_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class19Level | ||||||
| classification20 | Optional | string | 3489 | in_classification_20 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_20 (version 2015R2 or higher) | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification20 | ||||||
| class20Source | Optional | string | 3490 | in_class_20_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_20_SOURCE (version 2015R2 or higher) | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class20Source | ||||||
| class20Level | Optional | integer | 1175 | in_class_20_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_20_LEVEL (version 2015R2 or higher) | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class20Level | ||||||
| externalUpdateDate | Optional | date | 16077 | in_external_update_date | S | SECURITYDBO | ISSUER_ORGANIZATION | EXTERNAL_UPDATE_DATE (version 2017R1 or higher) | DATE | EagleML/referenceTransaction/issuer/organizationModel/externalUpdateDate | ||||||
| yearInc | Optional | decimal | 16078 | in_year_inc | N | SECURITYDBO | ISSUER_ORGANIZATION | YEAR_INC (version 2017R1 or higher) | NUMBER(28,12) | EagleML/referenceTransaction/issuer/organizationModel/yearInc | ||||||
| addressLine2 | Optional | string | 16133 | in_address_line_2 | SECURITYDBO | ISSUER_ORGANIZATION | ADDRESS_LINE_2 | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/addressLine2 | |||||||
| zipCode | Optional | string | 16134 | in_zip_code | SECURITYDBO | ISSUER_ORGANIZATION | ZIP_CODE | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/zipCode | |||||||
| acquiredByParent | Optional | YesNoOptionEnum | 16135 | in_acquired_by_parent | SECURITYDBO | ISSUER_ORGANIZATION | ACQUIRED_BY_PARENT | VARCHAR2(1) | EagleML/referenceTransaction/issuerOrganization/acquiredByParent | |||||||
| isUltParent | Optional | YesNoOptionEnum | 16136 | in_is_ult_parent | SECURITYDBO | ISSUER_ORGANIZATION | IS_ULT_PARENT | VARCHAR2(1) | EagleML/referenceTransaction/issuerOrganization/isUltParent | |||||||
| companyCorpTicker | Optional | string | 16137 | in_company_corp_ticker | SECURITYDBO | ISSUER_ORGANIZATION | COMPANY_CORP_TICKER | VARCHAR2(100) | EagleML/referenceTransaction/issuerOrganization/companyCorpTicker | |||||||
| gicsSector | Optional | string | 10181 | in_gics_sector | SECURITYDBO | ISSUER_ORGANIZATION | GICS_SECTOR | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/gicsSector | |||||||
| gicsSectorName | Optional | string | EagleML/referenceTransaction/issuerOrganization/gicsSectorName | |||||||||||||
| gicsIndustryGroup | Optional | string | 10183 | in_gics_industry_group | SECURITYDBO | ISSUER_ORGANIZATION | GICS_INDUSTRY_GROUP | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/gicsIndustryGroup | |||||||
| gicsIndustryGroupName | Optional | string | EagleML/referenceTransaction/issuerOrganization/gicsIndustryGroupName | |||||||||||||
| gicsIndustry | Optional | string | SECURITYDBO | ISSUER_ORGANIZATION | GICS_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/gicsIndustry | |||||||||
| gicsIndustryName | Optional | string | EagleML/referenceTransaction/issuerOrganization/gicsIndustryName | |||||||||||||
| gicsSubIndustry | Optional | string | SECURITYDBO | ISSUER_ORGANIZATION | GICS_SUB_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/gicsSubIndustry | |||||||||
| gicsSubIndustryName | Optional | string | EagleML/referenceTransaction/issuerOrganization/gicsSubIndustryName | |||||||||||||
| historyOnlyFlag | Optional | YesNoOptionEnum | EagleML/referenceTransaction/issuerOrganization/historyOnlyFlag | |||||||||||||
| issuerType | Optional | string | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_TYPE | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/issuerType | |||||||||
| phone | Optional | string | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_PHONE | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/phone | |||||||||
| cfcFlag | Optional | YesNoOptionEnum | SECURITYDBO | ISSUER_ORGANIZATION | CFC_FLAG | VARCHAR2(1) | EagleML/referenceTransaction/issuerOrganization/cfcFlag | |||||||||
| centralCounterParty | Optional | YesNoOptionEnum | SECURITYDBO | ISSUER_ORGANIZATION | CENTRAL_COUNTER_PARTY | VARCHAR2(1) | EagleML/referenceTransaction/issuerOrganization/centralCounterParty | |||||||||
| ||||||||||||||||
| Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | Data Type | XPATH | ||||||
| roleType | Required | string | 3347 | in_role_type | S | SECURITYDBO | ISSUER_ROLE_DETAILS | ROLE_TYPE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/roleModel/roleType | ||||||
| startDate | Required | date | 71 | in_start_date | S | SECURITYDBO | ISSUER_ROLE_DETAILS | START_DATE | DATE | EagleML/referenceTransaction/issuer/roleModel/startDate | ||||||
| endDate | Optional | date | 73 | in_end_date | S | SECURITYDBO | ISSUER_ROLE_DETAILS | END_DATE | DATE | EagleML/referenceTransaction/issuer/roleModel/endDate | ||||||
| percentOwned | Optional | decimal | 3348 | in_percent_owned | SECURITYDBO | ISSUER_ROLE_DETAILS | PERCENT_OWNED | NUMBER(28,12) | EagleML/referenceTransaction/issuer/roleModel/percentOwned | |||||||
| irdUpdateDate | Optional | date | F | SECURITYDBO | ISSUER_ROLE_DETAILS | IRD_UPDATE_DATE | DATE | EagleML/referenceTransaction/issuer/roleModel/irdUpdateDate | ||||||||
| irdChar1 | Optional | string | 8286 | in_ird_char1 | S | SECURITYDBO | ISSUER_ROLE_DETAILS | IRD_CHAR1 | VARCHAR2(30) | EagleML/referenceTransaction/issuer/roleModel/irdChar1 | ||||||
| ||||||||||||||||
| Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | Data Type | XPATH | ||||||
| fromIssuer | IssuerIdentifiersDataModel - Complex type (see extra table below) | EagleML/referenceTransaction/issuer/relationshipModel/fromIssuer/ | ||||||||||||||
| toIssuer | IssuerIdentifiersDataModel - Complex type (see extra table below) | EagleML/referenceTransaction/issuer/relationshipModel/toIssuer/ | ||||||||||||||
| roleType | Required | string | 8292 | in_role_type | S | SECURITYDBO | ISSUER_RELATIONSHIP | ROLE_TYPE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/relationshipModel/roleType | ||||||
| percentOwned | Optional | decimal | 8291 | in_percent_owned | F | SECURITYDBO | ISSUER_RELATIONSHIP | PERCENT_OWNED | NUMBER(28,12) | EagleML/referenceTransaction/issuer/relationshipModel/percentOwned | ||||||
| ||||||||||||||||
| Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | Data Type | XPATH | ||||||
| alphaRating | Optional | string | 3349 | in_alpha_rating | S | SECURITYDBO | ISSUER_RATING | ALPHA_RATING | CHAR(8) | EagleML/referenceTransaction/issuer/ratingModel/alphaRating | ||||||
| analystCode | Optional | string | 3407 | in_analyst_code | S | SECURITYDBO | ISSUER_RATING | ANALYST_CODE | CHAR(8) | EagleML/referenceTransaction/issuer/ratingModel/analystCode | ||||||
| approvalComments | Optional | string | 3412 | in_approval_comments | S | SECURITYDBO | ISSUER_RATING | APPROVAL_COMMENTS | VARCHAR2(255) | EagleML/referenceTransaction/issuer/ratingModel/approvalComments | ||||||
| approvedBy | Optional | string | 3409 | in_approved_by | S | SECURITYDBO | ISSUER_RATING | APPROVED_BY | CHAR(255) | EagleML/referenceTransaction/issuer/ratingModel/approvedBy | ||||||
| numericalRating | Optional | decimal | 3350 | in_numerical_rating | S | SECURITYDBO | ISSUER_RATING | NUMERICAL_RATING | CHAR(8) | EagleML/referenceTransaction/issuer/ratingModel/numericalRating | ||||||
| program | Optional | string | 3444 | in_program | S | SECURITYDBO | ISSUER_RATING | PROGRAM | VARCHAR2(20) | EagleML/referenceTransaction/issuer/ratingModel/program | ||||||
| provider | Optional | string | 3414 | in_provider | S | SECURITYDBO | ISSUER_RATING | PROVIDER | CHAR(12) | EagleML/referenceTransaction/issuer/ratingModel/provider | ||||||
| ratingCode | Optional | string | 3446 | in_rating_code | S | SECURITYDBO | ISSUER_RATING | RATING_CODE | VARCHAR2(12) | EagleML/referenceTransaction/issuer/ratingModel/ratingCode | ||||||
| ratingComments | Optional | string | 3411 | in_rating_comments | S | SECURITYDBO | ISSUER_RATING | RATING_COMMENTS | VARCHAR2(255) | EagleML/referenceTransaction/issuer/ratingModel/ratingComments | ||||||
| ratingTypeIndicator | Optional | string | 3445 | in_rating_type_indicator | S | SECURITYDBO | ISSUER_RATING | RATING_TYPE_INDICATOR | VARCHAR2(20) | EagleML/referenceTransaction/issuer/ratingModel/ratingTypeIndicator | ||||||
| reason | Optional | string | 3408 | in_reason | S | SECURITYDBO | ISSUER_RATING | REASON | VARCHAR2(255) | EagleML/referenceTransaction/issuer/ratingModel/reason | ||||||
| submittedBy | Optional | string | 3410 | in_submitted_by | S | SECURITYDBO | ISSUER_RATING | SUBMITTED_BY | CHAR(255) | EagleML/referenceTransaction/issuer/ratingModel/submittedBy | ||||||
| submittedDate | Optional | date | 3413 | in_submitted_date | S | SECURITYDBO | ISSUER_RATING | SUBMITTED_DATE | DATE | EagleML/referenceTransaction/issuer/ratingModel/submittedDate | ||||||
| ratingChar1 | Optional | string | 3448 | in_rating_char1 | S | SECURITYDBO | ISSUER_RATING | IR_CHAR1 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/ratingModel/ratingChar1 | ||||||
| ratingChar2 | Optional | string | 3449 | in_rating_char2 | S | SECURITYDBO | ISSUER_RATING | IR_CHAR2 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/ratingModel/ratingChar2 | ||||||
| ratingChar3 | Optional | string | 3450 | in_rating_char3 | S | SECURITYDBO | ISSUER_RATING | IR_CHAR3 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/ratingModel/ratingChar3 | ||||||
| ratingChar4 | Optional | string | 3415 | in_rating_char4 | S | SECURITYDBO | ISSUER_RATING | IR_CHAR4 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/ratingModel/ratingChar4 | ||||||
| ratingChar5 | Optional | string | 3416 | in_rating_char5 | S | SECURITYDBO | ISSUER_RATING | IR_CHAR5 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/ratingModel/ratingChar5 | ||||||
| ratingChar6 | Optional | string | 3417 | in_rating_char6 | S | SECURITYDBO | ISSUER_RATING | IR_CHAR6 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/ratingModel/ratingChar6 | ||||||
| ratingChar7 | Optional | string | 3440 | in_rating_char7 | S | SECURITYDBO | ISSUER_RATING | IR_CHAR7 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/ratingModel/ratingChar7 | ||||||
| ratingChar8 | Optional | string | 3441 | in_rating_char8 | S | SECURITYDBO | ISSUER_RATING | IR_CHAR8 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/ratingModel/ratingChar8 | ||||||
| ratingChar9 | Optional | string | 3442 | in_rating_char9 | S | SECURITYDBO | ISSUER_RATING | IR_CHAR9 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/ratingModel/ratingChar9 | ||||||
| ratingChar10 | Optional | string | 3457 | in_rating_char10 | S | SECURITYDBO | ISSUER_RATING | IR_CHAR10 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/ratingModel/ratingChar10 | ||||||
| ratingDate1 | Optional | date | 3451 | in_rating_date1 | S | SECURITYDBO | ISSUER_RATING | IR_DATE1 | DATE | EagleML/referenceTransaction/issuer/ratingModel/ratingDate1 | ||||||
| ratingDate2 | Optional | date | 3452 | in_rating_date2 | S | SECURITYDBO | ISSUER_RATING | IR_DATE2 | DATE | EagleML/referenceTransaction/issuer/ratingModel/ratingDate2 | ||||||
| ratingDate3 | Optional | date | 3453 | in_rating_date3 | S | SECURITYDBO | ISSUER_RATING | IR_DATE3 | DATE | EagleML/referenceTransaction/issuer/ratingModel/ratingDate3 | ||||||
| ratingFloat1 | Optional | decimal | 3454 | in_rating_float1 | F | SECURITYDBO | ISSUER_RATING | IR_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/issuer/ratingModel/ratingFloat1 | ||||||
| ratingFloat2 | Optional | decimal | 3455 | in_rating_float2 | F | SECURITYDBO | ISSUER_RATING | IR_FLOAT2 | NUMBER(28,12) | EagleML/referenceTransaction/issuer/ratingModel/ratingFloat2 | ||||||
| ratingFloat3 | Optional | decimal | 3456 | in_rating_float3 | F | SECURITYDBO | ISSUER_RATING | IR_FLOAT3 | NUMBER(28,12) | EagleML/referenceTransaction/issuer/ratingModel/ratingFloat3 | ||||||
| bkupUpdateSource | Optional | string | SECURITYDBO | ISSUER_RATING | BKUP_UPDATE_SOURCE | CHAR(8) | EagleML/referenceTransaction/issuer/ratingModel/bkupUpdateSource | |||||||||
| sourceDate | Optional | date | SECURITYDBO | ISSUER_RATING | SOURCE_DATE | DATE | EagleML/referenceTransaction/issuer/ratingModel/sourceDate | |||||||||
| ||||||||||||||||
| Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | Data Type | XPATH | ||||||
| subIssuerId | Optional | string | SECURITYDBO | ISSUER_XREF | SUB_ISSUER_ID | EagleML/referenceTransaction/issuer/xrefModel/subIssuerId | ||||||||||
| subIssuerIdType | Optional | string | SECURITYDBO | ISSUER_XREF | SUB_ISSUER_ID_TYPE | EagleML/referenceTransaction/issuer/xrefModel/subIssuerId | ||||||||||
| bondDummy | Optional | string | SECURITYDBO | ISSUER_XREF | BOND_DUMMY | EagleML/referenceTransaction/issuer/xrefModel/bondDummy | ||||||||||
| equityDummy | Optional | integer | SECURITYDBO | ISSUER_XREF | EQUITY_DUMMY | EagleML/referenceTransaction/issuer/xrefModel/equityDummy | ||||||||||
| ||||||||||||||||
| Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | Data Type | XPATH | ||||||
| legalId | Optional | string | 5089 | in_lei | S | SECURITYDBO | LEI_DETAILS | LEI | varchar2(20) | EagleML/referenceTransaction/issuer/legalEntityId/legalId | ||||||
| legalName | Optional | string | 5090 | in_legal_name | S | SECURITYDBO | LEI_DETAILS | LEGAL_NAME | nvarchar2(255) | EagleML/referenceTransaction/issuer/legalEntityId/legalName | ||||||
| entityStatus | Optional | string | 5091 | in_entity_status | S | SECURITYDBO | LEI_DETAILS | ENTITY_STATUS | nvarchar2(30) | EagleML/referenceTransaction/issuer/legalEntityId/entityStatus | ||||||
| legalForm | Optional | string | 5092 | in_legal_form | S | SECURITYDBO | LEI_DETAILS | LEGAL_FORM | nvarchar2(30) | EagleML/referenceTransaction/issuer/legalEntityId/legalForm | ||||||
| idAssignedDate | Optional | date | 5093 | in_id_assigned_date | S | SECURITYDBO | LEI_DETAILS | ID_ASSIGNED_DATE | date | EagleML/referenceTransaction/issuer/legalEntityId/idAssignedDate | ||||||
| idLastUpdateDate | Optional | date | 5094 | in_id_last_update_date | S | SECURITYDBO | LEI_DETAILS | ID_LAST_UPDATE_DATE | date | EagleML/referenceTransaction/issuer/legalEntityId/idLastUpdateDate | ||||||
| idDisabledDate | Optional | date | 5095 | in_id_disabled_date | S | SECURITYDBO | LEI_DETAILS | ID_DISABLED_DATE | date | EagleML/referenceTransaction/issuer/legalEntityId/idDisabledDate | ||||||
| idRecordState | Optional | string | 5096 | in_id_record_state | S | SECURITYDBO | LEI_DETAILS | ID_RECORD_STATE | nvarchar2(30) | EagleML/referenceTransaction/issuer/legalEntityId/idRecordState | ||||||
| idCertificationState | Optional | string | 5097 | in_id_certification_state | S | SECURITYDBO | LEI_DETAILS | ID_CERTIFICATION_STATE | nvarchar2(30) | EagleML/referenceTransaction/issuer/legalEntityId/idCertificationState | ||||||
| street | Optional | string | 5098 | in_street | S | SECURITYDBO | LEI_DETAILS | STREET | nvarchar2(255) | EagleML/referenceTransaction/issuer/legalEntityId/street | ||||||
| city | Optional | string | 5099 | in_city | S | SECURITYDBO | LEI_DETAILS | CITY | nvarchar2(255) | EagleML/referenceTransaction/issuer/legalEntityId/city | ||||||
| state | Optional | string | 5100 | in_state | S | SECURITYDBO | LEI_DETAILS | STATE | nvarchar2(255) | EagleML/referenceTransaction/issuer/legalEntityId/state | ||||||
| zip | Optional | string | 5180 | in_zip | S | SECURITYDBO | LEI_DETAILS | ZIP | nvarchar2(255) | EagleML/referenceTransaction/issuer/legalEntityId/zip | ||||||
| countryCode | Optional | string | 5181 | in_country_code | S | SECURITYDBO | LEI_DETAILS | COUNTRY_CODE | nvarchar2(30) | EagleML/referenceTransaction/issuer/legalEntityId/countryCode | ||||||
...