Treatment finder query report
Posted: Tue Apr 28, 2009 5:15 pm
There is a minor assumption that is not performing right....
The query assumes calendar year while some patients have fiscal year coverage and thus their figures are showing zeros for annual maximum and everything else is not falling in the right places thereafter. Please comment out line for calendar year in FormRpTreatmentFinder.cs :
The query assumes calendar year while some patients have fiscal year coverage and thus their figures are showing zeros for annual maximum and everything else is not falling in the right places thereafter. Please comment out line for calendar year in FormRpTreatmentFinder.cs :
Code: Select all
INSERT INTO tempannualmax
SELECT benefit.PlanNum, benefit.MonetaryAmt
FROM benefit, covcat
WHERE covcat.CovCatNum = benefit.CovCatNum
AND benefit.BenefitType = 5 /* limitation */
/*****************************************************************
AND benefit.TimePeriod = 2 /* calendar year */
*****************************************************************/
AND covcat.EbenefitCat=1
AND benefit.MonetaryAmt <> 0
GROUP BY benefit.PlanNum
ORDER BY benefit.PlanNum;