-
hcup-us.ahrq.gov/datainnovations/clinicaldata/AdvisoryCouncilmeeting12032009_rev.pdf
December 31, 2007 - performed
Gamma glutamyl
transferase
Prothrombin time Reference range of test
Agency for Health … Florida Center for Health Information and Policy Analysis
Lab Result Interface Code Comparisons
Lab Test … Florida Center for Health Information and Policy Analysis
Lab Result Interface Code Comparisons
Lab Test … Clinically determined erroneous
laboratory test results were
excluded from the analysis file. … To justify such costs the operational value of the availability
of the laboratory test results
-
hcup-us.ahrq.gov/datainnovations/clinicaldata/AppendixL_HL7DataTransmissionReqs.jsp
December 07, 2010 - Please note that OBX, Field 7 contains the normal range for the test performed on the patient identified … code
4
Observation Sub-ID
20
No
5
Observation Value
9999
Yes
Value of test … with the hospitalization, NTE[BAR]2 for a note concerning the second laboratory test, OBX[BAR]3 for … the results of the third laboratory test associated with the hospitalization, PV1[BAR]2 for the second … with the second hospitalization, OBX[BAR]2 for the results of the second laboratory test associated
-
hcup-us.ahrq.gov/db/nation/neds/stats/NEDS_2020_Hospital_MaskedStats.PDF
January 01, 2020 - Median 4.89 Variance 0.60
Mode 5.00 Range 4.00
Interquartile Range 0.29
Tests for Location: Mu0=0
Test … Mode 1,164,255.00 Range 6,071,480.00
Interquartile Range 1,426,133.00
Tests for Location: Mu0=0
Test … Variance 4,067.01
Mode 247.00 Range 245.00
Interquartile Range 92.00
Tests for Location: Mu0=0
Test … 12.00 Variance 160.97
Mode 2.00 Range 48.00
Interquartile Range 18.00
Tests for Location: Mu0=0
Test … Tests for Location: Mu0=0
Test Statistic p Value
Student's t t 30.02943 Pr > |t| <.0001
Sign M 497.5
-
hcup-us.ahrq.gov/db/nation/kid/tools/stats/KID_2022_MaskedStats_Hospital.PDF
January 01, 2022 - 6785286854.57
Mode 17,719.00 Range 370,624.00
Interquartile Range 79,594.00
Tests for Location: Mu0=0
Test … Variance 4,836.93
Mode 292.00 Range 290.00
Interquartile Range 104.00
Tests for Location: Mu0=0
Test … 1403451160.45
Mode 5,326.00 Range 173,787.00
Interquartile Range 29,692.00
Tests for Location: Mu0=0
Test … Variance 1,950.86
Mode 104.00 Range 187.00
Interquartile Range 65.00
Tests for Location: Mu0=0
Test … 16,011,111.44
Mode 1,029.00 Range 17,157.00
Interquartile Range 4,480.00
Tests for Location: Mu0=0
Test
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/hi27.jsp
September 01, 2014 - Objective
To link thirty-two specific laboratory test results from CY 2008-2011 with Hawaii Health … Laboratory test (observation value): The lab value is required to assign the adjusted risk of mortality … If the observation value was missing, the lab test was excluded. … Result
Test Result is Required
Observation Value
Observation values must be numeric … result status is not "Final" or "Corrected"
11,333
Test Result is a Microbiology
1,083,269
-
hcup-us.ahrq.gov/db/nation/nrd/stats/MaskedStats_NRD_2022_Hospital.PDF
January 01, 2022 - Variance 3.32142E11
Mode 191777.0 Range 3170736
Interquartile Range 543849
Tests for Location: Mu0=0
Test … Variance 7463
Mode 367.0000 Range 363.00000
Interquartile Range 57.00000
Tests for Location: Mu0=0
Test … Variance 8.69722E10
Mode 67080.0 Range 1380623
Interquartile Range 263109
Tests for Location: Mu0=0
Test … Variance 1305
Mode 33.00000 Range 142.00000
Interquartile Range 32.00000
Tests for Location: Mu0=0
Test
-
hcup-us.ahrq.gov/db/nation/nrd/stats/MaskedStats_NRD_2020_Hospital.PDF
January 01, 2020 - Variance 3.6096E11
Mode 180120.0 Range 3046695
Interquartile Range 559697
Tests for Location: Mu0=0
Test … Variance 6724
Mode 352.0000 Range 349.00000
Interquartile Range 79.00000
Tests for Location: Mu0=0
Test … Variance 7.98878E10
Mode 58114.0 Range 1255798
Interquartile Range 322928
Tests for Location: Mu0=0
Test … Variance 1134
Mode 37.00000 Range 134.00000
Interquartile Range 35.00000
Tests for Location: Mu0=0
Test
-
hcup-us.ahrq.gov/db/nation/nrd/stats/MaskedStats_NRD_2021_Hospital.PDF
January 01, 2021 - Variance 3.19766E11
Mode 194440.0 Range 3110374
Interquartile Range 557665
Tests for Location: Mu0=0
Test … Variance 6945
Mode 359.0000 Range 355.00000
Interquartile Range 53.00000
Tests for Location: Mu0=0
Test … Variance 8.57102E10
Mode 64516.0 Range 1400354
Interquartile Range 303028
Tests for Location: Mu0=0
Test … Variance 1196
Mode 49.00000 Range 137.00000
Interquartile Range 29.00000
Tests for Location: Mu0=0
Test
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/mn22.pdf
November 20, 2012 - Test – strep
throat=no
Test – strep
throat=yes
Strep throat=no 32 8 40
Strep
throat=yes … 2012 MFMER | slide-9
Center for the SCIENCE of HEALTH CARE DELIVERY
Specificity: Ability of the test … not have
strep throat, but only 32 patients were identified as not having strep throat:
Truth x test … Test – strep
throat=no
Test – strep
throat=yes
Strep throat=no 32(row percent
32/(32 + 8) … Center for the SCIENCE of HEALTH CARE DELIVERY
Proposed Algorithms: Methodology
Data used to test
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/mn15.xls
January 01, 2019 - Completed by: _______________________________
LOINC Code Worksheet TO BE COMPLETED BY HOSPITAL
Test … # Laboratory Test Name Specimen Type Units LOINC Code LOINC Name Comments Specimen Type Units Normal … Count
Additional Tests
REQUIRED LAB TESTS NOT DESCRIBED BY LOINC CODES IN LOINC CODE WORKSHEET
Test … ___________ Completed by: _______________________________
Current LOINC Code Information Sheet
Test … # Laboratory Test Name LOINC Code Specimen Type Units Normal Range Method Current ID & Comments
-
hcup-us.ahrq.gov/db/nation/neds/stats/NEDS_2022_Hospital_MaskedStats.PDF
January 01, 2022 - Variance 2.31907
Mode 4.702020 Range 18.82372
Interquartile Range 1.24904
Tests for Location: Mu0=0
Test … Variance 0.72343
Mode 5.000000 Range 4.00000
Interquartile Range 0.25641
Tests for Location: Mu0=0
Test … Variance 2.57132E12
Mode 1427646 Range 7554493
Interquartile Range 1667657
Tests for Location: Mu0=0
Test … Variance 4274
Mode 256.0000 Range 254.00000
Interquartile Range 83.00000
Tests for Location: Mu0=0
Test … Tests for Location: Mu0=0
Test Statistic p Value
Student's t t 32.18104 Pr > |t| <.0001
Sign M 496.5
-
hcup-us.ahrq.gov/db/nation/neds/stats/NEDS_2021_Hospital_MaskedStats.PDF
January 01, 2021 - Variance 1.87736
Mode 5.056336 Range 21.69475
Interquartile Range 1.51954
Tests for Location: Mu0=0
Test … Variance 0.56589
Mode 5.000000 Range 4.00000
Interquartile Range 0.31333
Tests for Location: Mu0=0
Test … Variance 1.9289E12
Mode 1277807 Range 6396419
Interquartile Range 1545140
Tests for Location: Mu0=0
Test … Variance 4118
Mode 166.0000 Range 247.00000
Interquartile Range 92.00000
Tests for Location: Mu0=0
Test … Tests for Location: Mu0=0
Test Statistic p Value
Student's t t 32.10319 Pr > |t| <.0001
Sign M 496.5
-
hcup-us.ahrq.gov/datainnovations/clinicaldata/FL19dataelemandExtractandReport.jsp
October 19, 2010 - DATA QUERY TOOLS
Florida Data Elements
Example Inbound Extract
Orderable Test … Interface Code
Orderable Test Name
Result Interface Code
Result Name
Specimen Type
Result … HEPATIC FUNCTION PANEL
AST
AST
SST
N
U/L
Example Outbound Report
Orderable Test … Interface Code
Orderable Test Name
Result Interface Code
Result Name
Specimen Type
Result
-
hcup-us.ahrq.gov/datainnovations/clinicaldata/FL17LOINCAdvicetoothers.jsp
July 01, 2016 - limited resources to work with the completed mappings, they take the entire mapped file and use the test … Secondly, using the test performance volume to identify the order lab codes ignores the full usage of … For example, Basic Metabolic Test may qualify in the top 100, with components like glucose, urea nitrogen … types; go to XXX specimen
CSF Panel
GLU
Glucose
mg/dL
CSF
Glucose Tolerance Test … GLU2
Glucose
mg/dL
Serum
12610-2; result code crosses challenges
Lactose Tolerance Test
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/hi9.pdf
April 29, 2014 - none of the three above, specify lab or vendor)
Hospital/Vendor Completing Report:_____
Lab Test … Lab Test Name LOINC Units Vendor
Chemistry Albumin Albumin 1751-7 g/dL
Alkaline phosphatase Alkaline
-
hcup-us.ahrq.gov/datainnovations/clinicaldata/FL20LOINCIntroductionHammond.pdf
February 25, 2008 - Observation Identifiers
Names and Codes (LOINC®)
• Has two sections
– Laboratory portion
• Standard test … is nnnnn-n where the last n is a
mod 10 check digit
• Each LOINC record corresponds to a
single test … CAP
• ACLA
• Most clinical laboratories
• Most major medical centers
• US government (for laboratory test … Feburary 2008 Hammond 31
Normal Limits
• A challenging problem when the normal
limits for the same test … • HL7 has endorsed the use of certain terminologies for
specific purposes
– LOINC for laboratory test
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/mn15.jsp
September 01, 2014 - _____________
LOINC Code Worksheet
LOINC Code Worksheet
TO BE COMPLETED BY HOSPITAL
Test … #
Laboratory Test Name
Specimen Type
Units
LOINC Code
LOINC Name
Comments
Specimen Type … #
Laboratory Test Name
Specimen Type
Units
Normal Range
Method
Current Id & Comments … Date Completed: __________________________
Completed by: _______________________________
Test … #
Laboratory Test Name
LOINC Code
Specimen Type
Units
Normal Range
Method
Current Id &
-
hcup-us.ahrq.gov/db/nation/nass/stats/nass_summary_stats_hospital_2019.pdf
January 01, 2019 - Variance 0.27570
Mode 1.348921 Range 4.08846
Interquartile Range 0.42057
Tests for Location: Mu0=0
Test … Variance 7.9332E10
Mode 138058.0 Range 1112840
Interquartile Range 281350
Tests for Location: Mu0=0
Test … Variance 7747
Mode 367.0000 Range 355.00000
Interquartile Range 64.00000
Tests for Location: Mu0=0
Test … Variance 5.90322E10
Mode 102347.0 Range 1063258
Interquartile Range 209641
Tests for Location: Mu0=0
Test … Variance 4596
Mode 272.0000 Range 262.00000
Interquartile Range 59.00000
Tests for Location: Mu0=0
Test
-
hcup-us.ahrq.gov/reports/methods/MS2015-09%20Addendum.pdf
December 10, 2022 - SAS Example 1
/* Create test file with three new data elements. */
data test;
set nis2019.NIS … sums, means, and standard errors for three data elements defined above. */
proc surveymeans data=test … sums, means, and standard errors for three data elements defined above. */
proc surveymeans data=test
-
hcup-us.ahrq.gov/reports/methods/MS2005-07%20Addendum.pdf
December 10, 2022 - SAS Example 1
/* Create test file with three new data elements. */
data test;
set nis2019.NIS … sums, means, and standard errors for three data elements defined above. */
proc surveymeans data=test … sums, means, and standard errors for three data elements defined above. */
proc surveymeans data=test