Type SnlStatSecurity
Type category Entity
Description SnlStatSecurity View
Fields
Name Type Filters Description
key id string(36)* = unique id
link batch Batch* = Definition of a batch, representing a set of updates linked to a particular condition.
link batchRun BatchRun* = Defines an instance of a Batch. Where a Batch has a fixed definition over time, a BatchRun represents a specific Version of the Batch on a specific asOf.
caHealthSchedule boolean Indicates that the schedule pertains to California Health
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
cusipIssuePreferredType string(50) Describes the type of preferred stock issued
cusipIssuePutableDesc string(50) Describes the puttable policy of the bond
cusipIssueRateTypeDesc string(50) Describes the interest payment methodology of the security
cusipIssuerName string(120) CUSIP Issuer Name
cusipIssuerTypeDesc string(30) Description of issuer type, as reported by the CUSIP Service Bureau, operated by Standard and Poor's.
divRate decimal{7,4} Stated annual dividend rate or interest coupon of a fixed-rate issue, or effective rate of a variable-rate issue during the period indicated
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
maturityDt dateTime 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
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.
naicABSCollateralTypeCode string(2) Predominant collateral type code for asset backed securities
naicABSCollateralTypeDesc string(200) Predominant collateral type for asset backed securities
naicBondCharacteristicCode string Indicates any special circumstances with respect to the timing or amount of the coupon payment(s) for the bond, using codes defined by the NAIC
naicBondCharacteristicDesc string Indicates any special circumstances with respect to the timing or amount of the coupon payment(s) for the bond
naicBondInvestCharacteristicCode string Code for the investment characteristics for bonds, as specified by the NAIC
naicBondInvestCharacteristicDesc string Investment characteristics for the coupon payment(s) for bonds, as specified by the NAIC
naicCollateralTypeCode string(2) Predominant collateral type code
naicCollateralTypeDesc string(200) Predominant collateral type
naicCommonStockInvestCharacteristicCode string Code for the investment characteristics for common stock, as specified by the NAIC
naicCommonStockInvestCharacteristicDesc string Investment characteristics for common stock, as specified by the NAIC
naicForeignBondTypeCode string(1) Indicates whether a bond is either denominated in a foreign currency or issued by a foreign entity, using codes defined by the NAIC
naicForeignBondTypeDesc string(150) Indicates whether a bond is either denominated in a foreign currency or issued by a foreign entity
naicICOCollateralTypeCode string(2) Predominant collateral type code for issuer credit obligations
naicICOCollateralTypeDesc string(200) Predominant collateral type for issuer credit obligations
naicMortgageLoanStanding string(15) Status of the mortgage loan. This includes whether the mortgage is considered in good standing, overdue by 90 days, under restructure, or in foreclosure.
naicRealEstateInvestCharacteristicCode string Code for the investment characteristics for real estate, as specified by the NAIC
naicRealEstateInvestCharacteristicDesc string Investment characteristics for real estate, as specified by the NAIC
naicSchedule string(110) The NAIC schedule that the investment should be filed on, as determined by SNL
naicScheduleDelay boolean Indicates the schedule is filed late and thus should not be aggregated until all filers have submitted data.
parValue decimal{14,6} 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.
shortName string(30) Shortened version of the company's name
snlSecurityId long(-2147483648,2147483647)* The id field uniquely identifies the entity record.
statAssetBondChar string(255) Indicates any special circumstances with respect to the timing or amount of the coupon payment(s) for the bond. Only applicable for 2015 and prior.
statAssetCity string(40) City
statAssetDesc string(243) Description
statAssetDesignation 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.
statAssetForeignCode 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.
statAssetForeignCodeDesc string(75) Indicates whether a bond is either denominated in a foreign currency or issued by a foreign entity, based on information filed by insurers holding the majority of a given security.Only applicable for 2015 and prior.
statAssetInterestRate decimal{22,8} Interest Rate
statAssetLocation string(40) State, province, country, or other location of the asset or counterparty
statAssetType string(100) Describes the type of investment listed using categories defined by the National Association of Insurance Commissioners (NAIC)
statAssetTypeStrategy string(60) Identifies whether the investment is a private equity or hedge fund investment along with the strategy of the investment. This item is unique to Schedule BA filings.
statCollateralTypeCode string(42) Predominant collateral type code. Only applicable for 2016 and prior.
statCollateralTypeDesc string(410) Predominant collateral type. Only applicable for 2016 and prior.
statFairValueMethodCode string(1) Code representing the method indicated to determine the rate per share used in obtaining fair value
statFairValueMethodDesc string(100) Description of the method used by the reporting entity to determine the rate per share to be used in obtaining fair value
statFvMethodSource string(255) Source of the method indicated to determine the rate per share used in obtaining fair value
statIssuerType string(80) The issuer type of an asset as defined by the NAIC
statStateCode string(2) State abbreviation
statStateName string(30) The name of a U.S. state or territory
tradingSymbol string(20) Ticker, or trading symbol, of this security as used on the issue's primary securities exchange
60 rows of 60 total
API Open API Specification