Data Collection Definitions

Care trajectory diabetes mellitus type 2 (Care Trajectory DM2)

  • Start date: 01/10/2017
  • End date creation: 09/03/2018
  • End date submission: 09/03/2018
  • End date comments: 09/03/2018
Full viewCSV column namesValidation rulesReference listsComputed expressionsAdditional informationCSV extract

1 Patient

patient identificator

National registry ID

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

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

Length:

50

Required:

false

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

Last 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:

50

Required:

false

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:

50

Required:

false

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:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

DateOfBirth

Validation
  • The date of birth cannot be in the future (warning)
choice

Sex

Technical specs

CSV column name:

patient_id|sex

Required:

false

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

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:

Postcode

boolean

Deceased?

Not to be included in the CSV.

Help

Not applicable

Technical specs

CSV column name:

patient_id|deceased

Required:

false

Read only

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

DeathIndicator

Options
LabelValue
YesTRUE
NoFALSE
date

Date of death

Not to be included in the CSV.

Help

Not applicable

Technical specs

Format:

DD/MM/YYYY

CSV column name:

patient_id|date_of_death

Only when:

Required:

false

Read only

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

DateOfDeath

2 Caregiver

text

RIZIV/INAMI-code of the treating physician

Technical specs

CSV column name:

rizivinamicode_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

3 Care trajectory

list

Start and end date of the care trajectory

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

Element conditions
MessageExpression
The start date of the care trajectory cannot be in the futuretypeof $.start_date_of_the_care_trajectory === 'string'?new Date($.start_date_of_the_care_trajectory)
The start date of the care trajectory cannot be before 01/09/2009typeof $.start_date_of_the_care_trajectory=== 'string'?$.start_date_of_the_care_trajectory>= '2009-09-01':true
The end date of the care trajectory cannot be before 01/09/2009typeof $.end_date_of_the_care_trajectory=== 'string'?$.end_date_of_the_care_trajectory>= '2009-09-01':true
Mapping of the clinical building blocks (indicative only)

Concept:

custom.CareTrajectories

Data element:

List items
date

Start date of the care trajectory

Technical specs

Format:

DD/MM/YYYY

CSV column name:

start_and_end_date_of_the_care_trajectory|0|start_date_of_the_care_trajectory

Required:

true

date

End date of the care trajectory

Technical specs

Format:

DD/MM/YYYY

CSV column name:

start_and_end_date_of_the_care_trajectory|0|end_date_of_the_care_trajectory

Required:

false

4 Clinical status

4.1 Anthropometry

list

Height

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

Element conditions
MessageExpression
Date of height measurement cannot be in the future typeof $.value_date_height=== 'string'?new Date($.value_date_height)
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.BodyHeight

Data element:

List items
number

Height (value)

Technical specs

CSV column name:

height|0|height_value

Length:

3,3

Required:

false

Validation
  • is less than 100 cm (warning)
  • is greater than 250 cm (warning)
text

Height (unit)

Technical specs

CSV column name:

height|0|height_unit

Length:

50

Required:

false

date

Date of height measurement

Technical specs

Format:

DD/MM/YYYY

CSV column name:

height|0|value_date_height

Required:

false

list

Weight

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

Element conditions
MessageExpression
Date of weight measurement cannot be in the futuretypeof $.value_date_weight === 'string'?new Date($.value_date_weight)
Date of weight measurement cannot be before 01/09/2008typeof $.value_date_weight=== 'string'?$.value_date_weight>= '2008-09-01':true
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.BodyWeight

Data element:

List items
number

Weight (value)

Technical specs

CSV column name:

weight|0|weight_value

Length:

3,3

Required:

false

Validation
  • is less than 25 kg (warning)
  • is greater than 250 kg (warning)
text

Weight (unit)

Technical specs

CSV column name:

weight|0|weight_unit

Length:

50

Required:

false

date

Date of weight measurement

Technical specs

Format:

DD/MM/YYYY

CSV column name:

weight|0|value_date_weight

Required:

false

4.2 Blood pressure

list

Systolic blood pressure

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

Element conditions
MessageExpression
Date of systolic blood pressure measurement cannot be in the futuretypeof $.value_date_systolic_blood_pressure=== 'string'?new Date($.value_date_systolic_blood_pressure)
Date of systolic blood pressure measurement cannot be before 01/09/2008typeof $.value_date_systolic_blood_pressure=== 'string'?$.value_date_systolic_blood_pressure>= '2008-09-01':true
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.BloodPressure

Data element:

List items
number

Systolic blood pressure (value)

Technical specs

CSV column name:

systolic_blood_pressure|0|systolic_blood_pressure_value

Length:

3

Required:

false

Validation
  • is less than 50 mmHg (warning)
  • is greater than 250 mmHg (warning)
text

Systolic blood pressure (unit)

Technical specs

CSV column name:

systolic_blood_pressure|0|systolic_blood_pressure_unit

Length:

50

Required:

false

date

Date of systolic blood pressure measurement

Technical specs

Format:

DD/MM/YYYY

CSV column name:

systolic_blood_pressure|0|value_date_systolic_blood_pressure

Required:

false

list

Diastolic blood pressure

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

Element conditions
MessageExpression
Date of diastolic blood pressure measurement cannot be in the futuretypeof $.value_date_diastolic_blood_pressure=== 'string'?new Date($.value_date_diastolic_blood_pressure)
Date of diastolic blood pressure measurement cannot be before 01/09/2008typeof $.value_date_diastolic_blood_pressure=== 'string'?$.value_date_diastolic_blood_pressure>= '2008-09-01':true
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.BloodPressure

Data element:

List items
number

Diastolic blood pressure (value)

Technical specs

CSV column name:

diastolic_blood_pressure|0|diastolic_blood_pressure_value

Length:

3

Required:

false

Validation
  • is less than 50 mmHg (warning)
  • is greater than 200 mmHg (warning)
text

Diastolic blood pressure (unit)

Technical specs

CSV column name:

diastolic_blood_pressure|0|diastolic_blood_pressure_unit

Length:

50

Required:

false

date

Date of diastolic blood pressure measurement

Technical specs

Format:

DD/MM/YYYY

CSV column name:

diastolic_blood_pressure|0|value_date_diastolic_blood_pressure

Required:

false

5 Clinical biology

5.1 HbA1c

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

Element conditions
MessageExpression
Date of HbA1c measurement cannot be in the futuretypeof $.value_date_hba1c=== 'string'?new Date($.value_date_hba1c)
Date of HbA1c measurement cannot be before 01/09/2008typeof $.value_date_hba1c=== 'string'?$.value_date_hba1c>= '2008-09-01':true
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

List items
number

HbA1c (value)

Technical specs

CSV column name:

hba1c|0|hba1c_value

Length:

3,3

Required:

false

text

HbA1c (unit)

Technical specs

CSV column name:

hba1c|0|hba1c_unit

Length:

50

Required:

false

date

Date of HbA1c measurement

Technical specs

Format:

DD/MM/YYYY

CSV column name:

hba1c|0|value_date_hba1c

Required:

false

5.2 LDL cholesterol

list

LDL cholesterol

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

Element conditions
MessageExpression
Date of LDL cholesterol measurement cannot be in the futuretypeof $.value_date_ldl_cholesterol === 'string'?new Date($.value_date_ldl_cholesterol)
Date of LDL cholesterol measurement cannot be before 01/09/2008typeof $.value_date_ldl_cholesterol=== 'string'?$.value_date_ldl_cholesterol>= '2008-09-01':true
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

List items
number

LDL cholesterol (value)

Technical specs

CSV column name:

ldl_cholesterol|0|ldl_cholesterol_value

Length:

4,3

Required:

false

Validation
  • is less than 5 mg/dl (warning)
  • is greater than 300 mg/dl (warning)
text

LDL cholesterol (unit)

Technical specs

CSV column name:

ldl_cholesterol|0|ldl_cholesterol_unit

Length:

50

Required:

false

date

Date of LDL cholesterol measurement

Technical specs

Format:

DD/MM/YYYY

CSV column name:

ldl_cholesterol|0|value_date_ldl_cholesterol

Required:

false