Data Dictionaries and Common Categories

These are some of the most relevant tables and columns in our data warehouse and various source systems.


Aggregate counts of all fields are available through i2b2.

More detailed information from patient records can be provided upon request with appropriate IRB approval.



GE Centricity - Administrative (Historical Data Source)

GE Centricity was the billing system used by UTPhysicians providers until 2021. This includes administrative data like transactions with charged procedure codes, and invoiced diagnosis codes. The data was collected from all Houston area hospitals serviced by UTPhysician providers, including Memorial Hermann, Lyndon B. Johnson, and Harris Health.
This data source is no longer being updated.

Demographics

Column Number of Records Unique Values Top 5 Most Common Values
Sex None None Female (3303977, 54.57%)
Male (2727903, 45.06%)
Unknown (20492, 0.34%)
Other (2029, 0.03%)
 

Transactions

Column Number of Records Unique Values Top 5 Most Common Values

Invoices

Column Number of Records Unique Values Top 5 Most Common Values

Allscripts Touchworks CDW - Clinical Data (Historical Data Source)

Touchworks by Allscripts was the primary Electronic Health Record system used by UTPhysicians until the switch to Epic in 2021. Patient charts and clinical data from all UTPhysicians clinics was aggregated into a searchable data warehouse by BIG-ARC.
This data source is no longer being updated.

Vitals

Column Number of Records Unique Values Top 5 Most Common Values

Immunizations

Column Number of Records Unique Values Top 5 Most Common Values

Labs

Column Number of Records Unique Values Top 5 Most Common Values

Appointments

Column Number of Records Unique Values Top 5 Most Common Values

Medications

Column Number of Records Unique Values Top 5 Most Common Values
 
Gentelella - Bootstrap Admin Template by Colorlib