countryOfRiskCode element is available only on v2017R2 or higher
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | SP TYPE | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
objectType | Required | ObjectTypeEnum | not stored in DB | EagleML/referenceTransaction/issuerOrganization/objectType | |||||||||||||
objectId | ObjectId | not stored in DB | EagleML/referenceTransaction/issuerOrganization/objectId | ||||||||||||||
objectDescription | FeedTypeEnum | not stored in DB | EagleML/referenceTransaction/issuerOrganization/objectDescription | ||||||||||||||
updateTimestamp | dateTime | not stored in DB | EagleML/referenceTransaction/issuerOrganization/updateTimestamp | ||||||||||||||
customElements | Not recommended | CustomElements | CustomElements - reserved for customizations | EagleML/referenceTransaction/issuerOrganization/customElements | |||||||||||||
sourceName | Required | string | 1102 | in_short_desc | S | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/issuerOrganization/sourceName | |||||||
updateSource | Required | string | 944 | in_update_source | S | SECURITYDBO | ISSUER_ORGANIZATION | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/updateSource | |||||||
effectiveDate | Required | date | 1109 | in_effective_date | S | SECURITYDBO | ISSUER_ORGANIZATION_HIST | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/issuerOrganization/effectiveDate | |||||||
languageId | integer | not stored in DB | EagleML/referenceTransaction/issuerOrganization/languageId | ||||||||||||||
tagNochangecase | string | 4637 | not stored in DB | EagleML/referenceTransaction/issuerOrganization/tagNochangecase | |||||||||||||
preserveNull | string | 5284 | not stored in DB | EagleML/referenceTransaction/issuerOrganization/preserveNull | |||||||||||||
noLoadValidationFlag | YesNoOptionEnum | not stored in DB, used to manage the download logic | EagleML/referenceTransaction/issuerOrganization/noLoadValidationFlag | ||||||||||||||
accountingValidationFlag | YesNoOptionEnum | not stored in DB, used to manage the download logic | EagleML/referenceTransaction/issuerOrganization/accountingValidationFlag | ||||||||||||||
issuerId | Required | string | 1144 | in_issuer_id | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_ID | CHAR(20) | EagleML/referenceTransaction/issuerOrganization/issuerId | |||||||
issuerName | string | 1173 | in_issuer_name | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_NAME | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/issuerName | ||||||||
issuerAlias | integer | 1147 | in_issuer_alias | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_ALIAS | NUMBER | EagleML/referenceTransaction/issuerOrganization/issuerAlias | ||||||||
issuerXrefIdentifiers | IssuerXrefIdentifiers | EagleML/referenceTransaction/issuerOrganization/issuerXrefIdentifiers/ | |||||||||||||||
address | string | 1145 | in_address | S | SECURITYDBO | ISSUER_ORGANIZATION | ADDRESS | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/address | ||||||||
city | string | 681 | in_city | S | SECURITYDBO | ISSUER_ORGANIZATION | CITY | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/city | ||||||||
state | string | 1153 | in_state | S | SECURITYDBO | ISSUER_ORGANIZATION | STATE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/state | ||||||||
userChar1 | string | not stored in DB | EagleML/referenceTransaction/issuerOrganization/userChar1 | ||||||||||||||
userChar2 | string | not stored in DB | EagleML/referenceTransaction/issuerOrganization/userChar2 | ||||||||||||||
userChar4 | string | not stored in DB | EagleML/referenceTransaction/issuerOrganization/userChar4 | ||||||||||||||
userChar5 | string | not stored in DB | EagleML/referenceTransaction/issuerOrganization/userChar5 | ||||||||||||||
userChar6 | string | not stored in DB | EagleML/referenceTransaction/issuerOrganization/userChar6 | ||||||||||||||
| string | SECURITYDBO | ISSUER_ORGANIZATION | COUNTRY_OF_DOMICLE | CHAR(30) | EagleML/referenceTransaction/issuerOrganization/countryOfRiskCode | |||||||||||
countryOfIncorporationCode | string | 1174 | in_country_incorporation | S | SECURITYDBO | ISSUER_ORGANIZATION | COUNTRY_INCORPORATION | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/countryOfIncorporationCode | ||||||||
currency | CurrencyCode | 1172 | in_currency | S | SECURITYDBO | ISSUER_ORGANIZATION | CURRENCY | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/currency | ||||||||
industryCode | string | 1155 | in_industry_code | S | SECURITYDBO | ISSUER_ORGANIZATION | INDUSTRY_CODE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/industryCode | ||||||||
industrySector1 | string | 1156 | in_industry_sector1 | S | SECURITYDBO | ISSUER_ORGANIZATION | INDUSTRY_SECTOR1 | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/industrySector1 | ||||||||
industrySector2 | string | 1171 | in_industry_sector2 | S | SECURITYDBO | ISSUER_ORGANIZATION | INDUSTRY_SECTOR2 | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/industrySector2 | ||||||||
industrySector3 | string | 1154 | in_industry_sector3 | S | SECURITYDBO | ISSUER_ORGANIZATION | INDUSTRY_SECTOR3 | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/industrySector3 | ||||||||
classificationSector1 | string | 3418 | in_classification_sector1 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_SECTOR1 | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/classificationSector1 | ||||||||
classificationSector2 | string | 3419 | in_classification_sector2 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_SECTOR2 | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/classificationSector2 | ||||||||
classificationSector3 | string | 1170 | in_classification_sector3 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_SECTOR3 | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/classificationSector3 | ||||||||
primaryAnalyst | string | 3421 | in_primary_analyst | S | SECURITYDBO | ISSUER_ORGANIZATION | PRIMARY_ANALYST | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/primaryAnalyst | ||||||||
creditAnalyst | string | 3422 | in_credit_analyst | S | SECURITYDBO | ISSUER_ORGANIZATION | CREDIT_ANALYST | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/creditAnalyst | ||||||||
updateDate | date | SECURITYDBO | ISSUER_ORGANIZATION | UPDATE_DATE | DATE | EagleML/referenceTransaction/issuerOrganization/updateDate | |||||||||||
shortDesc | string | 1102 | in_short_desc | S | not store in DB | EagleML/referenceTransaction/issuerOrganization/shortDesc | |||||||||||
countryExposure | string | 1152 | in_country_exposure | S | SECURITYDBO | ISSUER_ORGANIZATION | COUNTRY_EXPOSURE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/countryExposure | ||||||||
issuerChar1 | string | 3423 | in_issuer_char1 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR1 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar1 | ||||||||
issuerChar2 | string | 3424 | in_issuer_char2 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR2 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar2 | ||||||||
issuerChar3 | string | 3425 | in_issuer_char3 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR3 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar3 | ||||||||
issuerChar4 | string | 3426 | in_issuer_char4 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR4 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar4 | ||||||||
issuerChar5 | string | 3427 | in_issuer_char5 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR5 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar5 | ||||||||
issuerChar6 | string | 3428 | in_issuer_char6 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR6 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar6 | ||||||||
issuerChar7 | string | 3429 | in_issuer_char7 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR7 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar7 | ||||||||
issuerChar8 | string | 8101 | in_issuer_char8 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR8 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar8 | ||||||||
issuerChar9 | string | 8102 | in_issuer_char9 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR9 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar9 | ||||||||
issuerChar10 | string | 8103 | in_issuer_char10 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR10 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar10 | ||||||||
issuerChar11 | string | 8104 | in_issuer_char11 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR11 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar11 | ||||||||
issuerChar12 | string | 8105 | in_issuer_char12 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR12 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar12 | ||||||||
issuerChar13 | string | 8106 | in_issuer_char13 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR13 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar13 | ||||||||
issuerChar14 | string | 8107 | in_issuer_char14 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR14 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar14 | ||||||||
issuerChar15 | string | 8108 | in_issuer_char15 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_CHAR15 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/issuerChar15 | ||||||||
issuerDate1 | date | 3435 | in_issuer_date1 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_DATE1 | DATE | EagleML/referenceTransaction/issuerOrganization/issuerDate1 | ||||||||
issuerDate2 | date | 3436 | in_issuer_date2 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_DATE2 | DATE | EagleML/referenceTransaction/issuerOrganization/issuerDate2 | ||||||||
issuerDate3 | date | 3437 | in_issuer_date3 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_DATE3 | DATE | EagleML/referenceTransaction/issuerOrganization/issuerDate3 | ||||||||
issuerDate4 | date | 3438 | in_issuer_date4 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_DATE4 | DATE | EagleML/referenceTransaction/issuerOrganization/issuerDate4 | ||||||||
issuerDate5 | date | 3439 | in_issuer_date5 | S | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_DATE5 | DATE | EagleML/referenceTransaction/issuerOrganization/issuerDate5 | ||||||||
issuerFloat1 | decimal | 3430 | in_issuer_float1 | F | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/issuerOrganization/issuerFloat1 | ||||||||
issuerFloat2 | decimal | 3431 | in_issuer_float2 | F | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_FLOAT2 | NUMBER(28,12) | EagleML/referenceTransaction/issuerOrganization/issuerFloat2 | ||||||||
issuerFloat3 | decimal | 3432 | in_issuer_float3 | F | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_FLOAT3 | NUMBER(28,12) | EagleML/referenceTransaction/issuerOrganization/issuerFloat3 | ||||||||
issuerFloat4 | decimal | 3433 | in_issuer_float4 | F | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_FLOAT4 | NUMBER(28,12) | EagleML/referenceTransaction/issuerOrganization/issuerFloat4 | ||||||||
issuerFloat5 | decimal | 3434 | in_issuer_float5 | F | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_FLOAT5 | NUMBER(28,12) | EagleML/referenceTransaction/issuerOrganization/issuerFloat5 | ||||||||
countryDomicile | decimal | 4353 | in_country_domicile | S | SECURITYDBO | ISSUER_ORGANIZATION | COUNTRY_DOMICILE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/countryDomicile | ||||||||
counterparty | string | 213 | in_counterparty | S | SECURITYDBO | ISSUER_ORGANIZATION | COUNTERPARTY | VARCHAR2(1) | EagleML/referenceTransaction/issuerOrganization/counterparty | ||||||||
classification4 | string | 3491 | in_classification_4 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_4 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification4 | ||||||||
class4Source | string | 3458 | in_class_4_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_4_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class4Source | ||||||||
class4Level | integer | 1198 | in_class_4_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_4_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class4Level | ||||||||
classification5 | string | 3492 | in_classification_5 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_5 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification5 | ||||||||
class5Source | string | 3460 | in_class_5_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_5_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class5Source | ||||||||
class5Level | integer | 1148 | in_class_5_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_5_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class5Level | ||||||||
classification6 | string | 3461 | in_classification_6 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_6 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification6 | ||||||||
class6Source | string | 3462 | in_class_6_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_6_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class6Source | ||||||||
class6Level | integer | 1149 | in_class_6_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_6_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class6Level | ||||||||
classification7 | string | 3463 | in_classification_7 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_7 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification7 | ||||||||
class7Source | string | 3464 | in_class_7_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_7_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class7Source | ||||||||
class7Level | integer | 1150 | in_class_7_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_7_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class7Level | ||||||||
classification8 | string | 3465 | in_classification_8 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_8 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification8 | ||||||||
class8Source | string | 3466 | in_class_8_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_8_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class8Source | ||||||||
class8Level | integer | 1151 | in_class_8_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_8_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class8Level | ||||||||
classification9 | string | 3467 | in_classification_9 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_9 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification9 | ||||||||
class9Source | string | 3468 | in_class_9_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_9_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class9Source | ||||||||
class9Level | integer | 1158 | in_class_9_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_9_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class9Level | ||||||||
classification10 | string | 3469 | in_classification_10 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_10 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification10 | ||||||||
class10Source | string | 3470 | in_class_10_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_10_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class10Source | ||||||||
class10Level | integer | 1159 | in_class_10_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_10_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class10Level | ||||||||
classification11 | string | 3471 | in_classification_11 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_11 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification11 | ||||||||
class11Source | string | 3493 | in_class_11_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_11_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class11Source | ||||||||
class11Level | integer | 1160 | in_class_11_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_11_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class11Level | ||||||||
classification12 | string | 3473 | in_classification_12 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_12 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification12 | ||||||||
class12Source | string | 3474 | in_class_12_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_12_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class12Source | ||||||||
class12Level | integer | 1161 | in_class_12_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_12_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class12Level | ||||||||
classification13 | string | 3475 | in_classification_13 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_13 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification13 | ||||||||
class13Source | string | 3476 | in_class_13_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_13_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class13Source | ||||||||
class13Level | integer | 1162 | in_class_13_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_13_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class13Level | ||||||||
classification14 | string | 3477 | in_classification_14 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_14 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification14 | ||||||||
class14Source | string | 3494 | in_class_14_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_14_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class14Source | ||||||||
class14Level | integer | 1163 | in_class_14_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_14_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class14Level | ||||||||
classification15 | string | 3495 | in_classification_15 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_15 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification15 | ||||||||
class15Source | string | 3496 | in_class_15_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_15_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class15Source | ||||||||
class15Level | integer | 1164 | in_class_15_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_15_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class15Level | ||||||||
classification16 | string | 3481 | in_classification_16 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_16 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification16 | ||||||||
class16Source | string | 3482 | in_class_16_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_16_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class16Source | ||||||||
class16Level | integer | 1165 | in_class_16_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_16_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class16Level | ||||||||
classification17 | string | 3483 | in_classification_17 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_17 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification17 | ||||||||
class17Source | string | 3484 | in_class_17_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_17_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class17Source | ||||||||
class17Level | integer | 1166 | in_class_17_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_17_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class17Level | ||||||||
classification18 | string | 3485 | in_classification_18 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_18 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification18 | ||||||||
class18Source | string | 3486 | in_class_18_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_18_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class18Source | ||||||||
class18Level | integer | 1167 | in_class_18_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_18_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class18Level | ||||||||
classification19 | string | 3487 | in_classification_19 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_19 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification19 | ||||||||
class19Source | string | 3488 | in_class_19_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_19_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class19Source | ||||||||
class19Level | integer | 1169 | in_class_19_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_19_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class19Level | ||||||||
classification20 | string | 3489 | in_classification_20 | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASSIFICATION_20 | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/classification20 | ||||||||
class20Source | string | 3490 | in_class_20_source | S | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_20_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issuerOrganization/class20Source | ||||||||
class20Level | integer | 1175 | in_class_20_level | N | SECURITYDBO | ISSUER_ORGANIZATION | CLASS_20_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuerOrganization/class20Level | ||||||||
externalUpdateDate | date | 16077 | in_external_update_date | S | SECURITYDBO | ISSUER_ORGANIZATION | EXTERNAL_UPDATE_DATE | DATE | EagleML/referenceTransaction/issuerOrganization/externalUpdateDate | ||||||||
yearInc | decimal | 16078 | in_year_inc | N | SECURITYDBO | ISSUER_ORGANIZATION | YEAR_INC | NUMBER(28,12) | EagleML/referenceTransaction/issuerOrganization/yearInc | ||||||||
addressLine2 | string | 16133 | in_address_line_2 | SECURITYDBO | ISSUER_ORGANIZATION | ADDRESS_LINE_2 | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/addressLine2 | |||||||||
zipCode | string | 16134 | in_zip_code | SECURITYDBO | ISSUER_ORGANIZATION | ZIP_CODE | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/zipCode | |||||||||
acquiredByParent | YesNoOptionEnum | 16135 | in_acquired_by_parent | SECURITYDBO | ISSUER_ORGANIZATION | ACQUIRED_BY_PARENT | VARCHAR2(1) | EagleML/referenceTransaction/issuerOrganization/acquiredByParent | |||||||||
isUltParent | YesNoOptionEnum | 16136 | in_is_ult_parent | SECURITYDBO | ISSUER_ORGANIZATION | IS_ULT_PARENT | VARCHAR2(1) | EagleML/referenceTransaction/issuerOrganization/isUltParent | |||||||||
companyCorpTicker | string | 16137 | in_company_corp_ticker | SECURITYDBO | ISSUER_ORGANIZATION | COMPANY_CORP_TICKER | VARCHAR2(100) | EagleML/referenceTransaction/issuerOrganization/companyCorpTicker | |||||||||
gicsSector | string | 16809 | in_gics_sector | SECURITYDBO | ISSUER_ORGANIZATION | GICS_SECTOR | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/gicsSector | |||||||||
gicsSectorName | string | EagleML/referenceTransaction/issuerOrganization/gicsSectorName | |||||||||||||||
gicsIndustryGroup | string | 16810 | in_gics_industry_group | SECURITYDBO | ISSUER_ORGANIZATION | GICS_INDUSTRY_GROUP | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/gicsIndustryGroup | |||||||||
gicsIndustryGroupName | string | EagleML/referenceTransaction/issuerOrganization/gicsIndustryGroupName | |||||||||||||||
gicsIndustry | string | 16811 | in_gics_industry | SECURITYDBO | ISSUER_ORGANIZATION | GICS_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/gicsIndustry | |||||||||
gicsIndustryName | string | EagleML/referenceTransaction/issuerOrganization/gicsIndustryName | |||||||||||||||
gicsSubIndustry | string | 16812 | in_gics_sub_industry | SECURITYDBO | ISSUER_ORGANIZATION | GICS_SUB_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/gicsSubIndustry | |||||||||
gicsSubIndustryName | string | EagleML/referenceTransaction/issuerOrganization/gicsSubIndustryName | |||||||||||||||
historyOnlyFlag | YesNoOptionEnum | EagleML/referenceTransaction/issuerOrganization/historyOnlyFlag | |||||||||||||||
issuerType | string | 16832 | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_TYPE | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/issuerType | ||||||||||
phone | string | 16830 | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_PHONE | VARCHAR2(60) | EagleML/referenceTransaction/issuerOrganization/phone | ||||||||||
cfcFlag | YesNoOptionEnum | 16831 | SECURITYDBO | ISSUER_ORGANIZATION | CFC_FLAG | VARCHAR2(1) | EagleML/referenceTransaction/issuerOrganization/cfcFlag | ||||||||||
centralCounterParty | YesNoOptionEnum | 16833 | SECURITYDBO | ISSUER_ORGANIZATION | CENTRAL_COUNTER_PARTY | VARCHAR2(1) | EagleML/referenceTransaction/issuerOrganization/centralCounterParty | ||||||||||
| website | string | SECURITYDBO | ISSUER_ORGANIZATION | WEBSITE | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/website | |||||||||||
| issuerShortName | string | SECURITYDBO | ISSUER_ORGANIZATION | ISSUER_SHORT_NAME | VARCHAR2(255) | EagleML/referenceTransaction/issuerOrganization/issuerShortName | |||||||||||
| russellGlobal | EagleML/referenceTransaction/issuerOrganization/legalEntityId/ | ||||||||||||||||
...
| string | 17580 | in_russell_global | SECURITYDBO | ISSUER_SECTOR_DETAIL | RUSSELL_GLOBAL | russellGlobal | |||||
| barclaysIssuerIndustry | string | 17581 | in_barclays_issuer_ind | SECURITYDBO | ISSUER_SECTOR_DETAIL | BARCLAYS_ISSUER_IND | barclaysIssuerIndustry | ||||
| blackRockLipper | string | 17582 | in_blk_lipper | SECURITYDBO | ISSUER_SECTOR_DETAIL | BLK_LIPPER | blackRockLipper | ||||
| blkInfrastructureDebt | string | 17583 | in_blk_infra_debt | SECURITYDBO | ISSUER_SECTOR_DETAIL | BLK_INFRA_DEBT | blkInfrastructureDebt | ||||
| blkInfrastructureDebtClass | string | 17584 | in_blk_infra_debt_class | SECURITYDBO | ISSUER_SECTOR_DETAIL | BLK_INFRA_DEBT_CLASS | blkInfrastructureDebtClass | ||||
| bombayStockExchange | string | 17585 | in_bombay_stock_exchange | SECURITYDBO | ISSUER_SECTOR_DETAIL | BOMBAY_STOCK_EXCHANGE | bombayStockExchange | ||||
| chinaSecuritiesIndex | string | 17586 | in_china_securities_index | SECURITYDBO | ISSUER_SECTOR_DETAIL | CHINA_SECURITIES_INDEX | chinaSecuritiesIndex | ||||
| citiGlobal | string | 17587 | in_citi_global | SECURITYDBO | ISSUER_SECTOR_DETAIL | CITI_GLOBAL | citiGlobal | ||||
| citigroup | string | 17588 | in_citigroup | SECURITYDBO | ISSUER_SECTOR_DETAIL | CITIGROUP | citigroup | ||||
| sicIndustry | string | 17589 | in_sic_industry | SECURITYDBO | ISSUER_SECTOR_DETAIL | SIC_INDUSTRY | sicIndustry | ||||
| colombianStockExchange | string | 17590 | in_colombian_stock_exchange | SECURITYDBO | ISSUER_SECTOR_DETAIL | COLOMBIAN_STOCK_EXCHANGE | colombianStockExchange | ||||
| csfbIssuerIndustry | string | 17591 | in_csfb_issuer_ind | SECURITYDBO | ISSUER_SECTOR_DETAIL | CSFB_ISSUER_IND | csfbIssuerIndustry | ||||
| deutscheBorse | string | 17592 | in_deutsche_borse | SECURITYDBO | ISSUER_SECTOR_DETAIL | DEUTSCHE_BORSE | deutscheBorse | ||||
| dowJonesIssuer | string | 17593 | in_dow_jones_issuer | SECURITYDBO | ISSUER_SECTOR_DETAIL | DOW_JONES_ISSUER | dowJonesIssuer | ||||
| fitch | string | 17594 | in_fitch | SECURITYDBO | ISSUER_SECTOR_DETAIL | FITCH | fitch | ||||
| ftseIssuerIndustry | string | 17595 | in_ftse_issuer_ind | SECURITYDBO | ISSUER_SECTOR_DETAIL | FTSE_ISSUER_IND | ftseIssuerIndustry | ||||
| goldman | string | 17596 | in_goldman | SECURITYDBO | ISSUER_SECTOR_DETAIL | GOLDMAN | goldman | ||||
| gretaiSecurities | string | 17597 | in_gretai_securities | SECURITYDBO | ISSUER_SECTOR_DETAIL | GRETAI_SECURITIES | gretaiSecurities | ||||
| iBoxx | string | 17598 | in_iboxx | SECURITYDBO | ISSUER_SECTOR_DETAIL | IBOXX | iBoxx | ||||
| jpmAsianCreditIndex | string | 17599 | in_jpm_asian_credit_index | SECURITYDBO | ISSUER_SECTOR_DETAIL | JPM_ASIAN_CREDIT_INDEX | jpmAsianCreditIndex | ||||
| jpmCembiIndex | string | 17600 | in_jpm_cembi_index | SECURITYDBO | ISSUER_SECTOR_DETAIL | JPM_CEMBI_INDEX | jpmCembiIndex | ||||
| jpmEmbiIndex | string | 17601 | in_jpm_embi_index | SECURITYDBO | ISSUER_SECTOR_DETAIL | JPM_EMBI_INDEX | jpmEmbiIndex | ||||
| jpmIssuerIndustry | string | 17602 | in_jpm_issuer_ind | SECURITYDBO | ISSUER_SECTOR_DETAIL | JPM_ISSUER_IND | jpmIssuerIndustry | ||||
| lcdLeveragedLoanIndex | string | 17603 | in_lcd_leveraged_loan_index | SECURITYDBO | ISSUER_SECTOR_DETAIL | LCD_LEVERAGED_LOAN_INDEX | lcdLeveragedLoanIndex | ||||
| merrillLynchConvertibles | string | 17604 | in_merrill_lynch_convert | SECURITYDBO | ISSUER_SECTOR_DETAIL | MERRILL_LYNCH_CONVERT | merrillLynchConvertibles | ||||
| merrillLynchIssuer | string | 17605 | in_merrill_lynch_issuer | SECURITYDBO | ISSUER_SECTOR_DETAIL | MERRILL_LYNCH_ISSUER | merrillLynchIssuer | ||||
| moodyIssuerIndustry | string | 17606 | in_moody_issuer_ind | SECURITYDBO | ISSUER_SECTOR_DETAIL | MOODY_ISSUER_IND | moodyIssuerIndustry | ||||
| moodyCloDiversity | string | 17607 | in_moody_clo_diversity | SECURITYDBO | ISSUER_SECTOR_DETAIL | MOODY_CLO_DIVERSITY | moodyCloDiversity | ||||
| msciHedgeIssuerIndustry | string | 17608 | in_msci_hedge_issuer_ind | MSCI_HEDGE_ISSUER_IND | msciHedgeIssuerIndustry | ||||||
| msciIndustry | string | 17609 | in_msci_industry | MSCI_INDUSTRY | msciIndustry | ||||||
| nomuraIndustry | string | 17610 | in_nomura_industry | NOMURA_INDUSTRY | nomuraIndustry | ||||||
| nomuraIssuerIndustry | string | 17611 | in_nomura_issuer_ind | NOMURA_ISSUER_IND | nomuraIssuerIndustry | ||||||
| reutersIndustry | string | 17612 | in_reuters_industry | REUTERS_INDUSTRY | reutersIndustry | ||||||
| spIssuerIndustry | string | 17613 | in_sp_issuer_ind | SP_ISSUER_IND | spIssuerIndustry | ||||||
| scotiaDexssuerIndustry | string | 17614 | in_scotia_dex_issuer_ind | SCOTIA_DEX_ISSUER_IND | scotiaDexssuerIndustry | ||||||
| standardSicIndustry | string | standardSicIndustry | |||||||||
| sixSwissExchange | sixSwissExchange | ||||||||||
| taiwanStockExchange | taiwanStockExchange | ||||||||||
| topix | topix | ||||||||||
| ubsIssuerIndustry | ubsIssuerIndustry | ||||||||||
| warsawStockExchange | warsawStockExchange | ||||||||||
| wig | wig | ||||||||||
| iBoxxAlbi | iBoxxAlbi | ||||||||||
| globalPropertyResearch | globalPropertyResearch | ||||||||||
| iBoxxAudLargeCap | iBoxxAudLargeCap | ||||||||||
| londonStockExchange | londonStockExchange | ||||||||||
| bloombergMuniIndustry | bloombergMuniIndustry | ||||||||||
| iisl | iisl | ||||||||||
| localExchange | localExchange | ||||||||||
| thailandStockExchange | thailandStockExchange | ||||||||||
| malaysiaStockExchange | malaysiaStockExchange | ||||||||||
| japanStockExchange | japanStockExchange | ||||||||||
| indonesiaStockExchange | indonesiaStockExchange | ||||||||||
| philippinesStockExchange | philippinesStockExchange | ||||||||||
| indiaStockExchange | indiaStockExchange | ||||||||||
| koreaStockExchange | koreaStockExchange | ||||||||||
| csrcChina | csrcChina | ||||||||||
| sywgChina | sywgChina | ||||||||||
| naics | naics | ||||||||||
| bloombergGovernment | bloombergGovernment | ||||||||||
| bloombergFixedIncome | bloombergFixedIncome | ||||||||||
| bloombergEquity | bloombergEquity | ||||||||||
| bicsLevel1SectorCode | bicsLevel1SectorCode | ||||||||||
| bicsLevel1SectorName | bicsLevel1SectorName | ||||||||||
| bicsLevel2IndustryGroupCode | bicsLevel2IndustryGroupCode | ||||||||||
| bicsLevel2IndustryGroupName | bicsLevel2IndustryGroupName | ||||||||||
| bicsLevel3IndustryCode | bicsLevel3IndustryCode | ||||||||||
| bicsLevel3IndustryName | bicsLevel3IndustryName | ||||||||||
| bicsLevel4SubIndustryCode | bicsLevel4SubIndustryCode | ||||||||||
| bicsLevel4SubIndustryName | bicsLevel4SubIndustryName | ||||||||||
| bicsLevel5SegmentCode | bicsLevel5SegmentCode | ||||||||||
| bicsLevel5SegmentName | bicsLevel5SegmentName | ||||||||||
| bicsLevel6SegmentCode | bicsLevel6SegmentCode | ||||||||||
| bicsLevel6SegmentName | bicsLevel6SegmentName | ||||||||||
| bicsLevel7SegmentCode | bicsLevel7SegmentCode | ||||||||||
| bicsLevel7SegmentName | bicsLevel7SegmentName | ||||||||||
| naceClassCode | naceClassCode | ||||||||||
| naceClassName | naceClassName | ||||||||||
| naceSectorCode | naceSectorCode | ||||||||||
| naceSectorName | naceSectorName | ||||||||||
| naceDivisionCode | naceDivisionCode | ||||||||||
| naceDivisionName | naceDivisionName | ||||||||||
| naceGroupCode | naceGroupCode | ||||||||||
| naceGroupName | naceGroupName | ||||||||||
| icbSectorName | icbSectorName | ||||||||||
| icbSector | icbSector | ||||||||||
| icbSubsectorName | icbSubsectorName | ||||||||||
| icbSubsector | icbSubsector | ||||||||||
| icbSupersectorName | icbSupersectorName | ||||||||||
| icbSupersector | icbSupersector | ||||||||||
| icbIndustryName | icbIndustryName | ||||||||||
legalEntityId | EagleML/referenceTransaction/issuerOrganization/legalEntityId/ | ||||||||||