| key |
id |
string(36)* |
= |
Stat Investment Holding Unique Identifier |
|
affiliateInvestment |
boolean* |
|
Indicates that the investment is in a parent, subsidiary, or affiliate |
|
annualization |
decimal{22,8} |
|
Number by which flow financial items need to be multiplied to get an annualized figure |
| 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. |
|
ciqCompanyId |
long(-2147483648,2147483647) |
|
Unique identifier assigned to a company |
|
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. |
|
dateBegun |
dateTime |
|
Date on which fiscal period began |
|
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. |
|
isinReported |
string(12) |
|
As reported international code used to uniquely identify securities internationally pursuant to ISO 6166 |
|
latestInvestmentDate |
dateTime |
|
The most recent date on which the owner made additional investment in the security, or the date of initial investment if no additional investments have been made |
|
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 |
|
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 |
|
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). |
|
naicFXChgBACVLessEncum |
decimal{22,8} |
|
Foreign exchange change in book/adjusted carrying value less encumbrances |
|
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 |
|
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. |
|
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 |
|
naicSVOAdministrativeSymbol |
string(4) |
|
Administrative symbol as assigned by NAIC's Securities Valuation Office (SVO) |
|
originalInvestmentDate |
dateTime |
|
Date on which the owner made the initial investment in the security |
|
periodEndDate |
dateTime |
|
Date as of which the statutory insurance data is reported |
|
privatePlacementSecurity |
boolean |
|
Indicates that the security is a private placement. Private placement securities, which do not fall under the category of 144A securities, are identified by their private placement numbers (PPN). |
|
propertyAppraisalDate |
dateTime |
|
Date at which property was last appraised or revalued |
| link |
snlSecurityId |
SnlStatSecurity |
|
Security Unique Identifier |
|
spStatEntityId |
string(36)* |
|
Unique identifier for each Statutory entity |
|
statAssetAccretion |
decimal{22,8} |
|
Current year amortization of premium or accrual of discount up to the disposal date |
|
statAssetActualCost |
decimal{22,8} |
|
Cost of acquiring the bond including broker commission and other related fees, excluding accrued interest and dividends |
|
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. |
|
statAssetBookValue |
decimal{22,8} |
|
Book value of the investment |
|
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 |
|
statAssetBookValueLessEnc |
decimal{22,8} |
|
Book value of the investment net of encumbrances |
|
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 |
|
statAssetCapDeferredInt |
decimal{22,8} |
|
Interest and other items that can be capitalized |
|
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 |
|
statAssetCode |
string(10) |
|
Describes characteristics of investments not under the exclusive control of the insurer |
|
statAssetCodeDesc |
string(150) |
|
Code description |
|
statAssetCumDivUndeclared |
decimal{22,8} |
|
Undeclared cumulative dividends, including any additional interest accumulated |
|
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 |
|
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{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. |
|
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 |
|
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. |
|
statAssetFairValueRate |
decimal{25,8} |
|
Fair value of an investment on a per-unit basis |
|
statAssetFairValueRateAr |
decimal{22,8} |
|
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. |
|
statAssetImpairment |
decimal{22,8} |
|
Current year amount of non temporary write-down recognized by the company |
|
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) |
|
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. |
|
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. |
|
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. |
|
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 |
|
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. |
|
statAssetSharesOwned |
decimal{25,8} |
|
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. |
|
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. |
|
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 |
|
statCallDateMWCallProv |
date |
|
The expected call date for securities with a make-whole call provision. If the issuer is not expected to invoke the provision, indicate 'make-whole' instead. |
|
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. |
|
statCurOvrcollatFVAdjCL |
decimal{22,8} |
|
The percent of overcollateralization, calculated by comparing the fair value of the collateral to the book or adjusted carrying value of the collateral loans. Magnitude: (%) |
|
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(36)* |
|
S&P's unique key to identify institutions that file U.S. statutory financials with the NAIC. |
|
statFVCollBackingCollLoan |
decimal{22,8} |
|
The estimated market value of assets pledged as collateral for loans. This reflects the value that could be obtained from selling the collateral in a normal market transaction. Magnitude: ($) |
|
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 |
|
statInvestmentCurrent |
boolean* |
|
Indicates that the investment is currently being held |
|
statInvestmentHoldingFinlId |
string(36) |
|
Stat Investment Holding Finl Unique Identifier |
|
statInvestmentHoldingId |
string(36)* |
|
Stat Investment Holding Unique Identifier |
|
statInvestmentId |
string(36)* |
|
S&P's unique key to identify company investments |
|
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 |