Feature #859
Updated by RishiKesh Tuniki about 2 months ago
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** * https://www.opendental.com/manual/perio.html * https://www.opendental.com/manual243/graphicalperiochart.html * https://www.opendental.com/site/apiperioexams.html * https://www.opendental.com/site/apiperiomeasures.html * https://www.opendental.com/OpenDentalDocumentation25-2.xml#periomeasure ### 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 |            