Care trajectory chronic kidney disease (Care Trajectory CKD)

Version:
Status: inactive
How to create a CSV file for this data collection?

Start date: 01/10/2017
End date creation: 09/03/2018
End date submission: 09/03/2018
End date comments: 09/03/2018

Full view CSV column names Validation rules Reference lists Computed expressions Additional information CSV 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:

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

Label	Value
Yes	TRUE
No	FALSE

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:

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:

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

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

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

Label	Value
Yes	TRUE
No	FALSE

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

Message	Expression
The start date of the care trajectory cannot be in the future	typeof $.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/06/2009	typeof $.start_date_of_the_care_trajectory=== 'string'?$.start_date_of_the_care_trajectory>= '2009-06-01':true
The end date of the care trajectory cannot be before 01/06/2009	typeof $.end_date_of_the_care_trajectory=== 'string'?$.end_date_of_the_care_trajectory>= '2009-06-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

Message	Expression
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:

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

Message	Expression
Date of weight measurement cannot be in the future	typeof $.value_date_weight=== 'string'?new Date($.value_date_weight)
Date of weight measurement cannot be before 01/06/2008	typeof $.value_date_weight=== 'string'?$.value_date_weight>= '2008-06-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:

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

Message	Expression
Date of systolic blood pressure measurement cannot be in the future	typeof $.value_date_systolic_blood_pressure=== 'string'?new Date($.value_date_systolic_blood_pressure)
Date of systolic blood pressure measurement cannot be before 01/06/2008	typeof $.value_date_systolic_blood_pressure=== 'string'?$.value_date_systolic_blood_pressure>= '2008-06-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:

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:

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

Message	Expression
Date of diastolic blood pressure measurement cannot be in the future	typeof $.value_date_diastolic_blood_pressure=== 'string'?new Date($.value_date_diastolic_blood_pressure)
Date of diastolic blood pressure measurement cannot be before 01/06/2008	typeof $.value_date_diastolic_blood_pressure=== 'string'?$.value_date_diastolic_blood_pressure>= '2008-06-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:

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:

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

4.3 Diabetes

choice

Does the patient have diabetes mellitus?

Technical specs

CSV column name:

does_the_patient_have_diabetes

Required:

false

Options

Label	Value
Yes	1
No	0
Unknown	9

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferConcern

Data element:

5 Clinical biology

5.1 Renal function

list

Serum creatinine

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

Message	Expression
Date of serum creatinine measurement cannot be in the future	typeof $.value_date_serum_creatinine=== 'string'?new Date($.value_date_serum_creatinine)
Date of serum creatinine measurement cannot be before 01/06/2008	typeof $.value_date_serum_creatinine=== 'string'?$.value_date_serum_creatinine>= '2008-06-01':true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

List items

number

Serum creatinine (value)

Technical specs

CSV column name:

serum_creatinine|0|serum_creatinine_value

Length:

3,3

Required:

false

Validation

is less than 0.2 mg/dl (warning)
is greater than 5 mg /dl (warning)

text

Serum creatinine (unit)

Technical specs

CSV column name:

serum_creatinine|0|serum_creatinine_unit

Length:

Required:

false

date

Date of serum creatinine measurement

Technical specs

Format:

DD/MM/YYYY

CSV column name:

serum_creatinine|0|value_date_serum_creatinine

Required:

false

list

eGFR

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

Message	Expression
Date of eGFR measurement cannot be in the future	typeof $.value_date_egfr=== 'string'?new Date($.value_date_egfr)
Date of eGFR measurement cannot be before 01/06/2008	typeof $.value_date_egfr=== 'string'?$.value_date_egfr>= '2008-06-01':true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

List items

number

eGFR (value)

Technical specs

CSV column name:

egfr|0|egfr_value

Length:

4,3

Required:

false

Validation

is less than 5 ml/min/1.73m² (warning)
is greater than 60 ml/min/1.73m² (warning)

text

eGFR (unit)

Technical specs

CSV column name:

egfr|0|egfr_unit

Length:

Required:

false

date

Date of eGFR measurement

Technical specs

Format:

DD/MM/YYYY

CSV column name:

egfr|0|value_date_egfr

Required:

false

5.2 Blood hemoglobin

list

Blood hemoglobin

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

Message	Expression
Date of hemoglobin measurement cannot be in the future	typeof $.value_date_blood_hemoglobin=== 'string'?new Date($.value_date_blood_hemoglobin)
Date of hemoglobin measurement cannot be before 01/06/2008	typeof $.value_date_blood_hemoglobin=== 'string'?$.value_date_blood_hemoglobin>= '2008-06-01':true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

List items

number

Blood hemoglobin (value)

Technical specs

CSV column name:

blood_hemoglobin|0|blood_hemoglobin_value

Length:

3,3

Required:

false

Validation

is less than 5 g/dl (warning)
is greater than 20 g/dl (warning)

text

Blood hemoglobin (unit)

Technical specs

CSV column name:

blood_hemoglobin|0|blood_hemoglobin_unit

Length:

Required:

false

date

Date of blood hemoglobin measurement

Technical specs

Format:

DD/MM/YYYY

CSV column name:

blood_hemoglobin|0|value_date_blood_hemoglobin

Required:

false