Mount Sinai Data Warehouse Data Sources

The Mount Sinai Health System Data Warehouse represents one of the most comprehensive healthcare data repositories in the United States. This sophisticated infrastructure aggregates, standardizes, and preserves vast amounts of clinical, research, and administrative data from multiple source systems across the health system's hospitals, medical schools, and affiliated facilities.

Clinical Data Sources

The clinical data foundation of the Mount Sinai Data Warehouse draws primarily from Electronic Health Records (EHR), which document patient encounters across the health system. These records include structured data elements such as diagnoses, procedures, medications, laboratory results, and vital signs, as well as unstructured elements like clinical narratives and physician notes.

Inpatient Clinical Systems

• Epic Systems EHR The primary inpatient documentation platform
• Cerner Soarian Critical care and specialized units
• Meditech Legacy systems with historical patient data
• GE Healthcare Solutions Radiology and cardiology systems
• Philips Healthcare Critical care monitoring systems

Ambulatory and Outpatient Systems

• Epic Ambulatory Outpatient clinical documentation
• Allscripts Practice management and EHR for selected practices
• eClinicalWorks Community health centers and outreach programs
• NextGen Specialty clinics and research practices
• CareCloud Urgent care and virtual visit platforms

Laboratory and Diagnostic Sources

Laboratory and diagnostic testing generate enormous volumes of quantitative data that are critical for care delivery, research, population health, and quality improvement initiatives.

• Sunquest Laboratory Systems Core laboratory testing infrastructure
• Cerner PathNet Anatomic pathology and laboratory information systems
• BecSys Blood bank and transfusion medicine systems
• McKesson Pathology Specialized pathology collections
• PACS (Picture Archiving and Communication System) Medical imaging storage
• RIS (Radiology Information System) Radiology workflow and scheduling
• Muse Cardiology information systems
• Philips Vue Cardiac imaging and hemodynamic monitoring

Pharmacy and Medication Systems

Medication-related data streams provide essential information about prescribing patterns, dispensing, administration, and outcomes.

• Epic Willow Inpatient Inpatient medication management
• Epic Rx (RxE) Outpatient prescribing
• Baxter Pyxis Automated dispensing cabinets
• DoseEdge Intravenous compounding safety
• Mediware Specialty pharmaceuticals
• Tallman Hemophilia and specialty pharmacy management

Research Data Sources

As a leading academic medical center, Mount Sinai integrates numerous specialized research databases that support its world-class scientific investigations.

Biobanking and Genomics

• Biobank Mount Sinai's institutional biobank storing biological specimens
• LabKey Research data management platform
• REDCap Research data capture system
• i2b2 Informatics for Integrating Biology and the Bedside
• Genomics Data Repository Next-generation sequencing and molecular data
• Multi-omics Integration Platforms Transcriptomic, proteomic, and metabolomic data

Clinical Research Systems

• OnCore Clinical trial management system
• Velos Clinical research management
• ClincalTrials.gov Integration Public trial enrollment and outcomes data
• FHIR-based Research Platforms Real-time data extraction for research

Administrative and Financial Systems

Beyond clinical data, the warehouse incorporates administrative and financial information essential for operational analysis and value-based care initiatives.

• Enterprise Resource Planning (ERP) Financial management and supply chain
• Revenue Cycle Management Billing, insurance, and payment data
• Human Resources Systems Provider information and workforce analytics
• Supply Chain Systems Inventory, procurement, and utilization
• Patient Access Systems Registration, scheduling, and insurance verification
• Demand Management Capacity planning and patient flow data

External Data Integration

The Mount Sinai Data Warehouse also incorporates external data sources that supplement institutional data with community, regional, and national perspectives.

• Health Information Exchanges Regional data sharing initiatives
• State Health Departments Public health reporting and disease registries
• CDC Data Public health surveillance and national trends
• CMS Data Medicare and Medicaid claim data for accountable care
• Social Determinants of Health Databases Housing, food security, and community resources
• Environmental Data Air quality, climate information, and geographic health indicators

Data Integration and Standardization

Mount Sinai employs sophisticated ETL (Extract, Transform, Load) processes to harmonize data from these diverse sources. Key components of this integration framework include:

• Teradata Database Platform Enterprise data warehousing infrastructure
• Master Data Management Patient, provider, and location entity resolution
• Enterprise Terminology Services Clinical vocabulary management including SNOMED, LOINC, and ICD coding
• Real-time Data Pipelines FHIR-based streaming data integration
• Quality Assurance Processes Automated data validation and correction

Data Governance and Security

Mount Sinai maintains rigorous data governance frameworks to ensure data quality, integrity, and security. This includes data classification based on sensitivity, access controls through role-based security, comprehensive audit trails, and compliance frameworks aligned with HIPAA, HITECH, and other regulatory requirements.

Applications and Utilization

The integrated data warehouse supports numerous applications across the Mount Sinai Health System:

• Precision Medicine Initiatives Identification of patient cohorts for targeted therapies
• Quality Improvement Clinical outcomes measurement and benchmarking
• Population Health Management Risk stratification and care gap identification
• Operational Analytics Resource utilization and workflow optimization
• Research Support Study cohort identification, phenotype generation, and outcome measurement
• Artificial Intelligence Development Training data for machine learning and predictive analytics
• Reporting Regulatory reporting and executive dashboards

This comprehensive data infrastructure positions Mount Sinai as a leader in healthcare data utilization, enabling data-driven transformation across clinical care, research, and health system operations.