Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

foreignSecuritiesDepositoryYesNoOptionEnum17263in_foreign_sec_depositorySECURITYDBOISSUER_REGULATORYFOREIGN_SEC_DEPOSITORYVARCHAR2(2)EagleML/referenceTransaction/issuerRegulatory/foreignSecuritiesDepositoryinsuranceCompanySponsorYesNoOptionEnum17264in_insurance_co_sponsorSECURITYDBOISSUER_REGULATORYINSURANCE_CO_SPONSORVARCHAR2(2)EagleML/referenceTransaction/issuerRegulatory/insuranceCompanySponsorsecuritiesActIssuerYesNoOptionEnum17266in_securities_act_issuerSECURITYDBOISSUER_REGULATORYSECURITIES_ACT_ISSUERVARCHAR2(2)

EagleML/referenceTransaction/issuerRegulatory/securitiesActIssuer

sanctionScopestring18369in_scope_sancSECURITYDBOISSUER_REGULATORYSCOPE_SANCVARCHAR2(255)EagleML/referenceTransaction/issuerRegulatory/sanctionScopeconfidenceLeveldecimal18352in_confid_lvlSECURITYDBOISSUER_REGULATORYCONFID_LVLNUMBER(38,0)EagleML/referenceTransaction/issuerRegulatory/confidenceLevelsanctionedIndicatorYesNoOptionEnum18351in_sanctionedSECURITYDBOISSUER_REGULATORYSANCTIONEDVARCHAR2(20)EagleML/referenceTransaction/issuerRegulatory/sanctionedIndicatorisIssuingIndicatorYesNoOptionEnum18370in_is_issuingSECURITYDBOISSUER_REGULATORYIS_ISSUINGVARCHAR2(20)EagleML/referenceTransaction/issuerRegulatory/isIssuingIndicatoreuropeanSanctionDirectivestring18355in_eu_sancSECURITYDBOISSUER_REGULATORYEU_SANCVARCHAR2(2000)EagleML/referenceTransaction/issuerRegulatory/europeanSanctionDirectiveunitedStatesSDNSanctionDirectivestring18356in_us_sdn_sancSECURITYDBOISSUER_REGULATORYUS_SDN_SANCVARCHAR2(2000)EagleML/referenceTransaction/issuerRegulatory/unitedStatesSDNSanctionDirectiveunitedStatesNonSDNSanctionDirectivestring18357in_us_non_sdn_sancSECURITYDBOISSUER_REGULATORYUS_NON_SDN_SANCVARCHAR2(2000)EagleML/referenceTransaction/issuerRegulatory/unitedStatesNonSDNSanctionDirectiveunitedNationsSanctionDirectivestring18358in_un_sancSECURITYDBOISSUER_REGULATORYUN_SANCVARCHAR2(2000)EagleML/referenceTransaction/issuerRegulatory/unitedNationsSanctionDirectivehongKongSanctionDirectivestring18359in_hk_sancSECURITYDBOISSUER_REGULATORYHK_SANCVARCHAR2(2000)EagleML/referenceTransaction/issuerRegulatory/hongKongSanctionDirectiveunitedKindomSanctionDirectivestring18360in_uk_sancSECURITYDBOISSUER_REGULATORYUK_SANCVARCHAR2(2000)EagleML/referenceTransaction/issuerRegulatory/unitedKindomSanctionDirectivechinaSanctionDirectivestring18361in_ch_sancSECURITYDBOISSUER_REGULATORYCH_SANCVARCHAR2(2000)EagleML/referenceTransaction/issuerRegulatory/chinaSanctionDirectivecanadaSanctionDirectivestring18362in_ca_sancSECURITYDBOISSUER_REGULATORYCA_SANCVARCHAR2(2000)EagleML/referenceTransaction/issuerRegulatory/canadaSanctionDirectiveaustraliaSanctionDirectivestring18363in_au_sancSECURITYDBOISSUER_REGULATORYAU_SANCVARCHAR2(2000)EagleML/referenceTransaction/issuerRegulatory/australiaSanctionDirectivesingaporeSanctionDirectivestring18364in_sg_sancSECURITYDBOISSUER_REGULATORYSG_SANCVARCHAR2(2000)EagleML/referenceTransaction/issuerRegulatory/singaporeSanctionDirectivesanctionTargetCountrystring18365in_target_sancSECURITYDBOISSUER_REGULATORYTARGET_SANCVARCHAR2(255)EagleML/referenceTransaction/issuerRegulatory/sanctionTargetCountry

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/

booksAndRecordsDescriptionstring17255in_books_and_records_descSECURITYDBOISSUER_REGULATORYBOOKS_AND_RECORDS_DESCVARCHAR2(255)EagleML/referenceTransaction/issuerRegulatory/booksAndRecordsDescriptionsubCustodianYesNoOptionEnum17256in_sub_custodianSECURITYDBOISSUER_REGULATORYSUB_CUSTODIANVARCHAR2(2)EagleML/referenceTransaction/issuerRegulatory/subCustodianbankCustodianYesNoOptionEnum17257in_bank_custodianSECURITYDBOISSUER_REGULATORYBANK_CUSTODIANVARCHAR2(2)EagleML/referenceTransaction/issuerRegulatory/bankCustodianselfCustodianYesNoOptionEnum17259in_self_custodianSECURITYDBOISSUER_REGULATORYSELF_CUSTODIANVARCHAR2(2)EagleML/referenceTransaction/issuerRegulatory/selfCustodianforeignCustodianYesNoOptionEnum17261in_foreign_custodianSECURITYDBOISSUER_REGULATORYFOREIGN_CUSTODIANVARCHAR2(2)EagleML/referenceTransaction/issuerRegulatory/foreignCustodianotherCustodianTypestring17265in_other_custodian_typeSECURITYDBOISSUER_REGULATORYOTHER_CUSTODIAN_TYPEVARCHAR2(255)EagleML/referenceTransaction/issuerRegulatory/otherCustodianTypenationalSecuritiesExchangeMemberYesNoOptionEnum17258in_national_sec_exch_mbrSECURITYDBOISSUER_REGULATORYNATIONAL_SEC_EXCH_MBRVARCHAR2(2)EagleML/referenceTransaction/issuerRegulatory/nationalSecuritiesExchangeMembersecuritiesDepositoryYesNoOptionEnum17260in_securities_depositorySECURITYDBOISSUER_REGULATORYSECURITIES_DEPOSITORYVARCHAR2(2)EagleML/referenceTransaction/issuerRegulatory/securitiesDepositoryfuturesCommodityYesNoOptionEnum17262in_futures_commoditySECURITYDBOISSUER_REGULATORYFUTURES_COMMODITYVARCHAR2(2)EagleML/referenceTransaction/issuerRegulatory/futuresCommodity

Issuer Regulatory Model

EagleML/referenceTransaction/issuerRegulatory/