Hospital Episode Statistics (HES) Admitted Patient Care (APC) ETL Documentation
These materials are meant to serve as documentation and reference for how the HES APC dataset was converted to the OMOP Common Data Model (CDM).
The image below (Figure.1) shows a high-level diagram of how the native tables in the HES APC database were mapped to the OMOP CDM. The main HES APC tables converted include: (hes_patient, hes_diagnosis, hes_procedures_epi, hes_hospital, hes_acp and hes_episodes).
HES APC source Data Mapping for CDM v5.3 & CDM v5.4
Figure.1
Change log
12-Nov-2023
- Creation of documentation