HIV_Cohort_BAS (HIV_Cohort_BAS)

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

Start date: 31/03/2017

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

text

Identification of the data provider institution

Not to be included in the CSV.

Technical specs

CSV column name:

installation_id

Length:

100

Computed:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.HealthcareProvider

Data element:

HealthcareProviderIdentificationNumber

text

Head of service

Technical specs

CSV column name:

head_of_service

Length:

100

Reference list:

PHYSICIAN

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Caregiver

Data element:

CareGiverIdentificationNumber

1 Patient identification

text

Codepat of the patient

Technical specs

CSV column name:

CODEPAT

Length:

Required:

true

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:

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

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

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:

Postcode

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

boolean

Transgender?

Technical specs

CSV column name:

transgender

Required:

false

Options

Label	Value
Yes	TRUE
No	FALSE

2 BAS

date

Date of first visit at clinic

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:

FIRST_VIS_DATE

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Contact

Data element:

StartDateTime

number

Height of patient at visit/most current (cm)

Help

Unknown = 999

Technical specs

CSV column name:

HEIGHT

Length:

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.BodyHeight

Data element:

HeightValue

choice

Mode of infection (probable way of transmission)

Technical specs

CSV column name:

TRANSMISSION

Required:

true

Options

Label	Value
Homo/bisexual	1
Injecting drug user	2
Homo/bisexual + injecting drug user	3
Haemophiliac	4
Transfusion, non-haemophilia related	5
Heterosexual contact	6
Heterosexual contact and injecting DU	7
Perinatal	8
Other	90
Unknown	99

text

Nationality

Technical specs

CSV column name:

NATION

Length:

Reference list:

COUNTRY

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Nationality

Data element:

Nationality

choice

Ethnicity of patient

Technical specs

CSV column name:

ETHNIC

Required:

true

Options

Label	Value
White	10
Black	20
Black African	21
Black Caribbean	22
Hispanic	30
Asian	40
American	50
Indigenous	60
White/Black	1020
White/Asian	1040
Black/Hispanic	2030
Hispanic/Asian	3040
Other	97
Unknown	99