| 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 |
|
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. |
|
finlstatassetactualcost |
long |
|
Cost of acquiring the bond including broker commission and other related fees, excluding accrued interest and dividends |
|
finlstatassetbookvalue |
long |
|
Book value of the investment |
|
finlstatassetbookvaluelessenc |
long |
|
Book value of the investment 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 |
|
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. |
|
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. |
|
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. |
|
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. |
|
finlstatassetfairvaluerate |
long |
|
Fair value of an investment on a per-unit basis |
|
finlstatassetfairvalueratear |
long |
|
Fair value of an investment on a per-unit basis, as reported by filer |
|
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. |
|
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. |
|
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 |
|
finlstatassetrateshare |
long |
|
Rate per share |
|
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 |
|
finlstatassetstatuscode |
string(5) |
|
Describes characteristics of investments not under the exclusive control of the insurer. Only applicable for 2016 and prior. |
|
finlstatassetvendor |
string(40) |
|
Vendor or General Partner |
|
finlstatcalldate |
date |
|
The call date used to calculate the effective date of maturity |
|
finlstatcallprice |
long |
|
The call price used to calculate the effective date of maturity |
|
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 |
|
insurancestatreporteddate |
date |
|
Date as of which the statutory insurance data is reported |
|
isinreported |
string(12) |
|
As reported international code used to uniquely identify securities internationally pursuant to ISO 6166 |
|
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 |
|
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 |
|
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 |
|
keystatassettypestrategy |
long |
|
OID of KeyStatAssetTypeStrategy |
|
keystatassetvaluationmethod |
long |
|
Stat Asset Valuation Method OID |
|
keystatfairvaluelevel |
long |
|
Stat Fair Value Level OID |
|
keystatinvestment |
string |
|
S&P's unique key to identify company investments |
|
keystatinvestmentholding |
string |
|
Stat Investment Holding 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 |
|
naicbookexclaccruedinterest |
long |
|
Mortgage Loan Book Value excl Accrued Interest |
|
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). |
|
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 |
|
naicsvoadministrativesymbol |
string(4) |
|
Administrative symbol as assigned by NAIC's Securities Valuation Office (SVO) |
|
propertyappraisaldate |
date |
|
Date at which property was last appraised or revalued |
|
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. |