///<summary>Updates all claimproc estimates and also updates claim totals to db. Must supply procList which includes all procedures that this claim is linked to. Will also need to refresh afterwards to see the results</summary> public static void CalculateAndUpdate(List <Procedure> procList, List <InsPlan> planList, Claim claimCur, List <PatPlan> patPlans, List <Benefit> benefitList, int patientAge, List <InsSub> subList) { //we need more than just the claimprocs for this claim. //in order to run Procedures.ComputeEstimates, we need all claimprocs for all procedures attached to this claim List <ClaimProc> ClaimProcsAll = ClaimProcs.Refresh(claimCur.PatNum); List <ClaimProc> ClaimProcsForClaim = ClaimProcs.RefreshForClaim(claimCur.ClaimNum); //will be ordered by line number. double claimFee = 0; double dedApplied = 0; double insPayEst = 0; double insPayAmt = 0; double writeoff = 0; InsPlan plan = InsPlans.GetPlan(claimCur.PlanNum, planList); if (plan == null) { return; } long patPlanNum = PatPlans.GetPatPlanNum(claimCur.InsSubNum, patPlans); //first loop handles totals for received items. for (int i = 0; i < ClaimProcsForClaim.Count; i++) { if (ClaimProcsForClaim[i].Status != ClaimProcStatus.Received) { continue; //disregard any status except Receieved. } claimFee += ClaimProcsForClaim[i].FeeBilled; dedApplied += ClaimProcsForClaim[i].DedApplied; insPayEst += ClaimProcsForClaim[i].InsPayEst; insPayAmt += ClaimProcsForClaim[i].InsPayAmt; writeoff += ClaimProcsForClaim[i].WriteOff; } //loop again only for procs not received. //And for preauth. Procedure ProcCur; //InsPlan plan=InsPlans.GetPlan(claimCur.PlanNum,planList); List <ClaimProcHist> histList = ClaimProcs.GetHistList(claimCur.PatNum, benefitList, patPlans, planList, claimCur.ClaimNum, claimCur.DateService, subList); List <ClaimProc> claimProcListOld = new List <ClaimProc>(); //make a copy for (int i = 0; i < ClaimProcsAll.Count; i++) { claimProcListOld.Add(ClaimProcsAll[i].Copy()); } List <ClaimProcHist> loopList = new List <ClaimProcHist>(); for (int i = 0; i < ClaimProcsForClaim.Count; i++) //loop through each proc { ProcCur = Procedures.GetProcFromList(procList, ClaimProcsForClaim[i].ProcNum); //in order for ComputeEstimates to give accurate Writeoff when creating a claim, InsPayEst must be filled for the claimproc with status of NotReceived. //So, we must set it here. We need to set it in the claimProcsAll list. Find the matching one. for (int j = 0; j < ClaimProcsAll.Count; j++) { if (ClaimProcsAll[j].ClaimProcNum == ClaimProcsForClaim[i].ClaimProcNum) //same claimproc in a different list { if (ClaimProcsForClaim[i].Status == ClaimProcStatus.NotReceived && ProcCur != null) //ignores payments, etc { ClaimProcsAll[j].InsPayEst = ClaimProcs.GetInsEstTotal(ClaimProcsAll[j]); } } } //When this is the secondary claim, HistList includes the primary estimates, which is something we don't want because the primary calculations gets confused. //So, we must remove those bad entries from histList. for (int h = histList.Count - 1; h >= 0; h--) //loop through the histList backwards { if (histList[h].ProcNum != ProcCur.ProcNum) { continue; //Makes sure we will only be excluding histList entries for procs on this claim. } //we already excluded this claimNum when getting the histList. if (histList[h].Status != ClaimProcStatus.NotReceived) { continue; //The only ones that are a problem are the ones on the primary claim not received yet. } histList.RemoveAt(h); } Procedures.ComputeEstimates(ProcCur, claimCur.PatNum, ref ClaimProcsAll, false, planList, patPlans, benefitList, histList, loopList, false, patientAge, subList); //then, add this information to loopList so that the next procedure is aware of it. loopList.AddRange(ClaimProcs.GetHistForProc(ClaimProcsAll, ProcCur.ProcNum, ProcCur.CodeNum)); } //save changes in the list to the database ClaimProcs.Synch(ref ClaimProcsAll, claimProcListOld); ClaimProcsForClaim = ClaimProcs.RefreshForClaim(claimCur.ClaimNum); //But ClaimProcsAll has not been refreshed. for (int i = 0; i < ClaimProcsForClaim.Count; i++) { if (ClaimProcsForClaim[i].Status != ClaimProcStatus.NotReceived && ClaimProcsForClaim[i].Status != ClaimProcStatus.Preauth && ClaimProcsForClaim[i].Status != ClaimProcStatus.CapClaim) { continue; } ProcCur = Procedures.GetProcFromList(procList, ClaimProcsForClaim[i].ProcNum); if (ProcCur.ProcNum == 0) { continue; //ignores payments, etc } //fee: int qty = ProcCur.UnitQty + ProcCur.BaseUnits; if (qty == 0) { qty = 1; } if (plan.ClaimsUseUCR) //use UCR for the provider of the procedure { long provNum = ProcCur.ProvNum; if (provNum == 0) //if no prov set, then use practice default. { provNum = PrefC.GetLong(PrefName.PracticeDefaultProv); } //get the fee based on code and prov fee sched double feebilled = Fees.GetAmount0(ProcCur.CodeNum, ProviderC.ListLong[Providers.GetIndexLong(provNum)].FeeSched); if (feebilled > ProcCur.ProcFee) { ClaimProcsForClaim[i].FeeBilled = qty * feebilled; } else { ClaimProcsForClaim[i].FeeBilled = qty * ProcCur.ProcFee; } } //else if(claimCur.ClaimType=="Cap") {//Even for capitation, use the proc fee. // ClaimProcsForClaim[i].FeeBilled=0; //} else //don't use ucr. Use the procedure fee instead. { ClaimProcsForClaim[i].FeeBilled = qty * ProcCur.ProcFee; } claimFee += ClaimProcsForClaim[i].FeeBilled; if (claimCur.ClaimType == "PreAuth" || claimCur.ClaimType == "Other" || claimCur.ClaimType == "Cap") { //only the fee gets calculated, the rest does not ClaimProcs.Update(ClaimProcsForClaim[i]); continue; } //ClaimProcs.ComputeBaseEst(ClaimProcsForClaim[i],ProcCur.ProcFee,ProcCur.ToothNum,ProcCur.CodeNum,plan,patPlanNum,benefitList,histList,loopList); ClaimProcsForClaim[i].InsPayEst = ClaimProcs.GetInsEstTotal(ClaimProcsForClaim[i]); //Yes, this is duplicated from further up. ClaimProcsForClaim[i].DedApplied = ClaimProcs.GetDedEst(ClaimProcsForClaim[i]); if (ClaimProcsForClaim[i].Status == ClaimProcStatus.NotReceived) //(vs preauth) { ClaimProcsForClaim[i].WriteOff = ClaimProcs.GetWriteOffEstimate(ClaimProcsForClaim[i]); writeoff += ClaimProcsForClaim[i].WriteOff; /* * ClaimProcsForClaim[i].WriteOff=0; * if(claimCur.ClaimType=="P" && plan.PlanType=="p") {//Primary && PPO * double insplanAllowed=Fees.GetAmount(ProcCur.CodeNum,plan.FeeSched); * if(insplanAllowed!=-1) { * ClaimProcsForClaim[i].WriteOff=ProcCur.ProcFee-insplanAllowed; * } * //else, if -1 fee not found, then do not show a writeoff. User can change writeoff if they disagree. * } * writeoff+=ClaimProcsForClaim[i].WriteOff;*/ } dedApplied += ClaimProcsForClaim[i].DedApplied; insPayEst += ClaimProcsForClaim[i].InsPayEst; ClaimProcsForClaim[i].ProcDate = ProcCur.ProcDate.Date; //this solves a rare bug. Keeps dates synched. //It's rare enough that I'm not goint to add it to the db maint tool. ClaimProcs.Update(ClaimProcsForClaim[i]); //but notice that the ClaimProcs lists are not refreshed until the loop is finished. } //for claimprocs.forclaim claimCur.ClaimFee = claimFee; claimCur.DedApplied = dedApplied; claimCur.InsPayEst = insPayEst; claimCur.InsPayAmt = insPayAmt; claimCur.WriteOff = writeoff; //Cur=ClaimCur; Claims.Update(claimCur); }