Type SnlStatInvestmentHolding
Type category Entity
Description SnlStatInvestmentHolding View
Fields
Name Type Filters Description
key id string(36)* = Stat Investment Holding OID
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.
cusipReported string(9) As reported unique identifier of insurance securities, as provided by the CUSIP Service Bureau, which is operated by Standard & Poor's for the American Bankers Association
dataSourcePeriod string(6) Together with the KeyInstn and the restatement status, completes the unique key used to identify a financial period within the DataSource. Concatenation of the Fiscal Year and Fiscal Period values, or, for derived periods, may be 'LTM' or some other designation.
isinReported string(12) As reported international code used to uniquely identify securities internationally pursuant to ISO 6166
legalEntityId string(20) Legal Entity Identifier (LEI) is a reference code that uniquely identifies legally distinct entities that engage in financial transactions and associated reference data, based on the ISO 17442 standard
naicBondCharacteristicCode string(1) 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(255) Indicates any special circumstances with respect to the timing or amount of the coupon payment(s) for the bond
naicBookExclAccruedInterest decimal Mortgage Loan Book Value excl Accrued Interest
naicCapitalType string(35) Capital structure of securities, as reported on investment schedules under SVO Notching Guidelines, Part 1 Section 3 of the Purposes and Procedures Manual of the NAIC Investments Analysis Office
naicCollateralTypeCode string(2) Predominant collateral type code
naicCollateralTypeDesc string(200) Predominant collateral type
naicDesignation long(0,255) The National Association of Insurance Commissioners (NAIC) quality rating of bonds and stocks
naicDesignationCategory string(2) The combination of NAIC designation and NAIC designation modifier to relate more granular delineations of credit risk in insurer owned securities
naicDesignationModifier string(1) A more granular measure of credit risk within the NAIC designation
naicDesignationModifrSvoAdmin string(10) The national association of insurance commissioners (NAIC) quality rating of bonds and stocks. The securities designated 1 are the highest quality and 6 the lowest quality. Modifier indicates a more granular measure of credit risk within the NAIC Designation grade. Each delineation of credit risk is represented by a letter. Administrative symbol as assigned by NAIC's securities valuation office (SVO).
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
naicIssueName string(100) Name of the held security, as reported on investment schedules by the filing entity
naicIssuerName string(100) Name of the issuer of a held security, as reported on investment schedules by the filing entity
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.
naicRelatedPartyDesc string(500) Description of the code that reflects investment interactions involving related parties, regardless of whether the related party meets the affiliate definition, or the reporting entity has received domiciliary state approval to disclaim control or affiliation
naicSVOAdministrativeSymbol string(4) Administrative symbol as assigned by NAIC's Securities Valuation Office (SVO)
periodEndDate dateTime* Date as of which the statutory insurance data is reported
propertyAppraisalDate dateTime Date at which property was last appraised or revalued
statAssetActualCost decimal Cost of acquiring the bond including broker commission and other related fees, excluding accrued interest and dividends
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.
statAssetBookValue decimal Book value of the investment
statAssetBookValueLessEnc decimal Book value of the investment net of encumbrances
statAssetCarryValue decimal Fair value of the investment including the effect of foreign currency translations and accrued interest
statAssetCarryValueLessEnc decimal Fair value of the investment including the effect of foreign currency translations and accrued interest, net of encumbrances
statAssetCode string(10)* Describes characteristics of investments not under the exclusive control of the insurer
statAssetCodeDesc string(150)* Code 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.
statAssetDivNonAdUnpaid decimal Dividends declared by issuer that have not yet been paid on nonadmitted assets. May be negative in cases where the company sold holdings and needs to adjust the amount to account for such sales.
statAssetDivUnpaid decimal Dividends declared by issuer that have not yet been paid. May be negative in cases where the company sold holdings and needs to adjust the value to account for such sales.
statAssetEncumbrances decimal The amount of outstanding debt secured by the investment. This includes the insurer's portion of all encumbrances incurred by a partnership or joint venture.
statAssetFairValue decimal Fair value for year-end periods is as reported. Fair value for quarterly periods is a hybrid of the reported year-end fair value, adding the actual cost or subtracting the consideration received for any purchases or sales during the year-to-date period. Because investment detail balances are not reported on a quarterly basis, this item on a quarterly basis is meant as a general size indicator only.
statAssetFairValueRate decimal Fair value of an investment on a per-unit basis
statAssetFairValueRateAr decimal Fair value of an investment on a per-unit basis, as reported by filer
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.
statAssetInterestDueAccru decimal Interest on admitted assets that has been accrued as interest receivable
statAssetInterestRate decimal Interest Rate
statAssetInterestRateEff decimal Represents the discount rate used to discount the future interest and principal receipts back to original cost. The rate reflected here should be adjusted when an other than temporary impairment has been recognized.
statAssetInvestmentCommit decimal Amount of additional commitments, not yet invested, where the decision when and whether to invest is not made by the investor, but by someone else, typically by the hedge fund or limited partnership
statAssetLoanNumber string(15) The mortgage loan number assigned by the reporting entity. For foreign denominated mortgages, indicate the principal indebtedness amount in its local currency.
statAssetLoanType string(100)* E if the loan was made to an officer or director of the reporting entity/subsidiary/affiliate. "S" if the loan was made directly to a subsidiary or affiliate. "R" if the loan was made to a related party that doesn�t meet the affiliate definition. Otherwise, blank.
statAssetMatDateReported string(11) Date the asset matures, as contractually stated. On bonds purchased at a premium, the maturity date producing the lowest amortized value is reported. For Class One Bond Mutual Funds and Exchange Traded Funds, filers report 01/01/YYYY where YYYY is equal to current year + 2.
statAssetParValue decimal The face value of a bond, excluding interest only bonds which have no face value
statAssetParValueShare decimal Par Value Per Share
statAssetPaymentMethod string(4) Indicates when interest will be paid on the investment. This field will report the first three letters of the month in which interest is paid if the interest is paid annually. It will report the first letter of each month that interest is paid if it is paid semi-annually. If interest is paid quarterly, the first letter of the month in which each payment occurs will be reported. If interest is paid monthly an entry of "MON" will be reported. If interest is paid at maturity an entry of "MAT" will be reported.
statAssetPercentOut decimal{6,3} Shares owned as a percent of shares outstanding
statAssetRateShare decimal Rate per share
statAssetReValue decimal The appraisal value of the property (for land and buildings). For loans subject to a participation agreement, only the reporting entity�s pro rata share of the appraised value as it relates to the reporting entity�s interest in the mortgage loan is included.
statAssetSharesOwned decimal The number of shares the filer owns of an individual investment
statAssetStatusCode string(5) Describes characteristics of investments not under the exclusive control of the insurer. Only applicable for 2016 and prior.
statAssetStatusCodeDesc string(150) Describes characteristics of investments not under the exclusive control of the insurer. Only applicable for 2016 and prior.
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.
statAssetValuationMethodCode string(1) Code reported in the NAIC data corresponding to the valuation method used
statAssetValuationMethodDesc string(30) Description of valuation method used
statAssetVendor string(40) Vendor or General Partner
statCallDate dateTime The call date used to calculate the effective date of maturity
statCallPrice decimal The call price used to calculate the effective date of maturity
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.
statEffectiveDateMaturity dateTime The maturity date producing the lowest amortized value if the asset was purchased at a premium. For loan backed and structured securities, this would include the effective date of maturity that results from the estimated cash flows, incorporating appropriate prepayment assumptions.
statFairValueLevelCode string(1) Classification level code of security, carried at fair value, used by the reporting entity
statFairValueLevelDesc string(10) Classification level of security, carried at fair value, used by the reporting entity
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
link statInvestmentId SnlStatInvestment S&P's unique key to identify company investments
statIssuerType string(80) The issuer type of an asset as defined by the NAIC
statPropertyType string(30) Property type for the reported asset
statStateCode string(2) State abbreviation
statStateName string(30) The name of a U.S. state or territory
updDate dateTime* Last modification date and time of a physical row
80 rows of 80 total
API Open API Specification