Type SnlStatInvestmentTransactions
Type category Entity
Description snlStatInvestmentTransactions View
Fields
Name Type Filters Description
key id string(36)* = Unique ID to represent individual security
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
ciqCompanyId long(-2147483648,2147483647) Unique identifier assigned to a company
cusip string(9) Market identifier assigned by CUSIP bureau for a given security or an entity
excludeFromAdjustment boolean Indicates that the asset is excluded from adjustment calculation
federalTaxIDNumber string(10) The U.S. Internal Revenue Service uses the number to identify taxpayers that are required to file various business tax returns. EINs are used by employers, sole proprietors, corporations, partnerships, nonprofit associations, trusts, estates of decedents, government agencies, certain individuals, and other business entities.
institutionId long(-2147483648,2147483647) S&P's unique key to identify institutions. Institutions are corporations, partnerships, proprietorships, not-for-profit organizations, government agencies, and any other chartered organization.
insuranceStatRowNumber decimal{22,8} If the RowID of an insurance statutory form is a number, this field is the numerical value
isin string(12) Unique identifier used by the global capital markets
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
naic long(-2147483648,2147483647) 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
naicABSCollateralTypeCode string(2) Indicates any special circumstances with respect to the timing or amount of the coupon payment(s) for the bond
naicABSCollateralTypeDesc string(200) Predominant collateral type for asset backed securities
naicAlienId string(10) Alien Identification Number (AIN) assigned by the NAIC to risk-bearing entities for the purpose of identifying those who cede or assume reinsurance with a U.S. insurance company.
naicAssetCostOptionPrem decimal{22,8} Cost/Option Premium
naicAssetIntDueAcrdBonds decimal{22,8} Interest Due & Accrued on Bonds Not in Default
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 anyNAICBondInvestCharacteristicCode 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
naicBookExclAccruedInterest decimal{22,8} 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
naicChgbacvLessEncum decimal{22,8} Total change in book/adjusted carrying value less encumbrances
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
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
naicFxChgbacvLessEncum decimal{22,8} Foreign exchange change in book/adjusted carrying value less encumbrances
naicICOCollateralTypeCode string(2) Predominant collateral type code for issuer credit obligations
naicICOCollateralTypeDesc string(200) Predominant collateral type for issuer credit obligations
naicIntangLowerTier decimal{22,8} Goodwill at purchase of the stock of the lower-tier company, reduced by any subsequent impairment or write-off
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.
naicNonAdAssets decimal{22,8} Nonadmitted totals includes the sum of all assets in all lines reported. Excludes any valuation allowance. Nonadmitted assets are assets for which the state does not allow the company to take credit.
naicNonAdAssetsPrYr decimal{22,8} Prior year nonadmitted totals includes the sum of all assets in all lines reported. Excludes any valuation allowance. Prior year nonadmitted assets are assets for which the state does not allow the company to take credit.
naicNonAdInvestmentIncomeDue decimal{22,8} Nonadmitted investment income due and accrued is income earned on investments but not yet received. Excludes any valuation allowance. Nonadmitted assets are assets for which the state does not allow the company to take credit.
naicPaidAccruedInt decimal{22,8} Accrued interest acquired in the purchase of a short-term investment
naicPrYrBookAdjCarryValue decimal{22,8} Prior year Book Adjusted Carrying Value
naicPrYrBookLessEncumbances decimal{22,8} The prior year book value exclusive of encumbrances, such as mortgages or liens
naicPrYrBookValueExclAccInt decimal{22,8} The prior year book value exclusive of accrued interest
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
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
naicSchEcashEqAmtIntDueAccr decimal{22,8} Cash Equivalents: Amt of Interest Due and Accrued
naicSchEcashEquvBookAdjValue decimal{22,8} Cash Equivalents: Book, Adjusted Carrying Value
naicSchEcashEquvGrossInvInc decimal{22,8} Cash Equivalents: Gross Investment Income
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.
naicSub2VerifiedValuePrYr decimal{22,8} Total claimed value approved in the prior year's Sub-2 form submission with the NAIC
naicSubAffAssetValuePrYr decimal{22,8} Prior year book or adjusted carrying value of a parent, subsidiary or affiliated company assets held
naicSvoAdministrativeSymbol string(4) Administrative symbol as assigned by NAIC's Securities Valuation Office (SVO)
naicVisionFilingNumberPrYr string(12) Prior year NAIC vision filing number
naicubAffAssetValue decimal{22,8} Book or adjusted carrying value of a parent, subsidiary or affiliated company assets held
periodEndDate dateTime Ending date of the fiscal period, standardized to be the last day of the month in which the period ends. For example, if a fiscal period ends on June 29, this date will be June 30, so that there is a consistency among different companies.
propertyAppraisalDate dateTime Date at which property was last appraised or revalued
propertyAppraisalDateReport string(11) Date of last appraisal or valuation of the real estate.
link snlSecurityId SnlStatSecurity Security OID
statAffiliateType string(50) The type of affiliate for a company
statAssetAccretion decimal{22,8} Current year amortization of premium or accrual of discount up to the disposal date
statAssetAcquireDate dateTime Date Acquired
statAssetAcquireDateReported string(11) Date Acquired, As Reported
statAssetActualCost decimal{22,8} Cost of acquiring the bond including broker commission and other related fees, excluding accrued interest and dividends
statAssetAddInvestAftrAcqu decimal{22,8} Amount expended for additions and permanent improvement, excluding amounts expended for original acquisitions
statAssetAdditionalInv decimal{22,8} The additional cost of assets acquired, including the principal, broker's commission and incidental expense of effecting delivery
statAssetAgencySJState string(100) Name of the agency, sovereign jurisdiction, state or other location that has issued the security
statAssetAggDeferredInt decimal{22,8} Interest payments that are postponed beyond the scheduled payment date without being considered overdue, including interest reported as due and accrued but not received within 90 days which also covers all accrued interest for investments that pay interest less frequently than annually, as specified in the agreement terms
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.
statAssetBondInterest decimal{22,8} The amount of distributions received in cash or reinvested in additional shares
statAssetBookValueChange decimal{22,8} Change in carrying value which can result from an unrealized valuation increase or decrease, a accrual of discount or amortization of premium, or as a result of an other than temporary impairment
statAssetCapDeferredInt decimal{22,8} Interest and other items that can be capitalized
statAssetCarryValLessEncPy decimal{22,8} Fair value of the investment including the effect of foreign currency translations and accrued interest, net of encumbrances
statAssetCarryValue decimal{22,8} Fair value of the investment including the effect of foreign currency translations and accrued interest
statAssetCarryValueLessEnc decimal{22,8} Fair value of the investment including the effect of foreign currency translations and accrued interest, net of encumbrances
statAssetCity string(40) City
statAssetCode string(10) Describes characteristics of investments not under the exclusive control of the insurer
statAssetCodeDesc string(150) Code description
statAssetConsideration decimal{22,8} Total proceeds received at time of sale, including broker commission and delivery expense, but excluding accrued interest and dividends
statAssetCumDivUndeclared decimal{22,8} Undeclared cumulative dividends, including any additional interest accumulated
statAssetCurExpPayoffDateAR string(11) Current expected pay-off date resulting from estimated cash flows and prepayment assumptions, as reported
statAssetCurExpdPayoffDate dateTime Current expected pay-off date resulting from estimated cash flows and prepayment assumptions
statAssetCurOvercollatrliz decimal{22,8} Percent of the total value of collateral held to the total value of the outstanding obligations or liabilities
statAssetCyChngEncumb decimal{22,8} Decreases in encumbrances reported on real estate
statAssetCyDepAmortAccret decimal{22,8} Depreciation expense for the period, amortization of premium and the accrual of discount. The accrual of discount amounts are reported as increases to investment income in the Exhibit of Net Investment Income, while the amortization of premium amounts are to be reported as decreases to investment income.
statAssetCyDepreciation decimal{22,8} Depreciation expense for the period and shall include any depreciation recorded on a property held for sale, including depreciation that was recorded on property during the current year that was later classified as property held for sale
statAssetDesc string(243) Description
statAssetDescCompare string(240) A version of FinlStatAssetDesc used for comparing
statAssetDescParent string(40) Parent 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.
statAssetDispDateReported string(11) Disposal Date, As Reported
statAssetDisposalGain decimal{22,8} Total gain on an investment
statAssetDisposeDate dateTime The trade date for public securities and the funding date for private placements. In cases where multiple issues of the same security are disposed, the last date of disposal.
statAssetDivNonAdUnpaid decimal{22,8} 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.
statAssetDivReceived decimal{22,8} Dividends received
statAssetDivUnpaid decimal{22,8} 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{22,8} 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.
statAssetExchangeChange decimal{22,8} Changes in book value resulting from changes in foreign exchange rates
statAssetExchangeGain decimal{22,8} Total gain on an investment due to change in foreign exchange rate between the time a security is acquired and disposed
statAssetExpensesIncurred decimal{22,8} Amounts paid or accrued for taxes, repairs and other related expenses. Does not include interest incurred on encumbrances.
statAssetFairValue decimal{22,8} 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.
statAssetFairValueLessEn decimal{22,8} The fair value of the property less encumbrances
statAssetFairValueRate decimal{22,8} Fair value of an investment on a per-unit basis
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.
statAssetGrossLessEncum decimal{22,8} Gross Income Earned Less Interest Incurred on Encumbrances. Includes rental income on Home Office property.
statAssetId string(11) ID
statAssetImpairment decimal{22,8} Current year amount of non temporary write-down recognized by the company
statAssetIncludeIntangible string(3) Include Intangible Assets, As Reported? Only applicable for 2020 and prior.
statAssetIntAccPaid decimal{22,8} The amount of dividends associated with shares acquired between the dividend declaration date and ex-dividend date
statAssetIntIncDueAcc decimal{22,8} Interest income earned and legally due to be paid to the reporting entity as of the reporting date (interest due) plus interest income earned as of the reporting date but not legally due to be paid to the reporting entity until subsequent to the reporting date (interest accrued)
statAssetIntangible decimal{22,8} Goodwill included in carrying value of the stock of one or more lower-tier companies controlled by the subsidiary or affiliated company
statAssetInterest decimal{22,8} Gross amount of interest or dividends received
statAssetInterestDueAccru decimal{22,8} Interest on admitted assets that has been accrued as interest receivable
statAssetInterestRate decimal{22,8} Interest Rate
statAssetInterestRateEff decimal{22,8} 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{22,8} 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.
statAssetLocation string(40) State, province, country, or other location of the asset or counterparty
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.
statAssetMatureDate dateTime Date the bond matures. 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.
statAssetOrgExpPayoffDateAR string(11) Expected pay-off date at the time of original acquisition, as reported
statAssetOrgExpdPayoffDate dateTime Expected pay-off date at the time of original acquisition
statAssetOrignBalloonPymt decimal{22,8} Balloon payment due at maturity as percent of the original outstanding principal value
statAssetOrignOvercollatrliz decimal{22,8} Percent of collateral pledged at the time of asset origination to the total value of the underlying assets
statAssetPIKInt decimal{22,8} Paid in kind (PIK) interest included in the current principal balance
statAssetParValue decimal{22,8} The face value of a bond, excluding interest only bonds which have no face value
statAssetParValueShare decimal{22,8} 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
statAssetPostalCode string(300) Domestic or foreign postal code that reflects the location of the underlying property. Multiple postal codes may be reported, separated by commas from highest to lowest value, if more than one applies.
statAssetPurchaser string(40) The entity to whom the investment was sold or a description of how the investment was disposed
statAssetPurpose string(70) The purpose for holding an asset as reported to the NAIC by an insurance company
statAssetPymtDueMaturity decimal{22,8} Final principal payment including balloon payments as well as interest to be paid at maturity
statAssetRateShare decimal{22,8} Rate per share
statAssetReExpended decimal{22,8} Amounts expended for additions and permanent improvements, including and changes in encumbrances. Only those amounts expended after acquiring title are included.
statAssetReRevenue decimal{22,8} Amounts received on sale of rights and privileges, amounts from real estate sales where title has not transferred, except those received in the year of disposal, and other cash receipts that reduce the book value.
statAssetReValue decimal{22,8} 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.
statAssetRealizedGain decimal{22,8} Total gain on an investment, excluding any gain due to change in foreign exchange rate between the time a security is acquired and disposed
statAssetSharesOwned decimal{22,8} The number of shares the filer owns of an individual investment
statAssetStatus string(20) The state of an asset as reported to the NAIC
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.
statAssetUnrealizedValue decimal{22,8} Reflects any current year change in fair value for those securities carried at fair value. In situations where a security was carried at amortized cost in prior year and fair value in current year, this item reflects the difference between amortized cost and fair value at year-end.
statAssetValuationMethod string(7) Valuation Method
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
statAsstIntReceiveDurYear decimal{22,8} Interest cash and paid-in-kind (PIK) received during the year
statCallDate dateTime The call date used to calculate the effective date of maturity
statCallDateReport string(11) The call date used to calculate the effective date of maturity
statCallPrice decimal{22,8} 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.
statEffDateMatReported string(11) The maturity date producing the lowest amortized value if the bond 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.
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.
statEntityId string(20) S&P's unique key to identify institutions that file U.S. statutory financials with the NAIC
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
statFileName string(8) Insurance Stat Table Name
statFvMethodSource string(255) Source of the method indicated to determine the rate per share used in obtaining fair value
statIndirectPercentOwned decimal{6,3} Percentage of stock in Lower-Tier Company Owned Indirectly by Insurer on Statement Date
statIndirectSharesOwned decimal{22,8} Stock in Lower-Tier Company Owned Indirectly by Insurer on Statement Date
statInvTransactionsId string(36) Unique ID to represent individual security
statInvestmentIncome decimal{22,8} Interest, dividend, and other investment income received during year excluding distributions of investment during year
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
181 rows of 181 total
API Open API Specification