Extract Acute In-Hospital Episode Trajectories — extract_acute

Evaluates acute physiologic shifts over [visit_start_date, visit_end_date]:

Creatinine baseline, peak, nadir, delta from admission, and KDIGO Acute Kidney Injury staging (0-3).
Shock Index (Heart Rate / Systolic Blood Pressure) and binary high shock indicator (> 1.0).
Glycemic volatility (max Glucose - min Glucose) and intra-encounter glucose peak and nadir.

Usage

extract_acute_trajectories(
  con,
  cohort_table = "cohort",
  measurement_table = "measurement",
  visit_table = "visit_occurrence",
  id_col = "person_id",
  visit_col = "visit_occurrence_id",
  creatinine_concept_ids = c(3016723L, 3020564L),
  glucose_concept_ids = c(3004501L, 3000483L),
  heart_rate_concept_ids = c(3027018L, 3024171L),
  sbp_concept_ids = c(3004249L, 3012888L)
)

Arguments

con: Active DBI/DuckDB connection.
cohort_table: Character table name or data frame containing cohort index visits.
measurement_table: Name of measurement table (default "measurement").
visit_table: Name of visit table (default "visit_occurrence").
id_col: Patient ID column (default "person_id").
visit_col: Visit occurrence ID column (default "visit_occurrence_id").
creatinine_concept_ids: Concept IDs for Serum Creatinine (default c(3016723L, 3020564L)).
glucose_concept_ids: Concept IDs for Serum/Blood Glucose (default c(3004501L, 3000483L)).
heart_rate_concept_ids: Concept IDs for Heart Rate (default c(3027018L, 3024171L)).
sbp_concept_ids: Concept IDs for Systolic Blood Pressure (default c(3004249L, 3012888L)).

Value

A data frame with acute trajectory metrics per patient and encounter.