Also on this page:
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/ | ||||||||
OrganizationModel Data Map | ||||||||||
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 | |||
RoleModel Data Map | ||||||||||
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 |
irdChar2 | Optional | string | 8287 | in_ird_char2 | S | SECURITYDBO | ISSUER_ROLE_DETAILS | IRD_CHAR2 | VARCHAR2(30) | EagleML/referenceTransaction/issuer/roleModel/irdChar2 |
RelationshipModel Data Map | ||||||||||
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) | EagleML/referenceTransaction/issuer/relationshipModel/fromIssuer/ | ||||||||
toIssuer | IssuerIdentifiersDataModel - Complex type (see extra table) | 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 |
RatingModel Data Map | ||||||||||
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 | |||
XrefModel Data Map | ||||||||||
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 | ||||
LEI Data Map | ||||||||||
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 |