What is the specific TESTs of glucose? What is the control level of the glucose?

[ljz756245026]

The measure

• [X] Put an X between the brackets on this line if you have done all of the following:
  • Checked the online documentation: https://mimic.mit.edu/
  • Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=

Description

This is a clinical knowledge. I am doing analysis on MIMIC-IV(2.0) dataset. What I have done is that

SELECT * FROM mimiciv_hosp.d_labitems where label like '%lucose%' and fluid='Blood'

The result is

50809	"Glucose"	"Blood"	"Blood Gas"
50931	"Glucose"	"Blood"	"Chemistry"
52027	"Glucose, Whole Blood"	"Blood"	"Blood Gas"
52569	"Glucose"	"Blood"	"Chemistry"

Then, I run

SELECT * FROM mimiciv_hosp.labevents WHERE ITEMID=50809 LIMIT 1000

I got the glucose value successfully. Now, here is a question. How do you GROUPING the glucose value? There are several way to do blood glucose test(e.g. A1C Test, Fasting Blood Sugar Test, Glucose Tolerance Test, Random Blood Sugar Test ). For different tests, we can see whether the patients get diabetes according to the following tabe.

Result*	A1C Test	Fasting Blood Sugar Test	Glucose Tolerance Test	Random Blood Sugar Test
Diabetes	6.5% or above	126mg//dL or above	200mg//dL or above	200mg//dL or above
Prediabetes	5.7-6.4%	100-125mg//dL	140-199mg//dL	N//A
Normal	Below 5.7%	99mg//dL or below	140mg//dL or below	N//A

Of course, we can obtain information from the Diagnoses related forms (ICD-9, ICD-10). I am now concerned about Glucose, and I hope to understand the test method and grouping method of this indicator (as shown in the table). For GLUCOSE, what interval is normal, what interval is prediabetes, and what interval is diabetes. This test method and grouping method for my research, look forward to your reply.