WebCOBRA.com Community Message Boards

val
Posts: 5
Since: 01/07/2010

1. How are rate changes handled in the database. We need to know both the date the rate change was applied AND the effective date of the rate change. Where is this information stored?
a. Specifically, when a rate is changed, is the old amount kept and an adjustment entry made, or is the old amount disabled or deleted?
b. If the rate change is retroactive, such that it effects already disbursed premiums how does this show up?
c. In the Access database that we request from WebCobra, where are the ‘applied’ and ‘effective’ dates for the rate changes stored?
i. Could you give an example of a query to retrieve rate change information
Thank you

avogt
Posts: 4
Since: 02/24/2010

Val,

1) The information you’re looking for can be found in the BenefitRateStructures table. This table contains the benefit plan number, the beginning and end dates of each rate, as well as the date the rate was created.
2) Both the old and new rates stay in the system. You can still view old rates on the “View/Edit Benefit Plan” page.
3) In the current system, if the rate change affects existing premiums, these premiums are modified to reflect the new rates.
This is currently going through review for modification. The anticipated correction will be to lock all disbursed items and add new entries for the adjusted premium and any subsidy that would apply. These would then be disbursed at a later date.
4) A sample query would be:

SELECT * FROM BenefitPlans INNER JOIN BenefitRateStructures ON BenefitPlans.BenefitPlanID = BenefitRateStructures. BenefitPlanID ORDER BY BenefitPlans.BenefitPlanID