Skip to content

Home

Jump to bottom
Edward Palmer edited this page Jun 11, 2019 · 3 revisions

Background

This is the CC-HIC data dictionary. It is a comprehensive overview of all the data elements contributed to CC-HIC. All data elements are mapped to standardised medical ontologies so that it is very clear on what a data element is and what it is not.

This data dictionary is to be used when writing the ETL process from your local hospital EHR to the standardised OHDSI version 6 format (often colloquially called OMOP for historical reasons)

Data elements in CC-HIC are grouped into either core, or optional bundles. The core module is a collection of the mandatory minimum data elements that must be present to a high degree to onboard a site into the central CC-HIC database. It represents the first level of data quality and contains information that helps to identify a patient, and characterise their ICU stay. Optional bundles can be written by anyone from any CC-HIC site. We encourage a researcher to create their own data bundle and add it to the data dictionary in collaboration with the central CC-HIC team.

General Principles

Default values should not be used at any point in CC-HIC. Missing values should be contributed at empty cells. This includes dates and times.

Data Types

Each data element is specified with a data type. All data types must be contributed in the correct data type, and the correct format or will be rejected.

  • String
  • Integer
  • Boolean
    • All binary choices should be provided as TRUE or FALSE unquoted. The legacy XML pathway has many differing methods to contribute a binary response, and these are not supported in the OHDSI pathway
  • Floating Point
    • Floating point numbers should be provided to the precision specified for each data element.
  • Date
    • Dates should be provided in the format “YYYY-MM-DD”.
  • Time
    • In very rare instances, CC-HIC will ask for a time in isolation. In almost all circumstances, a time is broadly useless without its corresponding date information. In those cases, time should be contributed in the format of “HH:MM:SS”
  • Datetime
    • “YYYY-MM-DD HH:MM:DD-00” where the -00 is the temporal offset in hours from GMT
Clone this wiki locally