SQL Queries
Ready-to-use SQL queries for Open Dental. Copy, paste, run.
#Report / guideUpdated
1How to Run Query for Overdue BWXNeed to find patients overdue for bitewings? Learn how to run query for over due bwx in Open Dental to identify patients who need updated radiographs today.7/28/20262How to Run Query for Overdue X-Rays in Open DentalLearn how to run query for overdue xrays in Open Dental to identify patients who are due for bitewings or full-mouth series and improve your practice hygiene.7/28/20263Finding Over Due Xrays in Open DentalEasily identify patients with over due xrays using this custom SQL query. Keep your hygiene schedule full and ensure patients stay current on diagnostic imaging.7/28/20264How to See PPO Totals Per Month in Open DentalLearn how to see PPO total per month in Open Dental using a custom SQL query. Easily track your PPO production and write-offs with this step-by-step guide.7/9/20265Patient Portion Uncollected QueryUse this open dental uncollected patient portion query to identify active patients with outstanding balances. Easily track and collect what is owed to your office.4/9/20266Open Dental Unearned Income QueryNeed to track patient prepayments? Use this open dental unearned income query to easily identify and manage unearned balances in your practice's accounts.4/9/20267Open Dental Payment Plan Balance QueryNeed 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.4/9/20268Find Patients with Expired InsuranceUse this open dental expired insurance query to quickly identify active patients whose insurance coverage has already terminated, helping you update records.4/9/20269Membership Plan Patient List QueryNeed 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.4/9/202610Open Dental No-Show Rate QueryNeed 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.4/9/202611Find Family Members Not Listed as PatientsUse 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.4/9/202612Credit Balance Patients QueryNeed to find patients with credit balances? Use this open dental credit balance query to quickly identify accounts with negative balances for easy cleanup.4/9/202613Operatory Utilization by Day of WeekNeed 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.4/8/202614Identify Patients Seen Only OnceUse this open dental one visit patients query to identify individuals who have only had a single appointment, helping you improve your practice reactivation.4/8/202615Find Perio Patients Overdue for SRPUse 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.4/8/202616Referral Tracking by Referring DoctorNeed 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.4/8/202617Open Dental Average Production per Visit QueryNeed to track practice efficiency? Use this open dental average production per visit query to calculate your daily production averages for any date range.4/8/202618Insurance Verification Due QueryNeed to verify insurance before appointments? Use this open dental insurance verification due query to pull a list of patients with upcoming appointments.4/8/202619Unfinalized Insurance Payments QueryUse this open dental unfinalized payments query to identify insurance payments that were received but not finalized, ensuring your financial reports are accurate.4/8/202620Fee Schedule Comparison QueryNeed to compare fee schedules across providers? Use this open dental fee schedule comparison query to quickly identify discrepancies in your practice's billing.4/8/202621Finding Incomplete Procedure NotesUse this open dental incomplete notes query to quickly identify clinical procedures that are missing documentation, ensuring your records remain audit-ready.4/8/202622Average Production per New Patient QueryNeed 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.4/8/202623Top 20 Procedures by RevenueNeed to identify your most profitable services? Use this open dental top procedures query to quickly rank your top 20 procedures by total revenue generated.4/7/202624Monthly Production vs Collections QueryNeed 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.4/7/202625Provider Schedule Utilization QueryNeed to track provider productivity? Use this open dental schedule utilization query to analyze appointment patterns and optimize your daily office schedule.4/7/202626Find Patients With No Primary ProviderUse this open dental no provider assigned query to quickly identify active patients missing a primary provider assignment for better practice management.4/7/202627Year-over-Year Production QueryNeed 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.4/7/202628Daily Deposit Report by Payment TypeNeed 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.4/7/202629Crown and Bridge Production QueryNeed to track crown and bridge production? Use this simple SQL query to pull completed crown and bridge procedure totals by provider in Open Dental.4/7/202630Find Patients Without Email AddressesEasily identify active patients missing email addresses in your database with this simple open dental missing email query. Improve your digital communication.4/7/202631Insurance Verification Due QueryNeed to see which patients need insurance verification? Use this open dental insurance verification due query to identify patients with upcoming appointments.4/5/202632Finding Incomplete Procedure NotesEasily track down missing documentation with this open dental incomplete notes query. Identify procedures with blank notes to keep your patient charts compliant.4/5/202633Fee Schedule Comparison QueryNeed to audit your practice's pricing? Use this open dental fee schedule comparison query to easily identify discrepancies between your provider fee schedules.4/5/202634Tracking Uncollected Patient BalancesNeed to identify outstanding money? Use this open dental uncollected patient portion query to quickly list active patients with an unpaid balance on their account.4/5/202635Analyze No-Show Rates by Day of WeekUse 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.4/5/202636Open Dental Expired Insurance QueryEasily identify patients with expired insurance plans using this ready-to-use open dental expired insurance query. Keep your practice revenue cycle on track.4/4/202637Operatory Utilization by Day of WeekNeed to optimize your schedule? Use this open dental operatory utilization query to see which days your operatories are busiest and improve practice efficiency.4/4/202638Open Dental Average Production per Visit QueryNeed to track your practice's efficiency? Use this open dental average production per visit query to calculate your daily production metrics in seconds.4/4/202639Tracking Unfinalized Insurance PaymentsUse this open dental unfinalized payments query to identify insurance claims that have been processed but remain in an incomplete status in your system.4/4/202640Open Dental Unearned Income QueryNeed to track patient prepayments? Use this open dental unearned income query to identify all unearned income balances in your practice quickly and accurately.4/4/202641Average Production per New Patient QueryNeed 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.4/4/202642Tracking Payment Plan BalancesNeed to track outstanding balances? Use this open dental payment plan balance query to quickly identify patients with active payment plans and their totals.4/3/202643Finding Perio Patients Overdue for SRPUse this open dental SRP overdue query to identify active patients who have completed periodontal charting but are overdue for their scaling and root planing.4/3/202644Find Procedures Not Billed to InsuranceUse 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.4/3/202645Sealant Opportunities Ages 6-14Identify patients aged 6-14 who need sealants with this open dental sealant opportunities query. Easily pull a list for your hygiene recall or marketing.4/2/202646Monthly Production vs Collections QueryNeed to track your practice's financial health? Use this open dental production vs collections query to generate a monthly report directly in your software.4/2/202647Daily Deposit Report by Payment TypeNeed 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.4/2/202648Top 20 Procedures by RevenueNeed to identify your most profitable services? Use this open dental top procedures query to instantly rank your top 20 procedures by total revenue generated.4/2/202649Referral Tracking by Referring DoctorNeed 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.4/2/202650Find Inactive Patients Seen in Last 12 MonthsNeed 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.4/2/202651Find Patients Seen Only Once in Open DentalUse this open dental one visit patients query to identify patients who have only had a single appointment, helping you target reactivation efforts effectively.4/2/202652Crown and Bridge Production by ProviderNeed to track crown and bridge production? Use this open dental crown production query to quickly see completed work by provider for any date range.4/2/202653Find Patients With No Primary Provider AssignedEasily identify active patients missing a primary provider in Open Dental. Use this open dental no provider assigned query to clean up your patient database.4/2/202654Find Family Members Not Listed as PatientsUse 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.4/1/202655Finding Patients Without Email AddressesEasily identify active patients missing email addresses in your database with this ready-to-use open dental missing email query for your front desk team.4/1/202656Provider Schedule Utilization QueryNeed to track provider efficiency? Use this open dental schedule utilization query to see how many hours your providers are booked versus available.4/1/202657Year-over-Year Production QueryNeed 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.4/1/202658Identifying Membership Plan PatientsNeed 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.4/1/202659Track Insurance Payment Speed by CarrierUse 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.3/31/202660Scheduled Production for TomorrowNeed 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.3/31/202661Case Acceptance Rate by ProviderTrack your practice's performance with this open dental case acceptance rate query. Easily identify which providers are successfully converting treatment plans.3/31/202662Open Dental Write-offs by Carrier QueryNeed to track insurance adjustments? Use this open dental writeoffs by carrier query to easily identify total write-offs per insurance company in your practice.3/31/202663New Patient Referral Report QueryNeed 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.3/31/202664Hygiene Recare Overdue List with Phone NumbersNeed 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.3/30/202665Patient Balance Report QueryNeed 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.3/30/202666Active Patients by Insurance CarrierNeed 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.3/30/202667Open Dental Broken Appointments QueryNeed 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.3/30/202668Open Dental Production by Procedure QueryNeed to track production by procedure code? Use this ready-to-use SQL query to pull detailed production data directly from your Open Dental database.3/30/202669Open Dental AR Aging Query for Patient BalancesNeed 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.3/30/202670Open Dental Broken Appointments QueryNeed to track patient attendance? Use this open dental broken appointments query to quickly identify patients with broken appointments within a specific date range.3/29/202671Scheduled Production Query for TomorrowNeed to know your daily goal? Use this open dental scheduled production query to instantly see the total production value for all appointments scheduled tomorrow.3/29/202672Patient Balance Report QueryNeed 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.3/29/202673Open Dental Write-offs by Carrier QueryNeed to track insurance adjustments? Use this open dental writeoffs by carrier query to easily identify total write-offs per insurance company for your practice.3/29/202674Open Dental AR Aging QueryNeed 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.3/29/202675Open Dental Production by Procedure QueryNeed to track production by procedure code? Use this ready-to-use SQL query to pull detailed production data directly from your Open Dental database.3/28/202676Active Patients by Insurance CarrierNeed to see which active patients have specific insurance? Use this open dental patients by insurance query to generate a clean list for your practice.3/28/202677Track Insurance Payment Speed by CarrierUse this open dental insurance payment speed query to identify which carriers are slow to pay, helping you optimize your practice's revenue cycle management.3/28/202678Hygiene Recare Overdue List with Phone NumbersNeed 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.3/28/202679Case Acceptance Rate by ProviderNeed 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.3/28/202680New Patient Referral Report QueryNeed 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.3/28/202681Outstanding Insurance Claims Over 30 DaysNeed 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.3/28/202682Unscheduled Treatment Plan Value by ProviderNeed 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.3/28/202683Open Dental Overdue Recall QueryNeed 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.3/28/202684Net Production Query for Open DentalNeed to calculate your practice's true revenue? Use this open dental net production query to accurately track production, adjustments, and write-offs by date.3/28/202685Active Patients with No Upcoming AppointmentNeed 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.3/28/202686Open Dental Production Report by ProviderNeed 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.3/28/202687Collections by Provider ReportNeed 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.3/27/202688Open Dental Unscheduled Patients QueryNeed 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.3/27/202689Open Dental Overdue Recall QueryNeed 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.3/27/202690Open Dental AR Aging QueryNeed 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.3/27/202691Unscheduled Treatment Plan Value by ProviderUse this open dental unscheduled treatment query to identify the total value of treatment plans by provider and prioritize follow-ups for your practice.3/27/202692Tracking Outstanding Insurance Claims Over 30 DaysUse this open dental outstanding claims query to quickly identify insurance claims that have been pending for more than 30 days and need follow-up.3/27/202693Collections by Provider ReportNeed to track production and collections by provider? Use this open dental collections report query to get accurate data for your practice in seconds.3/27/202694Open Dental Production Report by ProviderNeed 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.3/27/202695Net Production Query with Adjustments and WriteoffsNeed an accurate view of your practice's performance? Use this open dental net production query to calculate gross production, adjustments, and write-offs.3/27/202696Monthly Production Report QueryNeed a custom production report? Use this SQL query for generating monthly production reports in Open Dental to see completed work by provider and date.3/27/2026