Patient Event Sequencing: Multi Site, Exploratory, Cross-Sectional Analysis


Created

Last Modified

Click on the thumbnail above to preview images.

Domain

Category

Parameters

Publisher

PEDSnet

Abstract

The Patient Event Sequencing module computes the days between two user-specified events and summarizes the distribution within the cohort. It assesses the plausibility of the sequence of two user-provided clinical events as they appear in a patient’s record. This allows the user to ensure that the two events, like a cancer diagnosis and chemotherapy, occur in a sensible order and within an expected length of time.

Probe

Clinical Assessment

Access Package

# install.packages("devtools") devtools::install_github('ssdqa/patienteventsequencing')

Visualization Output

This check outputs a bar graph for each site showing the proportion of patients whose time between events falls within each threshold window. The dotted line represents the median proportion for each window.

Raw Output

This check produces a raw data output containing 8 columns of data:

Column Data Type Definition
site character the name of the site being targeted
num_day numeric the number of days between event A and event B, using the date of event A as the index
user_cutoff numeric the user provided threshold for days between the events
event_a_name character the name of event A
event_b_name character the name of event B
pt_ct numeric the number of patients with num_days between the two events
total_pts numeric the total number of patients in the cohort
pts_without_both numeric the number of patients that are missing one of or both of the events, which prevents a date differential from being computed

Funder(s)

This research was made possible through the generous support of Patient-Centered Outcomes Research Institute. The statements presented in this work are solely the responsibility of the author(s) and do not necessarily represent the views of PCORI, its Board of Governors, or its Methodology Committee.

Provenance

Description

Clinical Subjects Headings

Related Data Quality Result

Patient Event Sequencing Study Results II: PRESERVE
Created:2025-04-08Affiliation:PEDSnet Data Coordinating Center
The results of a Patient Event Sequencing check using the Multi-Site, Exploratory, Cross-Sectional parameters. This check evaluates the time between a patient's cohort entry date and an antihypertensive prescription.
Patient Event Sequencing Study Results I: PAQS Query 3
Created:2025-05-30Affiliation:PEDSnet Data Coordinating Center
The results of a Patient Event Sequencing check using the Multi-Site, Exploratory, Cross-Sectional parameters. This check investigates the distribution of time between a T2DM diagnosis (index event) and a CKD diagnosis (outcome event).
Patient Event Sequencing Study Results II: PAQS Query 3
Created:2025-05-30Affiliation:PEDSnet Data Coordinating Center
The results of a Patient Event Sequencing check using the Multi-Site, Exploratory, Cross-Sectional parameters. This check investigates the distribution of time between an Hba1c result > 5.8% (index event) and an antidiabetic drug prescription (outcome event).

Related Person

Related Code

Study-Specific Quality, Utility, and Breadth Assessment
Created:2025-11Affiliation:PEDSnet Data Coordinating Center
This suite of R packages allows one to investigate multiple facets of data quality and customize analyses based on your study-specific needs. Each module allows up to 8 different analyses in either the OMOP or PCORnet CDM, all aimed at taking a different view of the data while still addressing the same data quality probe.

##### [View pkgdown summary here.](https://ssdqa.github.io/squba/)

Related Data Quality Check

Related Publications

Creative Commons license

Except where otherwised noted, this item's license is described as a CC-BY Attribution 4.0 License.

Cite this Data Quality Check

PEDSnet Data Coordinating Center. (2024, December). Patient Event Sequencing: Multi Site, Exploratory, Cross-Sectional Analysis. [D Q Check]. PEDSpace Knowledge Bank. https://doi.org/10.24373/pdsp-413