Skip to main content

Table 1 Overview of different data sources

From: A retrospective analysis of the health and social situation of homeless people in Berlin: study protocol

data source

topic

variables

categories

related objectives/ research questions

1

Floating medical record

General information

status of homelessness/ type of accommodation

own flat, hostel, sleeps at friends/ acquaintances, shelter, carrier housing, sleeping rough, other

O1a, O1b, O2d

status of health insurance

not insured, insured (type of company)

O1a, O1b, O2d

birthday

year of birth

O1a, O2d

number of visits

in total

O1a, O1b, O2d

number of medical consultations

–

O1a, O1b, O2d

duration of care (date of first and last visit)

in years

O1a, O1b, O2d

indications of debts

no, yes

O1a, O1b, O2d

Utilization of health centre services

medical reason

need of primary care, eye specialist, dentist

O2b, O2c

counselling

(at risk of) homelessness in need of psychologist, social worker, legal advice

O2b, O2c

Other

food, new clothes, hairdresser, shower, other

O2b, O2c

Medical history

diagnosis and provided treatment, medication, further recommendations

date of issue, 3-digit ICD-10-GM code*, prescribed medication by ATC code**

O2a, O2b, O2c, O2d, O2e, O2f

2

Social and medical anamnesis

Socio demographics

age

in years

O1a, O2d, O2f

sex

female, male, diverse

O1a, O2d, O2f

school education

number of school years

O1a, O2d, O2f

occupational education

unskilled, three-year apprenticeship, technical college degree, university degree

O1a, O2d, O2f

citizenship

list of 202 countries

O1a, O2d, O2f

family status

married (living together), married (living apart), single, divorced, widowed

O1a, O1b, O2d, O2f

family contact

no, yes (parents, siblings, children, other)

O1a, O1b, O2d, O2f

(un)employment

years of unemployment

O1a, O1b, O2d, O2f

reason for homelessness

job loss, divorce, debt, mental illness, change of location, detention, rental rate, escape from parental home, lease expired, other

O1a, O1b, O2d, O2f

source of income

social assistance, basic security, unemployment benefit, pension, newspaper sale, collect bottles, begging, other

O1a, O1b, O2d, O2f

detention experiences

no, yes

O1a, O1b, O2d, O2f

Medical history

somatic diseases

3-digit ICD-10-GM code*, date of consultation

O2a, O2d, O2e, O2f

psychiatric diseases

3-digit ICD-10-GM code* (F00-F99), date of consultation

O2a, O2d, O2e, O2f

dental health

dental problems, consultation of dentist, date of consultation

O2a, O2d, O2e, O2f

infectious diseases

hepatitis A, B, C, HIV, sexually transmitted diseases

O2a, O2d, O2e, O2f

medication

prescribed medication by ATC code**, date of prescription

O2a, O2d, O2e, O2f

3

Patient information sheet

Change of general information

status of homelessness/ type of accommodation

own flat, hostel, sleeps at friends/ acquaintances, shelter, carrier housing, sleeping rough, other

O1b, O2d, O2f

status of health insurance

not insured, insured (type of company)

O1b, O2d, O2f

status of financial support

social assistance, basic security, unemployment benefit, pension, other

O1b, O2d, O2f

4

Doctors letters

Hospital care

hospital discharge letters

institution, date of admission and discharge, date of issue, 3-digit ICD-10-GM code*, prescribed medication by ATC code**

O1a, O2a, O2b

Ambulatory care

physician’s letter

date of issue, 3-digit ICD-10-GM code*, prescribed medication by ATC code**

O1a, O2a, O2b

5

Psychological report

Psychological counselling

reason for counselling

date of issue, agreements (appointment: with social worker, for legal advice, with psychologist, job centre, other)

O1a, O2a, O2b

diagnosis

3-digit ICD-10-GM code* (F00-F99)

O1a, O2a, O2b

6

Psychiatric record

Psychiatric record

diagnosis

date of issue, 3-digit ICD-10-GM code*

O1a, O2a, O2b

medication

prescribed medication by ATC code**

O1a, O2a, O2b

7

Documents provided by the health centre

Certificates

doctors’ certificates

issued for which institution, date of issue, 3-digit ICD-10-GM code*, prescribed medication by ATC code**

O1a, O2a, O2b

Reports

any report

issued for which institution, date of issue, 3-digit ICD-10-GM code*, prescribed medication by ATC code**

O1a, O2a, O2b

8

Others

Other information provided in the medical record

x-ray images, electrocardiogram recordings, pictures, letters, notes, other documents

existing yes, no

O1a, O2a, O2b, O2c, O2f

  1. *ICD-10-GM International Classification of Diseases German Modification, **ATC code Anatomical Therapeutic Chemical Classification System