Whether you are looking for examples to help you learn how to write your own SOS database queries (SOS versions 2010 – 2016) or are looking for something ready-to-run, there is a very good chance that you will find something useful here.
(As a result of “evil-doers” we have had to suspend direct user contributions. You can search and view freely without a registration. Contributions and comments are welcome, however, so email them to query@sosoft.com and we will post them for you.)
See our complete list of queries below or write and execute your own SQL queries, using these resources…
- Here is an article that explains how to use the SOS-provided query tools for SOS Release 2010 through Release 2015.
- And another article specifically for SOS Release 2016.
- If you are looking for something a bit more visual to help you write your own SQL queries, check out Flyspeed SQL Query. There is a free evaluation, but if you find it useful, it is only $29 for a license. You really can’t go wrong! (SOS has no business relationship with Flyspeed. We just think that it is a great tool and a great value.) Here is an article we wrote to help you get started.
If you have a query you would like to contribute, or comments on any of the queries that you find here, please email your query or comments to query@sosoft.com and we’ll take it from there.
Contents of the Query Library, sorted alphabetically by Title…
- Account Aging Balance Detail on Specified Date
- Accounts and Payors in Collections
- Active Patient Balances Sorted by Primary Provider
- Active Patient Count For Date Range
- Active Patients Who Have Turned 18 During Treatment
- Active Patients with Birthdays in a Specified Month
- Active Patients with Last Date of Service and Next Appointment
- Active Patients with No Current Insurance
- Active Patients with No Service in Last 90 Days
- Active Patients with Zero Balance and No Recent Activity
- Active Patients Without a Diagnosis
- Adjustment Analysis by Month and Payor
- Adjustments by Type and by Client for a Period
- Adjustments Made in 2016 for Services Rendered in 2015
- Admissions by Zipcode
- Age, Gender, Primary Provider, and Number of Visits by Patient
- Aged Unapplied Credits
- Aging by Patient and Service Code
- Aging Grouped By Insurance Carrier
- Annual Sessions Remaining in Authorization
- Appointment Count by DataSet, Resource, and Month
- Appointment Count by Patient Category and Appointment Type
- Appointment Counts By Month
- Appointment Times Scheduled After Cancellation
- Average Number of Visits by Year, Month, and Provider
- Average Payment by Service and Payer for Period
- Back-dated Charge Splits and Credit Splits
- Balance Breakdown By Patient On Specified Date
- Billed Charges by Payor
- Billing Addresses For Mail Merge
- Birthdays and Ages
- Changes to an Account Primary Provider
- Charge Summary by Primary Provider for Period
- Charges by Place of Service and Year
- Charges By Sort Code
- Charges by Sort Code
- Checking for Fields that Should Be Included in Encounter Import
- CHIP Patients List
- Collections by Service for Period
- Completed Patients With Address For Mail Merge
- Count of Intakes by Year and Month
- Count of Intakes for Past 365 Days With Specified Dx
- Count of Patients and Services by Provider, Pt Category, Service Code
- Count Of Patients By Insurance Plan
- Count Of Patients By Insurance Plan
- Count of Patients by Provider with and without Medicaid
- Count of Patients by Provider with and without Medicaid
- Count of Patients by Provider with and without Medicaid
- Count Of Patients For An Age Range
- Count Of Patients For An Age Range
- Count of Referrals by Primary Provider and Referral Source, for Intake Date Range
- Count of Unique Patients for Period, Payor, and Service
- Count Service Dates for Patients, Grouped by Rendering Provider
- CPT Code Count for Period and Payor
- Credit Breakdown by Payor for Service Date Range
- Credit Breakdown by Payor Type for Service Date Range
- Credits by Sort Code
- Credits Without Sort Codes By Primary Provider
- Detailed and Summary Views of Cash Receipts for a Period
- Detailed List of Charge Balances by Payor On Specified Date
- Diagnosis Queries
- Discharged Patients With Rendering Provider
- E-Mail Addresses For Active Patients
- Expiring Authorizations by Primary Provider
- Export Appointment Data for Automated Reminder System
- Fees and Payments for Period, Grouped by Patient Category
- Fees and Service Count by Payor, CPT, Service, SortCode, Month, and Year
- Fees By Year and Week
- Fees for Period with Amount Paid by Facility and Provider
- Find Patients with No Recent Activity
- Flyspeed SQL Query: Getting Started
- Flyspeed SQL Query: How to configure your SOSDATA connection
- Future Dated Transactions And Splits
- How-To Request Help through the On-line Help Desk
- ICD-9 Diagosis Codes In Use and ICD-10 Suggestions from CMS GEMs
- Identifying Accounts with Unapplied “Balance Forward” Amounts
- Identifying Treatment Dropouts
- In Collection Balances by Provider, Age Group, and Diagnosis
- Insurance Carriers with Active Patients
- Insurance Services by Carrier for Period
- Intake Count for Period
- Intakes for Period with Age at Intake
- Intakes for Period with Primary Dx, Primary Provider, and Office Location
- Last Payments
- Length of Stay by Provider
- List Cities with Number of Patients Seen
- List Medicare Patients Showing 90 Day Countdown for PQRS Reporting
- List Next Treatment Plan Reviews
- List of Clients Who Turned 18 While in Treatment
- List Old Patients Who Can Be Legally Purged/Deleted
- List Patients Based on True Date of First Service
- List Patients with No Primary Diagnosis by Primary Provider
- List Secondary Insurance Policies by Patient
- Listing Patients With UserSort Fields
- Mailing Labels by Primary Provider, Pt Category, and Age
- Mailing Labels for Active Patients with Zero Balance
- Mailing Labels for Patients with Specific Insurance Payors
- Mailing Labels For Payors In Collections
- Medicaid Patients by Rendering Provider within Specified Date Range
- Next Appointment And Alarm
- Non-Insurance Balance By Place of Service, Date Range, and Provider
- Number of Services for Patients by Service Code and Rendering Provider
- Outstanding Account Cleanup
- Patient Count for Period by SortCode
- Patient Demographic Statistics
- Patient Export For Rx Service
- Patient List by Rendering Provider
- Patient List with Dates of Referral, Intake, and Discharge
- Patient Visits By Provider
- Patients and all ICD-10 Dx Codes in Professional Claim Setup(s)
- Patients by Dataset, Dx, and UserSort2
- Patients by Insurance Carrier and Group Number
- Patients by Last Four Digits of Social Security Number
- Patients by Provider and Category
- Patients By Rendering Provider
- Patients Seen In Period With Insurance And Provider
- Patients with any of Several Diagnoses Seen This Year
- Patients with Appointments Today and a Significant Balance, Sorted by Site and Provider
- Patients with Diagnosis in Any Position, By Provider
- Patients with Identifying Data, Provider, and Visit Count for Specified SortCodes
- Patients with Primary Provider and Primary Dx, Sorted by Provider Code
- Patients with Scheduler and Transaction Screen Warnings
- Patients With Specified Diagnosis, Intake Date, And Last Date of Service
- Patients with Unapplied Payments and Outstanding Balances
- Patients with Zero Balance
- Payment Breakdown Precentages by Provider and by Payer
- Payment Latency for Specified Payor Number
- Payments by Place of Service and Year
- Payments By Provider For Two Periods
- Payments by Service and Sort Code for Period
- Projected Collections for Period by Site
- Queries How-To (SOS 2009 and older)
- Queries How-To (SOS 2010 through 2015)
- Queries How-To (SOS 2016)
- Referral Source Net Revenue
- Referral Source, Patient Count and Charges By Month
- Referring Physicians for Payors with ID’s and Patient Count
- Reversed unapplied credits (refunds) for a period
- Scheduler Reminders
- Screening Today’s Appointments for Outstanding Balances
- Service Count and Units By Patient Category, Provider Type, and Service Code
- Service Count By Provider, Patient Category and Service Code For Period
- Service Count By Provider, Patient Category and Service Code For Period
- Service Count, Total Charges, and Applied Payments by Provider and Patient Category
- Services For Specified Payors For Period
- Session Distribution By Provider
- Simple Export of Basic Patient Information
- SOS Query Library
- Staff Productivity
- Total Amount In Collections
- Total Credits Without Sort Codes By Primary Provider
- Total Credits without Sort Codes, by Primary Provider
- Total of Non-Insurance Payments by Year
- Transactions with Missing Sort Codes for Period
- Treatment Plan Reviews In Next Thirty Days
- Working With User-Defined Field Dates
