To check which Open Dental patients still need scaling and root planing (SRP) scheduled, run a Treatment Finder report filtered to completed D4341/D4342 procedures with no future appointment attached, cross-reference the Procedures Not Billed and Insurance Estimates views for unscheduled crowns of care, and confirm each chart's periodontal status before contacting anyone. The dependable method combines a saved query, the patient's treatment plan status, and a periodic manual audit rather than a single report. This guide explains the database mechanics behind that workflow, the thresholds that define a true open case, and the operational steps that keep the list accurate.
Mechanism: how Open Dental stores an unscheduled SRP
Open Dental separates a procedure's clinical existence from its scheduling state. When a dentist marks D4341 (scaling and root planing, four or more teeth per quadrant) or D4342 (one to three teeth per quadrant) as treatment planned, the program writes a row to the procedurelog table with a status value. Status "TP" means treatment planned, "C" means completed, and "EC" means existing/conditions. A procedure can sit in TP status indefinitely with no appointment, which is exactly the population you are hunting.
Scheduling is a separate join. An appointment attaches to procedures through the appointment and procedurelog linkage, where each scheduled procedure carries an appointment number. If that field is empty, the procedure has no future visit. This is the structural definition of an "open" SRP: a treatment-planned D4341/D4342 with no appointment number and no completion date. The Treatment Finder report surfaces this by listing patients with TP procedures and showing whether an appointment exists.
Periodontal charting drives the clinical side. Open Dental records probing depths, bleeding points, and mobility in the perio chart module, and a completed periodontal exam can auto-generate a treatment plan for SRP when the dentist accepts it. The program does not decide that SRP is needed; it stores the dentist's diagnosis and the planned procedures that follow. The gap between "planned" and "scheduled" is where patients fall through.
Plain language: the software remembers what the dentist prescribed, but it will not chase the patient for you.
Quantified context: how large the unscheduled pool typically is
Practice-management audits commonly find that a meaningful share of treatment-planned procedures never convert to appointments. A 2023 dental industry survey of practice metrics reported that roughly one in four treatment-planned cases across all procedure types remained unscheduled at 90 days; SRP, which is often deferred for cost and anxiety reasons, tends to sit at or above that average. Treat these figures as directional, not benchmarked to your practice.
The clinically relevant windows are shorter than the financial ones. Periodontal disease progresses, and a patient diagnosed with moderate to severe periodontitis who delays SRP for 12 months can lose additional attachment. The American Academy of Periodontology's 2017 classification ties staging to attachment loss and probing depth, so a chart that qualified for SRP last year may now qualify for a more extensive plan.
Cost context matters for outreach framing. A full-mouth SRP of four quadrants commonly bills in the range of USD 200 to USD 400 per quadrant before insurance, and many plans cover SRP at 80 percent after deductible when periodontal documentation supports medical necessity. A patient who was quoted a out-of-pocket estimate months ago may respond differently when the practice re-verifies benefits. Numbers vary by region and carrier, so confirm against the patient's actual plan.
Timeline: from diagnosis to a booked SRP
| Stage | Typical timing | Open Dental status | What to check |
|---|---|---|---|
| Periodontal exam completed | Day 0 | Perio chart saved | Probing depths, bleeding, mobility |
| SRP treatment planned | Day 0 to 14 | Procedure status TP | D4341/D4342 rows created |
| Financial estimate presented | Day 0 to 30 | Treatment plan active | Insurance verification, patient portion |
| First contact attempt | Day 7 to 21 | No appointment number | Treatment Finder report |
| Recall or follow-up call | Day 30 | Still TP, unscheduled | Communication log |
| Case review / re-diagnosis | Day 90 to 180 | TP possibly revised | Perio chart update |
| Conversion or closure | Day 180+ | Completed or dismissed | Billing and chart note |
The table reflects general practice patterns rather than a mandated schedule. The point is that every row after "treatment planned" is a checkpoint where an unscheduled SRP can be identified and acted on.
Edge cases that break a simple report
The Treatment Finder report is a starting point, not a verdict. Several situations produce false positives or false negatives.
A procedure marked TP for a patient who transferred care elsewhere will sit in the list forever. Without a manual review, your outreach list fills with patients who already received SRP at another practice.
Insurance-driven staging creates partial plans. A patient may have D4341 planned for two quadrants now and two later, so a report filtered to "any TP procedure" overcounts open cases. Filter to the specific codes and check quadrant count.
Patients with a future hygiene appointment are technically scheduled, but not for SRP. A prophy or periodontal maintenance visit (D1110 or D4910) does not satisfy an open SRP plan; the report may show an appointment number and mask the real gap. Confirm the appointment type, not just its presence.
Minors and guardianship cases route contact through a parent, and the chart may list the patient's phone rather than the decision-maker's. Outreach to the wrong number stalls the case.
Dismissed or inactive patients appear in some report configurations. Open Dental's patient status field (active, inactive, archived) should be part of the filter logic.
Red-flag warnings: A TP SRP with no perio chart on file for more than 12 months warrants re-examination before scheduling. Patients with bleeding disorders, anticoagulant use, or poorly controlled diabetes need medical clearance before SRP, not just a booking. A patient who states they cannot afford care should be routed to a financial coordinator, not dropped. Repeated no-contact after three documented attempts should trigger a chart note and a case-review decision, not indefinite retries.
Misconceptions about tracking SRP patients
The most common misconception is that the Treatment Finder report alone is sufficient. It lists patients with TP procedures, but it does not enforce follow-up, does not log contact attempts, and does not distinguish SRP from other planned work unless filtered. A practice relying on the default report view will miss cases where a hygiene recall appointment replaced the SRP in the schedule.
Another misconception is that "scheduled" equals "solved." A patient booked for a consultation or a prophy is not booked for SRP. The appointment type must match the procedure. Practices that count any future appointment as converted overstate their completion rate.
A third misconception is that insurance verification is a one-time task. Benefits change at plan-year boundaries, usually January 1 for calendar-year plans, and a patient who was quoted a cost in November may face a different estimate in February. Re-verifying before the second outreach attempt improves conversion.
The counterintuitive professional caveat: aggressive outreach can backfire. Patients who feel pressured into SRP without understanding the diagnosis are more likely to no-show or cancel. A chart note documenting that the dentist explained the periodontal findings, ideally with the perio chart visible, correlates with better attendance than volume-based calling.
Plain language: the goal is a scheduled, informed patient, not a filled slot.
Comparison: methods for identifying unscheduled SRP patients
| Method | What it finds | Strength | Limitation |
|---|---|---|---|
| Treatment Finder report | All TP procedures, appointment status | Built-in, fast | Overcounts, no SRP filter by default |
| Procedures Not Billed report | Completed but unbilled work | Catches billing gaps | Misses unscheduled TP entirely |
| Custom query on procedurelog | Exact D4341/D4342 with empty appointment number | Precise, repeatable | Requires query access or a saved report |
| Insurance Estimates view | Planned work with benefit estimates | Links cost to plan | Depends on accurate fee schedules |
| Manual chart audit | Everything, including stale entries | Catches false positives | Time-intensive, not scalable |
| Hygiene recall list | Patients due for maintenance | Good for long-term tracking | Does not isolate open SRP |
| Communication log review | Contact history per patient | Shows follow-up gaps | Reactive, not discovery |
The strongest workflow layers the custom query with the Treatment Finder and a manual audit of anything older than 90 days. No single view is complete, and the practice that relies on one will leave patients unscheduled.
Practical actions: a repeatable checking workflow
Start with a saved filter rather than a fresh report each time. In Open Dental, use the Treatment Finder with procedure codes D4341 and D4342 selected, status set to TP, and the "has appointment" toggle off. Save this configuration so the front office runs the identical query weekly.
Tie the query to a cadence. A weekly pull every Monday morning surfaces new TP cases within seven days, which matches the first-contact window in the timeline above. Monthly-only reviews let cases age past the point where patients remember the conversation.
Document every contact attempt in the communication log with a date, channel, and outcome. A patient with three documented attempts and no response should move to a case-review list for the dentist, not stay in the active outreach queue.
Reconcile the list against chart status monthly. Remove patients who transferred, were dismissed, or completed SRP elsewhere. A list that only grows becomes noise, and staff stop trusting it.
Re-verify insurance for any case older than 60 days before the next contact. Quote the patient their current estimated portion, not the original figure.
Set a conversion threshold. If fewer than a defined share of contacted patients schedule within 30 days, examine whether the barrier is cost, scheduling convenience, or understanding of the diagnosis. The fix differs for each.
Plain language: run the same report, on the same day, every week, and act on what it shows.
Limitations and what this workflow cannot do
Open Dental stores what the practice enters, so the accuracy of any SRP tracking depends on chart hygiene. A dentist who plans SRP verbally without entering the procedure code leaves no data trail, and no report can find that patient. The system is a mirror of documentation quality, not a substitute for it.
The reports also cannot assess clinical urgency. Two patients with identical TP codes may have very different periodontal status, and the software does not rank them. A chart review by the dentist or hygienist is required to prioritize.
Version differences matter. The exact report names, filter options, and menu paths in Open Dental vary across versions, and cloud versus on-premise installations can present options differently. Confirm the current interface against your installed version rather than assuming a screenshot matches.
Finally, this workflow identifies candidates for scheduling; it does not produce a diagnosis, a treatment plan, or a coverage determination. Those remain clinical and administrative judgments made by the treating dentist and the patient's plan.
This article is general educational information about practice-management workflows, not a diagnosis, treatment plan, or insurance determination for any patient. It does not promise scheduling outcomes or coverage. Confirm clinical decisions with the treating dentist and coverage details with the patient's plan; for a medical emergency, contact local emergency services.