| key |
id |
string(36)* |
= |
Unique id for SERFF Filing at event level |
| link |
batch |
Batch |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun |
= |
The BatchRun in which the entity is sent. |
|
dispMultOverallRtImp |
decimal{7,3} |
|
Aggregate average of all companies included in the filing for statewide average percentage premium change to the accepted rates requested for the product |
|
dispMultiOverallRtInd |
decimal{7,3} |
|
Aggregate average of all companies included in the filing for the statewide average premium change for the product determined by the company to achieve state stated actuarial objectives for the filing |
|
dispMultiPgmPHAffect |
long(-2147483648,2147483647) |
|
Aggregate average of all companies included in the filing for the number of policyholders affected by the overall percentage rate impact |
|
dispMultiPgmWritPrem |
decimal{12,0} |
|
Aggregate average of all companies included in the filing for the statewide change in written premium for the product based on the proposed overall percentage rate impact |
|
dispositionComment |
string(8000) |
|
Comment on the disposition of the filing |
|
dispositionDate |
date |
|
The date when the Disposition Report was submitted to the filing company and final action was taken |
|
dispositionStatus |
string(40) |
|
The disposition status shows only for documents with a Closed status, and further describes the state action on the filing, such as Closed-Approved, Closed-Acknowledged, and others |
|
domicileDateApproved |
date |
|
Date contract or other filing or form filing was approved in state of domicile |
|
effectiveDate |
date |
|
Date when the company approved to have the product available in the market |
|
filingRemovalDate |
date |
|
Date set by the state to remove the filing from the SERFF database |
|
filingStatus |
string(40) |
|
Status of the filing. When the filing does not have a disposition it is pending, otherwise the filing status is the same as the disposition status. |
|
giOverallRateImpact |
decimal{7,3} |
|
Statewide premium change to the accepted rates requested for the product |
|
hhsStatusValue |
string(20) |
|
Status of filing defined by the U.S. Department of Health and Human Services (HHS) and reported by the company |
|
mostRecentSequence |
long(-32768,32767) |
|
Indicates the most recent data available within a time series. Rows with this value = 1 indicate that the row is the most recent. Some objects, but not all objects, require the calculation of varying numbers of data prior to the most recent. These rows are indicated with increasing values moving back through time. For example, the most recent row has a value of 1, the next most recent, or immediately prior, has a value of 2. The next prior record has a value of 3, and so on. The number of rows flagged with these values varies from object to object, but there will always be at least the one row marked with a 1. |
|
multOverallRateImpact |
decimal{7,3} |
|
Aggregate average of all companies included in the filing for statewide average percentage premium change to the accepted rates requested for the product |
|
multiOverallRtInd |
decimal{7,3} |
|
Aggregate average of all companies included in the filing for the statewide average premium change for the product determined by the company to achieve state stated actuarial objectives for the filing |
|
multiPgmEarnedPrem |
decimal{12,0} |
|
Statewide earned premium for the product |
|
multiPgmPHAffect |
long(-2147483648,2147483647) |
|
Aggregate average of all companies included in the filing for the number of policyholders affected by the overall percentage rate impact |
|
multiPgmWrittenPrem |
decimal{12,0} |
|
Aggregate average of all companies included in the filing for the statewide change in written premium for the product based on the proposed overall percentage rate impact |
|
newBusEffDate |
date |
|
The effective date for a new business filing as determined by the state insurance department |
|
newBusReqEffDate |
date |
|
The effective date for a new business filing as requested by the filing company |
|
overallRateImpact |
decimal{7,3} |
|
Statewide premium change to the accepted rates requested for the product |
|
publishDate |
dateTime |
|
For those publications that report data collected over a period of time (e.g., the Daily faxes), this date is represents the date that the data is approved for publication, to control into which dated publications this content should appear. This is also the first time at which a real-time "alert" (email) can be sent to a client. In the Articles object this item will only be populated when the language the article is written in is English. |
|
renewBusEffDate |
date |
|
The effective date for a renewal business filing as determined by the state insurance department |
|
renewBusReqEffDate |
date |
|
The effective date for a renewal business filing as requested by the filing company |
|
requestedEffectivDate |
date |
|
Date when the company expects to have the product ready for the market |
|
serffFilingEventAsOf |
date* |
|
The date the SERFF (System for Electronic Rate and Form Filing) filing event occurred |
|
serffFilingEventid |
long(-2147483648,2147483647)* |
|
Unique id for SERFF Filing at event level |
| link |
serffFilingid |
SnlSerffFiling |
|
Unique id for SERFF Filing at event level |
|
sfcNumber |
string(14) |
|
Unique identifier for an insurance product filing document on the SPGMI platform. It starts with the state abbreviation, followed by coverage type and a numeric code. |
|
stateReview |
string(30) |
|
The status of the filing demonstrating the level of review by the state |
|
stateStatusDate |
date |
|
Date when the state status of the filing changed |
|
status |
string(255) |
|
The SERFF (System for Electronic Rate and Form Filing) status describes the current step in the process for a SERFF filing. States have different regulations concerning when a document becomes available for public access. Some states will only have the status of Closed, indicating the final action has taken place for the policy filing. Other states will have earlier steps disclosed during the process, such as Submitted, where a state acknowledges the receipt of the filing. |
|
statusDate |
date |
|
Date when the SERFF (System for Electronic Rate and Form Filing) status changed |
|
statusState |
string(255) |
|
The state status (as standardized by SNL) describes the current step in the process as defined by the state. Some states choose to use the SERFF (System for Electronic Rate and Form Filing) status and leave this field blank. |