-
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.jsp
August 01, 2014 - 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
-
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/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/datainnovations/clinicalcontentenhancementtoolkit/hi31.pdf
March 23, 2010 - Application
*Account Number Create Date/Time
*Medical Record Number Patient Class
*DOB Hospital Test … (Order)
Gender Hospital Test Result (LOINC)
*SSN Observation Date/Time
*Patient First Name Results … CY2008-2011
9,450,293
Excluded
Not one of the 32;
Outside study period
Missing identifiers; test
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/mn4.jsp
August 01, 2014 - Platelet count
Prothrombin time
White blood count
Slide 7
Examples of LOINC Coding
Test … principal diagnosis
procedure
age group
Each row will contain information about a single lab
test … assistance as needed
Slide 12
Transmission & Analysis of Lab Data
Hospitals will submit a test … samples of lab data to the
project team
Project team will analyze test data and work with individual
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/ny8.pdf
November 12, 2013 - data with an extra column
for the MRN formatted for your
system.
2 DOH will send a list of 30 lab test … Send all test results for the
patients; NYSDOH will delete
those not needed for the study.
3
Hospital … If selection by lab test is a
problem, we will accept ALL
results for the patients on the
list.
-
hcup-us.ahrq.gov/datainnovations/clinicaldata/FL20LOINCIntroductionHammond.jsp
December 20, 2010 - Observation Identifiers Names and Codes (LOINC®)
Has two sections
Laboratory portion
Standard test … Format 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 … do a single mapping
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/clinicaldata/AHRQHCUP11182009CSullivanFinal.pdf
November 01, 2009 - Chloride Platelets Date of specimen Run
CPK MB PO2.sat Time of Specimen Run
Creatinine Potassium Type of test … 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 … for Health Information and Policy Analysis
Blood Culture Laboratory Data
LOINC Name
LOINC
Code
Test
-
hcup-us.ahrq.gov/tech_assist/standarderrors/508/508course_2016.jsp
January 01, 2016 - Subsets: Alternate Method Results
Verification of Results
Significance Testing
Using the Z-Test … Calculator
Z-Test Calculator LOS
Z-Test Calculator Trend
Wrap-Up
Key Points
Resources … The Z-Test calculator is a convenient way to do just that. … The Z-test calculator allows you to test the significance of the difference between two weighted counts … Return to Contents
Z-Test Calculator LOS
To test if the length of stay of a discharge with a principal
-
hcup-us.ahrq.gov/datainnovations/clinicaldata/AppendixG9_SurveyResultsCapabilities.pdf
September 22, 2010 - All reported availability of facility name, test ID, test name and unit of measure. … A couple reported the test method, specimen/source and reference ranges may
NOT be available from their
-
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/MS2003-02%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
-
hcup-us.ahrq.gov/datainnovations/clinicaldata/AppendixK_2LOINCCodesMap.jsp
October 02, 2010 - Site:
Date Completed:
Completed by:
Template
TO BE COMPLETED BY LABORATORY
Test … #
Laboratory Test Name
Specimen Type
Units
LOINC Code
LOINC Name
Comments
Specimen Type …
Additional Tests
Site:
Date Completed:
Completed by:
Additional Tests
Test … #
Laboratory Test Name
Specimen Type
Units
Normal Range
Method
Comments
… #
Laboratory Test Name
LOINC Code
Specimen Type
Units
Normal Range
Method
Comments
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/mn13.jsp
September 01, 2014 - Lab TESTS Desired for AHRQ PROJECT
Lab TESTS Desired for AHRQ PROJECT
Test … #
Laboratory Test Name
Specimen Type
Units
LOINC Code*
LOINC Name
1
Albumin
Serum
-
hcup-us.ahrq.gov/db/nation/neds/stats/NEDS_2018_Hospital_MaskedStats.PDF
January 01, 2018 - Variance 1.78273
Mode 6.225576 Range 9.60770
Interquartile Range 1.49968
Tests for Location: Mu0=0
Test … Variance 0.46335
Mode 5.000000 Range 4.00000
Interquartile Range 0.25225
Tests for Location: Mu0=0
Test … Variance 2.10233E12
Mode 1327741 Range 6778351
Interquartile Range 1546898
Tests for Location: Mu0=0
Test … Tests for Location: Mu0=0
Test Statistic p Value
Student's t t 39.23995 Pr > |t| <.0001
Sign M 495 … Tests for Location: Mu0=0
Test Statistic p Value
Student's t t 26.7266 Pr > |t| <.0001
Sign M 495
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/mn5.pdf
June 21, 2014 - to submit data from
electronic repositories using established data
specifications and formats
• Test … data submissions to validate protocols• Test data submissions to validate protocols
• Transmit data … assistance as needed
9
Future Collection and Use of Drug Datag
• A principal goal of this project is to test