Wednesday, March 7, 2012

Problem working around a process quirk

Hello. I work for a managed care organization. I am currently dealing
with a process which compensates practices for seeing members. A
"contact point" is awarded to a practice for treating a member. That
practice can only receive one contact point for a particular patient
within the specified time period - typically 6 months.
These contact points are calculated from new claims by populating a
cursor with the member id, practice, and latest contact date for all
member/practice contact point combinations, also sorted by those fields
in that order.
Scanning through the cursor, a contact point is logged for every
practice that sees a particular member. As a point is awarded, the
eligibility date for the next contact point for that particular member
is incremented by 6 months, and all new claims for that member/practice
combination are ignored within the cursor if the date of the claim is
prior to that next date of eligibility.
Here is a simplification of the TSQL code...
OPEN CURSOR
FETCH NEXT
Note @.MemberID, @.PracticeID and latest known @.ContactDate
WHILE @.@.FETCH_STATUS = 0
BEGIN
IF status date on new claim is at least 6 months
from last contact point...
BEGIN
Generate new point
Adjust latest known date to reflect that of new point
END
FETCH NEXT
IF @.MemberID or @.PracticeID are different on next record...
Note @.MemberID, @.PracticeID and latest known
@.ContactDate for this particular combination
END
Here's the catch. It is now required that certain specialties (at this
point just one) cover any practice that sees a patient under that
specialty. For example, lets assume that cardiology is that specialty in
question. If the member, John Doe, were seen on Feb 1, 2005 by the
practice, National Cardiologists, then no other claims would be eligible
for a contact point for any other practice for John Doe if they were
also cardiology claims for the next 6 months. However, this should not
affect claims involving other specialties.
I managed to ensure that the cursor reflects this requirement where that
specialty is concerned by making that latest contact point date the same
for each member on all practices of that specialty.
Where I'm having trouble is working it into this part of the process.
Any ideas would be greatly appreciated.
Rumble
"Write something worth reading, or do something worth writing."
-- Benjamin FranklinRumbledor <Rumbledor@.hotspamsuxmail.com> wrote in
news:Xns962F7318CC70BRumbledorhotmailcom
@.216.148.227.77:

> Hello. I work for a managed care organization. I am currently dealing
> with a process which compensates practices for seeing members. A
> "contact point" is awarded to a practice for treating a member. That
> practice can only receive one contact point for a particular patient
> within the specified time period - typically 6 months.
> ...
Nevermind. I worked it out.
Rumble
"Write something worth reading, or do something worth writing."
-- Benjamin Franklin

No comments:

Post a Comment