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.
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:
Then, AHCA, with 3M technical support and a 3M database design technical discussion:
After the joined record set is uploaded to the FTP site, independent contractor analysis occurs, followed by an independent contractor summary report. Then, 3M:
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 |