| Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | Data Type | XPath |
|---|---|---|---|---|---|---|---|---|---|---|
| objectType | Required | Required | ObjectTypeEnum | - | not stored in DB | EagleML/referenceTransaction/issuerRegulatory/objectType | ||||
| objectId | ObjectId | - | not stored in DB | EagleML/referenceTransaction/issuerRegulatory/objectId | ||||||
| objectDescription | FeedTypeEnum | - | not stored in DB | EagleML/referenceTransaction/issuerRegulatory/objectDescription | ||||||
| updateTimestamp | dateTime | - | EagleML/referenceTransaction/issuerRegulatory/updateTimestamp | |||||||
| historyOnlyFlag | YesNoOptionEnum | - | in_history_switch | not stored in DB | EagleML/referenceTransaction/issuerRegulatory/historyOnlyFlag | |||||
| customElements | Not recommended | CustomElements - reserved for customizations | EagleML/referenceTransaction/issuerRegulatory/customElements/ | |||||||
| Issuer Identifiers Model - see extra table | EagleML/referenceTransaction/issuerRegulatory/ | |||||||||
| 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 | ||
General
Content
Integrations