Initiative for Quality Improvement and Epidemiology in Children and Adolescents with Diabetes (IQECAD)

Version: from 01/01/2024 - 31/03/2024
Status: active, no new submissions
Unique ID: patient ID and audit period
How to create a CSV file for this data collection?

Start date: 31/12/2023
End date creation: 30/05/2024
End date submission: 08/09/2024

Full view CSV column names Validation rules Reference lists Computed expressions Additional information CSV extract

date

Start date audit period

Not to be included in the CSV.

Technical specs

Format:

DD/MM/YYYY

CSV column name:

start_date_audit_period

Default value:

2023-01-01

Required:

true

Read only

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

Validation

The difference between the start date of the audit period$ and the date of birth$ cannot be greater than or equal to 18 years of age. (error)
The date of HbA1c determination must be between the beginning and end of the audit period . (error)

date

End date audit period

Not to be included in the CSV.

Technical specs

Format:

DD/MM/YYYY

CSV column name:

end_date_audit_period

Default value:

2023-12-31

Required:

true

Read only

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

Validation

The diabetes diagnosis date cannot be after the audit period end date (error)
The start date of insulin treatment cannot be after the end date of the audit period (error)
The date of inclusion in your convention cannot be after the end date of the audit period (error)
The date of HbA1c determination must be between the beginning and end of the audit period . (error)
The date of birth cannot be later than end date of audit (error)
Date of death cannot be after the audit date (error)

1 Sampling

choice

Was this patient selected in step 1 or step 2 of the sampling?

Help

STEP 1: selection of your patients according to the inclusion and exclusion criteria.
STEP 2: selection of the remaining patients with a CGM convention, who were not selected during step 1, without taking into account the inclusion and exclusion criteria from step 1. Only centers that have a CGM convention with NIDHI may choose "Step 2". The "CGM Convention" means the "agreement on continuous glucose monitoring in the diabetic patient".

Technical specs

CSV column name:

was_this_patient_selected_in_step_1_or_step_2_of_the_sampling

Required:

true

Stable:

true

Options

Label	Value
Selected in step 1	1
Selected in step 2	2

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

Validation

The difference between the start date of the audit period$ and the date of birth$ cannot be greater than or equal to 18 years of age. (error)

choice

You have indicated that the patient is included in the CGM convention. Is the patient also included in your general convention?

Help

"General Convention" refers to the "rehabilitation agreement on self-regulation of diabetes mellitus in children and adolescents".

Technical specs

CSV column name:

you_have_indicated_that_the_patient_is_included_in_the_cgm_convention_is_the_patient_also_included_in_your_general_convention

Only when:

Required:

true

Options

Label	Value
No	0
Yes	1

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

choice

Is this patient treated in a center on initiation pathway?

Help

Only for centers not able to reach the minimum of 50 patients needed to be part of the convention (AZ Turnhout for UZ Gent and AZ Nikolaas for UZ Antwerpen)

Technical specs

CSV column name:

CD_TREAT_PAT_INI_PATH

Default value:

Required:

true

Options

Label	Value
No	0
Yes	1

2 General patient characteristics (at the end of the audit period)

list

Treating physician

This is a container for multiple answers. See the reference documentation for more details. Below you can find the information about the fields of the container

List items

text

NIHDI-code of the treating physician

Technical specs

CSV column name:

treating_physician|nihdicode_of_the_treating_physician

Length:

100

Reference list:

PHYSICIAN

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Caregiver

Data element:

CareGiverIdentificationNumber

2.1 Socio-demographic data

patient identificator

National registry ID of the patient

Help

Please encode a social security identification number (SSIN). Please note that the patient ID is always pseudonymised before being transferred to Healthdata.

Technical specs

CSV column name:

patient_id

Only when:

Required:

true

Stable:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

PatientIdentificationNumber

Validation

The validity of the national register number is checked with the mod97 check.

Fields

Section help

Please encode a social security identification number (SSIN). Please note that the patient ID is always pseudonymised before being transferred to Healthdata.

text

Internal patient ID

Help

This field can be used to enter an internal ID or reference number. It is available for internal use only and is not transferred to Healthdata. If there is an integration between HD4DP and your organisation's patient administration system, additional patient identification information such as date of birth, sex and SSIN can be automatically enriched based on this internal patient ID. Please do not encode the social security identification number (SSIN) in this field. The SSIN must be encoded in the field 'National registry ID of the patient'.

Technical specs

CSV column name:

patient_id|internal_patient_id

Required:

false

Stable:

true

boolean

Generated

Help

The patient_id|generated column can be set to 'TRUE' for an automatically generated patient_id.This column should only be added in case the patient_id is empty. If the column is set to 'TRUE', a patient_id is automatically generated based on the name, first name, date of birth and sex of the patient.

Technical specs

CSV column name:

patient_id|generated

Required:

false

Options

Label	Value
Yes	TRUE
No	FALSE

text

Name

Help

The name of the patient is never transferred to Healthdata and is available for your information only.

Technical specs

CSV column name:

patient_id|name

Length:

Only when:

Required:

true

Stable:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

LastName

text

First name

Help

The first name of the patient is never transferred and is available for your information only.

Technical specs

CSV column name:

patient_id|first_name

Length:

Only when:

Required:

true

Stable:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

FirstNames

date

Date of birth

Technical specs

Format:

DD/MM/YYYY

CSV column name:

patient_id|date_of_birth

Only when:

Required:

true

Stable:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

DateOfBirth

Validation

The difference between the start date of the audit period$ and the date of birth$ cannot be greater than or equal to 18 years of age. (error)
The date of diabetes diagnosis$ cannot be before the date of birth$ (error)
The date of death cannot be before the date of birth (error)
The date of birth cannot be later than end date of audit (error)

choice

Sex

Help

Select the administrative sex as registered in the National registry. For patients from countries with already an indication ‘X’ for indeterminate sex, please select 'unknown'.

Technical specs

CSV column name:

patient_id|sex

Only when:

Required:

true

Stable:

true

Options

Label	Value
Female	F
Male	M
Unknown	U

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

Gender

text

Place of residence

Technical specs

CSV column name:

patient_id|place_of_residence

Length:

Reference list:

POSTAL_CODE

Only when:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

Municipality

boolean

Deceased?

Technical specs

CSV column name:

patient_id|deceased

Only when:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

DeathIndicator

Options

Label	Value
Yes	TRUE
No	FALSE

date

Date of death

Technical specs

Format:

DD/MM/YYYY

CSV column name:

patient_id|date_of_death

Only when:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

DateOfDeath

Validation

The date of death cannot be before the date of birth (error)
Date of diagnosis of diabetes cannot be later than date of death (error)
The insulin treatment start date } cannot be later than date of death (error)
Date of death cannot be after the audit date (error)

text

Country of residence

Technical specs

CSV column name:

country_of_residence

Length:

100

Reference list:

COUNTRY

Only when:

Required:

false

choice

Does the patient live in a nuclear family?

Help

Nuclear Family Definition: Original father and mother are present. In case of adoption, this means that the original adoptive parents are still present. Single parents who decided to raise their child alone are not considered as a nuclear family.

Technical specs

CSV column name:

does_the_patient_live_in_a_nuclear_family

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1
No response	9

choice

Ethnicity of father

Help

"European Caucasian" categorization: Spanish, Greek, Finland, Turkey. "North Africa Caucasian" categorization: Morocco, Egypt, Libya. "Other" categorization: Iran, Afghanistan, Ukraine.

Technical specs

CSV column name:

ethnicity_of_father

Only when:

Required:

false

Stable:

true

Options

Label	Value
European Caucasian	1
North Africa Caucasian	6
Other	7
No answer	9

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

Nested option fields

When 7 Is selected:
text
If "other" ethnicity of father, specify:
Technical specs
CSV column name:
ethnicity_of_father|if_other_ethnicity_of_father_specify
Length:
100
Required:
false
Mapping of the clinical building blocks (indicative only)
Concept:
na
Data element:
na

choice

Ethnicity of mother

Help

"European Caucasian" categorization: Spanish, Greek, Finland, Turkey. "North Africa Caucasian" categorization: Morocco, Egypt, Libya. "Other" categorization: Iran, Afghanistan, Ukraine.

Technical specs

CSV column name:

ethnicity_of_mother

Only when:

Required:

false

Stable:

true

Options

Label	Value
European Caucasian	1
North Africa Caucasian	6
Other	7
No answer	9

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

Nested option fields

When 7 Is selected:
text
If "other" ethnicity of mother, specify:
Technical specs
CSV column name:
ethnicity_of_mother|if_other_ethnicity_of_mother_specify
Length:
100
Required:
false
Mapping of the clinical building blocks (indicative only)
Concept:
na
Data element:
na

choice

Are there any language barriers that impede communication with the PATIENT?

Technical specs

CSV column name:

are_there_any_language_barriers_that_impede_communication_with_the_patient

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1
No response	9

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

choice

Are there any language barriers that impede communication with the PARENTS?

Technical specs

CSV column name:

are_there_any_language_barriers_that_impede_communication_with_the_parents

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes, with 1 parent	1
Yes, with both parents	2
No response	9

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

choice

Does the patient have psychosocial distress ?

Help

This question should be discussed in conjunction with the patient, the parents and the team together

Technical specs

CSV column name:

CD_PAT_PSYCHOSOC_DISTRESS

Default value:

Required:

sample12

Options

Label	Value
No	0
Yes	1

2.2 Development

choice

Has puberty started?

Help

The start of the puberty corresponds to stages 2-5 according to Tanner classification.

Technical specs

CSV column name:

has_puberty_started

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1
No response	9

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferConcern

Data element:

ProblemStatus

2.3 Diabetes

choice

Diabetes type

Technical specs

CSV column name:

diabetes_type

Only when:

Required:

true

Stable:

true

Options

Label	Value
1	1
2	2
Other type	3

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferConcern

Data element:

ProblemName

date

Date of diagnosis of diabetes

Help

If only the year is known, enter 01/07/yyyy (e.g. 01/07/1989). If only the year and month are known, enter 15/mm/yyyy (e.g. 15/06/2001).

Technical specs

Format:

DD/MM/YYYY

CSV column name:

date_of_diagnosis_of_diabetes

Only when:

Required:

false

Stable:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferConcern

Data element:

ProblemStartDate

Validation

The diabetes diagnosis date cannot be after the audit period end date (error)
The date of diabetes diagnosis$ cannot be before the date of birth$ (error)
The date of the beginning of the insulin treatment cannot be before the date of diabetes diagnosis (error)
The date of inclusion in your convention cannot be before the date of diabetes diagnosis (error)
Date of diagnosis of diabetes cannot be later than date of death (error)

date

Start date of insulin treatment

Help

If only the year is known, enter 01/07/yyyy (e.g. 01/07/1989). If only the year and month are known, enter 15/mm/yyyy (e.g. 15/06/2001).

Technical specs

Format:

DD/MM/YYYY

CSV column name:

start_date_of_insulin_treatment

Only when:

Required:

false

Stable:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

MedicationPrescriptionDate

Validation

The start date of insulin treatment cannot be after the end date of the audit period (error)
The date of the beginning of the insulin treatment cannot be before the date of diabetes diagnosis (error)
The insulin treatment start date } cannot be later than date of death (error)

date

Inclusion date of the patient in your convention

Help

"Convention" refers to the "rehabilitation agreement for self-regulation of diabetes mellitus". If the patient left your center and then re-joined, please provide the date of the most recent return. If only the year is known, enter 01/07/yyyy (e.g. 01/07/1989). If only the year and month are known, enter 15/mm/yyyy (e.g. 15/06/2001).

Technical specs

Format:

DD/MM/YYYY

CSV column name:

inclusion_date_of_the_patient_in_your_convention

Only when:

Required:

false

Stable:

true

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

Validation

The date of inclusion in your convention cannot be after the end date of the audit period (error)
The date of inclusion in your convention cannot be before the date of diabetes diagnosis (error)

3 Care and results (the most recent results in the audit period)

3.1 Consultations

number

Number of consultations in the diabetes center

Help

In the audit period. Only count the consultations with the diabetologist.

Technical specs

CSV column name:

number_of_consultations_in_the_diabetes_center

Length:

Only when:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Contact

Data element:

StartDateTime

Validation

Number of consultations in the diabetes center: must be an integer (error)
The number of consultations cannot be less than 0 (error)
The maximum number of consultations per year is 50 (error)

3.2 Self-measurement of blood glucose

choice

The patient uses the following measurement method:

Technical specs

CSV column name:

the_patient_uses_the_following_measurement_method

Default value:

no_response

Only when:

Required:

false

Options

Label	Value
Finger-stick test	fingerstick_test
Continuous glucose monitoring (CGM)	continuous_glucose_monitoring_cgm
Flash glucose monitoring (FGM)	flash_glucose_monitoring_fgm
No response	no_response

Nested option fields

When continuous_glucose_monitoring_cgm Is selected:
choice
Is the patient included in the CGM-convention?
Help
Also answer "yes" if the patient has a CGM convention in another center.
Technical specs
CSV column name:
the_patient_uses_the_following_measurement_method|is_the_patient_included_in_the_cgmconvention
Required:
true
Options
Label Value
No 0
Yes 1
Mapping of the clinical building blocks (indicative only)
Concept:
na
Data element:
na
When flash_glucose_monitoring_fgm Is selected:
number
Mean number of scans per day
Help
The average of the last three months. This information can be found in the patient's FGM device.
Technical specs
CSV column name:
the_patient_uses_the_following_measurement_method|mean_number_of_scans_per_day
Length:
2.1
Required:
false

Label	Value
No	0
Yes	1

number

What was the average time of coverage over a period of 14 days (%)?

Help

% time FGM is active

Technical specs

CSV column name:

MS_CVG_14D_FGM

Only when:

Required:

false

Validation

Percentage of time must be an integer (error)
The % time is greater than 100 (error)
The % time is less than 0 (error)

number

What was the average time in range (70 to 180 mg/dl) over a period of 14 days (TIR in %) ?

Technical specs

CSV column name:

MS_RNG_14D_FGM

Only when:

Required:

false

Validation

Percentage of time must be an integer (error)
The % time is greater than 100 (error)
The % time is less than 0 (error)

number

What was the average time in hypoglycemia (

Technical specs

CSV column name:

MS_HYPO_14D_FGM

Only when:

Required:

false

Validation

Percentage of time must be an integer (error)
The % time is greater than 100 (error)
The % time is less than 0 (error)

number

What was the average time of coverage over a period of 14 days (%)?

Help

% time CGM is active

Technical specs

CSV column name:

MS_CVG_14D_CGM

Only when:

Required:

false

Validation

Percentage of time must be an integer (error)
The % time is greater than 100 (error)
The % time is less than 0 (error)

number

What was the average time in range (70 to 180 mg/dl) over a period of 14 days (TIR in %) ?

Technical specs

CSV column name:

MS_RNG_14D_CGM

Only when:

Required:

false

Validation

Percentage of time must be an integer (error)
The % time is greater than 100 (error)
The % time is less than 0 (error)

number

What was the average time in hypoglycemia (

Technical specs

CSV column name:

MS_HYPO_14D_CGM

Only when:

Required:

false

Validation

Percentage of time must be an integer (error)
The % time is greater than 100 (error)
The % time is less than 0 (error)

number

Mean number of blood glucose measurements per day

Help

This DOES NOT mean the convention category, but means the actual number of glycemia measurements performed per day (finger pricking). Average over the past three months. If the patient is using the FGM device and no longer performing a finger stick (glycemic measurement), answer "0" to the question. Do not leave the field blank, otherwise it will be considered a missing value. This field accepts numbers with decimal. An example: 0.3

Technical specs

CSV column name:

mean_number_of_blood_glucose_measurements_per_day

Length:

2.1

Only when:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

Validation

The average number of glycaemia measurements per day should not be less than 0 (error)
The average number of glycemic measurements per day is over 20 (error)

3.3 Anthropometry

number

Weight (kg)

Technical specs

CSV column name:

weight_kg

Length:

3.1

Only when:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.BodyWeight

Data element:

WeightValue

Validation

The BMI is below 10 kg/m². Check if the values of the weight and the height are correct. (error)
The BMI is above 50 kg/m². Check if the values of the weight and the height are correct. (error)
The BMI must be less than 100 kg/m². Check that the values for weight and the height have been entered correctly. (error)
Weight value can only have one digit after the decimal point (error)
The weight is more than 250 kg (error)
The weight may not be less than 0 kg (error)

number

Height (cm)

Technical specs

CSV column name:

height_cm

Length:

3.1

Only when:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.BodyHeight

Data element:

HeightValue

Validation

The BMI is below 10 kg/m². Check if the values of the weight and the height are correct. (error)
The BMI is above 50 kg/m². Check if the values of the weight and the height are correct. (error)
The BMI must be less than 100 kg/m². Check that the values for weight and the height have been entered correctly. (error)
The height value can only have one digit after the decimal point (error)
The height cannot be less than 0 cm (error)
The height is more than 230 cm. (error)

number

Body Mass Index, calculated (kg/m²)

Not to be included in the CSV.

Technical specs

CSV column name:

body_mass_index_calculated_kgm

Length:

3.2

Computed:

Only when:

Required:

false

Read only

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

Validation

The BMI is below 10 kg/m². Check if the values of the weight and the height are correct. (error)
The BMI is above 50 kg/m². Check if the values of the weight and the height are correct. (error)
The BMI must be less than 100 kg/m². Check that the values for weight and the height have been entered correctly. (error)

3.4 Blood pressure

number

Systolic blood pressure (mmHg)

Technical specs

CSV column name:

systolic_blood_pressure_mmhg

Length:

Only when:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.BloodPressure

Data element:

SystolicBloodPressure

Validation

The systolic blood pressure is below the diastolic blood pressure (error)
The systolic blood pressure is below 40 mmHg (error)
The systolic blood pressure (mmHg): must be a whole number (error)
Systolic blood pressure is greater than 250 mmHg (error)

number

Diastolic blood pressure (mmHg)

Technical specs

CSV column name:

diastolic_blood_pressure_mmhg

Length:

Only when:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.BloodPressure

Data element:

DiastolicBloodPressure

Validation

The systolic blood pressure is below the diastolic blood pressure (error)
The diastolic blood pressure is below 30 mmHg (error)
The diastolic blood pressure (mmHg): must be an integer (error)
Diastolic blood pressure is greater than 250 mmHg (error)

3.5 HbA1c

choice

Was HbA1c determined?

Help

In the audit period

Technical specs

CSV column name:

was_hba1c_determined

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

TestName

Validation

The number of HbA1c determinations: must be an integer (error)
HbA1c value can only have one decimal place (error)
The date of HbA1c determination must be between the beginning and end of the audit period . (error)

Nested option fields

When 1 Is selected:

list

HbA1c (%)

This is a container for multiple answers. See the reference documentation for more details. Below you can find the information about the fields of the container

Help

Please add all measurements of HbA1c (%) performed during the audit year

Element conditions

Message	Expression
The HbA1c value can only have one decimal point	(typeof $ ['MS_HBA1C_PCT'] === 'number' && $['MS_HBA1C_PCT'].toString().indexOf('.') !== -1)?($['MS_HBA1C_PCT'].toString().trim().length - $['MS_HBA1C_PCT'].toString().trim().indexOf('.') - 1
HbA1c cannot be less than 4%	typeof $['MS_HBA1C_PCT'] === 'number'?($['MS_HBA1C_PCT'] >= 4):true
HbA1c cannot exceed 20%	typeof $['MS_HBA1C_PCT'] === 'number'?($['MS_HBA1C_PCT']
Date of HbA1c measurement cannot be later than date of death	typeof $.DT_HBA1C_PCT=== 'string' && typeof $$.document.target.value.patient_id.date_of_death === 'string'?$$.document.target.value.patient_id.date_of_death > $.DT_HBA1C_PCT:true
Date of HbA1c measurement cannot be earlier than date of birth	typeof $.DT_HBA1C_PCT=== 'string' && typeof $$.document.target.value.patient_id.date_of_birth === 'string'?$$.document.target.value.patient_id.date_of_birth

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

Result

List items

Section help

Please add all measurements of HbA1c (%) performed during the audit year

number

HbA1c (%)

Technical specs

CSV column name:

was_hba1c_determined|hba1c_|0|MS_HBA1C_PCT

Length:

3.1

Required:

false

date

Date of the HbA1c measurement

Technical specs

Format:

DD/MM/YYYY

CSV column name:

was_hba1c_determined|hba1c_|0|DT_HBA1C_PCT

Required:

false

number

Number of HbA1c determinations

Help

In the audit period

Technical specs

CSV column name:

was_hba1c_determined|number_of_hba1c_determinations

Length:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

TestDateTime

3.6 Lipids

choice

Were blood lipids determined?

Help

In the audit period

Technical specs

CSV column name:

were_blood_lipids_determined

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

TestName

Validation

The total cholesterol is below 80 mg/dl (error)
The HDL-cholesterol is below 15 mg/dl (error)
The triglycerides are below 10 mg/dl (error)
The HDL-cholesterol is above or equal to the cholesterol total (error)
The LDL-cholesterol, measured in laboratory, is above or equal to the total cholesterol (error)
The LDL cholesterol, measured in laboratory, is below 20 mg/dl (error)
Total cholesterol value can only have one digit after the decimal point (error)
HDL cholesterol value can only have one digit after the decimal point (error)
Triglyceride value can only have one digit after the decimal point (error)
The LDL cholesterol value can only have one digit after the decimal point (error)

Nested option fields

When 1 Is selected:
number
Total cholesterol (mg/dl)
Technical specs
CSV column name:
were_blood_lipids_determined|total_cholesterol_mgdl
Length:
4.1
Required:
false
Mapping of the clinical building blocks (indicative only)
Concept:
be.en.hd.TransferLaboratoryResult
Data element:
Result
number
HDL cholesterol (mg/dl)
Technical specs
CSV column name:
were_blood_lipids_determined|hdl_cholesterol_mgdl
Length:
4.1
Required:
false
Mapping of the clinical building blocks (indicative only)
Concept:
be.en.hd.TransferLaboratoryResult
Data element:
Result
number
Triglycerides (mg/dl)
Technical specs
CSV column name:
were_blood_lipids_determined|triglycerides_mgdl
Length:
4.1
Required:
false
Mapping of the clinical building blocks (indicative only)
Concept:
be.en.hd.TransferLaboratoryResult
Data element:
Result
number
LDL cholesterol, calculated (mg/dl)
Not to be included in the CSV.
Technical specs
CSV column name:
were_blood_lipids_determined|ldl_cholesterol_calculated_mgdl
Length:
4.1
Computed:
Only when:
Required:
false
Read only
Mapping of the clinical building blocks (indicative only)
Concept:
na
Data element:
na
choice
Did the patient fast?
Technical specs
CSV column name:
were_blood_lipids_determined|did_the_patient_fast
Default value:
0
Required:
false
Options
Label Value
No 0
Yes 1
Mapping of the clinical building blocks (indicative only)
Concept:
na
Data element:
na
number
LDL cholesterol (mg/dl) measured in the lab
Help
Only if you have a value determined in the lab, so not the calculated value!
Technical specs
CSV column name:
were_blood_lipids_determined|ldl_cholesterol_mgdl_measured_in_the_lab
Length:
4.1
Required:
false
Mapping of the clinical building blocks (indicative only)
Concept:
be.en.hd.TransferLaboratoryResult
Data element:
Result

Label	Value
No	0
Yes	1

3.7 Kidneys

choice

Has the patient ever received screening for nephropathy ?

Technical specs

CSV column name:

has_the_patient_ever_received_screening_for_nephropathy_

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

TestName

Nested option fields

When 1 Is selected:
choice
Was the last screening result positive?
Help
Input the last known nephropathy screening result, even if it was not done during the audit period.
Technical specs
CSV column name:
has_the_patient_ever_received_screening_for_nephropathy_|was_the_last_screening_result_positive
Default value:
9
Required:
false
Options
Label Value
No 0
Yes 1
No response 9
choice
Was the last screening performed during the current audit year
Technical specs
CSV column name:
has_the_patient_ever_received_screening_for_nephropathy_|was_the_last_screening_performed_during_the_current_audit_year
Default value:
0
Required:
false
Options
Label Value
No 0
Yes 1

Label	Value
No	0
Yes	1
No response	9

Label	Value
No	0
Yes	1

3.8 Eyes

choice

Has the patient ever received screening for retinopathy ?

Technical specs

CSV column name:

has_the_patient_ever_received_screening_for_retinopathy_

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureType

Nested option fields

When 1 Is selected:
choice
Was the last screening result positive?
Help
Input the last known retinopathy screening result, even if it was not done during the audit period.
Technical specs
CSV column name:
has_the_patient_ever_received_screening_for_retinopathy_|was_the_last_screening_result_positive
Default value:
9
Required:
false
Options
Label Value
No 0
Yes 1
No response 9
choice
Was the last screening performed during the current audit year?
Technical specs
CSV column name:
has_the_patient_ever_received_screening_for_retinopathy_|was_the_last_screening_performed_during_the_current_audit_year
Default value:
0
Required:
false
Options
Label Value
No 0
Yes 1

Label	Value
No	0
Yes	1
No response	9

Label	Value
No	0
Yes	1

3.9 Acute complications

choice

Did the patient have episodes of SEVERE hypoglycemia?

Help

In the audit period. Definition of severe hypoglycemia: Semi- to fully unconscious status where the patient needs help from third parties. This is not equal to the number of hypoglycemia to be read on the glucometer!

Technical specs

CSV column name:

did_the_patient_have_episodes_of_severe_hypoglycemia

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1
No response	9

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferConcern

Data element:

ProblemName

Validation

Number of episodes of severe hypoglycemia: must be an integer (error)

Nested option fields

When 1 Is selected:
number
If yes, how many episodes of severe hypoglycemia OVER A PERIOD OF 3 MONTHS?
Technical specs
CSV column name:
did_the_patient_have_episodes_of_severe_hypoglycemia|if_yes_how_many_episodes_of_severe_hypoglycemia_over_a_period_of_3_months
Length:
2
Required:
false
Mapping of the clinical building blocks (indicative only)
Concept:
be.en.hd.TransferConcern
Data element:
ProblemName

choice

Was the patient admitted for ketoacidosis or for hyperosmolar hyperglycemic state (with or without ketosis) during the audit year?

Help

In the audit period. Do not count the "inaugural" ketoacidosis, when diagnosing diabetes.

Technical specs

CSV column name:

CD_ADMI_DKA_HYPRGL_ADT

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1
No response	9

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Contact

Data element:

Problem::ProblemName

Validation

Number of admissions for ketoacidosis or hyperosmolar hyperglycemic state during the audit year: must be an integer (error)

Nested option fields

When 1 Is selected:
number
If yes, how many admissions?
Technical specs
CSV column name:
CD_ADMI_DKA_HYPRGL_ADT|if_yes_how_many_admissions
Length:
2
Required:
false
Mapping of the clinical building blocks (indicative only)
Concept:
be.en.hd.Contact
Data element:
StartDateTime

3.10 Other

choice

Has the patient ever received screening for celiac disease?

Help

Coeliac screening: Antibody screening.

Technical specs

CSV column name:

has_the_patient_ever_received_screening_for__celiac_disease

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureType

Nested option fields

When 1 Is selected:
choice
Was the last screening result positive?
Help
Input the last known celiac screening result, even if it was not done during the audit period.
Technical specs
CSV column name:
has_the_patient_ever_received_screening_for__celiac_disease|was_the_last_screening_result_positive
Default value:
9
Required:
false
Options
Label Value
No 0
Yes 1
No response 9
Mapping of the clinical building blocks (indicative only)
Concept:
be.en.hd.TransferConcern
Data element:
ProblemName
choice
Was the last screening performed during the current audit year
Technical specs
CSV column name:
has_the_patient_ever_received_screening_for__celiac_disease|was_the_last_screening_performed_during_the_current_audit_year
Default value:
0
Required:
false
Options
Label Value
No 0
Yes 1

Label	Value
No	0
Yes	1
No response	9

Label	Value
No	0
Yes	1

choice

Has the patient ever received screening for thyroid autoimmunity ?

Technical specs

CSV column name:

has_the_patient_ever_received_screening_for_thyroid_autoimmunity_

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureType

Nested option fields

When 1 Is selected:
choice
Was the last screening result positive?
Help
Input the last known thyroid autoimmunity screening result, even if it was not done during the audit period.
Technical specs
CSV column name:
has_the_patient_ever_received_screening_for_thyroid_autoimmunity_|was_the_last_screening_result_positive
Default value:
9
Required:
false
Options
Label Value
No 0
Yes 1
No response 9
Mapping of the clinical building blocks (indicative only)
Concept:
be.en.hd.TransferConcern
Data element:
ProblemName
choice
Was the last screening performed during the current audit year?
Technical specs
CSV column name:
has_the_patient_ever_received_screening_for_thyroid_autoimmunity_|was_the_last_screening_performed_during_the_current_audit_year
Default value:
0
Only when:
Required:
false
Options
Label Value
No 0
Yes 1

Label	Value
No	0
Yes	1
No response	9

Label	Value
No	0
Yes	1

choice

Has the patient ever received screening for neuropathy ?

Technical specs

CSV column name:

has_the_patient_ever_received_screening_for_neuropathy_

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureType

Nested option fields

When 1 Is selected:
choice
Was the last screening result positive?
Help
Input the last known neuropathy screening result, even if it was not done during the audit period.
Technical specs
CSV column name:
has_the_patient_ever_received_screening_for_neuropathy_|was_the_last_screening_result_positive
Default value:
9
Required:
false
Options
Label Value
No 0
Yes 1
No response 9
choice
Was the last screening performed during the current audit year?
Technical specs
CSV column name:
has_the_patient_ever_received_screening_for_neuropathy_|was_the_last_screening_performed_during_the_current_audit_year
Default value:
0
Required:
false
Options
Label Value
No 0
Yes 1

Label	Value
No	0
Yes	1
No response	9

Label	Value
No	0
Yes	1

4 Drug treatments (at the end of the audit period)

4.1 Hypoglycemic treatment

choice

Insulin regimen

Technical specs

CSV column name:

insulin_regimen

Default value:

Only when:

Required:

false

Options

Label	Value
≤2 injections per day	1
3 injections per day	2
4 or more injections per day (basal-bolus regimen)	3
Insulin pump	4
Other schedule	5
No response	9

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

Frequency

Nested option fields

When 5 Is selected:
text
If "other" insulin schedule, specify:
Technical specs
CSV column name:
insulin_regimen|if_other_insulin_schedule_specify
Length:
100
Required:
false
Mapping of the clinical building blocks (indicative only)
Concept:
na
Data element:
na

choice

If "Insulin pump" insulin schedule, which type of technology did the patient mainly use during the audit year ?

Help

- A pump without sensor feedback is an insulin pump without direct communication with a sensor measuring the interstitial glucose level. - A sensor-augmented insulin pump (SAP) is an insulin pump coupled to a continuous glucose monitoring systems (CGMs), with only stop before/on low function - A hybrid closed-loop system is an insulin pump coupled with a continuous glucose monitoring systems (CGM) and an AI algorithm that uses data from the CGM and pump to automatically adjust the amount of insulin delivered. - Pump with fingersticks: The patient uses the finger as the main way to monitor blood glucose.

Technical specs

CSV column name:

CD_TPE_TECH_MAIN_USE

Only when:

Required:

false

Options

Label	Value
Pump without sensor feedback	1
Sensor-augmented pump (SAP)	2
Hybrid Closed loop Pumps	3
Pump with fingerpricks	4

number

Insulin dose (IU/day)

Technical specs

CSV column name:

insulin_dose_iuday

Length:

3.1

Only when:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

Dose

Validation

Insulin dose value can only have two decimal places (error)
The dose of insulin may not be less than 0 IU/day (error)
Insulin dose greater than 400 IU/day (error)

4.2 Other treatments

choice

Is the patient treated for celiac disease?

Technical specs

CSV column name:

is_the_patient_treated_for_celiac_disease

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1
No response	9

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

choice

Is the patient treated for hypo or hyperthyroidism?

Technical specs

CSV column name:

is_the_patient_treated_for_hypo_or_hyperthyroidism

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1
No response	9

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

choice

Is the patient treated for epilepsy?

Technical specs

CSV column name:

is_the_patient_treated_for_epilepsy

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1
No response	9

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

choice

Is the patient treated for arterial hypertension?

Technical specs

CSV column name:

is_the_patient_treated_for_arterial_hypertension

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1
No response	9

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

choice

Is the patient treated for dyslipidemia?

Technical specs

CSV column name:

is_the_patient_treated_for_dyslipidemia

Default value:

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1
No response	9

Mapping of the clinical building blocks (indicative only)

Concept:

Data element:

choice

Has the patient ever participated in an interventional clinical study to slow the development of diabetes?

Technical specs

CSV column name:

CD_PTCPD_CLIN_STDY_SLOW_DM

Default value:

Required:

false

Options

Label	Value
No	0
Yes	1
No response	9

choice

If "yes", was the patient still part of the clinical study during data collection?

Technical specs

CSV column name:

CD_STILL_CLIN_STDY_DATA_COLCN

Only when:

Required:

false

Options

Label	Value
No	0
Yes	1
No response	9