Scrum Team Roles in Healthcare IT: Matrix Reporting, Daily Work, and BAT Sign-Off Healthcare Scrum teams rarely look like the textbook picture. People join from different departments, report to different managers, and juggle production support while trying to finish sprint work. This article walks through the Scrum team roles on one healthcare IT team, then
Scrum Team Roles in Healthcare IT Read Post »
SQL for Healthcare QA Analysts: Data Validation Queries for EHR Testing SQL for healthcare QA analysts is the skill that proves what an EHR build did to the data. A screen shows only part of that. A screen can display the right value while the table underneath holds a duplicate, a null, or a code
SQL for Healthcare QA Analysts: Data Validation for EHR Testing Read Post »
Clarity LOS Calculation with DATEDIFF: Admit-to-Discharge Logic for Epic Analysts A Clarity LOS calculation looks like one line of SQL: DATEDIFF between admit and discharge. It is also the most common reason two Epic reports show different length-of-stay numbers for the same patients. The function counts calendar boundaries, not elapsed days, and the definition you
Clarity LOS Calculation with DATEDIFF Read Post »
Epic Clarity PAT_ENC Table: Columns, Joins, and Query Patterns for Analysts The Epic Clarity PAT_ENC table holds one row per patient encounter contact, and almost every visit-level report you will validate starts there. It also hides the most common reconciliation trap in Epic reporting: a row in PAT_ENC is not always a visit. This article
Epic Clarity PAT_ENC Table Read Post »
