Skip to main content

About VitalSync Queries

VitalSync Queries is a repository of SQL scripts and documentation for analyzing healthcare data from various Electronic Medical Record (EMR) systems and other healthcare data platforms.

Purpose​

The purpose of this documentation site is to provide a comprehensive resource for understanding and extracting value from healthcare data sources. Whether you're a data analyst, healthcare administrator, or IT professional, these resources can help you gain insights from your healthcare data.

Features​

  • SQL Scripts: Ready-to-use SQL scripts for common healthcare data analysis tasks
  • Documentation: Detailed documentation on database schemas and data structures
  • Analysis Guides: Step-by-step guides for performing various types of analyses
  • Best Practices: Recommendations for working with healthcare data

Current Data Sources​

  • PointClickCare (PCC): Analysis of the PCC EMR system, with a focus on the aging report

Future Plans​

We plan to expand this repository to include analysis for additional healthcare data sources:

  • Other EMR vendors (Epic, Cerner, Meditech, etc.)
  • Healthcare financial systems
  • Clinical data repositories
  • Population health platforms
  • Interoperability frameworks (FHIR, HL7)