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