| 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 |
|
crin |
string(10) |
|
The NAIC uses the number in lieu of the FEIN or Alien Insurer Identification Number to report transactions with certified reinsurers. The classification of a reinsurer as Certified applies on a prospective basis and is determined by the ceding insurer�s domiciliary state. |
|
cusip |
string(9) |
|
Market identifier assigned by CUSIP bureau for a given security or an entity |
|
dateendedstandard |
date |
|
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. |
|
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. |
|
finlstatassetaccretion |
long |
|
Current year amortization of premium or accrual of discount up to the disposal date |
|
finlstatassetacquiredate |
date |
|
Date Acquired |
|
finlstatassetacquiredatereport |
string(11) |
|
Date Acquired, As Reported |
|
finlstatassetactualcost |
long |
|
Cost of acquiring the bond including broker commission and other related fees, excluding accrued interest and dividends |
|
finlstatassetaddinvestaftracqu |
long |
|
Amount expended for additions and permanent improvement, excluding amounts expended for original acquisitions |
|
finlstatassetadditionalinv |
long |
|
The additional cost of assets acquired, including the principal, broker�s commission and incidental expense of effecting delivery |
|
finlstatassetbondinterest |
long |
|
The amount of distributions received in cash or reinvested in additional shares |
|
finlstatassetbookvaluechange |
long |
|
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 |
|
finlstatassetcapdeferredint |
long |
|
Interest and other items that can be capitalized |
|
finlstatassetcarryvallessencpy |
long |
|
Fair value of the investment including the effect of foreign currency translations and accrued interest, net of encumbrances |
|
finlstatassetcarryvalue |
long |
|
Fair value of the investment including the effect of foreign currency translations and accrued interest |
|
finlstatassetcarryvaluelessenc |
long |
|
Fair value of the investment including the effect of foreign currency translations and accrued interest, net of encumbrances |
|
finlstatassetcity |
string(40) |
|
City |
|
finlstatassetconsideration |
long |
|
Total proceeds received at time of sale, including broker commission and delivery expense, but excluding accrued interest and dividends |
|
finlstatassetcychngencumb |
long |
|
Decreases in encumbrances reported on real estate |
|
finlstatassetcydepamortaccret |
long |
|
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. |
|
finlstatassetcydepreciation |
long |
|
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 |
|
finlstatassetdesc |
string(243) |
|
Description |
|
finlstatassetdesccompare |
string(240) |
|
A version of FinlStatAssetDesc used for comparing |
|
finlstatassetdescparent |
string(40) |
|
Parent 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. |
|
finlstatassetdisposalgain |
long |
|
Total gain on an investment |
|
finlstatassetdisposedate |
date |
|
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. |
|
finlstatassetdisposedatereport |
string(11) |
|
Disposal Date, As Reported |
|
finlstatassetdivnonadunpaid |
long |
|
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. |
|
finlstatassetdivreceived |
long |
|
Dividends received |
|
finlstatassetdivunpaid |
long |
|
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. |
|
finlstatassetencumbrances |
long |
|
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. |
|
finlstatassetexchangechange |
long |
|
Changes in book value resulting from changes in foreign exchange rates |
|
finlstatassetexchangegain |
long |
|
Total gain on an investment due to change in foreign exchange rate between the time a security is acquired and disposed |
|
finlstatassetexpensesincurred |
long |
|
Amounts paid or accrued for taxes, repairs and other related expenses. Does not include interest incurred on encumbrances. |
|
finlstatassetfairvalue |
long |
|
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. |
|
finlstatassetfairvaluelessen |
long |
|
The fair value of the property less encumbrances |
|
finlstatassetfairvaluerate |
long |
|
Fair value of an investment on a per-unit basis |
|
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. |
|
finlstatassetgrosslessencum |
long |
|
Gross Income Earned Less Interest Incurred on Encumbrances. Includes rental income on Home Office property. |
|
finlstatassetid |
string(11) |
|
ID |
|
finlstatassetimpairment |
long |
|
Current year amount of non temporary write-down recognized by the company |
|
finlstatassetincludeintangible |
string(3) |
|
Include Intangible Assets, As Reported? Only applicable for 2020 and prior. |
|
finlstatassetintaccpaid |
long |
|
The amount of dividends associated with shares acquired between the dividend declaration date and ex-dividend date |
|
finlstatassetintangible |
long |
|
Goodwill included in carrying value of the stock of one or more lower-tier companies controlled by the subsidiary or affiliated company |
|
finlstatassetinterest |
long |
|
Gross amount of interest or dividends received |
|
finlstatassetinterestdueaccru |
long |
|
Interest on admitted assets that has been accrued as interest receivable |
|
finlstatassetinterestrate |
long |
|
Interest Rate |
|
finlstatassetinterestrateeff |
long |
|
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. |
|
finlstatassetinvestmentcommit |
long |
|
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 |
|
finlstatassetloannumber |
string(15) |
|
The mortgage loan number assigned by the reporting entity. For foreign denominated mortgages, indicate the principal indebtedness amount in its local currency. |
|
finlstatassetmarket |
string(7) |
|
NAIC Market Designation |
|
finlstatassetmaturedate |
date |
|
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. |
|
finlstatassetmaturedatereport |
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. |
|
finlstatassetparvalue |
long |
|
The face value of a bond, excluding interest only bonds which have no face value |
|
finlstatassetparvalueshare |
long |
|
Par Value Per Share |
|
finlstatassetpaymentmethod |
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 |
|
finlstatassetpercentout |
long |
|
Shares owned as a percent of shares outstanding |
|
finlstatassetpostalcode |
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. |
|
finlstatassetpurchaser |
string(40) |
|
The entity to whom the investment was sold or a description of how the investment was disposed |
|
finlstatassetrateshare |
long |
|
Rate per share |
|
finlstatassetrealizedgain |
long |
|
Total gain on an investment, excluding any gain due to change in foreign exchange rate between the time a security is acquired and disposed |
|
finlstatassetreexpended |
long |
|
Amounts expended for additions and permanent improvements, including and changes in encumbrances. Only those amounts expended after acquiring title are included. |
|
finlstatassetrerevenue |
long |
|
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. |
|
finlstatassetrevalue |
long |
|
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. |
|
finlstatassetsharesowned |
long |
|
The number of shares the filer owns of an individual investment |
|
finlstatassetstate |
string(40) |
|
State, province, country, or other location of the asset or counterparty |
|
finlstatassetstatuscode |
string(5) |
|
Describes characteristics of investments not under the exclusive control of the insurer. Only applicable for 2016 and prior. |
|
finlstatassetunrealizedvalue |
long |
|
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. |
|
finlstatassetvaluationmethod |
string(7) |
|
Valuation Method |
|
finlstatassetvendor |
string(40) |
|
Vendor or General Partner |
|
finlstatcalldate |
date |
|
The call date used to calculate the effective date of maturity |
|
finlstatcalldatereport |
string(11) |
|
The call date used to calculate the effective date of maturity |
|
finlstatcallprice |
long |
|
The call price used to calculate the effective date of maturity |
|
finlstateffdatematurityreport |
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. |
|
finlstateffectivedatematurity |
date |
|
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. |
|
finlstatfvmethodsource |
string(255) |
|
Source of the method indicated to determine the rate per share used in obtaining fair value |
|
finlstatindirecpercentout |
long |
|
Percentage of stock in Lower-Tier Company Owned Indirectly by Insurer on Statement Date |
|
finlstatindirectsharesowned |
long |
|
Stock in Lower-Tier Company Owned Indirectly by Insurer on Statement Date |
|
finlstatinvestmentincome |
long |
|
Interest, dividend, and other investment income received during year excluding distributions of investment during year |
|
insurancestatfilename |
string(8) |
|
Insurance Stat Table Name |
|
insurancestatrownumber |
long |
|
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 |
|
keyfinlstataffiliatetype |
long |
|
OID of Affiliate Type |
|
keyfinlstatasset |
string |
|
Unique ID to represent individual security |
|
keyfinlstatassetbondchar |
long |
|
Bond Char. Only applicable for 2015 and prior. |
|
keyfinlstatassetissuertype |
long |
|
Key of issuer type |
|
keyfinlstatassetloantype |
string(1) |
|
OID of Finl Stat Asset Loan Type |
|
keyfinlstatassetpurpose |
long |
|
OID of Asset Purpose |
|
keyfinlstatassetstatuscodelong |
long |
|
Finl Stat Asset Status Code Long OID |
|
keyfinlstatassettype |
long |
|
OID of Finl Stat Asset Type |
|
keyfinlstatcollateraltype |
long |
|
Finl Stat Collateral Type OID |
|
keyfinlstatfairvaluemethod |
long |
|
Finl Stat Fair Value Method OID |
|
keyfinlstatpropertytype |
long |
|
Finl Stat Property Type OID |
|
keyfinlstatstate |
long |
|
Finl Stat State OID |
|
keyinstn |
long |
|
S&P's unique key to identify institutions. Institutions are corporations, partnerships, proprietorships, not-for-profit organizations, government agencies, and any other chartered organization. |
|
keynaiccapitaltype |
long |
|
N A I C Capital Type 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 |
|
keynaicrelatedparty |
long |
|
N A I C Related Parties OID |
|
keysecurity |
long |
|
Security OID |
|
keystatassetstate |
long |
|
The state of the reported asset |
|
keystatassettypestrategy |
long |
|
OID of KeyStatAssetTypeStrategy |
|
keystatassetvaluationmethod |
long |
|
Stat Asset Valuation Method OID |
|
keystatentity |
string |
|
Stat Entity OID |
|
keystatfairvaluelevel |
long |
|
Stat Fair Value Level OID |
|
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 |
|
masknaicbondcharacteristic |
long |
|
Mask of NAIC Bond Characteristic |
|
naic |
long |
|
ID used by the National Association of Insurance Commissioners to identify insurance companies |
|
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 |
long |
|
Cost/Option Premium |
|
naicassetintdueacrdbonds |
long |
|
Interest Due & Accrued on Bonds Not in Default |
|
naicbookexclaccruedinterest |
long |
|
Mortgage Loan Book Value excl Accrued Interest |
|
naicchgbacvlessencum |
long |
|
Total change in book/adjusted carrying value less encumbrances |
|
naiccode |
string(11) |
|
ID used by the National Association of Insurance Commissioners to identify insurance companies |
|
naicdesignation |
long |
|
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 |
long |
|
Foreign exchange change in book/adjusted carrying value less encumbrances |
|
naicintanglowertier |
long |
|
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 |
|
naicnonadassets |
long |
|
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 |
long |
|
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 |
long |
|
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 |
long |
|
Accrued interest acquired in the purchase of a short-term investment |
|
naicpryrbookadjcarryvalue |
long |
|
Prior year Book Adjusted Carrying Value |
|
naicpryrbooklessencumbances |
long |
|
The prior year book value exclusive of encumbrances, such as mortgages or liens |
|
naicpryrbookvalueexcluacruint |
long |
|
The prior year book value exclusive of accrued interest |
|
naicschecashequvamtintdueacrud |
long |
|
Cash Equivalents: Amt of Interest Due and Accrued |
|
naicschecashequvbookadjvalue |
long |
|
Cash Equivalents: Book, Adjusted Carrying Value |
|
naicschecashequvgrossinvinc |
long |
|
Cash Equivalents: Gross Investment Income |
|
naicsub2verifiedvaluepryr |
long |
|
Total claimed value approved in the prior year's Sub-2 form submission with the NAIC |
|
naicsubaffassetvalue |
long |
|
Book or adjusted carrying value of a parent, subsidiary or affiliated company assets held |
|
naicsubaffassetvaluepryr |
long |
|
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 |
|
propertyappraisaldate |
date |
|
Date at which property was last appraised or revalued |
|
propertyappraisaldatereport |
string(11) |
|
Date of last appraisal or valuation of the real estate. |
|
rjin |
string(11) |
|
A unique identifier used for reporting transactions with a reciprocal jurisdiction reinsurer as listed in the NAIC listing of companies |
|
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. |