WebCOBRA.com Community Message Boards

cperez
Posts: 3
Since: 08/17/2010

Please advise where to locate the Benefit Plan Rate code.

avogt
Posts: 4
Since: 02/24/2010

I'm sorry, but I'm not sure exactly what field you're looking for. Can you give me any additional information?

The benefit plans themselves are in the table "BenefitPlans", and that table is connected to "BenefitRateStructures" by the column "BenefitPlanID". The BenefitRateStructures table includes start and end dates for the rate structure, and can be connected to either the "BenefitRateTiers" or the "MatrixCostingTiers" tables, based on the plan type (tier-based or table-based).