Issuer Regulatory Model Data Map Table
- Tsyganenko Victor (Unlicensed)
- Kinga Huszno
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 |