| 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 |
| filter_list |
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 (string format). 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 |
|
reportType |
string(255) |
|
Report type under a specific screening product report group |
|
sanctionEffectiveDate |
date |
|
Date sanctions go into effect. Mapped only if available on the sanction lists directly. |
|
sanctionList |
string(200) |
|
Name of the Sanction List by each country's authorizing body |
|
sanctionProgram |
string(255) |
|
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) |
| filter_list |
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 |