Spine Tango Intake (Spine Tango Intake)

Version: from 01/09/2019 - 31/03/2021
Status: inactive
How to create a CSV file for this data collection?

Start date: 06/04/2020
End date creation: 31/12/2023
End date submission: 31/12/2023
End date comments: 31/12/2023

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

1 Patient identification

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:

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

Length:

Required:

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

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)
The date of birth needs to be after 1900 (error)
The date of birth cannot be after the date of death (error)
The date of birth cannot be after Date of start of treatment (error)
The date of birth cannot be after Date of unsubscription (error)
The date of birth cannot be after Date of surgery (error)

choice

Sex

Technical specs

CSV column name:

patient_id|sex

Required:

true

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:

Place of residence

boolean

Deceased?

Technical specs

CSV column name:

patient_id|deceased

Only when:

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

text

Street

Technical specs

CSV column name:

street

Length:

100

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

Street

text

House number

Technical specs

CSV column name:

house_number

Length:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

HouseNumber

text

E-mail address

Technical specs

CSV column name:

email_address

Length:

100

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

E-mailAddress

boolean

Patient participates in questionnaire

Technical specs

CSV column name:

patient_participates_in_questionnaire

Required:

true

Options

Label	Value
Yes	TRUE
No	FALSE

text

Mobile phone number patient

Technical specs

CSV column name:

mobile_phone_number_patient

Length:

100

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

TelephoneNumber

text

Mobile phone number partner

Technical specs

CSV column name:

mobile_phone_number_partner

Length:

100

Required:

false

text

Phone number

Technical specs

CSV column name:

phone_number

Length:

100

Required:

false

text

Other number

Help

e.g. from children

Technical specs

CSV column name:

other_number

Length:

100

Required:

false

2 Caregiver

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.HealthProfessional

Data element:

HealthProfessionalIdentificationNumber

3 Planned treatment

choice

Treatment

Technical specs

CSV column name:

CD_TREAT

Required:

true

Options

Label	Value
Lumbar surgery	1
Conservative therapy - K60 spinal multidisciplinary rehabilitation	2

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.PlannedCareActivity

Data element:

Procedure::Procedure

date

Date of surgery - start date of conservative therapy

Technical specs

Format:

DD/MM/YYYY

CSV column name:

date_of_surgery

Required:

true

Validation

The date of birth cannot be after Date of surgery (error)

date

Date of unsubscription

Technical specs

Format:

DD/MM/YYYY

CSV column name:

date_of_unsubscription

Required:

false

Validation

The date of birth cannot be after Date of unsubscription (error)

date

Date of surgery - start date of conservative therapy plus 3 months

Not to be included in the CSV.

Technical specs

Format:

DD/MM/YYYY

CSV column name:

date_of_surgery_plus_3_months

Computed:

Required:

false

date

Date of surgery - start date of conservative therapy plus 6 months

Not to be included in the CSV.

Technical specs

Format:

DD/MM/YYYY

CSV column name:

date_of_surgery_plus_6_months

Computed:

Required:

false

date

Date of surgery - start date of conservative therapy plus 1 year

Not to be included in the CSV.

Technical specs

Format:

DD/MM/YYYY

CSV column name:

date_of_surgery_plus_1_year

Computed:

Required:

false

date

Date of surgery - start date of conservative therapy plus 2 year

Not to be included in the CSV.

Technical specs

Format:

DD/MM/YYYY

CSV column name:

date_of_surgery_plus_2_year

Computed:

Required:

false