...
...
...
...
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/sanctionTargetCountryElement | 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 |