Also on this page:
| Table of Contents |
|---|
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 | EagleML/referenceTransaction/issuer/issuerXrefIdentifiers/ | |||||||||||||||
organizationModel | EagleML/referenceTransaction/issuer//organizationModel/ | |||||||||||||||
roleModel | EagleML/referenceTransaction/issuer/roleModel/ | |||||||||||||||
relationshipModel | EagleML/referenceTransaction/issuer/relationshipModel/ | |||||||||||||||
ratingModel | EagleML/referenceTransaction/issuer/ratingModel/ | |||||||||||||||
xrefModel | EagleML/referenceTransaction/issuer/xrefModel/ | |||||||||||||||
legalEntityId | 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 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification4 | ||||||
class4Source | Optional | string | 3458 | in_class_4_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_4_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class4Source | ||||||
class4Level | Optional | integer | 1198 | in_class_4_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_4_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class4Level | ||||||
classification5 | Optional | string | 3492 | in_classification_5 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_5 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification5 | ||||||
class5Source | Optional | string | 3460 | in_class_5_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_5_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class5Source | ||||||
class5Level | Optional | integer | 1148 | in_class_5_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_5_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class5Level | ||||||
classification6 | Optional | string | 3461 | in_classification_6 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_6 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification6 | ||||||
class6Source | Optional | string | 3462 | in_class_6_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_6_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class6Source | ||||||
class6Level | Optional | integer | 1149 | in_class_6_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_6_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class6Level | ||||||
classification7 | Optional | string | 3463 | in_classification_7 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_7 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification7 | ||||||
class7Source | Optional | string | 3464 | in_class_7_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_7_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class7Source | ||||||
class7Level | Optional | integer | 1150 | in_class_7_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_7_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class7Level | ||||||
classification8 | Optional | string | 3465 | in_classification_8 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_8 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification8 | ||||||
class8Source | Optional | string | 3466 | in_class_8_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_8_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class8Source | ||||||
class8Level | Optional | integer | 1151 | in_class_8_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_8_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class8Level | ||||||
classification9 | Optional | string | 3467 | in_classification_9 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_9 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification9 | ||||||
class9Source | Optional | string | 3468 | in_class_9_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_9_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class9Source | ||||||
class9Level | Optional | integer | 1158 | in_class_9_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_9_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class9Level | ||||||
classification10 | Optional | string | 3469 | in_classification_10 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_10 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification10 | ||||||
class10Source | Optional | string | 3470 | in_class_10_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_10_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class10Source | ||||||
class10Level | Optional | integer | 1159 | in_class_10_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_10_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class10Level | ||||||
classification11 | Optional | string | 3471 | in_classification_11 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_11 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification11 | ||||||
class11Source | Optional | string | 3493 | in_class_11_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_11_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class11Source | ||||||
class11Level | Optional | integer | 1160 | in_class_11_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_11_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class11Level | ||||||
classification12 | Optional | string | 3473 | in_classification_12 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_12 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification12 | ||||||
class12Source | Optional | string | 3474 | in_class_12_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_12_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class12Source | ||||||
class12Level | Optional | integer | 1161 | in_class_12_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_12_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class12Level | ||||||
classification13 | Optional | string | 3475 | in_classification_13 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_13 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification13 | ||||||
class13Source | Optional | string | 3476 | in_class_13_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_13_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class13Source | ||||||
class13Level | Optional | integer | 1162 | in_class_13_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_13_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class13Level | ||||||
classification14 | Optional | string | 3477 | in_classification_14 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_14 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification14 | ||||||
class14Source | Optional | string | 3494 | in_class_14_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_14_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class14Source | ||||||
class14Level | Optional | integer | 1163 | in_class_14_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_14_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class14Level | ||||||
classification15 | Optional | string | 3495 | in_classification_15 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_15 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification15 | ||||||
class15Source | Optional | string | 3496 | in_class_15_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_15_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class15Source | ||||||
class15Level | Optional | integer | 1164 | in_class_15_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_15_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class15Level | ||||||
classification16 | Optional | string | 3481 | in_classification_16 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_16 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification16 | ||||||
class16Source | Optional | string | 3482 | in_class_16_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_16_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class16Source | ||||||
class16Level | Optional | integer | 1165 | in_class_16_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_16_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class16Level | ||||||
classification17 | Optional | string | 3483 | in_classification_17 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_17 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification17 | ||||||
class17Source | Optional | string | 3484 | in_class_17_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_17_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class17Source | ||||||
class17Level | Optional | integer | 1166 | in_class_17_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_17_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class17Level | ||||||
classification18 | Optional | string | 3485 | in_classification_18 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_18 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification18 | ||||||
class18Source | Optional | string | 3486 | in_class_18_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_18_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class18Source | ||||||
class18Level | Optional | integer | 1167 | in_class_18_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_18_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class18Level | ||||||
classification19 | Optional | string | 3487 | in_classification_19 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_19 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification19 | ||||||
class19Source | Optional | string | 3488 | in_class_19_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_19_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class19Source | ||||||
class19Level | Optional | integer | 1169 | in_class_19_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_19_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class19Level | ||||||
classification20 | Optional | string | 3489 | in_classification_20 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_20 | VARCHAR2(60) | EagleML/referenceTransaction/issuer/organizationModel/classification20 | ||||||
class20Source | Optional | string | 3490 | in_class_20_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_20_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuer/organizationModel/class20Source | ||||||
class20Level | Optional | integer | 1175 | in_class_20_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_20_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuer/organizationModel/class20Level | ||||||
externalUpdateDate | Optional | date | 16077 | in_external_update_date | S | SECURITYDBO | ISSUER_ORGANIZATION | EXTERNAL_UPDATE_DATE | DATE | EagleML/referenceTransaction/issuer/organizationModel/externalUpdateDate | ||||||
yearInc | Optional | decimal | 16078 | in_year_inc | N | SECURITYDBO | ISSUER_ORGANIZATION | YEAR_INC | 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 | ||||||
irdChar2 | Optional | string | 8287 | in_ird_char2 | S | SECURITYDBO | ISSUER_ROLE_DETAILS | IRD_CHAR2 | VARCHAR2(30) | EagleML/referenceTransaction/issuer/roleModel/irdChar2 | ||||||
| ||||||||||||||||
Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | Data Type | XPATH | ||||||
fromIssuer | EagleML/referenceTransaction/issuer/relationshipModel/fromIssuer/ | |||||||||||||||
toIssuer | 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 | ||||||