Type StatSecurity
Type category Entity
Description StatSecurity table
Fields
Name Type Filters Description
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.
43 rows of 43 total
API Open API Specification