Project

General

Profile

Actions

Feature #859

open

Implement Periodontal (Perio) Chart with Data Capture, Calculation, and Visualization

Added by RishiKesh Tuniki about 2 months ago. Updated 24 days ago.

Status:
Resolved
Priority:
Normal
Assignee:
Start date:
03/05/2026
Due date:
03/17/2026 (33 days late)
% Done:

100%

Estimated time:
Test Phase:
Select Test Phase

Description

Implement the Perio Chart visualization module in DentPal using periodontal exam and measurement data that has already been synchronized from PMS APIs and stored in the following tables:

>  Patients
>  PatientPerioExams
>  PatientPerioMeasurements

This task focuses on:

  • Retrieving periodontal exam data
  • Transforming raw measurement records into a Template chart structure
  • Performing auto-calculations
  • Rendering the Perio Chart UI

Reference template:
Is Attached

Reference Documentation

Existing Database Structure

Patients

Stores patient demographic information.

Key Fields:

Field Description
Id Internal Patient ID
PMSPatientId PMS system identifier
TenantId Tenant
ClinicId Clinic
PMSSourceSystem Source PMS

PatientPerioExams

Stores periodontal exam sessions.

Key Fields:

Field Description
Id Internal Perio Exam ID
PMSPerioExamID PMS exam identifier
PatientId Patient reference
ExamDate Date of exam
ProviderId Dentist/Provider
Note Exam notes

PatientPerioMeasurements

Stores individual periodontal measurements.

Key Fields:

Field Description
Id Internal Perio Mesurement ID
PerioExamID Exam reference
PatientId Patient reference
ToothNum Tooth number
SurfaceCode Surface (MB, B, DB, ML, L, DL etc.)
MeasurementType Type of measurement
MeasurementValue Value

Measurement Types Expected

Typical MeasurementType values:

Type
Mobility
Furcation
GingMargin
MGJ
Probing
SkipTooth
BleedSupPlaqCalc













Files

PERIO EXAM TEMPLATE.xlsx (13.4 KB) PERIO EXAM TEMPLATE.xlsx RishiKesh Tuniki, 03/05/2026 04:48 AM
PERIO EXAM TEMPLATE.pdf (45 KB) PERIO EXAM TEMPLATE.pdf RishiKesh Tuniki, 03/05/2026 04:48 AM
clipboard-202603051550-l18kw.png (23.3 KB) clipboard-202603051550-l18kw.png RishiKesh Tuniki, 03/05/2026 05:20 AM
clipboard-202603051550-xulho.png (5.82 KB) clipboard-202603051550-xulho.png RishiKesh Tuniki, 03/05/2026 05:20 AM
clipboard-202603051551-y88u0.png (18.8 KB) clipboard-202603051551-y88u0.png RishiKesh Tuniki, 03/05/2026 05:21 AM
clipboard-202603051551-lcb65.png (11.6 KB) clipboard-202603051551-lcb65.png RishiKesh Tuniki, 03/05/2026 05:21 AM
clipboard-202603051551-j5wqt.png (11.9 KB) clipboard-202603051551-j5wqt.png RishiKesh Tuniki, 03/05/2026 05:21 AM
clipboard-202603051552-8hbq7.png (6.98 KB) clipboard-202603051552-8hbq7.png RishiKesh Tuniki, 03/05/2026 05:22 AM
clipboard-202603051552-6ja6w.png (6.04 KB) clipboard-202603051552-6ja6w.png RishiKesh Tuniki, 03/05/2026 05:22 AM
clipboard-202603051552-32orm.png (14.7 KB) clipboard-202603051552-32orm.png RishiKesh Tuniki, 03/05/2026 05:22 AM
clipboard-202603051554-bsyju.png (12.7 KB) clipboard-202603051554-bsyju.png RishiKesh Tuniki, 03/05/2026 05:24 AM
clipboard-202603051555-509mb.png (13 KB) clipboard-202603051555-509mb.png RishiKesh Tuniki, 03/05/2026 05:25 AM
clipboard-202603051555-jpsrb.png (10.6 KB) clipboard-202603051555-jpsrb.png RishiKesh Tuniki, 03/05/2026 05:25 AM
clipboard-202603051556-gpytl.png (24.1 KB) clipboard-202603051556-gpytl.png RishiKesh Tuniki, 03/05/2026 05:26 AM
perio-chart-v3.html (35.6 KB) perio-chart-v3.html Redmine Admin, 03/11/2026 01:44 PM
INTEGRATION_GUIDE.md (6.17 KB) INTEGRATION_GUIDE.md Redmine Admin, 03/11/2026 01:59 PM
dentpal-perio-chart-scaffold.zip (27.6 KB) dentpal-perio-chart-scaffold.zip Redmine Admin, 03/11/2026 02:05 PM
clipboard-202603182210-reygd.png (47.6 KB) clipboard-202603182210-reygd.png RishiKesh Tuniki, 03/18/2026 12:40 PM
clipboard-202603182210-3uvdv.png (40.9 KB) clipboard-202603182210-3uvdv.png RishiKesh Tuniki, 03/18/2026 12:40 PM
PERIO EXAM TEMPLATE.pdf
clipboard-202603051550-l18kw.png
clipboard-202603051550-xulho.png
clipboard-202603051551-y88u0.png
clipboard-202603051551-lcb65.png
clipboard-202603051551-j5wqt.png
clipboard-202603051552-8hbq7.png
clipboard-202603051552-6ja6w.png
clipboard-202603051552-32orm.png
clipboard-202603051554-bsyju.png
clipboard-202603051555-509mb.png
clipboard-202603051555-jpsrb.png
clipboard-202603051556-gpytl.png
clipboard-202603182210-reygd.png
clipboard-202603182210-3uvdv.png
Actions

Also available in: Atom PDF