KCE Trial - Order sets for lab tests GPs - Patient (KCELABGP_Patient)

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

Start date: 20/10/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)

2 Physician identification

text

RIZIV/INAMI-code of the treating physician

Technical specs

CSV column name:

CD_RIZIV_TREAT_PHYS

Length:

100

Reference list:

PHYSICIAN

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Caregiver

Data element:

CareGiverIdentificationNumber

3 Laboratory test order

date

Date of laboratory test order

Technical specs

Format:

DD/MM/YYYY

CSV column name:

DT_LAB_TST

Required:

false

Validation

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

list

Indication for laboratory test order

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

Indication for laboratory test order

Help

In your opinion, what was the reason for the physician to order the laboratory tests?

Technical specs

CSV column name:

indication_for_laboratory_test_order_1|TX_INDICATN_LAB_TST_ORD

Required:

true

4 New diagnoses

list

New diagnoses

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 new diagnosis is before date of laboratory test order	typeof $$.document.target.value.DT_LAB_TST === 'string' && typeof $.DT_NEW_DIAG === 'string'?$.DT_NEW_DIAG>= $$.document.target.value.DT_LAB_TST:true
The date of new diagnosis cannot be in the future	typeof $.DT_NEW_DIAG=== 'string'?new Date($.DT_NEW_DIAG)
New diagnosis cannot have value '99- Other', please provide valid ICPC-2 code	$$.propertyManipulators.CD_NEW_DIAG.hasCode() ? $.CD_NEW_DIAG.code !== '99':true

List items

text

New diagnosis

Help

Select the new diagnosis from the thesaurus

Technical specs

CSV column name:

new_diagnoses|0|CD_NEW_DIAG

Length:

100

Reference list:

ICPC2

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Problem

Data element:

ProblemName

date

Date of new diagnosis

Technical specs

Format:

DD/MM/YYYY

CSV column name:

new_diagnoses|0|DT_NEW_DIAG

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Problem

Data element:

ProblemStartDate

5 Downstream activities

choice

Did the patient underwent any follow-up examinations because of this labtest or did he need to go to a specialist doctor?

Technical specs

CSV column name:

CD_PAT_EXAM

Required:

false

Options

Label	Value
Doesn't remember	2
No	0
Yes	1

list

Downstream investigations

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

List items

choice

Investigation type

Technical specs

CSV column name:

DWNSTRM_INV|0|CD_INVSTG_TPE

Required:

false

Options

Label	Value
Follow-up laboratory tests	1
Imaging	2
Function tests	3

text

Specification of investigation type

Help

Please specify the type and name of the follow-up investigation

Technical specs

CSV column name:

DWNSTRM_INV|0|TX_SPEC_INVSTG_TPE

Length:

200

Only when:

Required:

false

list

Downstream referrals

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

Referral specialty

Help

Please specify the specialty of the referral

Technical specs

CSV column name:

DWNSTRM_REF|0|CD_REFERL_SPECIALITY

Length:

Reference list:

KCELAB_SPECIALTY

Required:

false

choice

Investigations after referral

Help

Did the specialist order any additional investigations in relation to the laboratory test order?

Technical specs

CSV column name:

DWNSTRM_REF|0|CD_INVSTG_AFTER_REFERL

Required:

false

Options

Label	Value
Yes	1
No	0

choice

Investigation type

Technical specs

CSV column name:

DWNSTRM_REF|0|CD_INVSTG_TPE

Only when:

Required:

false

Options

Label	Value
Follow-up laboratory tests	1
Imaging	2
Function tests	3

text

Specification of investigation type

Help

Please specify the type and name of the follow-up investigation

Technical specs

CSV column name:

DWNSTRM_REF|0|TX_REFERL_SPEC_INVSTG_TPE

Length:

200

Only when:

Required:

false

choice

Did the patient have to start, stop or change any treatment as a result of this lab result?

Technical specs

CSV column name:

CD_PAT_TREAT

Required:

false

Options

Label	Value
Doesn't remember	2
No	0
Yes	1

multichoice

Please add them below

Technical specs

CSV column name:

please_add_them_below

Only when:

Required:

false

Options

Label	Value
Drug treatment-start	FL_START_DRUG_TREAT
Drug treatment-stop	FL_STOP_DRUG_TREAT
Drug treatment-change (e.g. other posology)	FL_DRUG_TREAT_CHNG
Bloodtransfusion	FL_BLDTRNSFSN
Surgery	FL_SURG
Oncologic treatment (chemotherapy, radiotherapy, immunotherapy,..)	FL_ONCO_TREAT_CHEMO_RADIOTHRP
Fysiotherapy or occupational therapy	FL_FYSIO_OCCUP_THERPY
Psychotherapy	FL_PSYCHOTY
Other	FL_TREAT_OTH

Nested option fields

When FL_TREAT_OTH Is selected:
text
Please specify
Technical specs
CSV column name:
please_add_them_below|TX_TREAT_OTH
Required:
false

6 Socio-economic status

choice

Level of education

Technical specs

CSV column name:

CD_LEVEL_EDU

Required:

false

Options

Label	Value
No high school	1
BSO	2
TSO	3
ASO	4
College	5
University	6
Post-graduate	7

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Education

Data element:

SchoolType

text

Level of income

Technical specs

CSV column name:

TX_LEVEL_INCM

Length:

200

Required:

false

text

Profession

Technical specs

CSV column name:

TX_PROF

Length:

200

Required:

false