HIV_Cohort_MED (HIV_Cohort_MED)
- Status: active
- How to create a CSV file for this data collection?
- Start date: 31/03/2017
1 Patient identification
Codepat of the patient
Technical specs
CSV column name:
CODEPAT
Length:
50
Required:
true
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:
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
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 |
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:
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
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
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:
Postcode
Deceased?
Help
This variable is not mandatory. This variable is only mandatory in the HIV_Cohort_BAS file and can be optionally provided in this file.
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 of death
Help
This variable is not mandatory. This variable is only mandatory in the HIV_Cohort_BAS file and can be optionally provided in this file.
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
2 MED
ATC code representing the treatment
Technical specs
CSV column name:
MED_ID
Length:
16
Reference list:
HIV_MED
Required:
true
Mapping of the clinical building blocks (indicative only)
Concept:
be.en.hd.MedicationPrescription
Data element:
ProductCode
Date of initiation of treatment
Help
Unknown day: use the 15th of the month (e.g. ??/12/1999 becomes 15/12/1999, with a maximum deviation of approximately two weeks from the actual date). Unknown month and day: use the 1st of July (e.g. ??/??/1999 becomes 01/07/1999). If the date is completely unknown, but mandatory for e.g. retrospective documentation of opportunistic infections: use the fictive date 11/11/1911.
Technical specs
Format:
DD/MM/YYYY
CSV column name:
MED_START_DATE
Required:
true
Mapping of the clinical building blocks (indicative only)
Concept:
be.en.hd.MedicationPrescription
Data element:
StartDate
Validation
- Date of initiation of treatment cannot be after Date of stopping treatment (warning)
Date of stopping
Help
Blank only allowed if treatment is still on-going. Day unknown: In this case the date should be coded as the 15th of the month – so that ??/12/1999 becomes 15/12/1999. This enables the date to be no more than 15 days away from the actual date. Month and day unknown: Best approach to this is to apply something similar, as with unknown dates, this would then mean that ??/??/1999 becomes 01/07/1999. Year unknown: If the year is unknown but the presence of the date value is needed as in case of opportunistic infections or adverse events (see later in this document) a fictive date should be used that couldn’t be mistaken with an actual date. An unknown year should be coded as 11/11/1911.
Technical specs
Format:
DD/MM/YYYY
CSV column name:
MED_END_DATE
Required:
false
Mapping of the clinical building blocks (indicative only)
Concept:
be.en.hd.MedicationPrescription
Data element:
EndDate
Validation
- Date of initiation of treatment cannot be after Date of stopping treatment (warning)