Skip to contents

Post-SEM Patient Interventions Dataset (After Discharge through Dec 31, 2019)

melior_post_sem_interventions_all.Rd

This dataset contains information about healthcare interventions performed after discharge for patients in the SEM cohort from the Melior journal system. The data represents interventions with dates up to December 31, 2019.

Usage

melior_post_sem_interventions_all()

Format

A data frame with 5,770,414 observations and 7 variables:

contact_id

Character. Unique identifier for each healthcare contact/encounter, serves as a foreign key to link with other datasets. Original field name: KontaktId

patient_id

Integer. Patient pseudonym identifier, serves as a foreign key to link with other patient-level data. Original field name: Alias

activity_type

Character. Type of healthcare activity or note. 290 unique values. Most common: "Epikris, tvärprofessionell" (11.2%), "Op-berättelse" (7.4%), "Kontakt utan besök" (6.6%). Original field name: AktivitetTyp

term_name

Character. Term name. 3 unique values: "KVÅ-kod" (99.9%), "KVÅ/Opkod" and "Tillägg KVÅ/Opkod" (<0.1%). Original field name: Term_Namn

intervention_code

Character. Patient intervention/procedure code (KVÅ code). 5,351 unique values across the dataset. Original field name: PatientAtgard_Kod

intervention_description

Character. Description of the patient intervention/procedure. 5,065 unique values across the dataset. Contains 55,145 NA values (1%). Original field name: PatientAtgard_Beskrivning

intervention_modified_date

POSIXct. Date/time when the intervention was recorded/modified. Date range: 2017-01-02 to 2019-12-31. Distribution by year: 2019 (44%), 2018 (40%), 2017 (16%). Original field name: PatientAtgard_ModifieradDatum

care_form

Character. Form of care ("Slutenvård" = Inpatient, "Öppenvård" = Outpatient). Distribution: Outpatient (70.7%), Inpatient (29.3%). Original field name: VårdtillfälleFörÅtgärd_VardformText

Source

Melior

Details

This file was extracted from the Melior electronic health record system. The original filename indicates it contains information about patient interventions (PatientAtgarder) performed after discharge (Efter_Vardkontakt) with discharge dates (UtskrivningDatum) up to December 31, 2019 (Till_20191231). KVÅ codes represent standardized Swedish healthcare procedure codes.

Note

  • Several fields from the original dataset have been omitted for efficiency:

    • AktivitetTermId (activity_term_id): ID that almost perfectly corresponded to activity_type with just 2 exceptions ('Bedömning/åtgärd' and 'Logopedkontakt' each mapped to 2 different IDs).

    • TermId (term_id): ID that almost perfectly corresponded to term_name (99.9% of records had value 1600019040 for "KVÅ-kod"). These fields add file size without contributing significant analytical value.

  • The majority of interventions were performed in outpatient settings (70.7%)

  • The dataset includes 5,351 unique intervention codes, with 1% of interventions missing descriptions

  • The data spans interventions over a 3-year period (2017-2019)

  • Unlike some other intervention datasets, this one does not include care episode start and end dates

  • This dataset represents interventions performed after the initial SEM cohort contact/discharge and tracks them through the end of 2019

  • Original field names are preserved in the documentation for reference

Examples