QIDiabetesDataSpec_v_0_3_0

	A	B	C	D
1	Diabetes Spec Change
2	Version	Date	Description/Comments	Reason
3	0.3.0	2024-02-06	Insulin: Added OmniPod Dash, V-Go, Beta Bionics, Ypsomed Pump, CeQur Pump to ins_pump_model Added MannKind/Zealand Pharma, Ypsomed, CeQur to ins_pump_company
4	0.3.0	2023-03-08	Glucose: Added cgm_high_above_180	To capture percentage of time above 180
5	0.3.0	2022-09-12	Disease: documented_transition_plan added along with accepted values transportation_insecurity, housing_insecurity have been added	To capture documented transition plan from pediatric to adult centre, transportation and housing insecurity
6			Insulin: Added ins_pen_company & ins_pen_model along with accepted values	To capture insulin pen use
7			Diabetes_core_observations: Added C-peptide lab test	To capture c-peptide lab value
8	0.2.4	2021-10-05	All Sheet: Data mapping priority added to all sheets	Classify variables based on QI metrics phases and population health
9	0.2.3	2021-06-08	Disease: dka_serum_bicarb dka_blood_pH dka_events_pro_dt	To capture severity of DKA events
10			Insulin: ins_dose_adjust Added new pump models	New Variables added to capture data for phase 2 metrics and include new insulin pump models
11			Monitoring: device_report_patient_reviewed cgm_binary Added new cgm models	New Variables added to capture data for phase 2 metrics and include new cgm models
12			Glucose: time_in_range cgm_low_below_70 cgm_low_below_54 cgm_high_above_250	New Variables added to capture time in range data
13	0.2.2 beta 9	2020-05-22	effective_date definition updated	"Clinically relevant date for observation" was too ambiguous. Instead encounter_date from the Encounter file is now used, which is much easier to understand and capture. The column name will remain effective_date.
14	0.2.2 beta 8	2019-12-11	Insulin: ins_regimen modification 1. Injection, #3 changed from 'mixed/split' to 'sliding scale'	1. 'sliding-scale' is the original and proper name for #3. It was accidently changed to 'mixed/split'.
15	0.2.2	Beta	Disease: Updated description 1. hypo_sym 2. sh_events_amb 3. sh_events_amb_pro 4. sh_events_inp 5. sh_events_inp_pro 6. dka_events_amb 7. dka_events_amb_pro 8. dka_events_inp 9. dka_events_inp_pro 10. other_events_inp_pro	Provide better explanation of variables
16			Disease: Added year only date format 1. t1d_dx_dt 2. flu_dt 3. eye_exam_dt 4. foot_exam_mf_dt 5. foot_exam_dt 6. dental_exam_dt	Full dates may not be available
17			Disease: Added note 1. t1d_dx_dt
18			Disease: Removed unused variables 1. sh_events_amb_method 2. sh_events_inp_method	The variables sh_events_amb and sh_events_amb_pro replaces sh_event_amb_method The variables sh_events_inp and sh_events_inp_pro replace sh_events_in_method
19			Monitoring: Modified definition from 1 month to 2 weeks 1. cgm_sensor_use_count 2. cgm_use_perc	Since devices report in 14 day periods it was decided to use 14 days instead of a month
20			Monitoring: Added year only format 1. cgm_st_dt	Full dates may not be available
21			Monitoring: Added bgm models 1. Added bgm model 11-6 TrueFocus (Trividia) 2. Added bgm model 8-8 OneTouch Ping (OneTouch)
22			Monitoring: Added cgm company/model 1. Added company Senseonics 2. Added model FreeStyle Libre 3. Added model FreeStyle Libre Pro 4. Added model Eversense 5. Removed BD	Keep current with CMG devices
23			Monitoring: Changed cgm_company/model values 1. cgm_company 'other' changed from 9 to 99 2. cgm_model 'other' changed from 9 to 99 3. cgm_company 'unknown' changed from 10 to 100 4. cgm_model 'unknown' changed from 10 to 10	To be consistent with bgm values
24			Insulin: ins_regimen modification 1. Injection, unknown dose method	1. Injection, unknown dose method added to allow for known injection users but unknown insulin dosing method
25			Insulin: value type updated 1. basal_ins_daily_inj 2. bolus_ins_daily_inj 3. t_ins_daily 4. basal_ins_daily 5. bolus_ins_daily
26			Guideline: 1. updated output file filename 2. provided example
27			Guideline updated Notes 1. patient_id 2. encounter_id 3. observation_id
28			All sheets: Added copyright logo
29	0.2.1	2018-04-26	Disease sheet added variables 1. sh_events_amb_pro 2. sh_events_inp_pro 3. dka_events_inp_pro 4. other_events_inp_pro Disease updated description 1. sh_events_amb 2. sh_events_inp 3. dka_events_amb 4. dka_events_inp Monitoring added variables 1. device_report_patient_reviewed Sheet Renamed 1. Examples changed to Guidelines 2. Diabetes_Core changed to Diabetes_Core_Observations Note Added 1. Guidelines 2. Diabetes_Core_Observations	To provide data for the Standard Report
30	0.2.0	2017-02-22	Original	None
31
32	©
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100