Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

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

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

Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Retrieve Charges