WebCOBRA.com Community Message Boards

MBENEFIEL
Posts: 19
Since: 05/07/2008

1. We are looking for a data map to the maximum Cobra effective date, that is, a date that defines the maximum time of coverage for an individual. I thought that was documented previously, in a payment table, but could not find it.

2. We also want to calculate the Number of Months coverage by subtracting the beginning effective date of coverage from this date. I believe that date calculation was also documented, which is the correct effective date mapping for this calculation?

Can you please reply with this answer - I could not find it in the quick search.

Thank you!

jwolgamott
Posts: 257
Since: 09/26/2005

No problem ---

Check out the QBBenefitAssignments table

FirstDayAfterLossCoverage = day that qb is effective "on COBRA" (if they enroll)
DayPQBNoLongerCovered = end of Federal COBRA

Note: if you have state extensions (QBBenefitAssignments.NoLongerOnSta teCoverage) or SS Disability Extenstions (qbgroupinformationcache.SocialSecu rityEndDate), this is not the date for you.

Further Note: This is the maximum Allowed coverage period, not the time they are actually on coverage.

select distinct qbgroups.Description, QB.FirstName, QB.LastName, qbbenefitassignments.FirstDayAfterLossCoverage, qbbenefitassignments.DayPQBNoLongerCovered
from qbgroups
inner join qb on qbgroups.designatedGroupContact = qb.qbautoid
inner join qbbenefitassignments on qbbenefitassignments.qbautoid = qb.qbautoid

Hope that helps!