SQL Queries
Ready-to-use SQL queries for Open Dental. Copy, paste, run.
92 articles
Patient Portion Uncollected Query
Use this open dental uncollected patient portion query to identify active patients with outstanding balances. Easily track and collect what is owed to your office.
Open Dental Unearned Income Query
Need to track patient prepayments? Use this open dental unearned income query to easily identify and manage unearned balances in your practice's accounts.
Open Dental Payment Plan Balance Query
Need to track patient debt? Use this open dental payment plan balance query to quickly identify active payment plans and their remaining balances in your office.
Find Patients with Expired Insurance
Use this open dental expired insurance query to quickly identify active patients whose insurance coverage has already terminated, helping you update records.
Membership Plan Patient List Query
Need to see which patients are on your in-house membership plan? Use this open dental membership plan query to pull an active list of enrolled patients.
Open Dental No-Show Rate Query
Need to track patient attendance? Use this open dental no show rate query to identify which days of the week have the highest broken appointment percentages.
Find Family Members Not Listed as Patients
Use this open dental family not patients query to identify individuals linked to your database who are not currently marked as active patients in your system.
Credit Balance Patients Query
Need to find patients with credit balances? Use this open dental credit balance query to quickly identify accounts with negative balances for easy cleanup.
Operatory Utilization by Day of Week
Need to optimize your schedule? Use this open dental operatory utilization query to see which days your chairs are busiest and identify gaps in your production.
Identify Patients Seen Only Once
Use this open dental one visit patients query to identify individuals who have only had a single appointment, helping you improve your practice reactivation.
Find Perio Patients Overdue for SRP
Use this open dental SRP overdue query to identify active patients who have had a perio diagnosis but are now overdue for their scaling and root planing.
Referral Tracking by Referring Doctor
Need to see which doctors are sending you the most patients? Use this open dental referral tracking query to identify your top sources of new business.
Open Dental Average Production per Visit Query
Need to track practice efficiency? Use this open dental average production per visit query to calculate your daily production averages for any date range.
Insurance Verification Due Query
Need to verify insurance before appointments? Use this open dental insurance verification due query to pull a list of patients with upcoming appointments.
Unfinalized Insurance Payments Query
Use this open dental unfinalized payments query to identify insurance payments that were received but not finalized, ensuring your financial reports are accurate.
Fee Schedule Comparison Query
Need to compare fee schedules across providers? Use this open dental fee schedule comparison query to quickly identify discrepancies in your practice's billing.
Finding Incomplete Procedure Notes
Use this open dental incomplete notes query to quickly identify clinical procedures that are missing documentation, ensuring your records remain audit-ready.
Average Production per New Patient Query
Need to track your marketing ROI? Use this open dental new patient value query to calculate the average production generated by new patients in your practice.
Top 20 Procedures by Revenue
Need to identify your most profitable services? Use this open dental top procedures query to quickly rank your top 20 procedures by total revenue generated.
Monthly Production vs Collections Query
Need to track your practice's financial health? Use this open dental production vs collections query to see your monthly totals in the User Query window.
Provider Schedule Utilization Query
Need to track provider productivity? Use this open dental schedule utilization query to analyze appointment patterns and optimize your daily office schedule.
Find Patients With No Primary Provider
Use this open dental no provider assigned query to quickly identify active patients missing a primary provider assignment for better practice management.
Year-over-Year Production Query
Need to compare your practice's performance? Use this open dental year over year production query to quickly analyze and compare your production data by date.
Daily Deposit Report by Payment Type
Need a custom daily deposit report? Use this open dental daily deposit query to quickly break down your practice's income by payment type for any date range.
Crown and Bridge Production Query
Need to track crown and bridge production? Use this simple SQL query to pull completed crown and bridge procedure totals by provider in Open Dental.
Find Patients Without Email Addresses
Easily identify active patients missing email addresses in your database with this simple open dental missing email query. Improve your digital communication.
Insurance Verification Due Query
Need to see which patients need insurance verification? Use this open dental insurance verification due query to identify patients with upcoming appointments.
Finding Incomplete Procedure Notes
Easily track down missing documentation with this open dental incomplete notes query. Identify procedures with blank notes to keep your patient charts compliant.
Fee Schedule Comparison Query
Need to audit your practice's pricing? Use this open dental fee schedule comparison query to easily identify discrepancies between your provider fee schedules.
Tracking Uncollected Patient Balances
Need to identify outstanding money? Use this open dental uncollected patient portion query to quickly list active patients with an unpaid balance on their account.
Analyze No-Show Rates by Day of Week
Use this open dental no show rate query to identify which days of the week have the highest broken appointment rates and optimize your practice schedule.
Open Dental Expired Insurance Query
Easily identify patients with expired insurance plans using this ready-to-use open dental expired insurance query. Keep your practice revenue cycle on track.
Operatory Utilization by Day of Week
Need to optimize your schedule? Use this open dental operatory utilization query to see which days your operatories are busiest and improve practice efficiency.
Open Dental Average Production per Visit Query
Need to track your practice's efficiency? Use this open dental average production per visit query to calculate your daily production metrics in seconds.
Tracking Unfinalized Insurance Payments
Use this open dental unfinalized payments query to identify insurance claims that have been processed but remain in an incomplete status in your system.
Open Dental Unearned Income Query
Need to track patient prepayments? Use this open dental unearned income query to identify all unearned income balances in your practice quickly and accurately.
Average Production per New Patient Query
Need to track your practice growth? Use this open dental new patient value query to calculate the average production generated by new patients in your office.
Tracking Payment Plan Balances
Need to track outstanding balances? Use this open dental payment plan balance query to quickly identify patients with active payment plans and their totals.
Finding Perio Patients Overdue for SRP
Use this open dental SRP overdue query to identify active patients who have completed periodontal charting but are overdue for their scaling and root planing.
Find Procedures Not Billed to Insurance
Use this open dental procedures not billed query to identify completed work that hasn't been sent to insurance, ensuring your practice gets paid on time.
Sealant Opportunities Ages 6-14
Identify patients aged 6-14 who need sealants with this open dental sealant opportunities query. Easily pull a list for your hygiene recall or marketing.
Monthly Production vs Collections Query
Need to track your practice's financial health? Use this open dental production vs collections query to generate a monthly report directly in your software.
Daily Deposit Report by Payment Type
Need a clear breakdown of daily collections? Use this open dental daily deposit query to see exactly how much money was collected by payment type in seconds.
Top 20 Procedures by Revenue
Need to identify your most profitable services? Use this open dental top procedures query to instantly rank your top 20 procedures by total revenue generated.
Referral Tracking by Referring Doctor
Need to see which doctors are sending you the most patients? Use this open dental referral tracking query to identify your top sources of new business.
Find Inactive Patients Seen in Last 12 Months
Need to identify patients who were active in the last year but haven't returned? Use this open dental inactive patients query to generate your recall list.
Find Patients Seen Only Once in Open Dental
Use this open dental one visit patients query to identify patients who have only had a single appointment, helping you target reactivation efforts effectively.
Crown and Bridge Production by Provider
Need to track crown and bridge production? Use this open dental crown production query to quickly see completed work by provider for any date range.
Find Patients With No Primary Provider Assigned
Easily identify active patients missing a primary provider in Open Dental. Use this open dental no provider assigned query to clean up your patient database.
Find Family Members Not Listed as Patients
Use this open dental family not patients query to identify individuals linked to your database who are not currently marked as active patients in your system.
Finding Patients Without Email Addresses
Easily identify active patients missing email addresses in your database with this ready-to-use open dental missing email query for your front desk team.
Provider Schedule Utilization Query
Need to track provider efficiency? Use this open dental schedule utilization query to see how many hours your providers are booked versus available.
Year-over-Year Production Query
Need to compare your practice's performance? Use this open dental year over year production query to see how your monthly production stacks up against last year.
Identifying Membership Plan Patients
Need to track your in-house plan members? Use this open dental membership plan query to quickly generate a list of active patients enrolled in your program.
Track Insurance Payment Speed by Carrier
Use this open dental insurance payment speed query to identify which carriers are slow to pay, helping you manage your practice's cash flow more effectively.
Scheduled Production for Tomorrow
Need to see tomorrow's production? Use this open dental scheduled production query to quickly pull a list of procedures and fees for your daily huddle.
Case Acceptance Rate by Provider
Track your practice's performance with this open dental case acceptance rate query. Easily identify which providers are successfully converting treatment plans.
Open Dental Write-offs by Carrier Query
Need to track insurance adjustments? Use this open dental writeoffs by carrier query to easily identify total write-offs per insurance company in your practice.
New Patient Referral Report Query
Need to track where your new patients come from? Use this simple SQL query to generate an open dental new patient referral report by month in seconds.
Hygiene Recare Overdue List with Phone Numbers
Need to contact patients who are past due for hygiene? Use this open dental recall list with phone query to generate a contact list for your front desk team.
Patient Balance Report Query
Need to identify patients with high balances? Use this open dental patient balance query to generate a list of accounts owing over a specific dollar amount.
Active Patients by Insurance Carrier
Need to see your active patient base by insurance provider? Use this simple open dental patients by insurance query to generate a clean list in seconds.
Open Dental Broken Appointments Query
Need to track missed visits? Use this open dental broken appointments query to generate a list of patients with broken appointments within a specific date range.
Open Dental Production by Procedure Query
Need to track production by procedure code? Use this ready-to-use SQL query to pull detailed production data directly from your Open Dental database.
Open Dental AR Aging Query for Patient Balances
Need to see who owes you money? Use this open dental AR aging query to generate a list of patient balances categorized by how long they have been outstanding.
Open Dental Broken Appointments Query
Need to track patient attendance? Use this open dental broken appointments query to quickly identify patients with broken appointments within a specific date range.
Scheduled Production Query for Tomorrow
Need to know your daily goal? Use this open dental scheduled production query to instantly see the total production value for all appointments scheduled tomorrow.
Patient Balance Report Query
Need to identify patients with high balances? Use this simple open dental patient balance query to pull a list of accounts owing over a specific amount today.
Open Dental Write-offs by Carrier Query
Need to track insurance adjustments? Use this open dental writeoffs by carrier query to easily identify total write-offs per insurance company for your practice.
Open Dental AR Aging Query
Need a custom report for patient balances? Use this open dental AR aging query to identify overdue accounts and manage your practice's cash flow effectively.
Open Dental Production by Procedure Query
Need to track production by procedure code? Use this ready-to-use SQL query to pull detailed production data directly from your Open Dental database.
Active Patients by Insurance Carrier
Need to see which active patients have specific insurance? Use this open dental patients by insurance query to generate a clean list for your practice.
Track Insurance Payment Speed by Carrier
Use this open dental insurance payment speed query to identify which carriers are slow to pay, helping you optimize your practice's revenue cycle management.
Hygiene Recare Overdue List with Phone Numbers
Need to contact overdue hygiene patients? Use this open dental recall list with phone query to quickly generate a list of active patients for your front desk.
Case Acceptance Rate by Provider
Need to track treatment plan success? Use this open dental case acceptance rate query to see which providers are closing the most treatment plans in your office.
New Patient Referral Report Query
Need to track where your new patients are coming from? Use this SQL query to generate an open dental new patient referral report for any date range you choose.
Outstanding Insurance Claims Over 30 Days
Need to track unpaid insurance? Use this open dental outstanding claims query to identify claims sent over 30 days ago that still haven't been paid.
Unscheduled Treatment Plan Value by Provider
Need to track production potential? Use this open dental unscheduled treatment query to see the total value of planned work for each provider in your practice.
Open Dental Overdue Recall Query
Need to find patients who haven't been in for a hygiene visit? Use this open dental overdue recall query to generate a list of active patients in seconds.
Net Production Query for Open Dental
Need to calculate your practice's true revenue? Use this open dental net production query to accurately track production, adjustments, and write-offs by date.
Active Patients with No Upcoming Appointment
Need to fill your schedule? Use this open dental unscheduled patients query to identify active patients who do not have a future appointment on the books.
Open Dental Production Report by Provider
Need an open dental production report by provider? Use this ready-to-use SQL query to quickly see completed production totals for your team in Open Dental.
Collections by Provider Report
Need to track production and payments by provider? Use this open dental collections report query to see exactly what each provider brought in for a date range.
Open Dental Unscheduled Patients Query
Need to find active patients without a future appointment? Use this simple SQL query to generate a list of open dental unscheduled patients for your practice.
Open Dental Overdue Recall Query
Need to find patients who missed their hygiene appointments? Use this open dental overdue recall query to generate a list of active patients for your recall team.
Open Dental AR Aging Query
Need a custom report for open dental ar aging? Use this simple SQL query to pull a list of active patients with outstanding balances in your practice.
Unscheduled Treatment Plan Value by Provider
Use this open dental unscheduled treatment query to identify the total value of treatment plans by provider and prioritize follow-ups for your practice.
Tracking Outstanding Insurance Claims Over 30 Days
Use this open dental outstanding claims query to quickly identify insurance claims that have been pending for more than 30 days and need follow-up.
Collections by Provider Report
Need to track production and collections by provider? Use this open dental collections report query to get accurate data for your practice in seconds.
Open Dental Production Report by Provider
Need an open dental production report by provider? Use this ready-to-use SQL query to quickly pull production totals for any date range in your practice.
Net Production Query with Adjustments and Writeoffs
Need an accurate view of your practice's performance? Use this open dental net production query to calculate gross production, adjustments, and write-offs.
Monthly Production Report Query
Need a custom production report? Use this SQL query for generating monthly production reports in Open Dental to see completed work by provider and date.