HIV Incidence (HIV_Incidence)

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

Start date: 21/02/2023

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

1 Data provided by the Aids Reference Laboratory (ARL)

text

Codepat of the patient

Technical specs

CSV column name:

CODEPAT

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:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

DateOfBirth

Validation

Date of birth cannot be in the future (error)
Probable year of transmission cannot be before the date of birth (error)
Date of death cannot be before date of birth (error)
Date of birth cannot be before 1910 (error)
Date of sampling cannot be before date of birth (error)
Date CD4 cannot be before date of birth (error)
Date viral load cannot be before date of birth (error)
Date of first clinical symptoms of seroconversion cannot be before date of birth (error)
Date of last negative test cannot be before date of birth (error)
Year of arrival cannot be before the date of birth (error)

choice

Sex

Technical specs

CSV column name:

patient_id|sex

Required:

true

Options

Label	Value
Male	M
Female	F
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:

true

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

Help

Unknown day: use the 15th of the month (e.g. ??/12/1999 becomes 15/12/1999) Unknown month and day: use the 1st of July (e.g. ??/??/2020 becomes 01/07/2020) If the date is completely unknown, use the fictive date 11/11/1911

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

Date of death cannot be before date of birth (error)
Date of death cannot be before 1980 (error)
Date of death cannot be in the future (error)
Date of sampling cannot be after date of death (error)
Date CD4 cannot be after date of death (error)
Date viral load cannot be after date of death (error)
Date of first clinical symptoms of seroconversion cannot be after date of death (error)
Date of last negative test cannot be after date of death (error)
Year of arrival cannot be after the date of death (error)
Probably year of transmission cannot be after the date of death (error)

text

Physician requesting the analysis

Technical specs

CSV column name:

PHYSICIAN

Length:

Reference list:

PHYSICIAN

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Caregiver

Data element:

CareGiverIdentificationNumber

choice

Type of HIV

Technical specs

CSV column name:

HIVType

Required:

true

Options

Label	Value
Human immunodeficiency virus I infection	HIV1
Human immunodeficiency virus II infection	HIV2
HIV1 + HIV2	HIV12
Non typable	NON

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferConcern

Data element:

ProblemName

choice

Acute HIV infection?

Help

According to the lab

Technical specs

CSV column name:

ACUTE

Required:

true

Options

Label	Value
Yes	Y
No	N
Unknown	UNK

date

Sampling date

Help

Technical specs

Format:

DD/MM/YYYY

CSV column name:

RNA_DATE

Required:

true

Validation

Date of first clinical symptoms is more than 6 months before the sampling date (warning)
Sampling date cannot be in the future (error)
Date of last negative test cannot be after the sampling date (error)
Date CD4 cannot be before sampling date (warning)
Date viral load cannot be before sampling date (warning)
Sampling date cannot be before 1975 (error)
Date of sampling cannot be before date of birth (error)
Date of sampling cannot be after date of death (error)

2 Data provided by the physician

choice

Transgender

Technical specs

CSV column name:

CD_TG

Required:

true

Options

Label	Value
M to F	MF
F to M	FM
No	N
Unknown	UNK

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

Nationality region

Technical specs

CSV column name:

NATION_REGION

Only when:

Required:

false

Options

Label	Value
Europe, country unknown	_E
Asia, country unknown	_A
North-Africa, country unknown	_N
Sub-saharan Africa, country unknown	_S
Africa, country unknown	_X
North-America, country unknown	_U
Latin-America, country unknown	_L
Former Yugoslavia	_Y

text

Current country of residence

Technical specs

CSV column name:

RESID

Length:

Reference list:

COUNTRY

Required:

true

choice

Current region of residence

Technical specs

CSV column name:

RESID_REGION

Only when:

Required:

false

Options

Label	Value
Europe, country unknown	_E
Asia, country unknown	_A
North-Africa, country unknown	_N
Sub-saharan Africa, country unknown	_S
Africa, country unknown	_X
North-America, country unknown	_U
Latin-America, country unknown	_L
Former Yugoslavia	_Y

text

Country of birth

Technical specs

CSV column name:

BIRTH_COUNTRY

Length:

Reference list:

COUNTRY

Required:

true

choice

Birth region

Technical specs

CSV column name:

BIRTH_REGION

Only when:

Required:

false

Options

Label	Value
Europe, country unknown	_E
Asia, country unknown	_A
North-Africa, country unknown	_N
Sub-saharan Africa, country unknown	_S
Africa, country unknown	_X
North-America, country unknown	_U
Latin-America, country unknown	_L
Former Yugoslavia	_Y

text

Year of arrival in Belgium

Technical specs

CSV column name:

ARRIVAL_BE

Length:

Only when:

Required:

false

Validation

Year of arrival format is YYYY (error)
Year of arrival cannot be in the future (error)
Year of arrival cannot be before 1910 (error)
Year of arrival cannot be before the date of birth (error)
Year of arrival cannot be after the date of death (error)

choice

The patient had sexual contact with

Technical specs

CSV column name:

SEX_CONTACT

Required:

true

Options

Label	Value
Women	F
Men	M
Both sexes	C
None	D
Unknown	UNK

multichoice

Sexual contacts with partners

Technical specs

CSV column name:

SEX_PARTNER

Required:

false

Options

Label	Value
Diagnosed HIV+	A
Intravenous drug user	B
Of nationality	C
Prostitute(s)	D
Unknown to patient	E

text

Nationality partner

Technical specs

CSV column name:

PARTNER_NATION

Length:

Reference list:

COUNTRY

Only when:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Nationality

Data element:

Nationality

choice

Nationality region partner

Technical specs

CSV column name:

PARTNER_REGION

Only when:

Required:

false

Options

Label	Value
Europe, country unknown	_E
Asia, country unknown	_A
North-Africa, country unknown	_N
Sub-saharan Africa, country unknown	_S
Africa, country unknown	_X
North-America, country unknown	_U
Latin-America, country unknown	_L
Former Yugoslavia	_Y

choice

Blood transmission

Technical specs

CSV column name:

BLOOD_TRANSM

Required:

true

Options

Label	Value
Intravenous drug user	A
Hemophilia	B
Transfusion	C
None	D
Unknown	UNK

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureType

text

Year of transfusion

Technical specs

CSV column name:

TRANSF_YEAR

Length:

Only when:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureStartDate

Validation

Year of transfusion format is YYYY (error)
Year of transfusion cannot be in the future (error)
Year of transfusion cannot be before 1950 (error)

text

Country of transfusion

Technical specs

CSV column name:

TRANSF_COUNTR

Length:

Reference list:

COUNTRY

Only when:

Required:

false

choice

Region of transfusion

Technical specs

CSV column name:

TRANSF_REGION

Only when:

Required:

false

Options

Label	Value
Europe, country unknown	_E
Asia, country unknown	_A
North-Africa, country unknown	_N
Sub-saharan Africa, country unknown	_S
Africa, country unknown	_X
North-America, country unknown	_U
Latin-America, country unknown	_L
Former Yugoslavia	_Y

choice

Child of HIV+ mother

Technical specs

CSV column name:

CHILD_HIV_MOTHER

Required:

true

Options

Label	Value
Yes	Y
No	N
Unknown	UNK

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.FamilyHistory

Data element:

ProblemName

choice

Professional risk

Technical specs

CSV column name:

PROF_RISK

Required:

true

Options

Label	Value
Medical/paramedical	M
Prostitution	P
Other	O
None	N
Unknown	UNK

text

Probable year of transmission

Technical specs

CSV column name:

PROB_YEAR

Length:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferProcedure

Data element:

ProcedureStartDate

Validation

Probable year of transmission: the format is YYYY (error)
Probable year of transmission cannot be in the future (error)
Probable year of transmission cannot be before the date of birth (error)
Probable year of transmission cannot be before 1980 (error)
Probably year of transmission cannot be after the date of death (error)

text

Probable country of transmission

Technical specs

CSV column name:

PROB_COUNTR

Length:

Reference list:

COUNTRY

Required:

false

choice

Probable region of transmission

Technical specs

CSV column name:

PROB_REGION

Only when:

Required:

false

Options

Label	Value
Europe, country unknown	_E
Asia, country unknown	_A
North-Africa, country unknown	_N
Sub-saharan Africa, country unknown	_S
Africa, country unknown	_X
North-America, country unknown	_U
Latin-America, country unknown	_L
Former Yugoslavia	_Y

number

Number of CD4 per mm³

Technical specs

CSV column name:

CD4_VALUE

Length:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

Result

Validation

Number of CD4 is above 2500 per mm³ (warning)
Number of CD4 per mm³ is negative (error)
Number of CD4 per mm³ should be an integer value (error)

date

Date CD4

Help

Date of measurement of the CD4 Unknown day: use the 15th of the month (e.g. ??/12/1999 becomes 15/12/1999) Unknown month and day: use the 1st of July (e.g. ??/??/2020 becomes 01/07/2020) If the date is completely unknown, use the fictive date 11/11/1911

Technical specs

Format:

DD/MM/YYYY

CSV column name:

D_CD4

Required:

false

Validation

Date CD4 cannot be in the future (error)
Date CD4 cannot be before sampling date (warning)
Date CD4 cannot be before 1980 (error)
Date CD4 cannot be before date of birth (error)
Date CD4 cannot be after date of death (error)

text

Viral load (copies/ml)

Help

Use < or > when below or above the detection limit of HIV-RNA assay; Do not use special values (e.g. 0 or 1), always use the actual detection limit (e.g.’<20’) in those cases; Only integer values, no logarithmic values

Technical specs

CSV column name:

RNA_VALUE

Length:

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferLaboratoryResult

Data element:

Result

Validation

Viral load (copies/ml) is 100000000 or higher (warning)
Viral load (copies/ml) is negative (error)
HIV-RNA measurement: No special values (e.g. 0 or 1) indicating results below detection or quantification limits allowed. Always use the actual detection limit (e.g. ‘<20’) in those cases. (error)

date

Date viral load

Help

Date of measurement of the viral load Unknown day: use the 15th of the month (e.g. ??/12/1999 becomes 15/12/1999) Unknown month and day: use the 1st of July (e.g. ??/??/2020 becomes 01/07/2020) If the date is completely unknown, use the fictive date 11/11/1911

Technical specs

Format:

DD/MM/YYYY

CSV column name:

D_VL

Required:

false

Validation

Date viral load cannot be in the future (error)
Date viral load cannot be before sampling date (warning)
Date viral load cannot be before 1980 (error)
Date viral load cannot be before date of birth (error)
Date viral load cannot be after date of death (error)

choice

Clinical stage

Technical specs

CSV column name:

CLIN_STAGE

Required:

true

Options

Label	Value
Primary infection - recent infection (	A2
Asymptomatic (stage 1)	B2
Symptomatic non AIDS (stages 2 & 3)	C2
AIDS (stage 4)	D2
Unknown	UNK

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.TransferConcern

Data element:

ProblemName

date

Date of first clinical symptoms of seroconversion

Help

Technical specs

Format:

DD/MM/YYYY

CSV column name:

SEROCO_CLIN_DATE

Only when:

Required:

false

Validation

Date of first clinical symptoms is more than 6 months before the sampling date (warning)
Date of first clinical symptoms of seroconversion cannot be before 1980 (error)
Date of first clinical symptoms of seroconversion cannot be before date of birth (error)
Date of first clinical symptoms of seroconversion cannot be after date of death (error)

date

Date of last negative test

Help

Technical specs

Format:

DD/MM/YYYY

CSV column name:

NEG_DATE

Required:

false

Validation

Date of last negative test cannot be after the sampling date (error)
Date of last negative test cannot be before 1980 (error)
Date of last negative test cannot be before date of birth (error)
Date of last negative test cannot be after date of death (error)

multichoice

Reason for testing

Technical specs

CSV column name:

CD_TEST_REASON

Required:

true

Options

Label	Value
A - Control of known seropositivity	FL_A_CTRL_SEROP
B - Clinical symptoms	FL_B_CLIN_SYMP
C - Preoperatory	FL_C_PREO
D - Prenatal	FL_D_PRENAT
E - Administrative reasons	FL_E_ADM_REAS
G - Confirmation autotest	FL_G_CONF_AUTOTST
H - Confirmation decentralized test	FL_H_CONF_DECENTR_TST
I - PEP	FL_I_PEP
J - Initiation PrEP	FL_J_INI_PREP
K - Follow-up PrEP	FL_K_FU_PREP
L - STI diagnosis	FL_L_STI_DIAGS
M - Risk	FL_M_RISK_LT_6M
N - Risk > 6 months	FL_N_RISK_GT_6M
O - No known exposure	FL_O_UNK_EXPOS
Not reported	FL_NOT_REPRT
F - Other	FL_F_OTH

choice

Test request initiative

Technical specs

CSV column name:

CD_TEST_INIT

Required:

true

Options

Label	Value
Proposed by the physician	A
Requested by the patient	B
Unknown	UNK

boolean

On ART

Help

is the patient already on antiretroviral treatment at the moment of diagnosis confirmation?

Technical specs

CSV column name:

CD_ON_ART

Only when:

Required:

false

Options

Label	Value
Yes	TRUE
No	FALSE