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 |
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.