Sidebar

About this dashboard

• Source: deidentified merge of Axium (dental) and Epic (medical) records, linked on chart number
• Grain: one row per patient (5,489 patients)
• Dental data filtered to completed procedures (Status LIKE '%C%'), TreatmentDate ≥ 2018-01-01
• All dates truncated to year; direct identifiers removed per HIPAA Safe Harbor

---

Match rates

• Axium dental match: 98.8%
• BMI on file: 77.9%
• Oral-cavity dx in Epic: 19.8%

---

See the accompanying data dictionary for full column definitions.

Sidebar

What’s on this page

Consolidates everything confirmed buildable from source data review, beyond the original three pages.

---

Confirmed available but not yet pulled in:

• CRP, INR, WBC/ANC — present in coh_lab_1y.csv
• CD4 / HIV viral load — present in coh_lab_1y.csv

---

Still needed from Axium:

• PTPERIO/PERCOND — real periodontal severity
• PTIMPLNT/PTIMPTX — implant outcomes
• APPOINT — scheduling/no-show
• PTREFER/REFERRAL — referral tracking (module exists, unextracted)
• PAYMENT/CLAIM/INSURANC — billing

---

Still needed from Epic:

• Full population counts by condition (not just linked)
• Active/current medication status
• Referral orders
• Vitals (BP)
• Structured smoking status
• Oncology treatment phase data

---

See project notes for the full needs breakdown.