| Patient/Demographics*
|
Patient
|
Includes most recently updated values for patient details and demographics across all systems. Narrowed down by inclusion criteria. Most commonly requested inclusion criteria based on:
- Diagnoses
- Age
- Procedures
- Visit at specific location in date range
Can be added to demographics upon request: RUCA codes, insurance (most recent available)
|
✓ Yes
|
✓ Yes
|
✓ Yes
|
| Visit/Encounter
|
Visit
|
Includes details on encounters, such as admission/visit start and end datetimes, discharge disposition, length of stay, reason for visit, etc. Encounters can be linked/used to limit values from other tables (Meditech accounts, Epic encounter keys)
|
✓ Yes
All encounters, scheduled or otherwise
|
✓ Yes
Visits and admissions occurring at the hospital
|
✓ Yes
Scheduled visits (often limited to 'Arrived')
|
| Diagnosis*
|
Patient diagnosis
|
Details about documented diagnosis, start and end dates, etc. Typically one row per diagnosis per patient. We can also create one row per set of comorbidities per patient using the Elixhauser or Charlson comorbidities lists.
|
✓ Yes
|
✓ Yes
|
✓ Yes
|
| Medication*+
|
Med administration
|
Details about medications administered by hospital or prescribed by clinics. No data available on prescriptions filled at outside providers. No data available currently on at-home med list.
|
✓ Yes
|
✓ Yes
|
✓ Yes
|
| Document*+
|
Document
|
Includes documents, reports, notes. Can be filtered based on the presence of a specific keyword/key phrase. Can be limited on document type. Most commonly requested document types include progress notes, HPI, operative notes, discharge summaries. Sometimes due to size of documents, this may require us to develop a REDCap project or an extra script to write individual documents to a shared server location.
|
✓ Yes
|
✓ Yes
|
✓ Yes
|
| Observation*+
|
Observation
|
Includes values not fitting into other tables, collected in Epic via 'flowsheet'. Most commonly requested include vitals (bp, heart rate, bmi, height, weight) and scores on standardized measures (e.g., PHQ-9, AUDIT, Glasgow Coma Score, MOCA score).
|
✓ Yes
|
✓ Yes
|
✓ Yes
|
| Laboratory Value*+
|
Lab value
|
One row per lab value, in Epic may be able to limit to sets. Most common requests include analytes from CBC, CMP, urinalysis.
|
✓ Yes
|
✓ Yes
|
✓ Yes
|
| Image Impression*+
|
Image impression
|
Impression from an image. At this time, we do not have access to images themselves, but they should be available in PACS system.
|
✓ Yes
|
✓ Yes
|
✗ No
|
| Procedure/Order*
|
Procedure/order
|
Details about dates, provider attending, etc. related to orders and/or procedures. Typically limited based on CPT code.
|
✓ Yes
|
✓ Yes
appears in billing
|
✓ Yes
|
| Birth/Delivery
|
Birth/baby
|
Details about births and deliveries performed at OU.
|
✓ Yes
|
✓ Yes
|
✗ No
|