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