HEALTHCARE COST & UTILIZATION PROJECT

User Support

Do Your own analysis
Explore Expert Research & Limited Datasets

Florida Project Summary

Florida Agency for Healthcare Administration logo

Adding Clinical Data to Statewide Administrative Data Pilot Project

The Agency for Health Care Administration (AHCA), Florida Center for Health Information and Policy Analysis, was awarded a contract from the Agency for Healthcare Research and Quality (AHRQ) that runs through September 2009 for a pilot project to study new ways to approach hospital quality measures. The pilot project funding is provided to add clinical laboratory data to the hospital administrative data already collected by the Agency under statutory authority. By adding clinical data to administrative data, AHRQ hopes to develop better predictors for hospital quality indicators. Florida is one of only three states that have received these grants.

Research has found that through the addition of present on admission to diagnoses it was possible to create risk adjustment models that have discriminatory power for rating hospital performance on selected AHRQ Inpatient Quality Indicators and Patient Safety Indicators.

One purpose of the pilot project is to demonstrate and evaluate the process required to 1) standardize laboratory data into a common nomenclature; 2) merge clinical data with hospital administrative data; 3) complete a statistical analysis of the merged dataset; 4) assess the added value of using clinical data to evaluate the quality of patient care within hospitals; 5) and describe all findings in a Final Report.

The Agency will work with 3M Health Information Systems, Inc (3M HIS) and the pilot hospitals to map their laboratory values to standardized Logical Observation Identifiers Names and Codes (LOINC) terminology and to evaluate the extent to which the 3M risk-adjustment model can be used in public hospital performance comparisons and can be made more accurate with the availability of the clinical data. During this contract (see Process Flowchart page 3):

The Agency will

3M HIS will:

Hospitals will:

For more information, visit the website at: http://ahca.myflorida.com/search/index.shtml?cx=012521305296577922040%3Apfndlojhd-4&cof=FORID%3A11&ie=UTF-8&q=adding+clinical+data+project&siteurl=ahca.myflorida.com%2Findex.shtml#943.Exit Disclaimer

Table 1: Clinical and Demographic Data Elements for the Pilot Project

Clinical Data Elements Abbreviation Low High Units
SGOT AST 8 35 U/L
CPK MB CKMB 0 3 ng/mL
Potassium K 3.5 5.1 mmol/L or mEq/L
Sodium Na 135 145 mmol/L or mEq/L
Troponin I TnT   <0.10 ng/ml
pH pH 7.35 7.45  
PO2.sat PO2 80 90 mmHg
pCO2 pCO2 35 45 mmHg
Prothrombin time- International Normalized Ratio (PT-INR) PT 11 13 seconds
Albumin ALB 35 50 g/L
Base Excess   -3 3  
Total bilrubin fractions Tbil 2 14 umol/L
Calcium (total) Ca 8.6 10.1 mg/dl
Calcium (ionized) Ical 1.15 1.29 mmol/L or mEq/L
Creatinine CREAT 0.7 1.3 mg/dL
Glucose GLUC 70 105 mg/dL
Alkaline phosphatase ALP 40 130 U/L
Blood urea nitrogen BUN 7 18 mg/dL
Hematocrit (Indices - MCV MCH) HCT      
Hematocrit (male) HCT 38 52 %
Hematocrit (female) HCT 35 47 %
Mean cell Hemoglobin MCH 26 34 pg
Mean Cell volume MCV 80 98 fl
Platelets Plt 150 400 x109/L or K/mm3
White blood cell count WBC 4 11 x109/L or K/mm3
Chloride Cl 95 108 mmol/L or mEq/L
Bicarbonate HCO3 22 26 mEq/L
Gamma glutamyl transferase GGT   50 U/L
SGPT ALT 8 40 U/L
Phosphorous PO4 1.9 4.7 mg/dL
Total Hemoglobin (male) HGB 14 18 g/dL
Total Hemoglobin (female) HGB 12 16 g/dL
Partial thromboplastin time PTT 29 41 seconds


Additional Lab Data Elements
Date of specimen Run
Time of Specimen Run
Type of test performed
Type of test performed
Demographic Data Elements Strong Width
Date of birth    
Gender string 1
Ethnicity string 1
Social Security Number Number 9
Zip Code string 5
the Agency Hospital Identification Number Number 8
Hospital unique patient tracking number or Billing number    
Admission Date    
Discharge Record date    
Discharge Record quarter    

FL AHCA / AHRQ Project Adding Clinical Data to Statewide Administrative Data Process Flow Chart

First, AHCA identifies participating pilot project hospitals with Electronic Lab Records. Then, Hospitals do the following:

  1. Hospital SMEs and technical staff provide lab test catalog terminology to 3M.
    1. 3M normalization and mapping of lab terminology via LOINC
  2. QA of LOINC normalized lab technology
    1. 3M normalization and mapping of lab terminology via LOINC
  3. Lab data translation based on LOINC mapping and QA of translated data
  4. Data files saved into comma separated value (CSV) Format
  5. Hospitals upload data sets to their secure FTP AHCA site (one site per hospital system)

Then, AHCA, with 3M technical support and a 3M database design technical discussion:

  1. Download lab records from AHCA FTP sites
  2. Insert data in Oracle database
  3. Merge lab records with administrative data for a joined record set
  4. Upload joined record set to FTP site

After the joined record set is uploaded to the FTP site, independent contractor analysis occurs, followed by an independent contractor summary report. Then, 3M:

  1. Download joined record set from the FTP site
  2. Create APR DRG groupings and perform a preliminary analysis
  3. Summary report

Then, the hospitals' review and feedback, with the 3M summary report and independent contractor summary report, inform the AHCA final report.


Internet Citation: Florida Project Summary. Healthcare Cost and Utilization Project (HCUP). July 2016. Agency for Healthcare Research and Quality, Rockville, MD. www.hcup-us.ahrq.gov/datainnovations/clinicaldata/FL10AHRQprojectsummarytoHospitals.jsp.
Are you having problems viewing or printing pages on this website?
If you have comments, suggestions, and/or questions, please contact hcup@ahrq.gov.
Privacy Notice, Viewers & Players
Last modified 7/20/16