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.

;WITH cteDiags AS ( SELECT f.ABBREVNAME AS Location, d.ICD9Code, COUNT(d.PatientVisitDiagsId) AS DiagCount FROM PatientVisit v INNER JOIN PatientVisitDiags d ON v.PatientVisitId = d.PatientVisitId INNER JOIN LOCREG f ON v.FacilityId = f.FacilityId WHERE v.Visit BETWEEN @Start AND @End GROUP BY f.ABBREVNAME, d.ICD9Code ), cte_Top AS ( SELECT ROW_NUMBER() OVER (PARTITION BY d.Location ORDER BY d.DiagCount DESC) AS RecNum, d.Location, d.ICD9Code, c.Description, d.DiagCount FROM cteDiags d INNER JOIN ICD9Codes c ON d.ICD9Code = c.Code ) SELECT Location, ICD9Code, Description, ICD10Code, DiagCount FROM cte_Top WHERE RecNum <= 100 ORDER BY Location, DiagCount DESC

;WITH cteDiags AS ( SELECT d.ICD9Code, COUNT(d.PatientVisitDiagsId) AS DiagCount FROM PatientVisit v INNER JOIN PatientVisitDiags d ON v.PatientVisitId = d.PatientVisitId INNER JOIN LOCREG f ON v.FacilityId = f.FacilityId WHERE v.Visit BETWEEN @Start AND @End AND f.ABBREVNAME = 'Hospital' --edit this to suit your needs GROUP BY d.ICD9Code ) SELECT TOP 100 d.ICD9Code, c.Description, md10.Code AS ICD10Code, d.DiagCount FROM cteDiags d INNER JOIN ICD9Codes c ON d.ICD9Code = c.Code INNER JOIN MasterDiagnosis md9 ON c.Code = md9.Code INNER JOIN ProblemCodeMap pcm ON md9.MasterDiagnosisId = pcm.FromMasterDiagnosisID INNER JOIN MasterDiagnosis md10 ON pcm.ToMasterDiagnosisID = md10.MasterDiagnosisId WHERE pcm.MappingType = 1 ORDER BY DiagCount DESC;

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

EMR Report: Top 100 Diagnoses by Location and Date