| key |
id |
string* |
= |
Unique identifier to represent each security (same as SecurityID). |
| timeline |
changeDatetime |
dateTime |
=< >= |
Last modification date and time of a physical row in UTC format. |
|
activeFlag |
boolean |
|
Indicates that the security is currently active. An inactive security suggests either the security is delisted, matured, called, redeemed, or involved in a reverse merger. |
|
cic |
string(4) |
|
Complementary Identification Code (CIC) is an asset classification schema for financial reporting in accordance with the insurance supervision law (VAG). A CIC is a four-digit alphanumeric code, which represents geographic as well as instrument-specific information. |
| link |
ciqCompanyId |
CompanyFoundation |
|
Unique universal identifier assigned to a company. |
|
ciqSecurityId |
long(-2147483648,2147483647) |
|
Unique identifier assigned to a security. |
|
couponRate |
decimal{19,5} |
|
The yield paid by a fixed income security. For equities, this value is null. (Magnitude: %) |
| link |
currencyId |
Currency |
|
Unique identifier for a currency. |
| link |
isoCfiCode |
CfiCode |
|
ISO CFI Code for classifying financial instruments in accordance with ISO 10962. |
|
issueDate |
date |
|
Approximate date the security was issued. This indicates the closest possible issue date received from data vendors. |
|
maturityDate |
date |
|
Date on which the security matures. |
|
parValue |
decimal{20,5} |
|
The face value of a fixed income instrument or stock value of a share as stated in statutory document by the security issuing entity.(Magnitude: $) |
|
primaryFlag |
boolean |
|
Indicates that the security is primary for the company. |
| link |
primaryListingExchangeId |
Exchange |
|
S&P exchange identifier for the primary listing exchange of the security. |
| link |
securityGroupId |
SecurityGroup |
|
Identifies the high-level classification of the security. One SecurityGroup can have multiple SecurityTypeIDs. e.g. Common Equity, Preferred Equity and Equity Depository Receipts subtypeids are represented under Equity Group. |
|
securityName |
string(200) |
|
Name of the Security. |
| link |
securitySubTypeId |
SecuritySubType |
|
Unique identifier assigned to security asset type. e.g. Common Stock, Corporate Bond/Note, Preferred Security, Term loan etc. Securitysubtypeid classification is most granular security asset class bifurcation. |
| link |
securityTypeId |
SecurityType |
|
Unique identifier assigned to mid-level asset class bifurcation. One SecurityType can have multiple securitysubtypeids. e.g. Common Stock, Limited Partnership and Operating Partnership units are classified as Common Equity securitytype. |
| link |
usCfiCode |
UsCfiCode |
|
US CFI Code for classifying financial instruments in order to identify the type and characteristics of each instrument. |