Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Also on this page:
ElementOptional/RequiredValue TypeStar TagSP ParameterSP TypeEagle DBDB TableDB FieldData TypeXPATH
objectTypeOptionalObjectTypeEnum


not stored in DB 
EagleML/referenceTransaction/issuer/objectType
objectIdOptionalObjectId


not stored in DB 
EagleML/referenceTransaction/issuer/objectId
objectDescriptionOptionalFeedTypeEnum


not stored in DB 
EagleML/referenceTransaction/issuer/objectDescription
updateTimestampOptionaldateTime


SECURITYDBOISSUER_ORGANIZATIONUPDATE_DATEDATEEagleML/referenceTransaction/issuer/updateTimestamp
customElementsOptionalCustomElements


reserved for customizations
EagleML/referenceTransaction/issuer/customElements
sourceNameOptionalstring - involved in resolution logics1102in_short_descSPACE_MASTERDBOINTERFACESSHORT_DESCCHAR(15)EagleML/referenceTransaction/issuer/sourceName
updateSourceOptionalstring944in_update_sourceSSECURITYDBOISSUER_ORGANIZATIONUPDATE_SOURCEVARCHAR2(255)EagleML/referenceTransaction/issuer/updateSource
effectiveDateOptionaldate1109in_effective_dateSSECURITYDBOISSUER_ORGANIZATIONUPDATE_DATEDATEEagleML/referenceTransaction/issuer/effectiveDate
languageIdOptionalinteger


not stored in DB 
EagleML/referenceTransaction/issuer/languageId
tagNochangecaseOptionalstring


not stored in DB 
EagleML/referenceTransaction/issuer/tagNochangecase
preserveNullOptionalstring


not stored in DB 
EagleML/referenceTransaction/issuer/preserveNull
noLoadValidationFlagOptionalYesNoOptionEnum


not stored in DB 
EagleML/referenceTransaction/issuer/noLoadValidationFlag
issuerIdRequiredstring1144in_issuer_idSSECURITYDBOISSUER_ORGANIZATIONISSUER_IDCHAR(20)EagleML/referenceTransaction/issuer/issuerId
issuerNameOptionalstring1173in_issuer_nameSSECURITYDBOISSUER_ORGANIZATIONISSUER_NAMEVARCHAR2(255)EagleML/referenceTransaction/issuer/issuerName
issuerAliasOptionalinteger1147in_issuer_aliasSSECURITYDBOISSUER_ORGANIZATIONISSUER_ALIASNUMBEREagleML/referenceTransaction/issuer/issuerAlias
issuerXrefIdentifiersIssuerXrefIdentifiers - Complex type (see extra table)EagleML/referenceTransaction/issuer/issuerXrefIdentifiers/
organizationModelOrganizationModel - complex type (see extra table below)EagleML/referenceTransaction/issuer//organizationModel/
roleModelRoleModel - complex type (see extra table below)EagleML/referenceTransaction/issuer/roleModel/
relationshipModelRelationshipModel - complex type (see extra table below)EagleML/referenceTransaction/issuer/relationshipModel/
ratingModelRatingModel - complex type (see extra table below)EagleML/referenceTransaction/issuer/ratingModel/
xrefModelXrefModel - complex type (see extra table below)EagleML/referenceTransaction/issuer/xrefModel/
legalEntityIdLEI - complex type (see extra table below)EagleML/referenceTransaction/issuer/legalEntityId/

OrganizationModel Data Map 

ElementOptional/RequiredValue TypeStar TagSP ParameterSP TypeEagle DBDB TableDB FieldData TypeXPATH
addressOptionalstring1145in_addressSSECURITYDBOISSUER_ORGANIZATIONADDRESSVARCHAR2(255)EagleML/referenceTransaction/issuer/organizationModel/address
cityOptionalstring681in_citySSECURITYDBOISSUER_ORGANIZATIONCITYVARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/city
stateOptionalstring1153in_stateSSECURITYDBOISSUER_ORGANIZATIONSTATEVARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/state
userChar1Optionalstring


not stored in DB 
EagleML/referenceTransaction/issuer/organizationModel/userChar1
userChar2Optionalstring


not stored in DB 
EagleML/referenceTransaction/issuer/organizationModel/userChar2
userChar4Optionalstring


not stored in DB 
EagleML/referenceTransaction/issuer/organizationModel/userChar4
userChar5Optionalstring


not stored in DB 
EagleML/referenceTransaction/issuer/organizationModel/userChar5
userChar6Optionalstring


not stored in DB 
EagleML/referenceTransaction/issuer/organizationModel/userChar6
countryOfRiskCodeOptionalstring


SECURITYDBOISSUER_ORGANIZATIONCOUNTRY_OF_DOMICLECHAR(30)EagleML/referenceTransaction/issuer/organizationModel/countryOfRiskCode
countryOfIncorporationCodeOptionalstring1174in_country_incorporationSSECURITYDBOISSUER_ORGANIZATIONCOUNTRY_INCORPORATIONVARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/countryOfIncorporationCode
currencyOptionalCurrencyCode1172in_currencySSECURITYDBOISSUER_ORGANIZATIONCURRENCYVARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/currency
industryCodeOptionalstring1155in_industry_codeSSECURITYDBOISSUER_ORGANIZATIONINDUSTRY_CODEVARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/industryCode
industrySector1Optionalstring1156in_industry_sector1SSECURITYDBOISSUER_ORGANIZATIONINDUSTRY_SECTOR1VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/industrySector1
industrySector2Optionalstring1171in_industry_sector2SSECURITYDBOISSUER_ORGANIZATIONINDUSTRY_SECTOR2VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/industrySector2
industrySector3Optionalstring1154in_industry_sector3SSECURITYDBOISSUER_ORGANIZATIONINDUSTRY_SECTOR3VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/industrySector3
classificationSector1Optionalstring3418in_classification_sector1SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_SECTOR1VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/classificationSector1
classificationSector2Optionalstring3419in_classification_sector2SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_SECTOR2VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/classificationSector2
classificationSector3Optionalstring1170in_classification_sector3SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_SECTOR3VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/classificationSector3
primaryAnalystOptionalstring3421in_primary_analystSSECURITYDBOISSUER_ORGANIZATIONPRIMARY_ANALYSTVARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/primaryAnalyst
creditAnalystOptionalstring3422in_credit_analystSSECURITYDBOISSUER_ORGANIZATIONCREDIT_ANALYSTVARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/creditAnalyst
updateDateRequireddate


SECURITYDBOISSUER_ORGANIZATIONUPDATE_DATEDATEEagleML/referenceTransaction/issuer/organizationModel/updateDate
shortDescOptionalstring1102in_short_descSnot stored in DB 
EagleML/referenceTransaction/issuer/organizationModel/shortDesc
countryExposureOptionalstring1152in_country_exposureSSECURITYDBOISSUER_ORGANIZATIONCOUNTRY_EXPOSUREVARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/countryExposure
issuerChar1Optionalstring3423in_issuer_char1SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR1VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar1
issuerChar2Optionalstring3424in_issuer_char2SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR2VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar2
issuerChar3Optionalstring3425in_issuer_char3SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR3VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar3
issuerChar4Optionalstring3426in_issuer_char4SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR4VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar4
issuerChar5Optionalstring3427in_issuer_char5SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR5VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar5
issuerChar6Optionalstring3428in_issuer_char6SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR6VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar6
issuerChar7Optionalstring3429in_issuer_char7SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR7VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar7
issuerChar8Optionalstring8101in_issuer_char8SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR8VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar8
issuerChar9Optionalstring8102in_issuer_char9SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR9VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar9
issuerChar10Optionalstring8103in_issuer_char10SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR10VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar10
issuerChar11Optionalstring8104in_issuer_char11SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR11VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar11
issuerChar12Optionalstring8105in_issuer_char12SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR12VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar12
issuerChar13Optionalstring8106in_issuer_char13SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR13VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar13
issuerChar14Optionalstring8107in_issuer_char14SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR14VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar14
issuerChar15Optionalstring8108in_issuer_char15SSECURITYDBOISSUER_ORGANIZATIONISSUER_CHAR15VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/issuerChar15
issuerDate1Optionaldate3435in_issuer_date1SSECURITYDBOISSUER_ORGANIZATIONISSUER_DATE1DATEEagleML/referenceTransaction/issuer/organizationModel/issuerDate1
issuerDate2Optionaldate3436in_issuer_date2SSECURITYDBOISSUER_ORGANIZATIONISSUER_DATE2DATEEagleML/referenceTransaction/issuer/organizationModel/issuerDate2
issuerDate3Optionaldate3437in_issuer_date3SSECURITYDBOISSUER_ORGANIZATIONISSUER_DATE3DATEEagleML/referenceTransaction/issuer/organizationModel/issuerDate3
issuerDate4Optionaldate3438in_issuer_date4SSECURITYDBOISSUER_ORGANIZATIONISSUER_DATE4DATEEagleML/referenceTransaction/issuer/organizationModel/issuerDate4
issuerDate5Optionaldate3439in_issuer_date5SSECURITYDBOISSUER_ORGANIZATIONISSUER_DATE5DATEEagleML/referenceTransaction/issuer/organizationModel/issuerDate5
issuerFloat1Optionaldecimal3430in_issuer_float1FSECURITYDBOISSUER_ORGANIZATIONISSUER_FLOAT1NUMBER(28,12)EagleML/referenceTransaction/issuer/organizationModel/issuerFloat1
issuerFloat2Optionaldecimal3431in_issuer_float2FSECURITYDBOISSUER_ORGANIZATIONISSUER_FLOAT2NUMBER(28,12)EagleML/referenceTransaction/issuer/organizationModel/issuerFloat2
issuerFloat3Optionaldecimal3432in_issuer_float3FSECURITYDBOISSUER_ORGANIZATIONISSUER_FLOAT3NUMBER(28,12)EagleML/referenceTransaction/issuer/organizationModel/issuerFloat3
issuerFloat4Optionaldecimal3433in_issuer_float4FSECURITYDBOISSUER_ORGANIZATIONISSUER_FLOAT4NUMBER(28,12)EagleML/referenceTransaction/issuer/organizationModel/issuerFloat4
issuerFloat5Optionaldecimal3434in_issuer_float5FSECURITYDBOISSUER_ORGANIZATIONISSUER_FLOAT5NUMBER(28,12)EagleML/referenceTransaction/issuer/organizationModel/issuerFloat5
countryDomicileOptionaldecimal4353in_country_domicileSSECURITYDBOISSUER_ORGANIZATIONCOUNTRY_DOMICILEVARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/countryDomicile
counterpartyOptionalstring213in_counterpartySSECURITYDBOISSUER_ORGANIZATIONCOUNTERPARTYVARCHAR2(1)EagleML/referenceTransaction/issuer/organizationModel/counterparty
classification4Optionalstring3491in_classification_4SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_4
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification4
class4SourceOptionalstring3458in_class_4_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_4_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class4Source
class4LevelOptionalinteger1198in_class_4_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_4_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class4Level
classification5Optionalstring3492in_classification_5SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_5
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification5
class5SourceOptionalstring3460in_class_5_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_5_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class5Source
class5LevelOptionalinteger1148in_class_5_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_5_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class5Level
classification6Optionalstring3461in_classification_6SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_6
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification6
class6SourceOptionalstring3462in_class_6_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_6_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class6Source
class6LevelOptionalinteger1149in_class_6_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_6_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class6Level
classification7Optionalstring3463in_classification_7SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_7
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification7
class7SourceOptionalstring3464in_class_7_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_7_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class7Source
class7LevelOptionalinteger1150in_class_7_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_7_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class7Level
classification8Optionalstring3465in_classification_8SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_8
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification8
class8SourceOptionalstring3466in_class_8_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_8_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class8Source
class8LevelOptionalinteger1151in_class_8_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_8_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class8Level
classification9Optionalstring3467in_classification_9SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_9
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification9
class9SourceOptionalstring3468in_class_9_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_9_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class9Source
class9LevelOptionalinteger1158in_class_9_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_9_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class9Level
classification10Optionalstring3469in_classification_10SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_10
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification10
class10SourceOptionalstring3470in_class_10_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_10_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class10Source
class10LevelOptionalinteger1159in_class_10_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_10_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class10Level
classification11Optionalstring3471in_classification_11SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_11
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification11
class11SourceOptionalstring3493in_class_11_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_11_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class11Source
class11LevelOptionalinteger1160in_class_11_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_11_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class11Level
classification12Optionalstring3473in_classification_12SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_12
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification12
class12SourceOptionalstring3474in_class_12_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_12_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class12Source
class12LevelOptionalinteger1161in_class_12_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_12_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class12Level
classification13Optionalstring3475in_classification_13SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_13
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification13
class13SourceOptionalstring3476in_class_13_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_13_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class13Source
class13LevelOptionalinteger1162in_class_13_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_13_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class13Level
classification14Optionalstring3477in_classification_14SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_14
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification14
class14SourceOptionalstring3494in_class_14_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_14_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class14Source
class14LevelOptionalinteger1163in_class_14_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_14_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class14Level
classification15Optionalstring3495in_classification_15SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_15
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification15
class15SourceOptionalstring3496in_class_15_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_15_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class15Source
class15LevelOptionalinteger1164in_class_15_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_15_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class15Level
classification16Optionalstring3481in_classification_16SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_16
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification16
class16SourceOptionalstring3482in_class_16_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_16_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class16Source
class16LevelOptionalinteger1165in_class_16_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_16_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class16Level
classification17Optionalstring3483in_classification_17SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_17
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification17
class17SourceOptionalstring3484in_class_17_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_17_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class17Source
class17LevelOptionalinteger1166in_class_17_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_17_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class17Level
classification18Optionalstring3485in_classification_18SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_18
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification18
class18SourceOptionalstring3486in_class_18_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_18_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class18Source
class18LevelOptionalinteger1167in_class_18_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_18_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class18Level
classification19Optionalstring3487in_classification_19SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_19
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification19
class19SourceOptionalstring3488in_class_19_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_19_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class19Source
class19LevelOptionalinteger1169in_class_19_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_19_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class19Level
classification20Optionalstring3489in_classification_20SSECURITYDBOISSUER_ORGANIZATIONCLASSIFICATION_20
(version 2015R2 or higher)
VARCHAR2(60)EagleML/referenceTransaction/issuer/organizationModel/classification20
class20SourceOptionalstring3490in_class_20_sourceSSECURITYDBOISSUER_ORGANIZATIONCLASS_20_SOURCE
(version 2015R2 or higher)
VARCHAR2(30)EagleML/referenceTransaction/issuer/organizationModel/class20Source
class20LevelOptionalinteger1175in_class_20_levelNSECURITYDBOISSUER_ORGANIZATIONCLASS_20_LEVEL
(version 2015R2 or higher)
NUMBER(38)EagleML/referenceTransaction/issuer/organizationModel/class20Level
externalUpdateDateOptionaldate16077in_external_update_dateSSECURITYDBOISSUER_ORGANIZATIONEXTERNAL_UPDATE_DATE
(version 2017R1 or higher)
DATEEagleML/referenceTransaction/issuer/organizationModel/externalUpdateDate
yearIncOptionaldecimal16078in_year_incNSECURITYDBOISSUER_ORGANIZATIONYEAR_INC
(version 2017R1 or higher)
NUMBER(28,12)EagleML/referenceTransaction/issuer/organizationModel/yearInc
addressLine2Optionalstring16133in_address_line_2
SECURITYDBOISSUER_ORGANIZATIONADDRESS_LINE_2VARCHAR2(255)EagleML/referenceTransaction/issuerOrganization/addressLine2
zipCodeOptionalstring16134in_zip_code
SECURITYDBOISSUER_ORGANIZATIONZIP_CODEVARCHAR2(255)EagleML/referenceTransaction/issuerOrganization/zipCode
acquiredByParentOptionalYesNoOptionEnum16135in_acquired_by_parent
SECURITYDBOISSUER_ORGANIZATIONACQUIRED_BY_PARENTVARCHAR2(1)EagleML/referenceTransaction/issuerOrganization/acquiredByParent
isUltParentOptionalYesNoOptionEnum16136in_is_ult_parent
SECURITYDBOISSUER_ORGANIZATIONIS_ULT_PARENTVARCHAR2(1)EagleML/referenceTransaction/issuerOrganization/isUltParent
companyCorpTickerOptionalstring16137in_company_corp_ticker
SECURITYDBOISSUER_ORGANIZATIONCOMPANY_CORP_TICKERVARCHAR2(100)EagleML/referenceTransaction/issuerOrganization/companyCorpTicker
gicsSectorOptionalstring10181in_gics_sector
SECURITYDBOISSUER_ORGANIZATIONGICS_SECTORVARCHAR2(60)EagleML/referenceTransaction/issuerOrganization/gicsSector
gicsSectorNameOptionalstring






EagleML/referenceTransaction/issuerOrganization/gicsSectorName
gicsIndustryGroupOptionalstring10183in_gics_industry_group
SECURITYDBOISSUER_ORGANIZATIONGICS_INDUSTRY_GROUPVARCHAR2(60)EagleML/referenceTransaction/issuerOrganization/gicsIndustryGroup
gicsIndustryGroupNameOptionalstring






EagleML/referenceTransaction/issuerOrganization/gicsIndustryGroupName
gicsIndustryOptionalstring


SECURITYDBOISSUER_ORGANIZATIONGICS_INDUSTRYVARCHAR2(60)EagleML/referenceTransaction/issuerOrganization/gicsIndustry
gicsIndustryNameOptionalstring






EagleML/referenceTransaction/issuerOrganization/gicsIndustryName
gicsSubIndustryOptionalstring


SECURITYDBOISSUER_ORGANIZATIONGICS_SUB_INDUSTRYVARCHAR2(60)EagleML/referenceTransaction/issuerOrganization/gicsSubIndustry
gicsSubIndustryNameOptionalstring






EagleML/referenceTransaction/issuerOrganization/gicsSubIndustryName
historyOnlyFlagOptionalYesNoOptionEnum






EagleML/referenceTransaction/issuerOrganization/historyOnlyFlag
issuerTypeOptionalstring


SECURITYDBOISSUER_ORGANIZATIONISSUER_TYPEVARCHAR2(255)EagleML/referenceTransaction/issuerOrganization/issuerType
phoneOptionalstring


SECURITYDBOISSUER_ORGANIZATIONISSUER_PHONEVARCHAR2(60)EagleML/referenceTransaction/issuerOrganization/phone
cfcFlagOptionalYesNoOptionEnum


SECURITYDBOISSUER_ORGANIZATIONCFC_FLAGVARCHAR2(1)EagleML/referenceTransaction/issuerOrganization/cfcFlag
centralCounterPartyOptionalYesNoOptionEnum


SECURITYDBOISSUER_ORGANIZATIONCENTRAL_COUNTER_PARTYVARCHAR2(1)EagleML/referenceTransaction/issuerOrganization/centralCounterParty

RoleModel Data Map

ElementOptional/RequiredValue TypeStar TagSP ParameterSP TypeEagle DBDB TableDB FieldData TypeXPATH
roleTypeRequiredstring3347in_role_typeSSECURITYDBOISSUER_ROLE_DETAILSROLE_TYPEVARCHAR2(30)EagleML/referenceTransaction/issuer/roleModel/roleType
startDateRequireddate71in_start_dateSSECURITYDBOISSUER_ROLE_DETAILSSTART_DATEDATEEagleML/referenceTransaction/issuer/roleModel/startDate
endDateOptionaldate73in_end_dateSSECURITYDBOISSUER_ROLE_DETAILSEND_DATEDATEEagleML/referenceTransaction/issuer/roleModel/endDate
percentOwnedOptionaldecimal3348in_percent_owned
SECURITYDBOISSUER_ROLE_DETAILSPERCENT_OWNEDNUMBER(28,12)EagleML/referenceTransaction/issuer/roleModel/percentOwned
irdUpdateDateOptionaldate

FSECURITYDBOISSUER_ROLE_DETAILSIRD_UPDATE_DATEDATEEagleML/referenceTransaction/issuer/roleModel/irdUpdateDate
irdChar1Optionalstring8286in_ird_char1SSECURITYDBOISSUER_ROLE_DETAILSIRD_CHAR1VARCHAR2(30)EagleML/referenceTransaction/issuer/roleModel/irdChar1

RelationshipModel Data Map

ElementOptional/RequiredValue TypeStar TagSP ParameterSP TypeEagle DBDB TableDB FieldData TypeXPATH
fromIssuerIssuerIdentifiersDataModel - Complex type (see extra table below)EagleML/referenceTransaction/issuer/relationshipModel/fromIssuer/
toIssuerIssuerIdentifiersDataModel - Complex type (see extra table below)EagleML/referenceTransaction/issuer/relationshipModel/toIssuer/
roleTypeRequiredstring8292in_role_typeSSECURITYDBOISSUER_RELATIONSHIPROLE_TYPEVARCHAR2(30)EagleML/referenceTransaction/issuer/relationshipModel/roleType
percentOwnedOptionaldecimal8291in_percent_ownedFSECURITYDBOISSUER_RELATIONSHIPPERCENT_OWNEDNUMBER(28,12)EagleML/referenceTransaction/issuer/relationshipModel/percentOwned

RatingModel Data Map

ElementOptional/RequiredValue TypeStar TagSP ParameterSP TypeEagle DBDB TableDB FieldData TypeXPATH
alphaRatingOptionalstring3349in_alpha_ratingSSECURITYDBOISSUER_RATINGALPHA_RATINGCHAR(8)EagleML/referenceTransaction/issuer/ratingModel/alphaRating
analystCodeOptionalstring3407in_analyst_codeSSECURITYDBOISSUER_RATINGANALYST_CODECHAR(8)EagleML/referenceTransaction/issuer/ratingModel/analystCode
approvalCommentsOptionalstring3412in_approval_commentsSSECURITYDBOISSUER_RATINGAPPROVAL_COMMENTSVARCHAR2(255)EagleML/referenceTransaction/issuer/ratingModel/approvalComments
approvedByOptionalstring3409in_approved_bySSECURITYDBOISSUER_RATINGAPPROVED_BYCHAR(255)EagleML/referenceTransaction/issuer/ratingModel/approvedBy
numericalRatingOptionaldecimal3350in_numerical_ratingSSECURITYDBOISSUER_RATINGNUMERICAL_RATINGCHAR(8)EagleML/referenceTransaction/issuer/ratingModel/numericalRating
programOptionalstring3444in_programSSECURITYDBOISSUER_RATINGPROGRAMVARCHAR2(20)EagleML/referenceTransaction/issuer/ratingModel/program
providerOptionalstring3414in_providerSSECURITYDBOISSUER_RATINGPROVIDERCHAR(12)EagleML/referenceTransaction/issuer/ratingModel/provider
ratingCodeOptionalstring3446in_rating_codeSSECURITYDBOISSUER_RATINGRATING_CODEVARCHAR2(12)EagleML/referenceTransaction/issuer/ratingModel/ratingCode
ratingCommentsOptionalstring3411in_rating_commentsSSECURITYDBOISSUER_RATINGRATING_COMMENTSVARCHAR2(255)EagleML/referenceTransaction/issuer/ratingModel/ratingComments
ratingTypeIndicatorOptionalstring3445in_rating_type_indicatorSSECURITYDBOISSUER_RATINGRATING_TYPE_INDICATORVARCHAR2(20)EagleML/referenceTransaction/issuer/ratingModel/ratingTypeIndicator
reasonOptionalstring3408in_reasonSSECURITYDBOISSUER_RATINGREASONVARCHAR2(255)EagleML/referenceTransaction/issuer/ratingModel/reason
submittedByOptionalstring3410in_submitted_bySSECURITYDBOISSUER_RATINGSUBMITTED_BYCHAR(255)EagleML/referenceTransaction/issuer/ratingModel/submittedBy
submittedDateOptionaldate3413in_submitted_dateSSECURITYDBOISSUER_RATINGSUBMITTED_DATEDATEEagleML/referenceTransaction/issuer/ratingModel/submittedDate
ratingChar1Optionalstring3448in_rating_char1SSECURITYDBOISSUER_RATINGIR_CHAR1VARCHAR2(60)EagleML/referenceTransaction/issuer/ratingModel/ratingChar1
ratingChar2Optionalstring3449in_rating_char2SSECURITYDBOISSUER_RATINGIR_CHAR2VARCHAR2(60)EagleML/referenceTransaction/issuer/ratingModel/ratingChar2
ratingChar3Optionalstring3450in_rating_char3SSECURITYDBOISSUER_RATINGIR_CHAR3VARCHAR2(60)EagleML/referenceTransaction/issuer/ratingModel/ratingChar3
ratingChar4Optionalstring3415in_rating_char4SSECURITYDBOISSUER_RATINGIR_CHAR4VARCHAR2(60)EagleML/referenceTransaction/issuer/ratingModel/ratingChar4
ratingChar5Optionalstring3416in_rating_char5SSECURITYDBOISSUER_RATINGIR_CHAR5VARCHAR2(60)EagleML/referenceTransaction/issuer/ratingModel/ratingChar5
ratingChar6Optionalstring3417in_rating_char6SSECURITYDBOISSUER_RATINGIR_CHAR6VARCHAR2(60)EagleML/referenceTransaction/issuer/ratingModel/ratingChar6
ratingChar7Optionalstring3440in_rating_char7SSECURITYDBOISSUER_RATINGIR_CHAR7VARCHAR2(60)EagleML/referenceTransaction/issuer/ratingModel/ratingChar7
ratingChar8Optionalstring3441in_rating_char8SSECURITYDBOISSUER_RATINGIR_CHAR8VARCHAR2(60)EagleML/referenceTransaction/issuer/ratingModel/ratingChar8
ratingChar9Optionalstring3442in_rating_char9SSECURITYDBOISSUER_RATINGIR_CHAR9VARCHAR2(60)EagleML/referenceTransaction/issuer/ratingModel/ratingChar9
ratingChar10Optionalstring3457in_rating_char10SSECURITYDBOISSUER_RATINGIR_CHAR10VARCHAR2(60)EagleML/referenceTransaction/issuer/ratingModel/ratingChar10
ratingDate1Optionaldate3451in_rating_date1SSECURITYDBOISSUER_RATINGIR_DATE1DATEEagleML/referenceTransaction/issuer/ratingModel/ratingDate1
ratingDate2Optionaldate3452in_rating_date2SSECURITYDBOISSUER_RATINGIR_DATE2DATEEagleML/referenceTransaction/issuer/ratingModel/ratingDate2
ratingDate3Optionaldate3453in_rating_date3SSECURITYDBOISSUER_RATINGIR_DATE3DATEEagleML/referenceTransaction/issuer/ratingModel/ratingDate3
ratingFloat1Optionaldecimal3454in_rating_float1FSECURITYDBOISSUER_RATINGIR_FLOAT1NUMBER(28,12)EagleML/referenceTransaction/issuer/ratingModel/ratingFloat1
ratingFloat2Optionaldecimal3455in_rating_float2FSECURITYDBOISSUER_RATINGIR_FLOAT2NUMBER(28,12)EagleML/referenceTransaction/issuer/ratingModel/ratingFloat2
ratingFloat3Optionaldecimal3456in_rating_float3FSECURITYDBOISSUER_RATINGIR_FLOAT3NUMBER(28,12)EagleML/referenceTransaction/issuer/ratingModel/ratingFloat3
bkupUpdateSourceOptionalstring


SECURITYDBOISSUER_RATINGBKUP_UPDATE_SOURCECHAR(8)EagleML/referenceTransaction/issuer/ratingModel/bkupUpdateSource
sourceDateOptionaldate


SECURITYDBOISSUER_RATINGSOURCE_DATEDATEEagleML/referenceTransaction/issuer/ratingModel/sourceDate

XrefModel Data Map

ElementOptional/RequiredValue TypeStar TagSP ParameterSP TypeEagle DBDB TableDB FieldData TypeXPATH
subIssuerIdOptionalstring


SECURITYDBOISSUER_XREFSUB_ISSUER_ID
EagleML/referenceTransaction/issuer/xrefModel/subIssuerId
subIssuerIdTypeOptionalstring


SECURITYDBOISSUER_XREFSUB_ISSUER_ID_TYPE
EagleML/referenceTransaction/issuer/xrefModel/subIssuerId
bondDummyOptionalstring


SECURITYDBOISSUER_XREFBOND_DUMMY
EagleML/referenceTransaction/issuer/xrefModel/bondDummy
equityDummyOptionalinteger


SECURITYDBOISSUER_XREFEQUITY_DUMMY
EagleML/referenceTransaction/issuer/xrefModel/equityDummy

LEI Data Map

ElementOptional/RequiredValue TypeStar TagSP ParameterSP TypeEagle DBDB TableDB FieldData TypeXPATH
legalIdOptionalstring5089in_leiSSECURITYDBOLEI_DETAILSLEIvarchar2(20)EagleML/referenceTransaction/issuer/legalEntityId/legalId
legalNameOptionalstring5090in_legal_nameSSECURITYDBOLEI_DETAILSLEGAL_NAMEnvarchar2(255)EagleML/referenceTransaction/issuer/legalEntityId/legalName
entityStatusOptionalstring5091in_entity_statusSSECURITYDBOLEI_DETAILSENTITY_STATUSnvarchar2(30)EagleML/referenceTransaction/issuer/legalEntityId/entityStatus
legalFormOptionalstring5092in_legal_formSSECURITYDBOLEI_DETAILSLEGAL_FORMnvarchar2(30)EagleML/referenceTransaction/issuer/legalEntityId/legalForm
idAssignedDateOptionaldate5093in_id_assigned_dateSSECURITYDBOLEI_DETAILSID_ASSIGNED_DATEdateEagleML/referenceTransaction/issuer/legalEntityId/idAssignedDate
idLastUpdateDateOptionaldate5094in_id_last_update_dateSSECURITYDBOLEI_DETAILSID_LAST_UPDATE_DATEdateEagleML/referenceTransaction/issuer/legalEntityId/idLastUpdateDate
idDisabledDateOptionaldate5095in_id_disabled_dateSSECURITYDBOLEI_DETAILSID_DISABLED_DATEdateEagleML/referenceTransaction/issuer/legalEntityId/idDisabledDate
idRecordStateOptionalstring5096in_id_record_stateSSECURITYDBOLEI_DETAILSID_RECORD_STATEnvarchar2(30)EagleML/referenceTransaction/issuer/legalEntityId/idRecordState
idCertificationStateOptionalstring5097in_id_certification_stateSSECURITYDBOLEI_DETAILSID_CERTIFICATION_STATEnvarchar2(30)EagleML/referenceTransaction/issuer/legalEntityId/idCertificationState
streetOptionalstring5098in_streetSSECURITYDBOLEI_DETAILSSTREETnvarchar2(255)EagleML/referenceTransaction/issuer/legalEntityId/street
cityOptionalstring5099in_citySSECURITYDBOLEI_DETAILSCITYnvarchar2(255)EagleML/referenceTransaction/issuer/legalEntityId/city
stateOptionalstring5100in_stateSSECURITYDBOLEI_DETAILSSTATEnvarchar2(255)EagleML/referenceTransaction/issuer/legalEntityId/state
zipOptionalstring5180in_zipSSECURITYDBOLEI_DETAILSZIPnvarchar2(255)EagleML/referenceTransaction/issuer/legalEntityId/zip
countryCodeOptionalstring5181in_country_codeSSECURITYDBOLEI_DETAILSCOUNTRY_CODEnvarchar2(30)EagleML/referenceTransaction/issuer/legalEntityId/countryCode
  • No labels