Type SanctionsMasterListData
Type category Entity
Description Sanctions Master List
Timeseries key id, reportDateavailable from 2025-01-17
Fields
Name Type Filters Description
key id string(100)* = EBS internal id - unique
timeline reportDate date =< >= Date at which report was run
filter_list authorizingBody string(50) = Country or body authorizing the sanctions (eg. US, UK, EU, etc.)
link batch Batch* = The Batch for which this BatchRun is an instance.
link batchRun BatchRun* = The BatchRun in which the Instrument is deliverd.
bloombergGlobalCompositeIdExchange string(100) Actual identifier value for the security/trading item (e.g., 082757015, BBG0039DCTG1, A1G9G1)
bloombergGlobalIdExchange string(100) Actual identifier value for the security/trading item (e.g., 082757015, BBG0039DCTG1, A1G9G1)
bloombergShareClass string(100) Actual identifier value for the security/trading item (e.g., 082757015, BBG0039DCTG1, A1G9G1)
bloombergTickerExchange string(100) Actual identifier value for the security/trading item (e.g., 082757015, BBG0039DCTG1, A1G9G1)
bloombergUniqueId string(300) Actual identifier value for the security/trading item (e.g., 082757015, BBG0039DCTG1, A1G9G1)
filter_list ciqCompanyId long = The unique entity identifier created by S&P Capital IQ. The identifier for the company each security relates to
companyName string(255) Name of the sanctioned company
countryOfIncorporation string(255) Country in which the entity was incorporated
countryOfIncorporationCode string(3) ISO Code for Country in which the entity was incorporated
currency string(50) The currency (i.e., trading currency) represents the currency in which a particular security (e.g., bond, stock or any other financial instrument) trades on a specific exchange.
currencyCode string(3) This is the 3-digit alpha ISO currency code
cusip string(50) Security identifier - CUSIP code
details string(255) Additional comments or details.
determination string(100) Determination made by applying any directives for non-blocking secutoral sanctions. Best effort basis. Possible Values - Sanctioned, Not Sanctioned, Potentially Sanctioned, Domiciled in a country
divestmentDateDetails string(255) Divestment Date. Mapped only if available on the sanction lists directly.
effectiveDateDetails string(255) Date sanctions go into effect. Mapped only if available on the sanction lists directly.
exchangeName string(100) S&P Capital IQ unique identifier for an exchange.
filter_list isin string(50) = Security identifier - ISIN code
issueDate date Approximate date the security was issued. This indicates the closest possible issue date received from our vendor.
listingDateDetails string(255) Listing Date. Mapped only if available on the sanction lists directly.
maturityDate date Date the security matures.
mic string(4) Identifies the entity operating an exchange, trading platform, regulated or non-regulated market or a trade reporting facility in a specific country.
parentCompany string(300) Pipe delimited values of Name of Parent Company
parentCompanyId string(512) Pipe delimited values of Parent Company ID
primaryListingExchange string(100) S&P Capital IQ identifier for the primary listing exchange of the security.
relationship string(255) Description of the relationship between the child company and the parent company.
reportGroup string(255) Report group for grouping screening product reports
filter_list reportType string(255) = Report type under a specific screening product report group
sanctionList string(200) Name of the Sanction List by each country's authorizing body
sanctionProgram string(200) Pipe delimited values of Sanctioned Programs
securityGroup string(100) Security Group description (e.g., Equity, Fixed Income)
filter_list securityId string(100) = The unique security identifier created by S&P GICRS.
securityName string(150) Name/type of security (e.g., common, preferred, etc.)
securitySubType string(100) Security asset type. Null values signify others.
securityType string(40) Security Type description (e.g., Common Equity, Preferred Equity, Corporate Debt)
sedol string(50) Security identifier - Sedol code
tickerExchange string(100) Actual identifier value for the security/trading item (e.g., 082757015, BBG0039DCTG1, A1G9G1)
tradingItemId string(100) The unique trading item identifier created by S&P Capital IQ
43 rows of 43 total
API Open API Specification