...
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 | 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 | EagleMLEagleML/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 | PERCENTIRD_UPDATE_OWNEDNUMBER(28,12)DATE | DATE | EagleML/referenceTransaction/issuer/roleModel/percentOwnedirdUpdateDate | irdUpdateDate|||||||||
irdChar1 | Optional | ||||||||||||||||
string | |||||||||||||||||
8286 | in_ird_char1 | S | SECURITYDBO | ISSUER_ROLE_DETAILS | IRD_ | ||||||||||||
CHAR1 | VARCHAR2(30) | EagleML/referenceTransaction/issuer/roleModel/ | |||||||||||||||
irdChar1 | |||||||||||||||||
irdChar1irdChar2 | Optional | string | 82868287 | in_ird_char1char2 | S | SECURITYDBO | ISSUER_ROLE_DETAILS | IRD_CHAR1CHAR2 | VARCHAR2(30) | EagleML/referenceTransaction/issuer/roleModel/irdChar1irdChar2 | |||||||
| |||||||||||||||||
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 |
...