HIV_DEATH (HIV_DEATH)

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

Start date: 09/04/2020

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

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?

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:

true

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

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:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

DateOfDeath

2 Treating physician

text

Treating physician

Technical specs

CSV column name:

treating_physician

Reference list:

PHYSICIAN

Required:

true

3 Death

choice

Sudden death?

Help

Was the death sudden?

Technical specs

CSV column name:

CD_SUD_DEATH

Required:

true

Options

Label	Value
No	0
Yes	1
Unknown	9

choice

Expected death?

Help

Was the death expected?

Technical specs

CSV column name:

CD_EXP_DEATH

Required:

true

Options

Label	Value
No	0
Yes	1
Unknown	9

list

Illnesses and conditions

This is a container for multiple answers. See the reference documentation for more details. Below you can find the information about the fields of the container

Help

Give up to 9 possibilities of illnesses and conditions (acute and chronic) or injuries that the patient had at the time of death

Element conditions

Message	Expression

List items

Section help

Give up to 9 possibilities of illnesses and conditions (acute and chronic) or injuries that the patient had at the time of death

text

Illness / condition / injury

Help

Use "Z78.9 - Other specified health status" if you can not find a correct ICD-10 code and specify in the free text field.

Technical specs

CSV column name:

illnesses_and_conditions|0|CD_ILLNESS_COND_INJRY

Reference list:

ICD10CM_2019

Required:

false

text

Specify other illness / condition / injury

Technical specs

CSV column name:

illnesses_and_conditions|0|TX_ILLNESS_COND_INJRY_OTH

Only when:

Required:

false

date

Date of onset

Technical specs

Format:

DD/MM/YYYY

CSV column name:

illnesses_and_conditions|0|DT_ONST

Required:

false

multiline

Brief narrative of the sequence of events leading to death

Technical specs

CSV column name:

TX_SEQ_EVENTS

Required:

true

fieldset

Summary of causal relation

Fields

text

Condition that directly caused death (immediate cause)

Help

Use "Z78.9 - Other specified health status" if you can not find a correct ICD-10 code and specify in the free text field. In case of unknown cause of death, use “ZZZZ – Unknown".

Technical specs

CSV column name:

summary_of_causal_relation|CD_DIR_COD

Reference list:

ICD10CM_2019

Required:

true

text

Specify other condition that directly caused death (immediate cause)

Technical specs

CSV column name:

summary_of_causal_relation|TX_DIR_COD_OTH

Only when:

Required:

true

list

Due to or as a consequence of

This is a container for multiple answers. See the reference documentation for more details. Below you can find the information about the fields of the container

List items

text

Due to or as a consequence of

Help

Use "Z78.9 - Other specified health status" if you can not find a correct ICD-10 code and specify in the free text field.

Technical specs

CSV column name:

summary_of_causal_relation|due_to_or_as_a_consequence_of|0|CD_CONSEQ

Reference list:

ICD10CM_2019

Required:

false

text

Specify other due to or as a consequence of

Technical specs

CSV column name:

summary_of_causal_relation|due_to_or_as_a_consequence_of|0|TX_CONSEQ_OTH

Only when:

Required:

false

text

Condition that initiated the train of morbid events (the underlying condition)

Help

Use "Z78.9 - Other specified health status" if you can not find a correct ICD-10 code and specify in the free text field.

Technical specs

CSV column name:

summary_of_causal_relation|CD_UNDERL_COND

Reference list:

ICD10CM_2019

Required:

true

text

Specify other condition that initiated the train of morbid events (the underlying condition)

Technical specs

CSV column name:

summary_of_causal_relation|TX_UNDERL_COND_OTH

Only when:

Required:

true