Belgian Pilot Spine Registry (Belgian Pilot Spine Registry)
- 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
Date of questionnaire completion
Technical specs
Format:
DD/MM/YYYY
CSV column name:
DT_QUES_COMPLD
Required:
true
HD4Patient code
Not to be included in the CSV.
Technical specs
CSV column name:
hd4patient_code
Reference list:
HD4PATIENT_CODE_SPINE_TANGO
Required:
false
Read only
Validation
- The length of the HD4Patient code must be 13 (error)
1 Patient identification
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.
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
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 |
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:
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
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:
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 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)
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 |
| Unknown | U |
Mapping of the clinical building blocks (indicative only)
Concept:
be.en.hd.Patient
Data element:
Gender
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:
Place of residence
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 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)
2 General health questionnaire (EQ5D)
Section help
The EQ5D questionnaire is an instrument to measure general health. The questionnaire consists of 5 questions concerning mobility, self-care, usual activities, pain/discomfort, and anxiety/depression.
Mobility
Technical specs
CSV column name:
CD_GEN_HLTH_MOBLTY
Required:
eq5dno
Options
| Label | Value |
| I have no problems in walking about | 1 |
| I have some problems in walking about | 2 |
| I am confined to bed | 3 |
| No answer | 4 |
Self-Care
Technical specs
CSV column name:
CD_GEN_HLTH_SC
Required:
eq5dno
Options
| Label | Value |
| I have no problems with self-care | 1 |
| I have some problems washing or dressing myself | 2 |
| I am unable to wash or dress myself | 3 |
| No answer | 4 |
Usual activities (e.g. work, study, housework, family or leisure activities)
Technical specs
CSV column name:
CD_GEN_HLTH_USUAL_ACTVTS
Required:
eq5dno
Options
| Label | Value |
| I have no problems with performing my usual activities | 1 |
| I have some problems with performing my usual activities | 2 |
| I am unable to perform my usual activities | 3 |
| No answer | 4 |
Pain / Discomfort
Technical specs
CSV column name:
CD_GEN_HLTH_PAIN_DISCMFRT
Required:
eq5dno
Options
| Label | Value |
| I have no pain or discomfort | 1 |
| I have moderate pain or discomfort | 2 |
| I have extreme pain or discomfort | 3 |
| No answer | 4 |
Anxiety / Depression
Technical specs
CSV column name:
CD_GEN_HLTH_ANXTY_DEPR
Required:
eq5dno
Options
| Label | Value |
| I am not anxious or depressed | 1 |
| I am moderately anxious or depressed | 2 |
| I am extremely anxious or depressed | 3 |
| No answer | 4 |
How good or bad is your health today?
Technical specs
CSV column name:
how_good_or_bad_is_your_health_today
Required:
eq5dno
Validation
- The value cannot be less than 0 (error)
- The value cannot be more than 100 (error)
3 Patient self-assessment (Comi Back)
Section help
Back problems such as pain and sensory dysfunctions can interfere with your daily life. This questionnaire evaluates the impact of your back problems on your daily life. Common complaints are back pain and/or pain in the legs/buttocks, as well as to sensory disturbances such as tingling, 'pins and needles' or numbness in any of these regions. In this questionnaire, pain in the buttock and/or somewhere in the leg (including foot) is grouped as 'leg pain and/or buttock pain'. Pain around or just above the lower butt fold is buttock pain. Pain around the pelvic crest is back pain.
Which of the following problems troubles you the most?
Help
Back problems can lead to back pain and/or pain in the legs/buttocks, as well as to sensory disturbances such as tingling, 'pins and needles' or numbness in any of these regions.
Technical specs
CSV column name:
CD_PROB
Required:
comino
Options
| Label | Value |
| Back pain | 1 |
| Leg/buttock pain | 2 |
| Sensory disturbances in the back/leg/buttocks, e.g. tingling, 'pins and needles', numbness | 3 |
| None of the above | 4 |
| No answer | 5 |
Pain score
Help
For the following 2 questions we would like you to indicate the severity of your pain, by ticking the appropriate box (where "0" = no pain, "10" = worst pain you can imagine). There are separate questions for back pain and for leg pain (sciatica)/buttock pain.
Technical specs
Required:
false
Questions
| Label | CSV column name |
| How severe was your back pain in the last week? | CD_BCK_PAIN |
| How severe was your leg pain (sciatica)/buttock pain in the last week? | CD_LEG_PAIN |
Answers
| Label | Value |
| 0 | 0 |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |
| 6 | 6 |
| 7 | 7 |
| 8 | 8 |
| 9 | 9 |
| 10 | 10 |
| No answer | 11 |
During the past week, how much did your back problem interfere with your normal work (including both work outside the home and housework)?
Technical specs
CSV column name:
CD_BCK_PAIN_INTERF_WRK
Required:
comino
Options
| Label | Value |
| Not at all | 1 |
| A little bit | 2 |
| Moderately | 3 |
| Quite a bit | 4 |
| Extremely | 5 |
| No answer | 6 |
If you had to spend the rest of your life with the symptoms you have right now, how would you feel about it?
Technical specs
CSV column name:
CD_LIFE_W_SYMP
Required:
comino
Options
| Label | Value |
| Very satisfied | 1 |
| Somewhat satisfied | 2 |
| Neither satisfied nor dissatisfied | 3 |
| Somewhat dissatisfied | 4 |
| Very dissatisfied | 5 |
| No answer | 6 |
Please reflect on the last week. How would you rate your quality of life?
Technical specs
CSV column name:
CD_RT_QUAL_LIFE
Required:
comino
Options
| Label | Value |
| Very good | 1 |
| Good | 2 |
| Moderate | 3 |
| Bad | 4 |
| Very bad | 5 |
| No answer | 6 |
During the past 4 weeks how many days did you cut down on the things you usually do (work, housework, school, recreational activities) because of your back problem?
Technical specs
CSV column name:
CD_DAYS_CUT_DWN_THNG
Required:
comino
Options
| Label | Value |
| None | 1 |
| Between 1 and 7 days | 2 |
| Between 8 and 14 days | 3 |
| Between 15 and 21 days | 4 |
| More than 21 days | 5 |
| No answer | 6 |
During the past 4 weeks, how many days did your back problem keep you from going to work (job, school, housework)?
Technical specs
CSV column name:
CD_BCK_PAIN_KEEP_FRM_WRK
Required:
comino
Options
| Label | Value |
| None | 1 |
| Between 1 and 7 days | 2 |
| Between 8 and 14 days | 3 |
| Between 15 and 21 days | 4 |
| More than 21 days | 5 |
| No answer | 6 |
Are you completing this questionnaire AFTER the treatment?
Technical specs
CSV column name:
FL_QUES_AFTER_TREAT
Required:
comino
Options
| Label | Value |
| Yes | TRUE |
| No | FALSE |
Did any complications arise as a consequence of your treatment in our institution (e.g. problems with wound healing, paralysis, sensory disturbances)?
Technical specs
CSV column name:
CD_COMPLIC_AFTER_TREAT
Only when:
Required:
comino
Options
| Label | Value |
| No | 0 |
| No answer | 3 |
| Yes | 1 |
Nested option fields
- When 1 Is selected:text
Please describe these
Technical specs
CSV column name:
CD_COMPLIC_AFTER_TREAT|TX_COMPLIC_AFTER_TREAT
Length:
100
Required:
true
How bothersome were these complications?
Technical specs
CSV column name:
CD_BOTHRSM
Only when:
Required:
comino
Options
| Label | Value |
| Not at all bothersome | 1 |
| Slightly bothersome | 2 |
| Moderately bothersome | 3 |
| Very bothersome | 4 |
| Extremely bothersome | 5 |
| No answer | 6 |
Since the treatment in our institution, have you had any further treatment(s) on your lumbar spine (back) in our or in other institutions?
Technical specs
CSV column name:
CD_FURTH_TREAT
Only when:
Required:
comino
Options
| Label | Value |
| No | 0 |
| Yes, but at a different level of the spine | 2 |
| Yes, at the same level of the spine (same segment) | 3 |
| No answer | 4 |
Over the course of treatment for your back problem, how satisfied were you with your overall medical care in our institution?
Technical specs
CSV column name:
CD_SAT_TREAT
Only when:
Required:
comino
Options
| Label | Value |
| Very satisfied | 1 |
| Somewhat satisfied | 2 |
| Neither satisfied nor dissatisfied | 3 |
| Somewhat dissatisfied | 4 |
| Very dissatisfied | 5 |
| No answer | 6 |
Overall, how much did the treatment in our institution help your back problem?
Technical specs
CSV column name:
CD_HELP_TREAT
Only when:
Required:
comino
Options
| Label | Value |
| Helped a lot | 1 |
| Helped | 2 |
| Helped only little | 3 |
| Didn't help | 4 |
| Made things worse | 5 |
| No answer | 6 |