Page 1 of 1
Insurance not displaying in Appointment table
Posted: Fri Aug 31, 2012 3:59 pm
by Tom
I am trying to match up appointments by patients' primary dental insurance. I have found quite a few appointments where the InsPlan1 field displays 0 instead of the patient's Ins Number tied to the InsPlan table. The patient has a record in the InsSub table and that links to the InsPlan table. I cannot figure out what is keeping that information from flowing to the Appointment table. The appointment itself is showing the patient's insurance.
Re: Insurance not displaying in Appointment table
Posted: Tue Sep 25, 2012 12:53 pm
by jsalmon
Those fields only get "automatically" set when the appointment is set complete so that you have a record of what insurance the patient had at that point in time. You are most likely looking at appointments that are not completed yet. Try filtering your results with "appointment.AptStatus=2" OR since the InsPlan1 and 2 fields can be manually set by the user at any point in time thus making it very possible that appointments of other statuses have values set. So a better filter would be something like "appointment.InsPlan1<>0".