Notifications
Clear all
Topic starter
Using CPS v10:
Does anyone know a query that will pull a list of patients that have not had their charges retrieved in billing?
Posted : April 17, 2013 1:13 am
This may give you a start Mike
Select mkpv.MIKPatientVisitId,mkpv.AppointmentsId, mkpv.PatientProfileId,mkpv.DateOfService,mkpvp.ProcedureCode,pv.TicketNumber,pvp.OrderCodeId,pvp.OrderId from MIKPatientVisit mkpv left outer join MIKPatientVisitProcs mkpvp on mkpv.MIKPatientVisitId = mkpvp.MIKPatientVisitId left outer join Appointments ap on ap.AppointmentsId = mkpv.AppointmentsId left outer join PatientVisit pv on pv.TicketNumber = ap.TicketNumber left outer join PatientVisitProcs pvp on pv.PatientVisitId = pvp.PatientVisitId
Posted : April 17, 2013 7:10 am
mikeseale said:
Using CPS v10:
Does anyone know a query that will pull a list of patients that have not had their charges retrieved in billing?
This guide may also be helpful. As a checks and balance best practice, it is important to run this check to ensure all EMR charges are brought into PM for billing purposes. This guide illustrates the best practice in capturing all billing. These steps should be followed on a regular basis by each office and on a monthly/quarterly basis by the person who oversees all billing operations as a whole. I hope you find this helpful: BEST PRACTICE GUIDE for EMR CHARGES
Also, there is a flaw in the system for losing EMR charges forever and losing the prompt to import them to PM. Look at this guide to make sure you do not lose charges.
email me if you have any questions at [email protected]
Posted : April 18, 2013 1:27 am
Topic starter
Thanks Ernie. I used that MIK table and was able to pull this off using the following query:
SELECT CASE WHEN pv.TicketNumber IS NULL THEN 'No Ticket Number' ELSE pv.TicketNumber END TicketNumber , pp.PatientId, pp.Last + ', ' + pp.First Patient, doc.ListName Doctor, fac.ListName Facility, mpv.DateOfService DOS FROM MIKPatientVisit mpv JOIN PatientProfile pp ON mpv.PatientProfileId = pp.PatientProfileId JOIN DoctorFacility doc ON mpv.DoctorId = doc.DoctorFacilityId JOIN DoctorFacility fac ON mpv.FacilityId = fac.DoctorFacilityId LEFT JOIN PatientVisit pv ON mpv.PatientVisitId = pv.PatientVisitId ORDER BY DOS, pp.Last, pp.First
Thanks for the additional billing info, Angela. That was very helpful insight.
Posted : April 18, 2013 5:57 am
Nice. Great that I could help some.
I think I will save your query also and add it to my list.
Thanks for sharing.
Posted : April 19, 2013 12:30 am
