Data Collection Definitions

Initiative for Quality improvement and Epidemiology in Diabetes (IQED)

  • Start date: 01/10/2024
  • End date creation: 01/03/2025
  • End date submission: 01/03/2025
  • End date comments: 21/05/2025
Full viewCSV column namesValidation rulesReference listsComputed expressionsAdditional informationCSV extract

1 Data provider info

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-10-01

Required:

true

Read only

Mapping of the clinical building blocks (indicative only)

Concept:

na

Data element:

na

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:

2024-09-30

Required:

true

Read only

Mapping of the clinical building blocks (indicative only)

Concept:

na

Data element:

na

Validation
  • The difference between the end date of the audit period and the date of birth must not be less than 16 years. (error)
  • The diagnosis date of diabetes must not fall after the end date of the audit period. vallen (error)
  • The start date of treatment with oral antidiabetics should not be after the end date of the audit period (error)
  • The start date of insulin treatment should not be after the end date of the audit period (error)
  • The inclusion date in your convention must not fall after the end date of the audit period (error)
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:

11

Reference list:

PHYSICIAN

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Caregiver

Data element:

CareGiverIdentificationNumber

text

NIHDI-code of the data provider institution

Not to be included in the CSV.

Help

This field is automatically filled and cannot be modified.

Technical specs

CSV column name:

installation_id

Computed:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.HealthcareProvider

Data element:

HealthcareProviderIdentificationNumber

text

Campus number

Help

Your centre has indicated to register as individual sites, please enter the campus number of the site before registering this patient.

Technical specs

CSV column name:

site_number

Length:

100

Reference list:

CAMPUS

Required:

true

Stable:

true

Mapping of the clinical building blocks (indicative only)

Concept:

na

Data element:

na

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

2.1 Sociodemographic 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

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 the 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 patient ID field.

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
LabelValue
YesTRUE
NoFALSE
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

Required:

noSSIN(Needed only if no national register number is entered)

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

Required:

noSSIN(Needed only if no national register number is entered)

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

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 end date of the audit period and the date of birth must not be less than 16 years. (error)
  • The diagnosis date of diabetes must not fall before the date of birth (error)
  • The date of death cannot be before the date of birth (error)
choice

Sex

Technical specs

CSV column name:

patient_id|sex

Required:

true

Stable:

true

Options
LabelValue
FemaleF
MaleM
UnknownU
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

Gender

text

Place of residence

Help

For patients not living in Belgium, choose postal code "9999" and provide the country of residence in the follow-up question.

Technical specs

CSV column name:

patient_id|place_of_residence

Length:

5

Reference list:

POSTAL_CODE

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

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

DeathIndicator

Options
LabelValue
YesTRUE
NoFALSE
date

Date of death

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:

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)
text

Country of residence

Technical specs

CSV column name:

country_of_residence

Reference list:

COUNTRY

Only when:

Required:

false

choice

Does the patient live in a nursing home?

Help

Both permanent residence and short-term and day care.

Technical specs

CSV column name:

CD_PAT_NURS_HOM

Required:

false

Options
LabelValue
No0
Yes1
No response9

2.2 Diabetes

choice

Diabetes type

Technical specs

CSV column name:

diabetes_type

Required:

true

Stable:

true

Options
LabelValue
11
22
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferConcern

Data element:

ProblemName

Validation
  • It was not indicated that this patient has type 1 diabetes, yet a value for the question "Was this patient added to the sample to reach the minimum of 25 type 1 diabetics? " was indicated. Please correct. (error)
choice

Was this patient added to the sample to reach the minimum of 25 type 1 diabetics?

Technical specs

CSV column name:

was_this_patient_added_to_the_sample_to_reach_the_minimum_of_25_type_1_diabetics

Only when:

Required:

true

Options
LabelValue
No0
Yes1
Mapping of the clinical building blocks (indicative only)

Concept:

na

Data element:

na

Validation
  • It was not indicated that this patient has type 1 diabetes, yet a value for the question "Was this patient added to the sample to reach the minimum of 25 type 1 diabetics? " was indicated. Please correct. (error)
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

Required:

false

Stable:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferConcern

Data element:

ProblemStartDate

Validation
  • The diagnosis date of diabetes must not fall after the end date of the audit period. vallen (error)
  • The diagnosis date of diabetes must not fall before the date of birth (error)
  • The start date of treatment with oral antidiabetics should not be before the diagnosis date of diabetes (error)
  • The start date of insulin treatment should not be before the diagnosis date of diabetes (error)
  • The inclusion date in your convention must not fall before the diagnosis date of diabetes (error)
date

Start date treatment with oral antidiabetics

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_treatment_with_oral_antidiabetics

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 treatment with oral antidiabetics should not be after the end date of the audit period (error)
  • The start date of treatment with oral antidiabetics should not be before the diagnosis date of diabetes (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

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 should not be after the end date of the audit period (error)
  • The start date of insulin treatment should not be before the diagnosis date of diabetes (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 subsequently rejoined, enter 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

Required:

false

Stable:

true

Mapping of the clinical building blocks (indicative only)

Concept:

na

Data element:

na

Validation
  • The inclusion date in your convention must not fall after the end date of the audit period (error)
  • The inclusion date in your convention must not fall before the diagnosis date of diabetes (error)

3 Medical history (at the end of the audit period)

choice

Has the patient already received a kidney transplant or is he receiving hemodialysis or peritoneal dialysis?

Technical specs

CSV column name:

has_the_patient_already_received_a_kidney_transplant_or_is_he_receiving_hemodialysis_or_peritoneal_dialysis

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureType

choice

Has the patient ever received treatment (laser photocoagulation and/or intravitreal injection) for diabetic retinopathy?

Technical specs

CSV column name:

has_the_patient_ever_received_treatment_laser_photocoagulation_andor_intravitreal_injection_for_diabetic_retinopathy

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureType

Validation
  • The answer to the question "Did the patient ever receive treatment (laser photocoagulation and/or intravitreal injection) for diabetic retinopathy?" is "No," yet a value was entered to the question "If so, during the audit period? This is inconsistent. Please correct. (error)
  • For this patient, it is indicated that this patient was once treated for diabetic retinopathy, however, does not have (extinguished) diabetic retinopathy . This is inconsistent. Please correct. (error)
Nested option fields
  • When 1 Is selected:
    choice

    If yes, during the audit period?

    Technical specs

    CSV column name:

    has_the_patient_ever_received_treatment_laser_photocoagulation_andor_intravitreal_injection_for_diabetic_retinopathy|if_yes_during_the_audit_period

    Required:

    false

    Options
    LabelValue
    No0
    Yes1
    No response9
    Mapping of the clinical building blocks (indicative only)

    Concept:

    be.en.hd.TransferProcedure

    Data element:

    ProcedureStartDate

choice

Has the patient ever received treatment (laser photocoagulation and/or intravitreal injection) for diabetic maculopathy?

Technical specs

CSV column name:

has_the_patient_ever_received_treatment_laser_photocoagulation_andor_intravitreal_injection_for_diabetic_maculopathy

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureType

Validation
  • The answer to the question "Did the patient ever receive treatment (laser photocoagulation and/or intravitreal injection) for diabetic maculopathy?" is "No," yet a value was entered to the question "If so, during the audit period? This is inconsistent. Please correct. (error)
Nested option fields
  • When 1 Is selected:
    choice

    If yes, during the audit period?

    Technical specs

    CSV column name:

    has_the_patient_ever_received_treatment_laser_photocoagulation_andor_intravitreal_injection_for_diabetic_maculopathy|if_yes_during_the_audit_period

    Required:

    false

    Options
    LabelValue
    No0
    Yes1
    No response9
    Mapping of the clinical building blocks (indicative only)

    Concept:

    be.en.hd.TransferProcedure

    Data element:

    ProcedureStartDate

choice

Does or did the patient have diabetic retinopathy?

Help

Also answer 'Yes' if the retinopathy is extinct. Also answer 'Yes' if only 1 eye is affected. Also answer 'Yes' if you have indicated that this patient has ever been treated (laser photocoagulation and/or intravitreal injection) for diabetic retinopathy.

Technical specs

CSV column name:

does_the_patient_have_diabetic_retinopathy

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferConcern

Data element:

ProblemName

Validation
  • For this patient, it is indicated that this patient was once treated for diabetic retinopathy, however, does not have (extinguished) diabetic retinopathy . This is inconsistent. Please correct. (error)
choice

Is the patient blind?

Help

Blindness occurs if vision in both eyes is less than 6/40 fractional or than 1/10 Snellan.

Technical specs

CSV column name:

is_the_patient_blind

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferConcern

Data element:

ProblemName

choice

Has the patient ever suffered a diabetic foot ulcer?

Help

Foot wound due to neuropathy and/or vasculopathy. Note: do not count ingrown nails, blisters and leg wounds.

Technical specs

CSV column name:

has_the_patient_ever_suffered_a_diabetic_foot_ulcer

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferConcern

Data element:

ProblemName

Validation
  • The answer to the question "Has the patient ever had a diabetic foot wound?" is "No," yet a value was filled in to the question "If yes, during the audit period?". This is inconsistent. Please correct. (error)
Nested option fields
  • When 1 Is selected:
    choice

    If yes, during the audit period?

    Technical specs

    CSV column name:

    has_the_patient_ever_suffered_a_diabetic_foot_ulcer|if_yes_during_the_audit_period

    Required:

    false

    Options
    LabelValue
    No0
    Yes1
    No response9
    Mapping of the clinical building blocks (indicative only)

    Concept:

    be.en.hd.TransferConcern

    Data element:

    ProblemStartDate

choice

Has the patient ever received revascularization of the lower limbs?

Help

Count both endovascular and surgical revascularizations.

Technical specs

CSV column name:

has_the_patient_ever_received_revascularization_of_the_lower_limbs

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureType

Validation
  • The answer to the question "Has the patient ever received revascularization of the lower limbs?" is "No," yet a value was filled in to the question "If yes, during the audit period?". This is inconsistent. Please correct. (error)
Nested option fields
  • When 1 Is selected:
    choice

    If yes, during the audit period?

    Technical specs

    CSV column name:

    has_the_patient_ever_received_revascularization_of_the_lower_limbs|if_yes_during_the_audit_period

    Required:

    false

    Options
    LabelValue
    No0
    Yes1
    No response9
    Mapping of the clinical building blocks (indicative only)

    Concept:

    be.en.hd.TransferProcedure

    Data element:

    ProcedureStartDate

choice

Has the patient ever received a minor amputation of the lower limbs?

Help

Minor amputation: below the ankle, i.e. where heel support is still possible. Give the situation of the limb where the most severe amputation happened.

Technical specs

CSV column name:

has_the_patient_ever_received_a_minor_amputation_of_the_lower_limbs

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureType

choice

Has the patient ever received a major amputation of the lower limbs?

Help

Major amputation: above the ankle, i.e. where heel support is no longer possible. Give the situation of the limb where the most severe amputation happened.

Technical specs

CSV column name:

has_the_patient_ever_received_a_major_amputation_of_the_lower_limbs

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureType

choice

Has the patient ever suffered a myocardial infarction?

Technical specs

CSV column name:

has_the_patient_ever_suffered_a_myocardial_infarction

Required:

false

Options
LabelValue
No0
Yes1
No response9
Validation
  • The answer to the question "Has the patient ever suffered a myocardial infarction?" is "No," yet a value was filled in to the question "If yes, during the audit period?". This is inconsistent. Please correct. (error)
Nested option fields
  • When 1 Is selected:
    choice

    If yes, during the audit period?

    Technical specs

    CSV column name:

    has_the_patient_ever_suffered_a_myocardial_infarction|if_yes_during_the_audit_period

    Required:

    false

    Options
    LabelValue
    No0
    Yes1
    No response9
choice

Has the patient ever suffered a stroke?

Technical specs

CSV column name:

has_the_patient_ever_suffered_a_stroke

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferConcern

Data element:

ProblemName

Validation
  • The answer to the question "Has the patient ever suffered a stroke?" is "No," yet a value was filled in to the question "If yes, during the audit period?". This is inconsistent. Please correct. (error)
Nested option fields
  • When 1 Is selected:
    choice

    If yes, during the audit period?

    Technical specs

    CSV column name:

    has_the_patient_ever_suffered_a_stroke|if_yes_during_the_audit_period

    Required:

    false

    Options
    LabelValue
    No0
    Yes1
    No response9
    Mapping of the clinical building blocks (indicative only)

    Concept:

    be.en.hd.TransferConcern

    Data element:

    ProblemStartDate

choice

Has the patient ever received carotid revascularisation ?

Technical specs

CSV column name:

CD_PAT_TCAR

Required:

false

Options
LabelValue
No0
Yes1
No response9
Validation
  • The answer to the question "Has the patient ever received carotid revascularisation ?" is "No," yet a value was filled in to the question "If yes, during the audit period?". This is inconsistent. Please correct. (error)
Nested option fields
  • When 1 Is selected:
    choice

    If yes, during the audit period?

    Technical specs

    CSV column name:

    CD_PAT_TCAR|if_yes_during_the_audit_period

    Required:

    false

    Options
    LabelValue
    No0
    Yes1
    No response9
choice

Has the patient ever received a coronary revascularization (PCI/CABG) ?

Technical specs

CSV column name:

CD_PAT_PCI_CABG

Required:

false

Options
LabelValue
No0
Yes1
No response9
Validation
  • The answer to the question "Has the patient ever received a coronary revascularization (PCI/CABG) ?" is "No," yet a value was filled in to the question "If yes, during the audit period?". This is inconsistent. Please correct. (error)
Nested option fields
  • When 1 Is selected:
    choice

    If yes, during the audit period?

    Technical specs

    CSV column name:

    CD_PAT_PCI_CABG|if_yes_during_the_audit_period

    Required:

    false

    Options
    LabelValue
    No0
    Yes1
    No response9
choice

Has the patient a diagnosis of heart failure confirmed and followed up by a cardiologist?

Technical specs

CSV column name:

CD_PAT_HFAE_DIAGS

Required:

false

Options
LabelValue
No0
Yes1
No response9

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

4.1 Self-measurement of blood glucose

choice

The patient uses the following measurement method:

Help

Indicate the main method. To answer "Sensor based continuous glucose monitoring (rtCGM/isCGM)", the use of sensor-based continuous glucose measurement should be intended for long-term use (at least 2 months) and not as a short test period.

Technical specs

CSV column name:

the_patient_uses_the_following_measurement_method

Required:

false

Options
LabelValue
Finger-stick testfingerstick_test
Sensor based continuous glucose monitoring (rtCGM/isCGM)sensor_based_cgm
No responseno_response
Mapping of the clinical building blocks (indicative only)

Concept:

na

Data element:

na

Validation
  • There was not indicated that the patient used "Sensor based continuous glucose monitoring (rtCGM/isCGM)", yet a value was filled in to the question "TIR". This is inconsistent. Please correct. (error)
  • There was not indicated that the patient used "Sensor based continuous glucose monitoring (rtCGM/isCGM)", yet a value was filled in to the question "TBR". This is inconsistent. Please correct. (error)
  • There was not indicated that the patient used "Sensor based continuous glucose monitoring (rtCGM/isCGM)", yet a value was filled in to the question "CV". This is inconsistent. Please correct. (error)
  • It was not indicated that the patient uses an insulin pump and CGM, yet a value was given for: Is the patient using a (hybrid) closed loop system? Please correct. (error)

4.2 Smoking habits

choice

Smoking status

Help

Ex-smoker: if the patient has not smoked for > 6 months; Smoker: user of tobacco or e-cigarette

Technical specs

CSV column name:

smoking_status

Required:

false

Options
LabelValue
Never smoked0
Ex-smoker1
Smoker2
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

Be.en.hd.TobaccoUse

Data element:

TobaccoUseStatus

4.3 Anthropometry

number

Weight (kg)

Technical specs

CSV column name:

weight_kg

Length:

3.1

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.BodyWeight

Data element:

WeightValue

Validation
  • The weight cannot be less than 0 kg (error)
  • Weight can only have 1 number after the decimal seperator (error)
  • The weight is greater than 999.9 kg (error)
number

Height (cm)

Technical specs

CSV column name:

height_cm

Length:

3.1

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.BodyHeight

Data element:

HeightValue

Validation
  • The length is greater than 999.9 cm (error)
  • Height can only have 1 number after the decimal seperator (error)
  • The length cannot be less than 0 cm (error)
number

Waist circumference (cm)

Technical specs

CSV column name:

waist_circumference_cm

Length:

3.1

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

na

Data element:

na

Validation
  • The abdominal circumference is greater than 999.9 cm (error)
  • Waist circumference can only have 1 number after the decimal seperator (error)
  • The abdominal circumference should not be less than 0 cm (error)

4.4 Blood pressure

number

Systolic blood pressure (mmHg)

Technical specs

CSV column name:

systolic_blood_pressure_mmhg

Length:

3

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.BloodPressure

Data element:

SystolicBloodPressure

Validation
  • Diastolic blood pressure is greater than or equal to systolic blood pressure (error)
  • The systolic blood pressure is greater than 999 mmHg (error)
  • Systolic blood pressure (mmHg) must be an integer (error)
  • The systolic blood pressure should not be less than 0 mmHg (error)
number

Diastolic blood pressure (mmHg)

Technical specs

CSV column name:

diastolic_blood_pressure_mmhg

Length:

3

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.BloodPressure

Data element:

DiastolicBloodPressure

Validation
  • Diastolic blood pressure is greater than or equal to systolic blood pressure (error)
  • Diastolic blood pressure is greater than 999 mmHg (error)
  • Diastolic blood pressure (mmHg) must be an integer (error)
  • Diastolic blood pressure should not be less than 0 mmHg (error)

4.5 HbA1c

choice

Was HbA1c determined?

Help

In the audit period

Technical specs

CSV column name:

was_hba1c_determined

Required:

false

Options
LabelValue
No0
Yes1
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

TestName

Validation
  • The HbA1c is greater than 99.9% (error)
  • Number of HbA1c determinations must be an integer (error)
  • HbA1c can only have 1 number after the decimal seperator (error)
  • The HbA1c should not be less than 0% (error)
  • The number of HbA1c determinations should not be less than 0 (error)
  • The number of HbA1c determinations is greater than 99 (error)
  • The answer to the question "Was HbA1c determined?" is "No," yet a value was filled in to the question "HbA1c (%)". This is inconsistent. Please correct. (error)
  • The answer to the question "Was HbA1c determined?" is "No," yet a value was filled in to the question "Number of HbA1c determinations". This is inconsistent. Please correct. (error)
Nested option fields
  • When 1 Is selected:
    number

    HbA1c (%)

    Help

    The measured HbA1c value, not the Glucose Management Indicator.

    Technical specs

    CSV column name:

    was_hba1c_determined|hba1c_

    Length:

    3.1

    Required:

    false

    Mapping of the clinical building blocks (indicative only)

    Concept:

    be.en.hd.TransferLaboratoryResult

    Data element:

    Result

    number

    Number of HbA1c determinations

    Help

    In the audit period

    Technical specs

    CSV column name:

    was_hba1c_determined|number_of_hba1c_determinations

    Length:

    2

    Required:

    false

    Mapping of the clinical building blocks (indicative only)

    Concept:

    be.en.hd.TransferLaboratoryResult

    Data element:

    TestName

number

Time in Range (TIR) over a period of 14-30 days (%) - (70-180 mg/dL)

Help

Take the values of the last readout. To be completed if average daily rtCGM/isCGM usage is more than 70%, which corresponds to 5 days/week.

Technical specs

CSV column name:

MS_TIR_14D

Only when:

Required:

false

Validation
  • The TIR must be an integer (error)
  • The TIR must be no smaller than 0 (error)
  • The TIR must be no larger than 100 (error)
  • There was not indicated that the patient used "Sensor based continuous glucose monitoring (rtCGM/isCGM)", yet a value was filled in to the question "TIR". This is inconsistent. Please correct. (error)
number

Time Below Range (TBR) over a period of 14-30 days (%) - Level 1 (54 - 69 mg/dL)

Help

Take the values of the last readout. To be completed if average daily rtCGM/isCGM usage is more than 70%, which corresponds to 5 days/week.

Technical specs

CSV column name:

MS_TBR_14D_LEVEL1

Only when:

Required:

false

Validation
  • The TBR must be no larger than 100 (error)
  • The TBR must be no smaller than 0 (error)
  • The TBR must be an integer (error)
  • There was not indicated that the patient used "Sensor based continuous glucose monitoring (rtCGM/isCGM)", yet a value was filled in to the question "TBR". This is inconsistent. Please correct. (error)
number

Time Below Range (TBR) over a period of 14-30 days (%) - Level 2 (

Help

Take the values of the last readout. To be completed if average daily rtCGM/isCGM usage is more than 70%, which corresponds to 5 days/week.

Technical specs

CSV column name:

MS_TBR_14D_LEVEL2

Only when:

Required:

false

Validation
  • The TBR must be no larger than 100 (error)
  • The TBR must be no smaller than 0 (error)
  • The TBR must be an integer (error)
  • There was not indicated that the patient used "Sensor based continuous glucose monitoring (rtCGM/isCGM)", yet a value was filled in to the question "TBR". This is inconsistent. Please correct. (error)
number

Coefficient of Variation over a period of 14-30 days (%)

Help

Take the values of the last readout. To be completed if average daily rtCGM/isCGM usage is more than 70%, which corresponds to 5 days/week.

Technical specs

CSV column name:

MS_COV_14D

Only when:

Required:

false

Validation
  • The CV must be no larger than 100 (error)
  • The CV must be no smaller than 0 (error)
  • The CV must be an integer (error)
  • There was not indicated that the patient used "Sensor based continuous glucose monitoring (rtCGM/isCGM)", yet a value was filled in to the question "CV". This is inconsistent. Please correct. (error)

4.6 Lipids

choice

Were blood lipids determined?

Help

In the audit period

Technical specs

CSV column name:

were_blood_lipids_determined

Required:

false

Options
LabelValue
No0
Yes1
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

TestName

Validation
  • HDL-cholesterol is greater than 999.9 mg/dl (error)
  • HDL cholesterol is greater than or equal to total cholesterol (error)
  • Triglycerides are greater than 9999.9 mg/dL (error)
  • LDL cholesterol, measured in lab, is greater than 999.9 mg/dl (error)
  • LDL-cholesterol, measured in lab, is greater than or equal to total cholesterol (error)
  • Totaal cholesterol can only have 1 number after the decimal seperator (error)
  • HDL cholesterol can only have 1 number after the decimal seperator (error)
  • Triglycerides can only have 1 number after the decimal seperator (error)
  • LDL cholesterol can only have 1 number after the decimal seperator (error)
  • Cholesterol is greater than 999.9 mg/dL (error)
  • Total cholesterol must not be smaller than 0 mg/dL (error)
  • HDL cholesterol should not be less than 0 mg/dL (error)
  • Triglycerides must not be smaller than 0 mg/dL (error)
  • LDL cholesterol, measured in lab, should not be less than 0 mg/dL (error)
  • The answer to the question "Was blood lipids determined?" is "No," yet a value was filled in to the question "Total cholesterol (mg/dL)". This is inconsistent. Please correct. (error)
  • The answer to the question "Was blood lipids determined?" is "No," yet a value was filled in to the question "HDL cholesterol (mg/dL)". This is inconsistent. Please correct. (error)
  • The answer to the question "Was blood lipids determined?" is "No," yet a value was filled in to the question "Triglycerides (mg/dL)". This is inconsistent. Please correct. (error)
  • The answer to the question "Was blood lipids determined?" is "No," yet a value was filled in to the question "Did the patient fast?". This is inconsistent. Please correct. (error)
  • The answer to the question "Was blood lipids determined?" is "No," yet a value was filled in to the question "LDL cholesterol (mg/dL) measured in the lab". This is inconsistent. Please correct. (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

    choice

    Did the patient fast?

    Technical specs

    CSV column name:

    were_blood_lipids_determined|did_the_patient_fast

    Required:

    false

    Options
    LabelValue
    No0
    Yes1
    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, 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

4.7 Kidneys

choice

Was serum creatinine determined?

Help

In the audit period

Technical specs

CSV column name:

was_serum_creatinine_determined

Required:

false

Options
LabelValue
No0
Yes1
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

TestName

Validation
  • Serum creatinine can only have 3 numbers after the decimal seperator (error)
  • Serum creatinine should not be less than 0 mg/dL (error)
  • Serum creatinine is greater than 999.999 mg/dL (error)
  • The answer to the question "Was serum creatinine determined?" is "No," yet a value was filled in to the question "Serum creatinine (mg/dL)". This is inconsistent. Please correct. (error)
Nested option fields
  • When 1 Is selected:
    number

    Serum creatinine (mg/dL)

    Technical specs

    CSV column name:

    was_serum_creatinine_determined|serum_creatinine_mgdl

    Length:

    3.3

    Required:

    false

    Mapping of the clinical building blocks (indicative only)

    Concept:

    be.en.hd.TransferLaboratoryResult

    Data element:

    Result

choice

Was microalbuminuria determined?

Help

In the audit period

Technical specs

CSV column name:

was_microalbuminuria_determined

Required:

false

Options
LabelValue
No0
Yes1
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

TestName

Validation
  • Result for albuminuria can only have 2 numbers after the decimal seperator (error)
  • The albuminuria should not be less than 0 mg/dL (error)
  • The albuminuria is greater than 9999.99 mg/dL (error)
  • The answer to the question "Was microalbuminuria determined?" is "No," yet a value was filled in to the question "Result for albuminuria (mg/g crea)". This is inconsistent. Please correct. (error)
Nested option fields
  • When 1 Is selected:
    number

    Result for albuminuria (mg/g crea)

    Help

    Urine albumine creatinine ratio (mg/g crea) -When the value is below detection limit, take half of the detection limit

    Technical specs

    CSV column name:

    was_microalbuminuria_determined|result_for_albuminuria

    Length:

    4.2

    Required:

    false

    Mapping of the clinical building blocks (indicative only)

    Concept:

    be.en.hd.TransferLaboratoryResult

    Data element:

    Result

4.8 Eyes

choice

Was screening for retinopathy performed?

Help

In the audit period

Technical specs

CSV column name:

was_screening_for_retinopathy_performed

Required:

false

Options
LabelValue
No0
Yes1
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureType

4.9 Feet

choice

Was sensation testing (monofilament or biothesiometer or tuning fork) performed?

Help

In the audit period

Technical specs

CSV column name:

was_sensation_testing_monofilament_or_biothesiometer_or_tuning_fork_performed

Required:

false

Options
LabelValue
No0
Yes1
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureType

Validation
  • The answer to the question "Was sensation testing (monofilament or biothesiometer or tuning fork) performed?" is "No," yet a test result was filled in. This is inconsistent. Please correct. (error)
Nested option fields
  • When 1 Is selected:
    choice

    Result of sensation testing

    Help

    Test with monofilament: is considered disturbed if the patient does not feel the monofilament on at least 2 out of 3 points. - Test with biothesiometer (>=25 V) or tuning fork 128 Hz: is considered impaired if the patient does not feel the vibrations. Also answer "Impaired result" if only 1 foot is affected.

    Technical specs

    CSV column name:

    was_sensation_testing_monofilament_or_biothesiometer_or_tuning_fork_performed|result_of_sensation_testing

    Required:

    false

    Options
    LabelValue
    Normal result1
    Abnormal result2
    No response9
    Mapping of the clinical building blocks (indicative only)

    Concept:

    na

    Data element:

    na

choice

Was an exam of the foot pulses performed?

Help

In the audit period

Technical specs

CSV column name:

was_an_exam_of_the_foot_pulses_performed

Required:

false

Options
LabelValue
No0
Yes1
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureType

Validation
  • The answer to the question "Was an exam of the foot pulses performed?" is "No," yet a test result was filled in. This is inconsistent. Please correct. (error)
Nested option fields
  • When 1 Is selected:
    choice

    Result of the exam of the foot pulses

    Help

    Foot pulsations are considered absent if no pulsations are present. Also answer "Absent pulsations" if only 1 foot is affected.

    Technical specs

    CSV column name:

    was_an_exam_of_the_foot_pulses_performed|result_of_the_exam_of_the_foot_pulses

    Required:

    false

    Options
    LabelValue
    Pulses present1
    Pulses absent2
    No response9
    Mapping of the clinical building blocks (indicative only)

    Concept:

    na

    Data element:

    na

4.10 Acute complications

choice

Did the patient have episodes of SEVERE hypoglycemia?

Help

In the audit period. Definition severe hypoglycemia: semi- to completely unconscious status where the patient requires third-party assistance. Thus, this is not equivalent to the number of hypoglycemics read on the glucometer!

Technical specs

CSV column name:

did_the_patient_have_episodes_of_severe_hypoglycemia

Required:

false

Options
LabelValue
No0
Yes1
No response9
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)?

Help

In the audit period. Do not count the "inaugural" ketoacidosis, in the diagnosis of diabetes.

Technical specs

CSV column name:

was_the_patient_admitted_for_ketoacidosis_or_for_hyperosmolar_hyperglycemic_state_with_or_without_ketosis

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Contact

Data element:

Problem::ProblemName

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

5.1 Hypoglycemic treatment

choice

Insulin regimen

Technical specs

CSV column name:

insulin_regimen

Required:

false

Options
LabelValue
Insulin pump4
Injections6
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

Frequency

Validation
  • It was not indicated that the patient uses an insulin pump and CGM, yet a value was given for: Is the patient using a (hybrid) closed loop system? Please correct. (error)
choice

Does the patient use a (hybrid-) closed loop system?

Technical specs

CSV column name:

CD_CLOSE_LOOP_SYSTM

Only when:

Required:

false

Options
LabelValue
No0
Yes1
No response9
Validation
  • It was not indicated that the patient uses an insulin pump and CGM, yet a value was given for: Is the patient using a (hybrid) closed loop system? Please correct. (error)
choice

Treatment with biguanides?

Technical specs

CSV column name:

treatment_with_biguanides

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

ProductName

choice

Treatment with sulphonylurea and/or glinides?

Technical specs

CSV column name:

treatment_with_sulphonylurea_andor_glinides

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

ProductName

choice

Treatment with glitazones?

Technical specs

CSV column name:

treatment_with_glitazones

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

ProductName

choice

Treatment with DPP-4 inhibitors?

Technical specs

CSV column name:

treatment_with_dpp4_inhibitors

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

ProductName

choice

Treatment with SGLT2 inhibitors?

Technical specs

CSV column name:

treatment_with_sglt2_inhibitors

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

ProductName

choice

Treatment with incretin mimetics or GLP-1 receptor agonists?

Technical specs

CSV column name:

treatment_with_incretin_mimetics_or_glp1_receptor_agonists

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

ProductName

5.2 Cardiovascular treatment

choice

Treatment with statins?

Technical specs

CSV column name:

treatment_with_statins

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

ProductName

choice

Treatment with fibrates?

Technical specs

CSV column name:

treatment_with_fibrates

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

ProductName

choice

Treatment with ezetimibe?

Technical specs

CSV column name:

treatment_with_ezetimibe

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

ProductName

choice

Treatment with other lipid lowering medication?

Technical specs

CSV column name:

CD_TREAT_OTH_LIP_LOW_MEDICT

Required:

false

Options
LabelValue
No0
Yes1
No response9
choice

Treatment with antiaggregants or anticoagulants?

Technical specs

CSV column name:

treatment_with_antiaggregants_or_anticoagulants

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

ProductName

choice

Treatment with ACE inhibitors or sartans?

Technical specs

CSV column name:

treatment_with_ace_inhibitors_or_sartans

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

ProductName

choice

Does the patient receive other antihypertensive drugs?

Help

By "other" we mean antihypertensive drugs that do NOT act on the renin-angiotensin system.

Technical specs

CSV column name:

does_the_patient_receive_other_antihypertensive_drugs

Required:

false

Options
LabelValue
No0
Yes1
No response9
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.MedicationPrescription

Data element:

ProductName

choice

Is the patient being treated for neuropathic pain?

Technical specs

CSV column name:

CD_PAT_TREATD_NEUROPT_PAIN

Required:

false

Options
LabelValue
No0
Yes1
No response9