Issuer Organization Data Map Table

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

Issuer Xref Identifiers Model Data Map

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
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification4

class4Source

string

3458

in_class_4_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_4_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class4Source

class4Level

integer

1198

in_class_4_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_4_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class4Level

classification5

string

3492

in_classification_5

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_5
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification5

class5Source

string

3460

in_class_5_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_5_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class5Source

class5Level

integer

1148

in_class_5_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_5_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class5Level

classification6

string

3461

in_classification_6

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_6
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification6

class6Source

string

3462

in_class_6_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_6_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class6Source

class6Level

integer

1149

in_class_6_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_6_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class6Level

classification7

string

3463

in_classification_7

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_7
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification7

class7Source

string

3464

in_class_7_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_7_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class7Source

class7Level

integer

1150

in_class_7_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_7_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class7Level

classification8

string

3465

in_classification_8

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_8
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification8

class8Source

string

3466

in_class_8_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_8_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class8Source

class8Level

integer

1151

in_class_8_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_8_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class8Level

classification9

string

3467

in_classification_9

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_9
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification9

class9Source

string

3468

in_class_9_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_9_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class9Source

class9Level

integer

1158

in_class_9_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_9_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class9Level

classification10

string

3469

in_classification_10

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_10
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification10

class10Source

string

3470

in_class_10_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_10_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class10Source

class10Level

integer

1159

in_class_10_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_10_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class10Level

classification11

string

3471

in_classification_11

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_11
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification11

class11Source

string

3493

in_class_11_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_11_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class11Source

class11Level

integer

1160

in_class_11_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_11_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class11Level

classification12

string

3473

in_classification_12

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_12
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification12

class12Source

string

3474

in_class_12_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_12_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class12Source

class12Level

integer

1161

in_class_12_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_12_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class12Level

classification13

string

3475

in_classification_13

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_13
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification13

class13Source

string

3476

in_class_13_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_13_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class13Source

class13Level

integer

1162

in_class_13_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_13_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class13Level

classification14

string

3477

in_classification_14

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_14
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification14

class14Source

string

3494

in_class_14_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_14_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class14Source

class14Level

integer

1163

in_class_14_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_14_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class14Level

classification15

string

3495

in_classification_15

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_15
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification15

class15Source

string

3496

in_class_15_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_15_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class15Source

class15Level

integer

1164

in_class_15_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_15_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class15Level

classification16

string

3481

in_classification_16

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_16
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification16

class16Source

string

3482

in_class_16_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_16_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class16Source

class16Level

integer

1165

in_class_16_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_16_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class16Level

classification17

string

3483

in_classification_17

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_17
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification17

class17Source

string

3484

in_class_17_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_17_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class17Source

class17Level

integer

1166

in_class_17_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_17_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class17Level

classification18

string

3485

in_classification_18

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_18
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification18

class18Source

string

3486

in_class_18_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_18_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class18Source

class18Level

integer

1167

in_class_18_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_18_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class18Level

classification19

string

3487

in_classification_19

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_19
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification19

class19Source

string

3488

in_class_19_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_19_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class19Source

class19Level

integer

1169

in_class_19_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_19_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class19Level

classification20

string

3489

in_classification_20

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASSIFICATION_20
(version 2015R2 or higher)

VARCHAR2(60)

EagleML/referenceTransaction/issuerOrganization/classification20

class20Source

string

3490

in_class_20_source

S

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_20_SOURCE
(version 2015R2 or higher)

VARCHAR2(30)

EagleML/referenceTransaction/issuerOrganization/class20Source

class20Level

integer

1175

in_class_20_level

N

SECURITYDBO

ISSUER_ORGANIZATION

CLASS_20_LEVEL
(version 2015R2 or higher)

NUMBER(38)

EagleML/referenceTransaction/issuerOrganization/class20Level

externalUpdateDate
(supported in  2017R1)

date

16077

in_external_update_date

S

SECURITYDBO

ISSUER_ORGANIZATION

EXTERNAL_UPDATE_DATE
(version 2017R1 or higher)

DATE

EagleML/referenceTransaction/issuerOrganization/externalUpdateDate

yearInc
(supported in  2017R1)

decimal

16078

in_year_inc

N

SECURITYDBO

ISSUER_ORGANIZATION

YEAR_INC
(version 2017R1 or higher)

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

 LEI Model

EagleML/referenceTransaction/issuerOrganization/legalEntityId/