| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
|
appstatus |
long |
|
Status of this object's data with respect to approval for publication |
|
cusip |
string(9) |
|
Market identifier assigned by CUSIP bureau for a given security or an entity |
|
cusipissuenumber |
string(2) |
|
CUSIP Issue Number as reported by the CUSIP Service Bureau, operated by Standard Poor's |
|
cusipissuername |
string(120) |
|
CUSIP Issuer Name |
|
divrate |
long |
|
Stated annual dividend rate or interest coupon of a fixed-rate issue, or effective rate of a variable-rate issue during the period indicated |
|
finlstatassetcity |
string(40) |
|
City |
|
finlstatassetdesc |
string(243) |
|
Description |
|
finlstatassetdesignation |
string(10) |
|
The National Association of Insurance Commissioners (NAIC) quality rating for each bond or preferred stock. The securities designated 1 are the highest quality and 6 the lowest quality. Market indicator identifies how the security was valued. Mortgage backed securities are treated differently and are based on modeled expected recovery values compared with carrying value reported by the company. Only applicable for 2019 and prior. |
|
finlstatassetforeigncode |
string(1) |
|
Indicates whether a bond is either denominated in a foreign currency or issued by a foreign entity.Only applicable for 2015 and prior. |
|
finlstatassetinterestrate |
long |
|
Interest Rate |
|
finlstatassetstate |
string(40) |
|
State, province, country, or other location of the asset or counterparty |
|
finlstatfvmethodsource |
string(255) |
|
Source of the method indicated to determine the rate per share used in obtaining fair value |
|
fndgmaturity |
date |
|
The maturity date of debt securities, or the date on which the security must be redeemed by the issuer or otherwise repaid by the borrower |
|
fndgparvalue |
long |
|
Can be expressed as a percent or a monetary value. Conventional debt issues are shown as a relative percent of the net offering proceeds that are assigned to the equity account, rather than to paid-in capital where the par value provides a starting basis for pricing or trading the issue. For non-conventional debt issues, such as corporate units, monetary amounts are displayed representing the face value of the security. For these securities, par value represents the stated value of the issue. |
|
isin |
string(12) |
|
Unique identifier used by the global capital markets |
|
issuebondcounsel |
string(60) |
|
Firm that prepares the legal opinion for the issuance of a bond |
|
issuecallableattributeoption |
string(1) |
|
A security where the issuer has the right to redeem the security prior to maturity |
|
issuefinancialadvisor |
string(60) |
|
Firm that advises issuer on the issuance of a security |
|
issueunderwriter |
string(60) |
|
Firm that administers the public issuance and distribution of securities |
|
keycusipissuepreferredtype |
long |
|
Key of preferred type |
|
keycusipissueputable |
long |
|
Key of issue putable |
|
keycusipissueratetype |
long |
|
Key of rate type |
|
keycusipissuertype |
string(1) |
|
C U S I P Issuer Type OID |
|
keyfinlstatassetbondchar |
long |
|
Bond Char. Only applicable for 2015 and prior. |
|
keyfinlstatassetissuertype |
long |
|
Key of issuer type |
|
keyfinlstatassettype |
long |
|
OID of Finl Stat Asset Type |
|
keyfinlstatcollateraltype |
long |
|
Finl Stat Collateral Type OID |
|
keyfinlstatfairvaluemethod |
long |
|
Finl Stat Fair Value Method OID |
|
keyfinlstatstate |
long |
|
Finl Stat State OID |
|
keynaiccollateraltype |
long |
|
N A I C Collateral Type OID |
|
keynaicforeignbondtype |
long |
|
N A I C Foreign Bond Code OID |
|
keynaicmortgageloanstanding |
long |
|
N A I C Mortgage Loan Standing OID |
|
keynaicschedule |
long |
|
N A I C Schedule OID |
|
keysecurity |
long |
|
Security OID |
|
keystatassettypestrategy |
long |
|
OID of KeyStatAssetTypeStrategy |
|
masknaicbondcharacteristic |
long |
|
Mask of NAIC Bond Characteristic |
|
mbspoolprefix |
string(3) |
|
Helps distinguish the types of mortgages pooled into that security. All individual mortgages are assigned a pool serial number, which is shared with the individual security issue. This field is an attribute of that serial number. |
|
naics |
string(6) |
|
North American Industry Classification System (NAICS) code. NAICS is a system for classifying establishments by type of business activity. Promulgated by the U.S. Office of Management and Budget, it is the first industry classification system developed in accordance with a single principle of aggregation, the principle that producing units that use similar production processes should be grouped together. Within a company's assigned NAICS code there are various levels of classification, including Sector (the first two digits), Industry Group (the first four digits), and National Industry (the first six digits). For example, 22: Utilities (Sector), 2211: Electric Power Gen., Transmission, Dist (Industry Group) and 221111: Hydroelectric Power Generation (National Industry). |
|
shortname |
string(30) |
|
Shortened version of the company's name |
|
tradingsymbol |
string(20) |
|
Ticker, or trading symbol, of this security as used on the issue's primary securities exchange |
|
upddate |
date |
|
Last modification date and time of a physical row |
|
updoperation |
long |
|
Indicates whether the row is new, updated, or (logically) deleted. Logically deleted rows should not appear in any product data, nor in default views of the data. 0: New, 1: Updated, 2: Logical Deletion. |