Table 1.
Data type | Description | Relevance | Example |
---|---|---|---|
Patient demographics | Age, gender, race/ethnicity, primary language | Examines prevalence, management, and disparities in chronic conditions by individual characteristics | What percent of children are diagnosed with asthma? |
Geographic location and demographics | County and census tract of residence, American Community Survey measures | Examines how differences in social and environmental characteristics within a region are associated with chronic conditions | How is neighborhood poverty associated with treatment adherence for diabetes? |
Encounters | Date, and encounter type | Examines how frequency and timing of patient visits affect prevention and management of chronic conditions | How frequently are adults with depression seen? |
Diagnoses and procedures | ICD-9/10 diagnosis code, date of diagnosis, procedure type and date | Calculates prevalence of diagnosed chronic health conditions and related procedures | What percent of adults have been diagnosed with high blood pressure? |
Laboratory results | Test type, date of test, result | Captures undiagnosed chronic conditions and examine screening rates | What percent of Denver adults have been tested for hepatitis C virus? |
Pharmacy | Outpatient prescription orders and dispenses | Examines relationship between diagnosis of chronic conditions and pharmaceutical treatment for these conditions | What percent of adults with high cholesterol are prescribed cholesterol-lowering medication? |
Vital signs | Objectively-measured height, weight, blood pressure | Adds to diagnostic information to examine relationships of vital signs to chronic condition prevalence | What percent of adults are overweight or obese? What percent of adults with hypertension are well controlled? |
Social History | Self-reported data on tobacco use and exposure, alcohol/drug use | Examines the relationship between health behaviors and chronic conditions | What percent of children are exposed to second hand smoke? |
Note: Table is organized to the common data model (CDM); only a portion of the 17 CDM tables are presented here.