crucialevent
The crucialevent table contains a row for an instance of an event (described by crucialevent.eventtype) such as a hospitalization, ED visit, beginning of care management, or a specified service/procedure. By normalizing events into this structure, features that describe the event can be computed relative to the event date. Using this structure, events can be readily compared and summarized to determine relationships and patterns with observations that occur before and after the event.
Usage
Filter crucialevent by crucialevent.eventtype in order to limit an analysis to a particular event definition. The crucialevent table can be join to derivedpatient; however, note that the columns in the derivedpatient table generally describe the current state of the patient, not the patient at the time of the event.
Core crucialevent definitions (represented as crucialevent.eventtype) include:
- All hospitalization admissions
- Emergent hospitalizations
- ACSC hospitalization
- ACO 8 Readmission
- All ED
- Avoidable ED
- CM initiated
- CAUTI
- CDIFF
- CLABSI
- MRSA
- ACO 38 MCC admissions
- ACO 43 ACSC discharge
Source Concepts
- claim
- encounter
Table Schema
