Data Dictionary

Selected Cell

Cell:

Value:

Starting_Page General_Rules Abbreviations Data_Dictionary

100

How to use ResiMETA Data Dictionary

This data dictionary is linked to ResiMETA database (ResiMETA_Database_v01_Upload) and can be used to:

understand the overall structure of the database and the correct interpretation of coded variables

look up definitions, coding schemes, variable formats or abbreviations

The document consists of 3 tabs

General_Rules

provides information on general formatting and coding rules that apply to all variables in the database

Abbreviations

provides information on abbreviations and acronyms used throughout the database and associated documentation

Data_Dictionary

provides variable-level unique details, including variable names, data type, and coding schemes

For questions or support, feel free to contact:

resimeta@lir-mainz.de

Data Dictionary Status

Certain variables are currently being finalized and are not yet included in this version of the data dictionary. These variables will be added in the upcoming release.

We continuously update and refine the dataset to ensure completeness and accuracy. Users are encouraged to refer to the latest version for the most up-to-date information.

100

Missing Data Codes

"NA" (not applicable), "NR" (not reported)

Format Rules

write dates according to ISO 8601 format: YYYY-MM-DD.

store percentages as numeric values (float or integer)

write all words in lowercase, except proper names

use a period (.) as the decimal separator, not a comma (,)

use a comma followed by a space (, ) as the separator for content units (e.g., mean age per subgroup)

when multiple separations occur within one separate entity, use double slashes (//) to separate superior entities (e.g., mothers: 2, 4, 6 // fathers: 5, 7, 8)

use “and,” “or,” and “to” as separators for multiple numbers within one cell (e.g., multiple overlap categories)

use hyphen (-) as minus sign and as a hyphen for numerical or content ranges

write out abbreviations used by study authors (e.g., write out “HCW” as “health care workers”), except for standard abbreviations listed in the sheet Abbreviations (e.g., “PTSD”)

do NOT use quotation marks (“ ”) or arrows (->), as these may cause formatting problems

the symbols >, <, ≥, and ≤ (greater than, less than, greater than or equal to, and less than or equal to) may be used in string fields

100

Abbreviation

Description

PTSD

post-traumatic stress disorder

HIC

high-income country

UMIC

upper-middle-income country

LMIC

lower-middle-income country

LIC

low-income country

COVID-19

coronavirus disease caused by severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2)

ASD

autism spectrum disorder

RCT

randomized controlled trial

ICU

intensive care unit

TBI

traumatic brain injury

SARS

severe acute respiratory syndrome

DSM-IV

Diagnostic and Statistical Manual of Mental Disorders, fourth edition

DSM-V

Diagnostic and Statistical Manual of Mental Disorders, fifth edition

NATO

North Atlantic Treaty Organization

IVF

in vitro fertilization

HIV

human immunodeficiency virus

USA

United States of America

U.S.

United States

ART

assisted reproductive technology

United Kingdom

100

Field name

Description

Data Extraction Rules

Example

Field Type/Format

Data Type # continous # discrete (counting discrete units, intervals equal and meaningful, e.g. number of participants, number of adverse events) # ordinal (categories/ranks, intervals uequal/undefined, e.g. Likert scales, educational level) # nominal

Prompt Type

Allowed Values

Unit

Number of Decimal Places

Value Labels

Computation Rule

Level3: Basic Study Data

Level3.1: Study Description and Data Extraction Details

Study Number

unique number assigned to every study publication

# if multiple samples examined seperately within one publication (e.g. seperate trajectories for mothers and fathers, use same study number

integer

nominal

input field

Study ID

unique study identifier consisting of surname of the first author and year of publication

# multiple publications by same first author in one year: use index letters after the year (e.g. Bonanno_2012a, Bonanno_2012b) # multiple samples examined seperately within one publication (e.g. seperate trajectories for mothers and fathers: use index numbers after study ID (e.g. Bonanno_2012a_1 / Bonanno_2012a_2) # conference abstracts: add "_CA" (e.g. Ng_2023_CA)

Åhlin_2020

string

nominal

input field

Study Input

indication which study information were availabe: only prevalence estimates for trajectories (TRAJ), resilience factor ratings (RF), or both (TRAJ_RF)

auto-calculated from other variables

TRAJ

string

nominal

drop-down list (single)

TRAJ; RF; TRAJ_RF

pending

Study Input Unique or Primary Studies

indication which study information were availabe, considering only primary studies in case of overlapping data reports (i.e. multiple studies alayzing the same underlying sample): only prevalence estimates for trajectories (TRAJ), resilience factor ratings (RF), or both (TRAJ_RF)

auto-calculated from other variables

TRAJ

string

nominal

drop-down list (single)

TRAJ; RF; TRAJ_RF

pending

Publication Permanent Identifier

permanent identifier for publication (preferably DOI, otherwise Handle URL or institutional repository link)

# formatted according to the latest version of the style guide of the American Psychological Association (APA style)

https://doi.org/10.5271/sjweh.3889

string

nominal

input field

Publication Year

year of publication

# extract year of official journal publication (vs. year of online publication)

2020

integer

continous

input field

4 digits

year

APA Citation

full citation of publication

# formatted according to the latest version of the style guide of the American Psychological Association (APA style)

Åhlin , J. K., Peristera, P., Westerlund, H., & Magnusson Hanson, L. L. (2020). Psychosocial working characteristics before retirement and depressive symptoms across the retirement transition: A longitudinal latent class analysis. Scandinavian Journal of Work, Environment & Health, 46(5), 488-497. https://doi.org/10.5271/sjweh.3889

string

nominal

input field

Search Update

timepoint of search update wave study was included in database

# format "YYYY-MM"

2023-08

date

continous

input field

Contact to Authors

indication whether contact with the authors is required (yes) or not (no) due to ambiguities or questions concerning the study and reported data

# ambiguities or questions can arise at various points (e.g. discrepancies between sample sizes reported, crucial information on study design or analyses missing, …)

answer received

string

nominal

drop-down list (single)

no need; contact needed; contacted; answer received

Publication Examining Multiple Populations

pending

Superior Study ID if Publication Examining Multiple Populations

pending

Population Description If Multiple Populations

pending

Overlapping Data Number

number assigned to every dataset reported in multiple publications

pending

string

nominal

input field

Overlapping Data Reports (Study IDs)

study IDs of other reports of same or overlapping datasets (e.g. cohort or sample overlap)

pending

Nyberg_2019, Peristera_2020

string

nominal

input field

Overlapping Data Report Category

categorization of other reports of same or overlapping datasets

pending

3 and 5

string

nominal

input field

1 = same cohort / different subsamples (completely different subjects, eg. mothers vs. fathers) 2 = same sample / different outcomes (in case of multiple differences only code studies with unique outcomes) 3 = same sample / different RFs or RFs yes (in case of multiple differences only code studies WITH RFs) 4 = same sample / different analyses (statistical model), timepoints or inclusion criteria

Unique or Primary (Overlap Resolved) Study

indication if study is relevant for main analyses based on comparison with overlapping reports

pending

integer

nominal

drop-down list (single)

1; 2; 3

0 = no 1 = yes 2 = only for RFs

Number of Outcomes Overall

pending

auto-calculated from other variables

pending

Outcome Names Overall

pending

auto-calculated from other variables

pending

Resilience Factors Overall

whether relevant resilience factors were examined in the study (yes) or not (no)

auto-calculated from other variables

yes

string

nominal

drop-down list (single)

yes; no

pending

Number of Resilience Factors Overall

pending

auto-calculated from other variables

pending

Resilience Factor Names Overall

pending

auto-calculated from other variables

pending

Country

country of study conduction

# study country reported as UK, Great Britain or England: always extract as United Kingdom; if location can be specified geographically based on information about place of study (e.g. London) include England (Scotland, Wales and Northern Ireland excluded) in braces, e.g. " United Kingdom (England)" # USA/UK: extract as United States of America / United Kingdom # study includes multiple countries: "Mixed (country1, county2,...)", e.g. "Mixed (Côte d’Ivoire, Ghana)

Sweden

string

nominal

input field

Level3.2: Socioeconomic and Cultural Indicators

Income Group

pending

Human Development Index (HDI)

pending

Gini-Index

pending

Power Distance

pending

Individualism

pending

Masculinity

pending

Uncertainty Avoidance

pending

Long Term Orientation

pending

Indulgence

pending

Education: Inequality-Adjusted Education Index

pending

Industrialization: CIP Index Score

pending

Industrialization: CIP Index Rank

pending

Richness: 2020 GDP

pending

Richness: 2020 GDP Rank

pending

Democracy: Democracy Index 2020

pending

Democracy: Democracy Index 2020 Rank

pending

Global Collectivism Index (GCI)

pending

Level3.4: Population

Population Type

pending

Mixed Population Types

pending

Special Population Specified

pending

Working Population Specified

pending

Student Population Specified

pending

Clinical Population Specified

pending

Description of Population

brief description of the included population

# brief description of the target population, focusing on recruitment context; no information on stressor intensity, sample size, age, or nationality (captured in separate columns) # quoted from publication or self-formulated

Swedish retirees with an observable retirement transition

string

nominal

input field

Name of Primary Sample (Survey/Cohort Study)

if the data of the study originate from a superordinate study (e.g. survey, cohort or panel data), the name of this superordinate study is given here

# full name and abbreviation (if reported) # try using identical names for same cohorts (e.g. check if cohort is already included in database and use same name) # if secondary analyses of primary study without specific name: "NA"

Swedish Longitudinal Occupational Survey of Health (SLOSH)

string

nominal

input field

Description of Primary Sample (Survey/Cohort Study)

if the data of the study originate from a superordinate study (e.g. survey, cohort or panel data) or the study is a secondary analyses, a brief description of the superordinate sample or primary study is given here

# quoted from publication

a cohort survey of individuals aged 16–64 years from across the entire country and fairly representative of the Swedish working population

string

nominal

input field

Female Participants (n)

absolute number of women in the study sample

# given or self-calculated

930

integer

discrete

input field

Female Participants (%)

percentage of women in the study sample

# given or self-calculated # extract as many decimal places as specified in publication

53,6

float

continous

input field

[0;100]

variable

Age M (Years)

mean age of the study sample

# extract as many decimal places as specified in publication # if only the age per trajectory was reported, calculate value for full sample

65,9

float

continous

input field

years

variable

Age SD (Years)

standard deviation of mean age of the study sample

# extract as many decimal places as specified in publication # if only the age per trajectory was reported, calculate value for full sample

1,9

float

continous

input field

years

variable

If No M(SD) Reported: Other Age Information

pending

Age Minimum (Years)

minimum age of the study sample (regarding total age range)

# extract as many decimal places as specified in publication # CAVE: extract age range of actual study sample, not age range specified in inclusion criteria

float

continous

input field

years

variable

Age Maximum (Years)

maximum age of the study sample (regarding total age range)

# extract as many decimal places as specified in publication # CAVE: extract age range of actual study sample, not age range specified in inclusion criteria

float

continous

input field

years

variable

Age Categories

absolute (and relative) sample size for age categories specified in publication

# age in years # format "age category 1: n (%), age category 2: n (%), …"

<25: 96 (15,61); ≥25: 519 (84,39)

string

nominal

input field

years

Age Group

categorization of study sample into age groups

# 0-24: young age; 25-60: middle age; >60: old age # based on age range, otherwise on M + / - SD

middle and old age

string

nominal

drop-down list (single)

young age; middle age; old age; young and middle age; middle and old age; young, middle and old age; unlcear; NR; NA

Level3.5: Stressor

Major Life Stressor

main or index stressor in the study

# only extract ONE stressor (according to curve interpretation of authors; prioritize causal event [e.g. earthquake > nuclear accident]) # format "COVID-19 pandemic"

COVID-19 pandemic

string

nominal

input field

Major Life Stressor Category

categorization of index stressor into defined categories

# "other" = stressor doesn't fit into categories (open new categorie if stressor occurs in at least two studies) # "mixed" = persons experiencing different stressors analyzed in one study

pandemics, epidemics

string

nominal

drop-down list (single)

pandemics, epidemics; conflicts, wars; humanitarian migration; environmental / natural disasters; non-environmental disasters; adversive childhood experiences; bereavement; health related stressors: acute event; health related stressors: diagnosis / onset; health related stressors: treatment / surgery; health related stressors in close connections; pregnancy, birth; military stressors; job loss, retirement; educational transition; marriage; divorce; violence exposure, witnessing; menopause; financial or economic crises; terrorist attacks, mass shootings; work-related stressors; assisted reproductive treatment; other; mixed

Study Design Overall

categorization of study design across outcomes (i.e. pre stressor-data analyzed or not)

# pre-stressor data available = at least 1 outcome with pre-stressor measurement (even if other outcomes were measured only post-stressor)

pre-stressor data available

string

nominal

drop-down list (single)

pre-stressor data available; no pre-stressor data available; pre-stressor data available (retrospective assessment), unclear

pending

Level2: Trajectory Analyses → every outcome in seperate row (e.g. X rows for studys with X outcomes)

Level2.1: Outcome

Unique or Primary (Overlap Resolved) Outcome

pending

Authors' Name of Outcome

name of outcome as stated in publication

depressive symptoms

string

nominal

input field

Outcome Labeling

categorization of outcome into defined labels

# CAVE: based on assessment tool (authors' labeling may sometimes differ) # outcomes reported at least five times will be assigned to a new category, otherwise “not yet categorized”

depressive symptoms

string

nominal

drop-down list (single)

general distress; depressive symptoms; anxiety symptoms; PTSD symptoms; stress symptoms; positive mental health; loneliness; social support; internalizing symptoms; externalizing symptoms; negative affect; positive affect; suicidality; grief symptoms; rumination; fatigue; resilience; functional impairment; not yet categorized;

Outcome Category

categorization of outcome into defined categories

mental distress

string

nominal

drop-down list (single)

mental distress; positive mental health; psychological functioning/functional impairment; posttraumatic growth; resilience; resilience factors; not yet categorized

Outcomes or Assessment Tools Merged for Modelling

whether multiple outcomes were merged for trajectory modeling, i.e. studies using more than one assessment tool for one trajectory modelling

# multiple merging options: a) merging of different outcomes (e.g. mental distress score as composite of anxiety and depression assessment tools), b) merging of different asssessment tools (eg. 2 scales assessing different PTSD symptoms), c) joint modelling of outcomes assessed at different timepoints with different assessment tools (e.g. scale A at baseline and scale B at follow-up)

string

nominal

drop-down list (single)

yes; no; unclear

Outcome Assessment Tool Full Name

full name of assessment tool for outcome

# extract full name and additional information concerning version (e.g. "8-item version", "slightly altered version") or subscale (e.g. "anxiety subscale") # do NOT extract information about translated versions (e.g. "EPDS, German version")

Edinburgh Postnatal Depression Scale

string

nominal

input field

Outcome Assessment Tool Abbreviation

abbreviation of assessment tool for outcome

EPDS

string

nominal

input field

Outcome Rating Mode

mode in which the instrument was rated (i.e. self-rated or other-rated)

self-rated

string

nominal

drop-down list (single)

self-rated; other-rated; unclear

Level2.2: Study Design

Study Design Outcome Level

categorization of study design (i.e. pre stressor-data analyzed or not)

pre-stressor data available

string

nominal

drop-down list (single)

pre-stressor data available; no pre-stressor data available; retrospective assessed pre-stressor data available; unclear

Number of Timepoints Analyzed in Model

number of measurement timepoints included in analysis

pending

integer

discrete

input field

[0;∞]

Number of Timepoints Analyzed Before Stressor Exposure

number of analyzed measurement timepoints before stressor exposure

pending

integer

discrete

input field

[0;∞]

Number of Timepoints Analyzed After Stressor Exposure

number of analyzed measurement timepoints after stressor exposure

pending

integer

discrete

input field

[0;∞]

Timepoint Range

pending

Timepoint Range Before Stressor Exposure

pending

Timepoint Range After Stressor Exposure

pending

Time Points Analyzed

pending

Level2.3: Method

Total N for Modeling

sample size used for modeling

# reported in publication or self calculated using trajectory sample sizes

1735

integer

discrete

input field

[150; ∞]

Level2.4: Trajectories

Number of Identified Trajectories

number of identified trajectories

integer

discrete

input field

[2; ∞]

Double Trajectories

pending

Resilient Label (Authors)

label used by study authors for trajectory that was classified as resilient trajectory by research team

no depression, stable (very low) / group 1

string

nominal

input field

Resilient (%)

percentage of participants assigned to trajectory classified as resilient

# reported in publication or self calculated # extract as many decimal places as specified in publication (2 decimal places if self calculated)

27,2

float

continous

input field

[0;100]

percentage

variable

pending