CLIF-2.0 Data Dictionary

Below is the entity-relationship diagram (ERD) that provides an overview of the relational CLIF database structure.

Relational CLIF (RCLIF) is a database that is organized into clinically relevant column categories - demographics, objective measures, respiratory support, orders, and inputs-outputs. Below are sample templates for each table in R-CLIF. Here you can find detailed descriptions of each table and their fields.

You can use our custom GPT- CLIF Assistant to learn more about CLIF and develop analysis scripts.

CLIF maturity

CLIF is still under development and some parts of the format are more mature than others. CLIF will also need to evolve as the set of minimum Common Data Elements for studying critical illness expands or changes over time.

The consortium has two different maturity concepts: one for the overall ER model and one for the individual tables.

Overall Maturity Level for CLIF

• Experimental: Majority of critical illness and hospital course not represented in Entity-Relationship (ER) model, expect frequent breaking changes.
• Beta: Core ER model complete and breaking changes to the existing structure unlikely. Actively seeking feedback about new tables to add to the ER model to fully capture critical illness.
• Stable: Tested and recommended for general use. EHR data not currently represented in CLIF outside the scope of the format.
• Mature: Widely adopted across majority of consortium sites with majority of tables in stable or mature (see maturity levels for CLIF Tables). ER model very stable.
• Deprecated: No longer maintained.

The entity-relationship model for this project is currently at the Beta level for adult patients in a general medical intensive care unit. Major breaking changes to the existing structure are unlikely. The consortium is actively seeking feedback about new tables and fields to add to the ER model to achieve the goal of representing developing a minimum Common ICU Data Elements (mCIDE)

For pediatric patients, CLIF is in the Experimental maturity phase. CLIF is also Experimental for adult patients in specialty ICUs (e.g. cardiac intensive care unit, surgical intensive care unit, and neurointensive care unit).

Maturity Levels for CLIF Tables

There are two critical maturity elements for each CLIF table: 1) field structure and 2) Common ICU data Element development. Each CLIF table has one or more consortium physician-data scientists who are responsible for table design.

• Concept: A planned future CLIF table that has yet to be used in a federated project. The table structure and CDE elements are in draft form. Permissible values of category variables may still need to be defined. Seeking conceptual feedback. Significant changes to all aspects of the table are possible.
• Beta: Table purpose, structure, and field names complete and used in at least one federated CLIF project. CDE for category variables defined. Actively testing the table’s practical use in projects.
• Stable: Tested and recommended for general use. CDE stable with permissible values for all category variables precisely defined and locked. Fully implemented at multiple consortium sites and used in a peer-reviewed publication.
• Mature: Adopted across a majority of the CLIF consortium sites and very stable.
• Deprecated: No longer maintained.

The CLIF-1.0 data dictionary is available here and is now deprecated

General inpatient tables

The data in these tables are typically of most electronic data warehouse systems and are not specific to critical illness. The CLIF versions of these general tables are designed to ensure that they clearly represent the minimum set of data required for critical illness research. Whenever possible, CLIF seeks compatibility with existing EHR data standards.

Patient

This table contains demographic information about the patient that does not vary between hospitalizations. It is inspired by the OMOP Person table

Variable Name	Data Type	Definition	Permissible Values
patient_id	VARCHAR	Unique identifier for each patient. This is presumed to be a distinct individual.
race_name	VARCHAR	Patient race string from source data	No restriction
race_category	VARCHAR	A standardized CDE description of patient’s race per the US Census permissible values. The source data may contain different strings for race.	Black or African American, White, American Indian or Alaska Native, Asian, Native Hawaiian or Other Pacific Islander, Unknown, Other
ethnicity_name	VARCHAR	Patient ethnicity string from source data	No restriction
ethnicity_category	VARCHAR	Description of patient’s ethnicity per the US census definition. The source data may contain different strings for ethnicity.	Hispanic, Non-Hispanic, Unknown
sex_name	VARCHAR	Patient’s biological sex as given in the source data.	No restriction
sex_category	VARCHAR	Patient’s biological sex.	Male, Female, Unknown
birth_date	DATETIME	Patient’s date of birth.	Date format should be %Y-%m-%d
death_dttm	DATETIME	Patient’s death date, including time.	Datetime format should be %Y-%m-%d %H:%M:%S
language_name	VARCHAR	Patient’s preferred language.	Original string from the source data
language_category	VARCHAR	Maps language_name to a standardized list of spoken languages	Under-development

Example:

patient_id	race_name	race_category	ethnicity_name	ethnicity_category	sex_category	birth_date	death_dttm	language_name	language_category
132424	Black or African-American	Black or African American	Not Hispanic, Latino/a, or Spanish origin	Non-Hispanic	Male	2145-05-09	NA	English	English
132384	White	White	Not Hispanic, Latino/a, or Spanish origin	Non-Hispanic	Female	2145-03-30	NA	English	English
542367	Black or African-American	Black or African American	Not Hispanic, Latino/a, or Spanish origin	Non-Hispanic	Male	2145-01-29	NA	English	English
989862	White	White	Not Hispanic, Latino/a, or Spanish origin	Non-Hispanic	Female	2145-11-06	NA	English	English
428035	More than one Race	Other	Not Hispanic, Latino/a, or Spanish origin	Non-Hispanic	Male	2145-10-13	NA	English	English

Hospitalization

The hospitalization table contains information about each hospitalization event. Each row in this table represents a unique hospitalization event for a patient. This table is inspired by the visit_occurance OMOP table but is specific to inpatient hospitalizations (including those that begin in the emergency room).

Variable Name	Data Type	Definition	Permissible Values
patient_id	VARCHAR	Unique identifier for each patient, linking to the patient table	No restriction
hospitalization_id	VARCHAR	Unique identifier for each hospitalization encounter. Each hospitalization_id represents a unique stay in the hospital	No restriction
hospitalization_joined_id	VARCHAR	Unique identifier for each continuous inpatient stay in a health system which may span different hospitals (Optional)	No restriction
admission_dttm	DATETIME	Date and time the patient is admitted to the hospital	Datetime format should be %Y-%m-%d %H:%M:%S
discharge_dttm	DATETIME	Date and time the patient is discharged from the hospital	Datetime format should be %Y-%m-%d %H:%M:%S
age_at_admission	INT	Age of the patient at the time of admission, in years	No restriction
admission_type_name	VARCHAR	Type of inpatient admission. Original string from the source data	e.g. “Direct admission”, “Transfer”, “Pre-op surgical”
admission_type_category	VARCHAR	Admission disposition mapped to mCIDE categories	Under-development
discharge_name	VARCHAR	Original discharge disposition name string recorded in the raw data	No restriction, e.g. “home”
discharge_category	VARCHAR	Maps discharge_name to a standardized list of discharge categories	Home, Skilled Nursing Facility (SNF), Expired, Acute Inpatient Rehab Facility, Hospice, Long Term Care Hospital (LTACH), Acute Care Hospital, Group Home, Chemical Dependency, Against Medical Advice (AMA), Assisted Living, Still Admitted, Missing, Other, Psychiatric Hospital, Shelter, Jail
zipcode_nine_digit	VARCHAR	Patient’s 9 digit zip code, used to link with other indices such as ADI and SVI	No restriction
zipcode_five_digit	VARCHAR	Patient’s 5 digit zip code, used to link with other indices such as ADI and SVI	No restriction
census_block_code	VARCHAR	15 digit FIPS code	No restriction
census_block_group_code	VARCHAR	12 digit FIPS code	No restriction
census_tract	VARCHAR	11 digit FIPS code	No restriction
state_code	VARCHAR	2 digit FIPS code	No restriction
county_code	VARCHAR	5 digit FIPS code	No restriction

Notes:

1. If a patient is discharged to Home/Hospice, then discharge_category == Hospice.

2. The geographical indicators(zipcode_nine_digit, zipcode_five_digit, census_block_code, census_block_group_code, census_tract, state_code, county_code) should be added if they are available in your source dataset. zipcode_nine_digit is preferred over zipcode_five_digit, and census_block_code is ideal for census based indicators.The choice of geographical indicators may differ depending on the project.

3. If a patient is transferred between different hospitals within a health system, a new hospitalization_id should be created

4. If a patient is initially seen in an ER in hospital A and then admitted to inpatient status in hospital B, one hospitalization_id should be created for data from both stays

5. A hospitalization_joined_id can also be created from a CLIF table from contiguous hospitalization_ids

Example:

patient_id	hospitalization_id	hospitalization_joined_id	admission_dttm	discharge_dttm	age_at_admission	admission_type_name	admission_type_category	discharge_name	discharge_category	zipcode_five_digit	zipcode_nine_digit	census_block_group_code	latitude	longitude
101001	12345678	22334455	2024-11-01 08:15:00	2024-11-04 14:30:00	65	Direct admission	Inpatient	Discharged to Home or Self Care (Routine Discharge)	Home	60637	606370000	170313202001	41.81030	-87.59697
101002	87654321	22334455	2024-11-04 15:00:00	2024-11-07 11:00:00	72	Transfer from another hospital	Acute Care Transfer	Transferred to Acute Inpatient Rehab Facility	Acute Inpatient Rehab Facility	46311	463110000	170313301002	41.55030	-87.30101
101003	11223344	11223344	2024-10-20 07:45:00	2024-10-22 10:20:00	59	Pre-op surgical	Pre-op	Expired	Expired	60446	604460000	170313401003	41.70010	-87.60315

ADT

The admission, discharge, and transfer (ADT) table is a start-stop longitudinal dataset that contains information about each patient’s movement within the hospital. It also has a hospital_id field to distinguish between different hospitals within a health system.

Variable Name hospitalization_id	Data Type VARCHAR	Definition ID variable for each patient encounter	Permissible Values No restriction
hospital_id	VARCHAR	Assign a unique ID to each hospital within a healthsystem	No restriction
hospital_type	VARCHAR	Maps hospital_id to a standardized list of hospital types	academic, community
in_dttm	DATETIME	Start date and time at a particular location	Datetime format should be %Y-%m-%d %H:%M:%S
out_dttm	DATETIME	End date and time at a particular location	Datetime format should be %Y-%m-%d %H:%M:%S
location_name	VARCHAR	Location of the patient inside the hospital. This field is used to store the patient location from the source data. This field is not used for analysis.	No restriction
location_category	VARCHAR	Maps location_name to a standardized list of ADT location categories	ed, ward, stepdown, icu, procedural, l&d, hospice, psych, rehab, radiology, dialysis, other
location_type	VARCHAR	Maps location_name to a standardized list of ADT location types	general_icu, medical_icu, surgical_icu, cardiac_icu, mixed_cardiac_icu, cvicu_icu, neuro_icu, mixed_neuro_icu

Note:

• Procedural areas and operating rooms should be mapped to Procedural. Pre/Intra/Post-procedural/OR EHR data (such as anesthesia flowsheet records from Labs, Vitals, Scores, Respiratory Support) are not currently represented in CLIF.
• For location_type, this is currently limited to location_category = icu and the following ICU types should be used:
  • general_icu: Default if unknown type.
  • medical_icu: For medical intensive care units.
  • surgical_icu: For surgical intensive care units.
  • cardiac_icu: For cardiac intensive care units without surgical patients.
  • mixed_cardiac_icu: For mixed cardiac intensive care units that include cardiac surgery patients.
  • cvicu_icu: For surgical cardiovascular intensive care units.
  • neuro_icu: For neuro intensive care units without surgery.
  • mixed_neuro_icu: For mixed neuro intensive care units that include neurosurgery patients.
• If location type is unknown and location category is icu, location_type should be labeled as general_icu.
• Future iterations may expand location_type to descripe other location categories

Example:

hospitalization_id	hospital_id	hospital_type	in_dttm	out_dttm	location_name	location_category	location_type
20010012	ABC	academic	2024-12-01 10:00:00	2024-12-01 14:00:00	B06F	icu	general_icu
20010012	ABC	academic	2024-12-01 14:30:00	2024-12-02 08:00:00	B78D	ward
20010015	ABC	academic	2024-11-30 16:45:00	2024-12-01 12:00:00	B06T	icu	medical_icu
20010015	ABC	academic	2024-12-01 12:30:00	2024-12-02 07:00:00	N23E	procedural
20010020	EFG	community	2024-11-28 09:00:00	2024-11-29 17:00:00	B78D	ward

Vitals

The vitals table is a long-form (one vital sign per row) longitudinal table.

Variable Name	Data Type	Definition	Permissible Values
hospitalization_id	VARCHAR	ID variable for each patient encounter.	No restriction
recorded_dttm	DATETIME	Date and time when the vital is recorded.	Datetime format should be %Y-%m-%d %H:%M:%S
vital_name	VARCHAR	This field is used to store the description of the flowsheet measure from the source data. This field is not used for analysis.	No restriction
vital_category	VARCHAR	Maps vital_name to a list standard vital sign categories	temp_c, heart_rate, sbp, dbp, spo2, respiratory_rate, map, height_cm, weight_kg
vital_value	DOUBLE	Recorded value of the vital. Ensure that the measurement unit is aligned with the permissible units of measurements.	temp_c = Celsius, height_cm = Centimeters, weight_kg = Kg, map = mm/Hg, spo2 = %. No unit for heart_rate, sbp, dbp, and respiratory_rate
meas_site_name	VARCHAR	Site where the vital is recorded. No CDE corresponding to this variable (Optional field)	No restrictions. Note: no _category CDE variable exists yet

Example:

hospitalization_id	recorded_dttm	vital_name	vital_category	vital_value	meas_site_name
20010012	2024-12-01 08:00	HEIGHT	height_cm	170.0	unspecified
20010012	2024-12-01 08:15	WEIGHT	weight_kg	70.0	unspecified
20010012	2024-12-01 08:30	PULSE	heart_rate	72.0	unspecified
20010012	2024-12-01 08:45	BLOOD PRESSURE (SYSTOLIC)	sbp	120.0	unspecified
20010012	2024-12-01 08:45	BLOOD PRESSURE (DIASTOLIC)	dbp	80.0	unspecified
20010012	2024-12-01 08:50	RESPIRATORY RATE	respiratory_rate	16.0	unspecified
20010012	2024-12-01 09:00	TEMPERATURE	temp_c	36.8	unspecified
20010012	2024-12-01 09:15	SPO2	spo2	98.0	unspecified
20010013	2024-12-01 09:30	MEAN ARTERIAL PRESSURE (MAP)	map	85.0	arterial

Labs

The labs table is a long form (one lab result per row) longitudinal table. Each lab result

Variable Name	Data Type	Definition	Permissible Values
hospitalization_id	VARCHAR	ID variable for each patient encounter.	No restriction
lab_order_dttm	DATETIME	Date and time when the lab is ordered.	Datetime format should be %Y-%m-%d %H:%M:%S
lab_collect_dttm	DATETIME	Date and time when the specimen is collected.	Datetime format should be %Y-%m-%d %H:%M:%S
lab_result_dttm	DATETIME	Date and time when the lab results are available.	Datetime format should be %Y-%m-%d %H:%M:%S
lab_order_name	VARCHAR	Procedure name for the lab, e.g. “Complete blood count w/ diff”	No restriction
lab_order_category	VARCHAR	Maps lab_order_nameto standardized list of common lab order names, e.g. “CBC”	CDE under development
lab_name	VARCHAR	Original lab component as recorded in the raw data, e.g. “AST (SGOT)”.	No restriction
lab_category	VARCHAR	Maps lab_name to a minimum set of standardized labs identified by the CLIF consortium as minimum necessary labs for the study of critical illness.	List of lab categories in CLIF
lab_value	VARCHAR	Recorded value corresponding to a lab. Lab values are often strings that can contain non-numeric results (e.g. “> upper limit of detection”).	No restriction
lab_value_numeric	DOUBLE	Parse out numeric part of the lab_value variable (optional).	Numeric
reference_unit	VARCHAR	Unit of measurement for that lab.	Permissible reference values for each lab_category listed here
lab_specimen_name	VARCHAR	Original fluid or tissue name the lab was collected from as given in the source data	No restriction
lab_specimen_category	VARCHAR	fluid or tissue the lab was collected from, analogous to the LOINC “system” component.	working CDE c(blood/plasma/serum, urine, csf, other).
lab_loinc_code	VARCHAR	LOINC code for the lab	No restrictions

Note: The lab_value field often has non-numeric entries that are useful to make project-specific decisions. A site may choose to keep the lab_value field as a character and create a new field lab_value_numeric that only parses the character field to extract the numeric part of the string.

Example:

hospitalization_id	lab_order_dttm	lab_collect_dttm	lab_result_dttm	lab_order_name	lab_name	lab_category	lab_value	lab_value_numeric	reference_unit	lab_type_name	lab_loinc_code
12345	2024-12-01 08:15	2024-12-01 08:30	2024-12-01 09:00	Complete Blood Count	Hemoglobin	hemoglobin	12.3	12.3	g/dL	standard	718-7
12345	2024-12-01 08:15	2024-12-01 08:30	2024-12-01 09:05	Complete Blood Count	White Blood Cell Count	wbc	5.6	5.6	10^3/uL	standard	6690-2
12345	2024-12-01 08:15	2024-12-01 08:30	2024-12-01 09:10	Metabolic Panel	Sodium	sodium	138	138	mmol/L	standard	2951-2
12345	2024-12-01 08:15	2024-12-01 08:30	2024-12-01 09:20	Metabolic Panel	Potassium	potassium	4.1	4.1	mmol/L	standard	2823-3
67890	2024-12-01 09:30	2024-12-01 09:45	2024-12-01 10:15	Arterial Blood Gas	pH	ph	7.35	7.35		standard	2744-1
67890	2024-12-01 09:30	2024-12-01 09:45	2024-12-01 10:20	Arterial Blood Gas	pCO2	pco2	40	40	mmHg	standard	2019-8
67890	2024-12-01 09:30	2024-12-01 09:45	2024-12-01 10:25	Arterial Blood Gas	pO2	po2	90	90	mmHg	standard	2703-7
67890	2024-12-01 09:30	2024-12-01 09:45	2024-12-01 10:30	Arterial Blood Gas	Bicarbonate	bicarbonate	24	24	mmol/L	standard	2028-3

Patient Assessments

The patient_assessments table captures various assessments performed on patients across different domains, including neurological status, sedation levels, pain, and withdrawal. The table is designed to provide detailed information about the assessments, such as the name of the assessment, the category, and the recorded values.

Variable Name	Data Type	Definition	Permissible Values
hospitalization_id	VARCHAR	Primary Identifier. Unique identifier linking assessments to a specific patient hospitalization.
recorded_dttm	DATETIME	The exact date and time when the assessment was recorded, ensuring temporal accuracy.	Datetime format should be %Y-%m-%d %H:%M:%S
assessment_name	VARCHAR	Assessment Tool Name. The primary name of the assessment tool used (e.g., GCS, NRS, SAT Screen).	No restriction
assessment_category	VARCHAR	Maps assessment_name to a standardized list of patient assessments	List of permissible assessment categories here
assessment_group	VARCHAR	Broader Assessment Group. This groups the assessments into categories such as “Sedation,” “Neurologic,” “Pain,” etc.	List of permissible assessment groups here
numerical_value	DOUBLE	Numerical Assessment Result. The numerical result or score from the assessment component.	Applicable for assessments with numerical outcomes (e.g., 0-10, 3-15).
categorical_value	VARCHAR	Categorical Assessment Result. The categorical outcome from the assessment component.	Applicable for assessments with categorical outcomes (e.g., Pass/Fail, Yes/No).
text_value	VARCHAR	Textual Assessment Result. The textual explanation or notes from the assessment component.	Applicable for assessments requiring textual data.

Example:

hospitalization_id	recorded_dttm	assessment_name	assessment_category	assessment_group	numerical_value	categorical_value	text_value
12345	2024-12-01 08:15	NUR RA GLASGOW ADULT EYE OPENING	gcs_eye	Neurological	4	NA	NA
12345	2024-12-01 08:15	NUR RA GLASGOW ADULT VERBAL RESPONSE	gcs_verbal	Neurological	5	NA	NA
12345	2024-12-01 08:15	NUR RA GLASGOW ADULT BEST MOTOR RESPONSE	gcs_motor	Neurological	6	NA	NA
12345	2024-12-01 08:15	NUR RA GLASGOW ADULT SCORING	gcs_total	Neurological	15	NA	NA
67890	2024-12-01 10:30	BRADEN ASSESSMENT	braden_total	Nursing Risk	18	NA	NA
67890	2024-12-01 10:30	SAT SCREEN	sat_delivery_pass_fail	Sedation	NA	Pass	NA

Provider

Continuous start stop record of every provider who cared for the patient.

Variable Name	Data Type	Definition	Permissible Values
hospitalization_id	VARCHAR	Unique identifier for each hospitalization, linking the provider to a specific encounter	No restriction
provider_id	VARCHAR	Unique identifier for each provider. This represents individual healthcare providers	No restriction
start_dttm	DATETIME	Date and time when the provider’s care or involvement in the patient’s case began	Datetime format should be %Y-%m-%d %H:%M:%S
stop_dttm	DATETIME	Date and time when the provider’s care or involvement in the patient’s case ended	Datetime format should be %Y-%m-%d %H:%M:%S
provider_role_name	VARCHAR	The original string describing the role or specialty of the provider during the hospitalization	No restriction
provider_role_category	VARCHAR	Maps provider_role_name to list of standardized provider roles	under development

Example:

hospitalization_id	provider_id	start_dttm	stop_dttm	provider_role_name	provider_role_category
1001014	P12345	2023-05-01 08:00:00	2023-05-01 20:00:00	Attending Physician	Attending
1001014	P54321	2023-05-01 08:00:00	2023-05-02 08:00:00	Resident Physician	Resident
1001014	P67890	2023-05-01 08:00:00	2023-05-03 08:00:00	Nurse Practitioner	Nurse Practitioner
1002025	P11223	2023-06-10 09:00:00	2023-06-10 21:00:00	Critical Care Specialist	Critical Care
1002025	P44556	2023-06-10 09:00:00	2023-06-11 09:00:00	Respiratory Therapist	Respiratory Therapy
1003036	P33445	2023-07-15 07:30:00	2023-07-15 19:30:00	Attending Physician	Attending
1003036	P66789	2023-07-15 07:30:00	2023-07-16 07:30:00	Charge Nurse	Nurse
1004047	P99887	2023-08-20 10:00:00	2023-08-20 22:00:00	Physical Therapist	Therapy

Admission Diagnosis

Record of all diagnoses associated with the hospitalization. Expect breaking changes to this table as we seek to align it with existing diagnosis ontologies

Variable Name	Data Type	Definition	Permissible Values
patient_id	VARCHAR	Unique identifier for each patient	No restriction
diagnostic_code	DOUBLE	numeric diagnosis code	valid code in the diagnositic_code_format
diagnosis_code_format	VARCHAR	description of the diagnostic code format	icd9 ,icd10
start_dttm	DATETIME	date time the diagnosis was recorded	Datetime format should be %Y-%m-%d %H:%M:%S
end_dttm	DATETIME	date time the diagnosis was noted as resolved (if resolved)	Datetime format should be %Y-%m-%d %H:%M:%S

Example:

patient_id	diagnostic_code	diagnosis_code_format	start_dttm	end_dttm
1001014	250.00	icd9	2023-05-01 08:00:00	2023-05-10 08:00:00
1001014	J45.909	icd10	2023-05-01 08:00:00	2023-05-15 08:00:00
1002025	401.9	icd9	2023-06-10 09:00:00	2023-06-12 09:00:00
1002025	E11.9	icd10	2023-06-10 09:00:00	2023-06-20 09:00:00
1003036	414.01	icd9	2023-07-15 07:30:00	2023-07-30 07:30:00
1003036	I25.10	icd10	2023-07-15 07:30:00	2023-07-25 07:30:00
1004047	530.81	icd9	2023-08-20 10:00:00	2023-08-22 10:00:00
1004047	K21.9	icd10	2023-08-20 10:00:00	2023-08-24 10:00:00

Medication Admin Intermittent

This table has exactly the same schema as medication_admin_continuous described below. The consortium decided to separate the medications that are administered intermittently from the continuously administered medications. However, the CDE for medication_category remains undefined for medication_admin_intermittent.

Medication Orders

This table records the ordering (not administration) of medications. The table is in long form (one medication order per row) longitudinal table. Linkage to the medication_admin_continuous and medication_admin_intermittent tables is through the med_order_id field.

Variable Name	Data Type	Definition	Permissible Values
hospitalization_id	VARCHAR	Unique identifier for each hospitalization, linking medication orders to a specific encounter	No restrictions
med_order_id	VARCHAR	Unique identifier for each medication order	No restrictions
order_start_dttm	DATETIME	Date and time when the medication order was initiated	Datetime format should be %Y-%m-%d %H:%M:%S
order_end_dttm	DATETIME	Date and time when the medication order ended or was discontinued	Datetime format should be %Y-%m-%d %H:%M:%S
ordered_dttm	DATETIME	Date and time when the medication was actually ordered	Datetime format should be %Y-%m-%d %H:%M:%S
med_name	VARCHAR	Name of the medication ordered	No restrictions
med_category	VARCHAR	Maps med_name to a list of permissible medication names	Combined CDE of medication_admin_continuous and medication_admin_intermittent , under development
med_group	VARCHAR	Limited number of medication groups identified by the CLIF consortium
med_order_status_name	VARCHAR	Status of the medication order, e.g. “held”, or “given”	No restrictions
med_order_status_category	VARCHAR	Maps med_order_status_name to a standardized list of medication order statuses	Under-development
med_route_name	VARCHAR	Route of administration for the medication	No restrictions, Examples include Oral, Intravenous
med_dose	DOUBLE	Dosage of the medication ordered	Numeric
med_dose_unit	VARCHAR	Unit of measurement for the medication dosage	Examples include mg, mL, units
med_frequency	VARCHAR	Frequency with which the medication is administered, as per the order	Examples include Once Daily, Every 6 hours
prn	BOOLEAN	Indicates whether the medication is to be given “as needed” (PRN)	0 (No), 1 (Yes)

Example:

hospitalization_id	med_order_id	order_start_dttm	order_end_dttm	ordered_dttm	med_name	med_category	med_group	med_order_status_name	med_order_status_category	med_route_name	med_dose	med_dose_unit	med_frequency	prn
12345	456789	2023-10-01 14:00:00	2023-10-02 14:00:00	2023-10-01 13:30:00	Norepinephrine 8 mg/250 mL	norepinephrine	vasoactives	active	ongoing	Intravenous	8.0	mg/mL	Continuous	0
12346	456790	2023-10-01 16:00:00	2023-10-02 10:00:00	2023-10-01 15:30:00	Vancomycin 1 g IV	vancomycin	antibiotics	active	ongoing	Intravenous	1.0	g	Every 12 hours	0
12347	456791	2023-10-02 08:00:00	2023-10-03 08:00:00	2023-10-02 07:30:00	Furosemide 40 mg IV	furosemide	diuretics	discontinued	discontinued	Intravenous	40.0	mg	Once Daily	0
12348	456792	2023-10-02 12:00:00	2023-10-02 18:00:00	2023-10-02 11:45:00	Insulin Regular 100 units/mL SC	insulin	endocrine	held	held	Subcutaneous	100.0	units/mL	As Needed	1
12349	456793	2023-10-03 08:00:00	2023-10-03 20:00:00	2023-10-03 07:30:00	Acetaminophen 1 g PO	acetaminophen	analgesics	active	ongoing	Oral	1.0	g	Every 6 hours	0
12350	456794	2023-10-03 10:00:00	2023-10-03 18:00:00	2023-10-03 09:45:00	Heparin 5,000 units SC	heparin	anticoagulant	active	ongoing	Subcutaneous	5000.0	units	Every 8 hours	0
12351	456795	2023-10-03 14:00:00	2023-10-03 22:00:00	2023-10-03 13:30:00	Morphine Sulfate 2 mg IV	morphine	analgesics	active	ongoing	Intravenous	2.0	mg	As Needed	1
12352	456796	2023-10-03 20:00:00	2023-10-04 08:00:00	2023-10-03 19:45:00	Dexamethasone 10 mg IV	dexamethasone	steroids	active	ongoing	Intravenous	10.0	mg	Once Daily	0

Critical illness specific tables

Respiratory Support

The respiratory support table is a wider longitudinal table that captures simultaneously recorded ventilator settings and observed ventilator parameters. The table is designed to capture the most common respiratory support devices and modes used in the ICU. It will be sparse for patients who are not on mechanical ventilation.

Variable Name	Data Type	Definition	Permissible Values
hospitalization_id	VARCHAR	ID variable for each patient encounter
recorded_dttm	DATETIME	Date and time when the device settings and/or measurement was recorded.	Datetime format should be %Y-%m-%d %H:%M:%S
device_name	VARCHAR	Includes raw string of the devices. Not used for analysis	No restriction
device_category	VARCHAR	Maps device_name to a standardized list of respiratory support device categories	IMV, NIPPV, CPAP, High Flow NC, Face Mask, Trach Collar, Nasal Cannula, Room Air, Other
vent_brand_name	VARCHAR	Ventilator model name when device_category is IMV or NIPPV	No restriction
mode_name	VARCHAR	Includes raw string of the modes, e.g. “CMV volume control”	No restriction
mode_category	VARCHAR	Maps mode_name to a standardized list of modes of mechanical ventilation	Assist Control-Volume Control, Pressure Control, Pressure-Regulated Volume Control, SIMV, Pressure Support/CPAP, Volume Support, Other
tracheostomy	BOOLEAN	Indicates if tracheostomy is present	0 = No, 1 = Yes
fio2_set	DOUBLE	Fraction of inspired oxygen set in decimals (e.g. 0.21)	No restriction, see Expected _set values for each device_category and mode_category
lpm_set	DOUBLE	Liters per minute set	No restriction, see Expected _set values for each device_category and mode_category
tidal_volume_set	DOUBLE	Tidal volume set (in mL)	No restriction, see Expected _set values for each device_category and mode_category
resp_rate_set	DOUBLE	Respiratory rate set (in bpm)	No restriction, see Expected _set values for each device_category and mode_category
pressure_control_set	DOUBLE	Pressure control set (in cmH2O)	No restriction, see Expected _set values for each device_category and mode_category
pressure_support_set	DOUBLE	Pressure support set (in cmH2O)	No restriction, see Expected _set values for each device_category and mode_category
flow_rate_set	DOUBLE	Flow rate set	No restriction, see Expected _set values for each device_category and mode_category
peak_inspiratory_pressure_set	DOUBLE	Peak inspiratory pressure set (in cmH2O)	No restriction, see Expected _set values for each device_category and mode_category
inspiratory_time_set	DOUBLE	Inspiratory time set (in seconds)	No restriction, see Expected _set values for each device_category and mode_category
peep_set	DOUBLE	Positive-end-expiratory pressure set (in cmH2O)	No restriction, see Expected _set values for each device_category and mode_category
tidal_volume_obs	DOUBLE	Observed tidal volume (in mL)	No restriction
resp_rate_obs	DOUBLE	Observed respiratory rate (in bpm)	No restriction
plateau_pressure_obs	DOUBLE	Observed plateau pressure (in cmH2O)	No restriction
peak_inspiratory_pressure_obs	DOUBLE	Observed peak inspiratory pressure (in cmH2O)	No restriction
peep_obs	DOUBLE	Observed positive-end-expiratory pressure (in cmH2O)	No restriction
minute_vent_obs	DOUBLE	Observed minute ventilation (in liters)	No restriction
mean_airway_pressure_obs	DOUBLE	Observed mean airway pressure	No restriction

Expected *_set values for each device_category and mode_category

device_category == “IMV”

ventilator setting	Assist Control-Volume Control	Pressure Support/CPAP	Pressure Control	Pressure-Regulated Volume Control	SIMV	Volume Support
fio2_set	E	E	E	E	E	E
tidal_volume_set	E			E	P	E
resp_rate_set	E		E	E	E
pressure_control_set			E		P
pressure_support_set		E			E
flow_rate_set	P				P
inspiratory_time_set	P		E		P
peep_set	E	E	E	E	E	E

E = Expected ventilator setting for the mode, P = possible ventilator setting for the mode.

device_category == “NIPPV”

mode_category is Pressure Support/CPAP and the fio2_set, peep_set , and either pressure_support_set OR peak_inspiratory_pressure_set (IPAP) is required.

device_category == “CPAP”

mode_category is Pressure Support/CPAP and the fio2_set and peep_set are required.

device_category == “High Flow NC”

mode_category is NA and the fio2_set and lpm_set are required.

device_category == “Face Mask”

mode_category is NA lpm_set is required. fio2_set is possible.

device_category == “Trach Collar” or “Nasal Cannula”

mode_category is NA and lpm_set is required.

Example:

hospitalization_id	recorded_dttm	device_name	device_category	mode_name	mode_category	vent_brand_name	tracheostomy	fio2_set	lpm_set	tidal_volume_set	resp_rate_set	pressure_control_set	pressure_support_set	flow_rate_set	tidal_volume_obs	resp_rate_obs	plateau_pressure_obs	peak_inspiratory_pressure_obs	peep_obs	minute_vent_obs	mean_airway_pressure_obs
12345	2024-12-01 08:00	Ventilator	IMV	CMV Volume Ctrl	Assist Control-Volume Control	Vent A	1	0.50	40	500	18	15	5	50	450	18	20	25	5	9.0	12.0
12345	2024-12-01 09:00	Ventilator	IMV	SIMV	SIMV	Vent A	1	0.45	35	480	20	18	8	55	470	20	21	28	6	10.5	14.0
67890	2024-12-01 10:30	HFNC	High Flow NC	N/A	Other	N/A	0	0.30	60	NA	NA	NA	NA	60	NA	NA	NA	NA	NA	NA	NA
67890	2024-12-01 11:00	CPAP	CPAP	CPAP	Pressure Support/CPAP	CPAP X	0	0.40	50	NA	NA	NA	10	NA	NA	NA	NA	NA	8	NA	NA

Medication Admin Continuous

The medication admin continuous table is a long-form (one medication administration record per) longitudinal table designed for continuous infusions of common ICU medications such as vasopressors and sedation (Boluses of these drugs should be recorded in med_admin_intermittent). Note that it only reflects dose changes of the continuous medication and does not have a specific “end_time” variable to indicate the medication being stopped. The end of a continuous infusion should be recorded as a new row with med_dose = 0 and an appropriate mar_action_name (e.g. “stopped” or “paused”).

Variable Name	Data Type	Definition	Permissible Values
hospitalization_id	VARCHAR	ID variable for each patient encounter
med_order_id	VARCHAR	Medication order ID. Foreign key to link this table to other medication tables
admin_dttm	DATETIME	Date and time when the medicine was administered	Datetime format should be %Y-%m-%d %H:%M:%S
med_name	VARCHAR	Original med name string recorded in the raw data which often contains concentration e.g. “NOREPInephrine 8 mg/250 mL”
med_category	VARCHAR	Maps med_name to a limited set of active ingredients for important ICU medications, e.g. “norepinephrine”	List of continuous medication categories in CLIF
med_group	VARCHAR	Limited number of ICU medication groups identified by the CLIF consortium, e.g. “vasoactives”	List of continuous medication groups in CLIF
med_route_name	VARCHAR	Medicine delivery route	e.g. IV, enteral
med_route_category	VARCHAR	Maps med_route_name to a standardized list of medication delivery routes	Under-development
med_dose	DOUBLE	Quantity taken in dose
med_dose_unit	VARCHAR	Unit of dose. It must be a rate, e.g. mcg/min. Boluses should be mapped to med_admin_intermittent
mar_action_name	VARCHAR	MAR (medication administration record) action, e.g. “stopped”
mar_action_category	VARCHAR	Maps mar_action_name to a standardized list of MAR actions	Under-development

Example:

hospitalization_id	admin_dttm	med_name	med_category	med_group	med_route_name	med_route_category	med_dose	med_dose_unit	mar_action_name
792391	2123-11-13 12:28:00	PROPOFOL 10 MG/ML INTRAVENOUS EMULSION	propofol	sedation	Intravenous	NA	75.0000	mcg/kg/min	New Bag
792391	2123-11-13 13:49:00	REMIFENTANIL CONTINUOUS IV (ANESTHESIA)	remifentanil	sedation	NA	NA	0.0500	mcg/kg/min	New Bag
792391	2123-11-13 14:03:00	PROPOFOL 10 MG/ML INTRAVENOUS EMULSION	propofol	sedation	Intravenous	NA	0.0000	mcg/kg/min	Stopped
370921	2123-02-12 03:07:00	PHENYLEPHRINE 5 MG/50 ML (100 MCG/ML) IN 0.9 % SODIUM CHLORIDE	phenylephrine	vasoactives	Intravenous	NA	20.0000	mcg/min	New Bag
370921	2123-02-12 03:14:00	PHENYLEPHRINE 5 MG/50 ML (100 MCG/ML) IN 0.9 % SODIUM CHLORIDE	phenylephrine	vasoactives	Intravenous	NA	50.0000	mcg/min	Rate Change
702344	2123-04-27 04:30:00	HEPARIN (PORCINE) 25,000 UNIT/250 ML IN 0.45 % SODIUM CHLORIDE	heparin	anticoagulation	Intravenous	NA	18.0000	Units/kg/hr	New Bag

Position

The position table is a long form (one position per row) longitudinal table that captures all documented position changes of the patient. The table is designed for the explicit purpose of constructing the position_category CDE and identifying patients in prone position.

Variable Name	Data Type	Definition	Permissible Values
hospitalization_id	VARCHAR	ID variable for each patient encounter. This table only includes those encounters that have proning documented ever.
recorded_dttm	DATETIME	Date and time when the vital is recorded.	Datetime format should be %Y-%m-%d %H:%M:%S
position_name	VARCHAR	This field is used to store the description of the position from the source data. This field is not used for analysis.	No restriction
position_category	VARCHAR	Maps position_name to either prone or not prone.	prone, not_prone

Example:

hospitalization_id	recorded_dttm	position_name	position_category
84	2123-06-20 00:00:00	Supine–turn R	not_prone
84	2123-06-20 06:00:00	Supine–turn L	not_prone
84	2123-06-20 12:00:00	Supine–back	not_prone
84	2123-06-20 16:00:00	Supine–turn R	not_prone
84	2123-06-20 20:00:00	Supine–back;Supine–turn intolerant	not_prone
84	2123-06-20 22:00:00	Supine–turn intolerant,microturn L	not_prone
84	2123-06-20 00:00:00	Supine–turn intolerant,microturn L;Supine–back	not_prone
84	2123-06-20 01:10:00	30 Degrees	not_prone

Dialysis

The dialysis table is a wider longitudinal table that captures the start and stop times of dialysis sessions, the type of dialysis performed, and the amount of dialysate flow and ultrafiltration.

Variable Name	Data Type	Definition	Permissible values
hospitalization_id	VARCHAR	ID variable for each patient encounter
start_dttm	DATETIME	Start date and time of dialysis session	Datetime format %Y-%m-%d %H:%M:%S
stop_dttm	DATETIME	Stop date and time of dialysis session	Datetime format %Y-%m-%d %H:%M:%S
dialysis_type_name	VARCHAR	Name of dialysis type	No restriction
dialysis_type_category	VARCHAR	Maps dialysis_type_name to a list of standardized dialysis types	intermittent, peritoneal, crrt
crrt_mode_name	VARCHAR	Name of the CRRT mode, e.g. “CVVHD”	No restriction
crrt_mode_category	VARCHAR	Maps crrt_mode_name to a standardized list of CRRT modes	under development
fluid_removal_amt	DOUBLE	Amount of fluid removed during dialysis	Numeric
dialysate_flow_rate	DOUBLE	Rate of dialysate flow	Numeric

Example:

hospitalization_id	start_dttm	stop_dttm	dialysis_type_name	dialysis_type_category	crrt_mode_name	crrt_mode_category	fluid_removal_amt	dialysate_flow_rate
101	2024-01-01 08:00:00	2024-01-01 12:00:00	Hemodialysis	intermittent	NA	NA	2500.0	500.0
102	2024-01-02 10:00:00	2024-01-02 14:30:00	CRRT	crrt	CVVHD	continuous venovenous hemodialysis	1500.0	700.0
103	2024-01-03 09:30:00	2024-01-03 13:30:00	Peritoneal Dialysis	peritoneal	NA	NA	2000.0	NA
104	2024-01-04 11:00:00	2024-01-04 15:00:00	CRRT	crrt	CVVHDF	continuous venovenous hemodiafiltration	1800.0	600.0

ECMO_MCS

The ECMO/MCS table is a wider longitudinal table that captures the start and stop times of ECMO/MCS support, the type of device used, and the work rate of the device.

Variable Name	Description
hospitalization_id	Unique identifier for the hospitalization event.
recorded_dttm	Date and time when the device settings and/or measurement was recorded.
device_name	Name of the ECMO/MCS device used including brand information, e.g. “Centrimag”
device_category	Maps device_name to a standardized list of ECMO or MCS
device_metric_name	String that captures the measure of work rate of the device, e.g., RPMs.
device_rate	Numeric value of work rate, e.g., 3000 RPMs.
flow	Blood flow in L/min.
sweep	Gas flow rate in L/min.

Example:

hospitalization_id	start_dttm	end_dttm	device_name	device_category	device_metric_name	device_rate	flow	sweep
1001	2024-01-01 08:00:00	2024-01-03 10:00:00	Centrimag	MCS	RPMs	3000	4.5	NA
1002	2024-01-05 12:00:00	2024-01-07 14:30:00	ECMO VV	ECMO	Flow Rate	NA	5.2	2.0
1003	2024-01-10 09:00:00	2024-01-12 15:45:00	TandemHeart	MCS	RPMs	2800	3.8	NA
1004	2024-01-15 14:00:00	2024-01-17 16:00:00	ECMO VA	ECMO	Sweep	NA	4.1	3.5

Intake_Output

The intake_output table is long form table that captures the times intake and output events were recorded, the type of fluid administered or recorded as “out”, and the amount of fluid.

Variable Name	Description
hospitalization_id	Unique identifier for the hospitalization event.
intake_dttm	Date and time of intake.
fluid_name	Name of the fluid administered.
amount	Amount of fluid administered (in mL).
in_out_flag	Indicator for intake or output (1 for intake, 0 for output).

Example:

hospitalization_id	intake_dttm	fluid_name	amount	in_out_flag
1001	2024-01-01 08:00:00	Normal Saline	500	1
1001	2024-01-01 10:30:00	Urine	300	0
1002	2024-01-05 09:15:00	Dextrose	250	1
1002	2024-01-05 14:00:00	Urine	400	0
1003	2024-01-10 07:45:00	Lactated Ringer’s	600	1
1003	2024-01-10 12:00:00	Drainage	200	0

Therapy_Details

The therapy_details table is a wide longitudinal table that captures the details of therapy sessions. The table is designed to capture and categorize the most common therapy elements used in the ICU.

Variable Name	Description
hospitalization_id	Unique identifier for the hospitalization event.
session_start_dttm	Date and time when the therapy session started.
therapy_element_name	Name of the therapy element.
therapy_element_category	Category of the therapy element.
therapy_element_value	Value associated with the therapy element.

Example:

hospitalization_id	session_start_dttm	therapy_element_name	therapy_element_category	therapy_element_value
1001	2024-01-01 08:00:00	Physical Therapy	Rehabilitation	45.0
1001	2024-01-01 10:00:00	Respiratory Therapy	Respiratory Support	3.0
1002	2024-01-05 09:30:00	Occupational Therapy	Rehabilitation	60.0
1002	2024-01-05 11:00:00	Speech Therapy	Rehabilitation	30.0
1003	2024-01-10 07:00:00	Ventilation Support	Respiratory Support	2.5

Microbiology Culture

The microbiology culture table is a wide longitudinal table that captures the order and result times of microbiology culture tests, the type of fluid collected, the component of the test, and the organism identified.

Variable Name	Data Type	Definition	Permissible Values
hospitalization_id	VARCHAR	ID variable for each patient encounter.
order_dttm	DATETIME	Date and time when the test is ordered.	Datetime format should be %Y-%m-%d %H:%M:%S
collect_dttm	DATETIME	Date and time when the specimen is collected.	Datetime format should be %Y-%m-%d %H:%M:%S
result_dttm	DATETIME	Date and time when the results are available.	Datetime format should be %Y-%m-%d %H:%M:%S
fluid_name	VARCHAR	Cleaned fluid name string from the raw data. This field is not used for analysis.	No restriction. Check this file for examples
fluid_category	VARCHAR	Fluid categories defined according to the NIH common data elements.	CDE NIH Infection Site
component_name	VARCHAR	Original component names from the source data.	No restriction
component_category	VARCHAR	Maps component_name to a standardized list of component categories	culture, gram stain, smear
organism_name	VARCHAR	Cleaned organism name string from the raw data. This field is not used for analysis.	No restriction. Check this file for examples
organism_category	VARCHAR	Maps organism_name to the standardized list of organisms in the NIH CDE	CDE NIH Organism

Example:

hospitalization_id	order_dttm	collect_dttm	result_dttm	fluid_name	fluid_category	component_name	component_category	organism_name	organism_category
12345	2023-10-01 14:00:00	2023-10-01 15:00:00	2023-10-03 10:00:00	culture, blood (bacterial & fungal)	blood/buffy coat	culture	culture	no growth	no growth
12345	2023-10-01 16:00:00	2023-10-01 17:00:00	2023-10-03 12:00:00	culture, urine	genito-urinary tract	culture	culture	escherichia_coli	escherichia (also e. coli)
12346	2023-11-01 10:30:00	2023-11-01 11:15:00	2023-11-02 09:00:00	culture & stain, respiratory	lower respiratory tract	gram stain	gram stain	gram positive cocci	gram positive cocci (nos)
12346	2023-11-02 12:00:00	2023-11-02 12:45:00	2023-11-03 08:30:00	culture, cerebrospinal fluid	csf	culture	culture	no growth	no growth
12347	2023-09-15 14:20:00	2023-09-15 15:00:00	2023-09-17 11:30:00	culture & stain, afb	other unspecified	afb smear	smear	no growth	no growth
12348	2023-08-10 09:00:00	2023-08-10 09:45:00	2023-08-12 08:00:00	culture, blood (bacterial & fungal)	blood/buffy coat	culture	culture	staphylococcus_aureus	staphylococcus (all)
12349	2023-07-25 11:00:00	2023-07-25 11:30:00	2023-07-27 10:15:00	culture, urine	genito-urinary tract	culture	culture	enterococcus_faecium	enterococcus (all species)
12350	2023-06-15 13:30:00	2023-06-15 14:00:00	2023-06-17 09:45:00	culture & stain, respiratory	lower respiratory tract	gram stain	gram stain	gram negative rod	gram negative rod (nos)

Sensitivity

This table is used to store the susceptibility results of the organisms identified in the Microbiology Culture table and may be renamed to Microbiology_Susceptibility

Variable Name	Data Type	Definition	Permissible Values
culture_id	VARCHAR	Unique identifier linking to the culture from which the sensitivity test was performed
antibiotic	VARCHAR	Name of the antibiotic tested for sensitivity	Examples include Penicillin, Vancomycin
sensitivity	VARCHAR	The result of the sensitivity test, indicating the organism’s resistance or susceptibility	Resistant, Intermediate, Susceptible
mic	DOUBLE	Minimum Inhibitory Concentration (MIC) value, which measures the lowest concentration of an antibiotic needed to inhibit growth

Example:

culture_id	antibiotic	sensitivity	mic
1001	Penicillin	Susceptible	0.25
1001	Vancomycin	Resistant	8.0
1002	Amoxicillin	Intermediate	4.0
1003	Ciprofloxacin	Susceptible	0.5
1004	Gentamicin	Resistant	16.0

Microbiology_Nonculture

The microbiology non-culture table is a wide longitudinal table that captures the order and result times of non-culture microbiology tests, the type of fluid collected, the component of the test, and the result of the test.

Variable Name	Description
hospitalization_id	Unique identifier for the hospitalization event.
result_dttm	Date and time when the non-culture result was obtained.
collect_dttm	Date and time when the sample was collected.
order_dttm	Date and time when the test was ordered.
fluid_name	Name of the fluid sample.
component_category	Category of the component tested.
result_unit_category	Unit category of the test result.
result_category	Category of the test result.

Example:

hospitalization_id	result_dttm	collect_dttm	order_dttm	fluid_name	component_category	result_unit_category	result_category
101	2024-01-01 10:00:00	2024-01-01 08:00:00	2024-01-01 07:30:00	Blood	PCR	Units/mL	Positive
102	2024-01-02 11:30:00	2024-01-02 09:30:00	2024-01-02 08:15:00	Cerebrospinal Fluid	Antigen Detection	mg/L	Negative
103	2024-01-03 15:00:00	2024-01-03 13:00:00	2024-01-03 12:45:00	Sputum	Gene Amplification	copies/mL	Detected
104	2024-01-04 09:45:00	2024-01-04 07:15:00	2024-01-04 06:30:00	Urine	Molecular Pathogen ID	ng/mL	Not Detected
105	2024-01-05 18:00:00	2024-01-05 16:00:00	2024-01-05 15:00:00	Pleural Fluid	Protein Quantification	g/dL	Elevated

Procedures

A longitudinal record of each bedside ICU procedure performed on the patient (e.g. central line placement, chest tube placement). Note that this table is not intended to capture the full set of procedures performed on inpatients.

Variable Name	Data Type	Definition	Permissible Values
hospitalization_id	VARCHAR	Unique identifier for each hospitalization, linking the procedure to a specific encounter
procedure_name	VARCHAR	Name of the procedure performed on the patient	Examples include “Central Line Placement”
procedure_category	VARCHAR	Maps procedure_name to a list of standardized procedures	CDE under development
diagnosis	VARCHAR	The diagnosis or reason for performing the procedure
start_dttm	DATETIME	Date and time when the procedure was initiated

Example:

hospitalization_id	procedure_name	procedure_category	diagnosis	start_dttm
1001	Central Line Placement	Vascular Access	Sepsis with hypotension	2024-01-01 08:00:00
1001	Chest Tube Placement	Respiratory Support	Pneumothorax	2024-01-01 10:00:00
1002	Endotracheal Intubation	Airway Management	Acute Respiratory Failure	2024-01-05 09:30:00
1002	Paracentesis	Diagnostic Procedure	Suspected peritonitis	2024-01-05 11:00:00
1003	Arterial Line Placement	Vascular Access	Hemodynamic Monitoring	2024-01-10 07:00:00

Transfusion

This table provides detailed information about transfusion events linked to specific hospitalizations.

Variable Name	Data Type	Definition	Permissible Values
hospitalization_id	VARCHAR	Unique identifier linking the transfusion event to a specific hospitalization in the CLIF database.	Unique identifier, e.g., 123456
transfusion_start_dttm	DATETIME	The date and time the transfusion of the blood component began.	Example: 2024-12-03 08:30:00
transfusion_end_dttm	DATETIME	The date and time the transfusion of the blood component ended.	Example: 2024-12-03 10:00:00
component_name	VARCHAR	The name of the blood component transfused.	E.g., Red Blood Cells, Plasma, Platelets
attribute_name	VARCHAR	Attributes describing modifications to the component.	E.g., Leukocyte Reduced, Irradiated
volume_transfused	DOUBLE	The volume of the blood component transfused.	Example: 300
volume_units	VARCHAR	The unit of measurement for the transfused volume.	Example: mL
product_code	VARCHAR	ISBT 128 Product Description Code representing the specific blood product.	Example: E0382

Example:

hospitalization_id	transfusion_start_dttm	transfusion_end_dttm	component_name	attribute_name	volume_transfused	volume_units	product_code
123456	2024-12-03 08:30:00	2024-12-03 10:00:00	Red Blood Cells	Leukocyte Reduced	300	mL	E0382
789012	2024-12-04 14:00:00	2024-12-04 16:30:00	Platelets	Irradiated	250	mL	P0205
456789	2024-12-05 12:15:00	2024-12-05 13:45:00	Plasma		200	mL	F0781

Code Status

This table provides a longitudinal record of changes in a patient’s code status during their hospitalization. It tracks the timeline and categorization of code status updates, facilitating the analysis of care preferences and decisions.

Variable Name	Data Type	Definition	Permissible Values
hospitalization_id	VARCHAR	Unique identifier linking the code status event to a specific hospitalization in the CLIF database.	Unique identifier, e.g., 123456
start_dttm	DATETIME	The date and time when the specific code status was initiated.	Example: 2024-12-03 08:30:00
code_status_name	VARCHAR	The name/description of the code status.	Free text to describe the code status.
code_status_category	VARCHAR	Categorical variable specifying the code status during the hospitalization.	E.g., DNR, UDNR, DNR/DNI, Full, Presume Full, Other

Notes:

• The code_status_category set of permissible values is under development

Example:

hospitalization_id	start_dttm	code_status_name	code_status_category
12345	2024-12-01T08:30:00	Do Not Resuscitate	DNR
12345	2024-12-02T14:00:00	Do Not Intubate	DNR/DNI
12345	2024-12-03T10:15:00	Full Code	Full

Invasive Hemodynamics

The invasive_hemodynamics table records invasive hemodynamic measurements during a patient’s hospitalization. These measurements represent pressures recorded via invasive monitoring and are expressed in millimeters of mercury (mmHg).

Column Name	Data Type	Description	Permissible Values
hospitalization_id	VARCHAR	Unique identifier linking to the specific hospitalization.	N/A
recorded_dttm	DATETIME	The date and time when the measurement was recorded.	N/A
measure_name	VARCHAR	Description of the site or context of the invasive hemodynamic measurement.	Free text (e.g., “Right Atrium”)
measure_category	VARCHAR	Categorical variable specifying the type of invasive hemodynamic measurement.	CVP, RA, RV, PA_systolic, PA_diastolic, PA_mean, PCWP
measure_value	DDOUBLE	The numerical value of the invasive hemodynamic measurement in mmHg.	Positive decimal values (e.g., 5.00, 25.65)

Notes:

• All measure_value entries should be recorded in mmHg.
• The measure_category field ensures standardization of invasive hemodynamic data.
  • CVP - Central Venous Pressure
  • RA - Right Atrial Pressure
  • RV - Right Ventricular Pressure
  • PA_systolic - Pulmonary Artery Systolic Pressure
  • PA_diastolic - Pulmonary Artery Diastolic Pressure
  • PA_mean - Pulmonary Artery Mean Pressure
  • PCWP - Pulmonary Capillary Wedge Pressure

Example:

hospitalization_id	recorded_dttm	measure_name	measure_category	measure_value
12345	2024-12-01T08:30:00	CVP	CVP	12.50
12345	2024-12-01T09:00:00	Pulmonary Artery-Sys	PA_systolic	25.00
12345	2024-12-01T09:30:00	Wedge	PCWP	18.75

Key ICU orders

The key_icu_orders table captures key orders related to physical therapy (PT) and occupational therapy (OT) during ICU stays. It includes details about the hospitalization, the timing of the order, the specific name of the order, its category, and the status of the order (completed or sent).

Column Name	Data Type	Description	Permissible Values
hospitalization_id	VARCHAR	Unique identifier linking the order to a specific hospitalization.	N/A
order_dttm	DATETIME	Date and time when the order was placed.	Datetime format should be %Y-%m-%d %H:%M:%S
order_name	VARCHAR	Name of the specific order (e.g., “PT Evaluation”, “OT Treatment”).	N/A
order_category	VARCHAR	Category of the order. Permissible values are:	Under-development. Some examples include: PT_evaluation, PT_treat, OT_evaluation, OT_treat
order_status_name	VARCHAR	Status of the order. Permissible values are:	sent, completed

Example:

hospitalization_id	order_dttm	order_name	order_category	order_status_name
12345	2024-12-15 10:00:00	PT Initial Evaluation	PT_evaluation	completed
67890	2024-12-16 14:30:00	OT Follow-up Treatment	OT_treat	sent
54321	2024-12-16 08:00:00	PT Mobility Session	PT_treat	completed
98765	2024-12-15 11:15:00	OT Cognitive Assessment	OT_evaluation	sent

Future proposed tables

These are tables without any defined structure that the consortium has not yet committed to implementing.

• Clinical Decision Support: This table will capture the actions of clinical decision support tools embedded in the EHR. The table will have the following fields: cds_name, cds_category, cds_value, cds_trigger_ddtm.