patient_ID |
Auto-generated unique identifier for each patient |
clinic_code |
Identifies site at which care is being provided |
sex |
Sex |
ethnicity |
Ethnicity |
age |
Age |
start_date |
Date on which patient was added to the electronic record |
raw_code (health) |
Health condition |
start_date (health) |
Date on which diagnosis was added to the patient health profile |
end_date (health) |
Date on which diagnosis was archived in the patient health profile |
raw_code (lab) |
Laboratory test |
result (lab) |
Laboratory result |
service_date (lab) |
Date on which lab result was received |
raw_code (service) |
Service |
result (service) |
Service result |
service_date (service) |
Date on which service was provided |
raw_code (medication) |
Medication |
start_date (medication) |
Date on which medication was prescribed |
end_date (medication) |
Date on which medication was discontinued |
visit_date |
Date on which office visit occurred |
bp_systolic |
Systolic blood pressure (linked to visit_date) |
bp_diastolic |
Diastolic blood pressure (linked to visit_date) |
weight |
Weight (linked to visit_date) |
height |
Height (linked to visit_date) |
waist_circ |
Waist circumference (linked to visit_date) |