Issuer Organization Data Map Table#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 | ||||||||
countryOfRiskCode (available on v2017 and higher) | 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 | |||||
legalEntityId | EagleML/referenceTransaction/issuerOrganization/legalEntityId/ |
Fields denoted by * (supported in 2017R1) exist in the XML schema today. However, these fields are not supported yet by the underlying core stored procedure and therefore these fields will not be loaded/exported. The stored procedure will be updated in 2017R1 release to include these additional fields.