Issuer Regulatory Model Data Map Table

Element

Optional/ Required

Value Type

Star Tag

SP Parameter

SP TYPE

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Element

Optional/ Required

Value Type

Star Tag

SP Parameter

SP TYPE

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

booksAndRecordsDescription

 

 

string

17255

in_books_and_records_desc

SECURITYDBO

ISSUER_REGULATORY

BOOKS_AND_RECORDS_DESC

VARCHAR2(255)

EagleML/referenceTransaction/issuerRegulatory/booksAndRecordsDescription

subCustodian

 

 

YesNoOptionEnum

17256

in_sub_custodian

SECURITYDBO

ISSUER_REGULATORY

SUB_CUSTODIAN

VARCHAR2(2)

EagleML/referenceTransaction/issuerRegulatory/subCustodian

bankCustodian

 

 

YesNoOptionEnum

17257

in_bank_custodian

SECURITYDBO

ISSUER_REGULATORY

BANK_CUSTODIAN

VARCHAR2(2)

EagleML/referenceTransaction/issuerRegulatory/bankCustodian

selfCustodian

 

 

YesNoOptionEnum

17259

in_self_custodian

SECURITYDBO

ISSUER_REGULATORY

SELF_CUSTODIAN

VARCHAR2(2)

EagleML/referenceTransaction/issuerRegulatory/selfCustodian

foreignCustodian

 

 

YesNoOptionEnum

17261

in_foreign_custodian

SECURITYDBO

ISSUER_REGULATORY

FOREIGN_CUSTODIAN

VARCHAR2(2)

EagleML/referenceTransaction/issuerRegulatory/foreignCustodian

otherCustodianType

 

 

string

17265

in_other_custodian_type

SECURITYDBO

ISSUER_REGULATORY

OTHER_CUSTODIAN_TYPE

VARCHAR2(255)

EagleML/referenceTransaction/issuerRegulatory/otherCustodianType

nationalSecuritiesExchangeMember

 

 

YesNoOptionEnum

17258

in_national_sec_exch_mbr

SECURITYDBO

ISSUER_REGULATORY

NATIONAL_SEC_EXCH_MBR

VARCHAR2(2)

EagleML/referenceTransaction/issuerRegulatory/nationalSecuritiesExchangeMember

securitiesDepository

 

 

YesNoOptionEnum

17260

in_securities_depository

SECURITYDBO

ISSUER_REGULATORY

SECURITIES_DEPOSITORY

VARCHAR2(2)

EagleML/referenceTransaction/issuerRegulatory/securitiesDepository

futuresCommodity

 

 

YesNoOptionEnum

17262

in_futures_commodity

SECURITYDBO

ISSUER_REGULATORY

FUTURES_COMMODITY

VARCHAR2(2)

EagleML/referenceTransaction/issuerRegulatory/futuresCommodity

foreignSecuritiesDepository

 

 

YesNoOptionEnum

17263

in_foreign_sec_depository

SECURITYDBO

ISSUER_REGULATORY

FOREIGN_SEC_DEPOSITORY

VARCHAR2(2)

EagleML/referenceTransaction/issuerRegulatory/foreignSecuritiesDepository

insuranceCompanySponsor

 

 

YesNoOptionEnum

17264

in_insurance_co_sponsor

SECURITYDBO

ISSUER_REGULATORY

INSURANCE_CO_SPONSOR

VARCHAR2(2)

EagleML/referenceTransaction/issuerRegulatory/insuranceCompanySponsor

securitiesActIssuer

 

 

YesNoOptionEnum

17266

in_securities_act_issuer

SECURITYDBO

ISSUER_REGULATORY

SECURITIES_ACT_ISSUER

VARCHAR2(2)

EagleML/referenceTransaction/issuerRegulatory/securitiesActIssuer

sanctionScope

 

 

string

18369

in_scope_sanc

SECURITYDBO

ISSUER_REGULATORY

SCOPE_SANC

VARCHAR2(255)

EagleML/referenceTransaction/issuerRegulatory/sanctionScope

confidenceLevel

 

 

decimal

18352

in_confid_lvl

SECURITYDBO

ISSUER_REGULATORY

CONFID_LVL

NUMBER(38,0)

EagleML/referenceTransaction/issuerRegulatory/confidenceLevel

sanctionedIndicator

 

 

YesNoOptionEnum

18351

in_sanctioned

SECURITYDBO

ISSUER_REGULATORY

SANCTIONED

VARCHAR2(20)

EagleML/referenceTransaction/issuerRegulatory/sanctionedIndicator

isIssuingIndicator

 

 

YesNoOptionEnum

18370

in_is_issuing

SECURITYDBO

ISSUER_REGULATORY

IS_ISSUING

VARCHAR2(20)

EagleML/referenceTransaction/issuerRegulatory/isIssuingIndicator

europeanSanctionDirective

 

 

string

18355

in_eu_sanc

SECURITYDBO

ISSUER_REGULATORY

EU_SANC

VARCHAR2(2000)

EagleML/referenceTransaction/issuerRegulatory/europeanSanctionDirective

unitedStatesSDNSanctionDirective

 

 

string

18356

in_us_sdn_sanc

SECURITYDBO

ISSUER_REGULATORY

US_SDN_SANC

VARCHAR2(2000)

EagleML/referenceTransaction/issuerRegulatory/unitedStatesSDNSanctionDirective

unitedStatesNonSDNSanctionDirective

 

 

string

18357

in_us_non_sdn_sanc

SECURITYDBO

ISSUER_REGULATORY

US_NON_SDN_SANC

VARCHAR2(2000)

EagleML/referenceTransaction/issuerRegulatory/unitedStatesNonSDNSanctionDirective

unitedNationsSanctionDirective

 

 

string

18358

in_un_sanc

SECURITYDBO

ISSUER_REGULATORY

UN_SANC

VARCHAR2(2000)

EagleML/referenceTransaction/issuerRegulatory/unitedNationsSanctionDirective

hongKongSanctionDirective

 

 

string

18359

in_hk_sanc

SECURITYDBO

ISSUER_REGULATORY

HK_SANC

VARCHAR2(2000)

EagleML/referenceTransaction/issuerRegulatory/hongKongSanctionDirective

unitedKindomSanctionDirective

 

 

string

18360

in_uk_sanc

SECURITYDBO

ISSUER_REGULATORY

UK_SANC

VARCHAR2(2000)

EagleML/referenceTransaction/issuerRegulatory/unitedKindomSanctionDirective

chinaSanctionDirective

 

 

string

18361

in_ch_sanc

SECURITYDBO

ISSUER_REGULATORY

CH_SANC

VARCHAR2(2000)

EagleML/referenceTransaction/issuerRegulatory/chinaSanctionDirective

canadaSanctionDirective

 

 

string

18362

in_ca_sanc

SECURITYDBO

ISSUER_REGULATORY

CA_SANC

VARCHAR2(2000)

EagleML/referenceTransaction/issuerRegulatory/canadaSanctionDirective

australiaSanctionDirective

 

 

string

18363

in_au_sanc

SECURITYDBO

ISSUER_REGULATORY

AU_SANC

VARCHAR2(2000)

EagleML/referenceTransaction/issuerRegulatory/australiaSanctionDirective

singaporeSanctionDirective

 

 

string

18364

in_sg_sanc

SECURITYDBO

ISSUER_REGULATORY

SG_SANC

VARCHAR2(2000)

EagleML/referenceTransaction/issuerRegulatory/singaporeSanctionDirective

sanctionTargetCountry

 

 

string

18365

in_target_sanc

SECURITYDBO

ISSUER_REGULATORY

TARGET_SANC

VARCHAR2(255)

EagleML/referenceTransaction/issuerRegulatory/sanctionTargetCountry