KCE Trial - Order sets for lab tests GPs - Lab (KCELABGP_Lab)

Version:
Status: active
Unique ID: patient ID and date of laboratory test order
How to create a CSV file for this data collection?

Start date: 09/05/2019

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

1 Patient identification

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:

false

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

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:

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

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:

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

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:

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

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 (error)
Date of birth cannot be after date of death (error)

choice

Sex

Technical specs

CSV column name:

patient_id|sex

Required:

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

Options

Label	Value
Female	F
Male	M
Unkown	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:

Place of residence

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

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 in the future (error)
Date of birth cannot be after date of death (error)

choice

CG1 code

Help

If no insurance data is available, please enter '999'.

Technical specs

CSV column name:

cg1_code

Required:

true

Options

Label	Value
100	100
101	101
110	110
111	111
120	120
121	121
130	130
131	131
140	140
141	141
150	150
151	151
410	410
411	411
420	420
421	421
430	430
431	431
440	440
441	441
450	450
451	451
470	470
471	471
999	999

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Payer

Data element:

InsuranceType

choice

CG2 code

Help

If no insurance data is available, please enter '999'.

Technical specs

CSV column name:

cg2_code

Required:

true

Options

Label	Value
000	000
100	100
101	101
110	110
111	111
120	120
121	121
130	130
131	131
140	140
141	141
150	150
151	151
460	460
461	461
900	900
901	901
999	999

2 Physician identification

text

RIZIV/INAMI-code of the treating physician

Technical specs

CSV column name:

physician

Length:

100

Reference list:

PHYSICIAN

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.HealthProfessional

Data element:

HealthProfessionalIdentificationNumber

3 Laboratory test panel

date

Date of laboratory test order

Technical specs

Format:

DD/MM/YYYY

CSV column name:

date_of_laboratory_test_order

Required:

true

Validation

The date of laboratory test order cannot be before 01/11/2017 (error)
The date of laboratory test order cannot be in the future (error)

number

Total cost for laboratory test panel (€)

Technical specs

CSV column name:

total_cost_for_laboratory_test_panel

Length:

10.5

Required:

true

Validation

cannot be negative (error)

4 Laboratory tests

list

Laboratory tests

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

Laboratory test code

Help

If possible, please provide LOINC code.

Technical specs

CSV column name:

laboratory_tests|0|laboratory_test_code

Length:

100

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.LaboratoryTestResult

Data element:

TestName

text

Laboratory test result

Technical specs

CSV column name:

laboratory_tests|0|laboratory_test_result

Length:

100

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.LaboratoryTestResult

Data element:

Result

text

Laboratory test lower reference limit

Technical specs

CSV column name:

laboratory_tests|0|laboratory_test_lower_reference_limit

Length:

100

Only when:

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.LaboratoryTestResult

Data element:

ReferenceRangeLowerLimit

text

Laboratory test upper reference limit

Technical specs

CSV column name:

laboratory_tests|0|laboratory_test_upper_reference_limit

Length:

100

Only when:

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.LaboratoryTestResult

Data element:

ReferenceRangeUpperLimit

boolean

Normal value for laboratory test?

Technical specs

CSV column name:

laboratory_tests|0|normal_value_for_laboratory_test

Only when:

Required:

true

Options

Label	Value
Yes	TRUE
No	FALSE