| key |
id |
string(36)* |
= |
unique id |
| 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 |
|
cusip |
string(9) |
|
Market identifier assigned by CUSIP bureau for a given security or an entity |
|
cusipIssueNumber |
string(2) |
|
CUSIP Issue Number as reported by the CUSIP Service Bureau, operated by Standard Poor's |
|
cusipIssuePreferredType |
string(50) |
|
Describes the type of preferred stock issued |
|
cusipIssuePutableDesc |
string(50) |
|
Describes the puttable policy of the bond |
|
cusipIssueRateTypeDesc |
string(50) |
|
Describes the interest payment methodology of the security |
|
cusipIssuerName |
string(120) |
|
CUSIP Issuer Name |
|
cusipIssuerTypeDesc |
string(30) |
|
Description of issuer type, as reported by the CUSIP Service Bureau, operated by Standard and Poor's. |
|
divRate |
decimal{7,4} |
|
Stated annual dividend rate or interest coupon of a fixed-rate issue, or effective rate of a variable-rate issue during the period indicated |
|
isin |
string(12) |
|
Unique identifier used by the global capital markets |
|
issueBondCounsel |
string(60) |
|
Firm that prepares the legal opinion for the issuance of a bond |
|
issueCallableAttributeOption |
string(1) |
|
A security where the issuer has the right to redeem the security prior to maturity |
|
issueFinancialAdvisor |
string(60) |
|
Firm that advises issuer on the issuance of a security |
|
issueUnderwriter |
string(60) |
|
Firm that administers the public issuance and distribution of securities |
|
maturityDt |
dateTime |
|
The maturity date of debt securities, or the date on which the security must be redeemed by the issuer or otherwise repaid by the borrower |
|
mbsPoolPrefix |
string(3) |
|
Helps distinguish the types of mortgages pooled into that security. All individual mortgages are assigned a pool serial number, which is shared with the individual security issue. This field is an attribute of that serial number. |
|
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 |
|
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 |
|
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 |
|
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 |
|
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. |
|
parValue |
decimal{14,6} |
|
Can be expressed as a percent or a monetary value. Conventional debt issues are shown as a relative percent of the net offering proceeds that are assigned to the equity account, rather than to paid-in capital where the par value provides a starting basis for pricing or trading the issue. For non-conventional debt issues, such as corporate units, monetary amounts are displayed representing the face value of the security. For these securities, par value represents the stated value of the issue. |
|
shortName |
string(30) |
|
Shortened version of the company's name |
|
snlSecurityId |
long(-2147483648,2147483647)* |
|
The id field uniquely identifies the entity record. |
|
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. |
|
statAssetCity |
string(40) |
|
City |
|
statAssetDesc |
string(243) |
|
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. |
|
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. |
|
statAssetInterestRate |
decimal{22,8} |
|
Interest Rate |
|
statAssetLocation |
string(40) |
|
State, province, country, or other location of the asset or counterparty |
|
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. |
|
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. |
|
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 |
|
statIssuerType |
string(80) |
|
The issuer type of an asset as defined by the NAIC |
|
statStateCode |
string(2) |
|
State abbreviation |
|
statStateName |
string(30) |
|
The name of a U.S. state or territory |
|
tradingSymbol |
string(20) |
|
Ticker, or trading symbol, of this security as used on the issue's primary securities exchange |