Allscripts TouchWorks

Allscripts is the health record system for UT Physicians. Allscripts contains data on patients seen in outpatient UT clinics, including laboratory data. Allscripts does not contain information on patients seen in an inpatient setting. Tables of commonly requested information are presented. Data are loaded into the CDW nightly.

Datamart last refreshed: 2021-12-20
# of patients in TouchWorks
Type of Query Number of Records
Patients with clinical data 3,674,357

The EHR contains demographic information on several million patients. However, the Clinical Data Warehouse has measures which reduce the total counts:

  • Exclusion of records without a complete encounter at a UT Physicians clinic
  • Exclusion of records missing all of the clinical data elements shown here
  • De-duplication algorithms to account for duplicate records

Thus, the final counts loaded into our i2b2 instance will be lower than the total records in Centricity.

# of patients in datamart
Type of Query Number of Records
Patients w/Image Notes 1,615,136
Patients w/Immunizations 321,673
Patients w/Labs 846,958
Patients w/Medications 833,776
Patients w/Text Notes 1,617,898
Patients w/Vitals 939,726
Patients with any observation 1,810,404
Total Patients 2,057,540
Common immunizations in Allscripts
Immunizations Total Records
DTaP 106,128 - 2.72%
DTaP, unspecified formulation 173,043 - 4.43%
hepatitis A vaccine, pediatric/adolescent dosage, 104,447 - 2.67%
Hepatitis B, pediatric/adolescent dosage 130,902 - 3.35%
Hib, Haemophilus influenzae type b vaccine, PRP-T 101,543 - 2.60%
influenza virus vaccine, unspecified formulation 92,711 - 2.37%
Ipol Injection Injectable 120,715 - 3.09%
PCV 13, pneumococcal conjugate vaccine, 13 valent 109,339 - 2.80%
PNEUMO (7VAL) 185,335 - 4.75%
Prevnar 13 Intramuscular Suspension 143,121 - 3.66%