======Query Directory======

[[AccountsAndPayorsInCollections Accounts and Payors in Collections]]
[[ActivePatientBalancesSortedByPrimaryProvider Active Patient Balances Sorted by Primary Provider]]
[[ActivePatientsWhoHaveTurned18DuringTreatment Active Patients Who Have Turned 18 During Treatment]]
[[ActivePatientsWithNoCurrentInsurance Active Patients with No Current Insurance]]
[[ActivePatientsWithoutDiagnosis Active Patients Without a Diagnosis]]
[[ActivePatientsWithZeroBalanceAndNoRecentActivity Active Patients with Zero Balance and No Recent Activity]]
[[AdjustmentsByTypeByClientForPeriod Adjustments by Type and by Client for a Period]]
[[AgingGroupedByInsuranceCarrier Aging Grouped By Insurance Carrier]]
[[AnnualSessionsRemainingInAuthorization Annual Sessions Remaining in Authorization]]
[[AppointmentCountsByMonth Appointment Counts By Month]]
[[ScheduledAfterCancellation Appointment Times Scheduled After Cancellation]]
[[BilledChargesByPayer Billed Charges By Payer]]
[[BillingAddressesForMailMerge Billing Addresses for Mail Merge]]
[[BirthdaysAndAges Birthdays and Ages]]
[[ChargesBySortCode Charges By Sort Code]]
[[CHIPPatientsList CHIP Patients List]]
[[CompletedPatientsWithAddressForMailMerge Completed Patients With Address For Mail Merge]]
[[CountPatientsServicesByProviderPtCategSrvCodeForPeriod Count of Patients and Services by Provider, Pt Category, Service Code]]
[[CountOfPatientsByInsurancePlan Count Of Patients By InsurancePlan]]
[[CountOfPatientsByProviderWithAndWithoutMedicaid Count of Patients by Provider with and without Medicaid]]
[[CountOfPatientsForAnAgeRange Count Of Patients For An Age Range]]
[[CountOfReferralsByPrimaryProviderAndReferralSourceForIntakeDateRange Count of Referrals by Primary Provider and Referral Source, for Intake Date Range]]
[[CreditsWithoutSortCodesByPrimaryProvider Credits Without Sort Codes By Primary Provider]]
[[DiagnosisQueries Diagnosis Queries]]
[[DetailedListOfChargeBalancesByPayorOnDate Detailed List of Charge Balances by Payor On Specified Date]]
[[DischargedPatientsWithRenderingProvider Discharged Patients With Rendering Provider]]
[[DxCodesInUse Diagnosis Codes In Use]]
[[EMailAddressesActivePatients Email addresses for Active Patients ]]
[[FeesCountByPayorCPTServiceSortCodeMonthYear Fees and Visit Count by Payor, CPT, Service, SortCode, Month, and Year]]
[[FeesByYearAndWeek Fees By Year And Week]]
[[FutureDatedTransactionsAndSplits Future-dated Transaction And Splits]]
[[IdentifyingTreatmentDropouts Identifying Treatment Dropouts]]
[[IntakesForPeriodWithAgeAtIntake Intakes for Period with Age at Intake]]
[[IntakesWithPrimaryDxProviderOffice Intakes for Period with Primary Dx, Primary Provider, and Office Location]]
[[LabelsForPayorsInCollections Labels for Payors In Collections]]
[[ListNextTPReviews List Next Treatment Plan Reviews]]
[[UserSortFields Listing Patients With UserSort Fields]]
[[MailingLabelsByProviderCategoryAge Mailing Labels by Primary Provider, Pt Category, and Age]]
[[NextAppointmentAndAlarm Next Appointment And Alarm]]
[[NonInsuranceBalanceByPOSDateProvider Non-Insurance Balance By Place of Service, Date Range, and Provider ]]
[[OutstandingAccountCleanup Outstanding Account Cleanup]]
[[PatientCountByProviderPtCategSrvCodeForPeriod Patient Count By Provider, Patient Category and Service Code For Period]]
[[PatientExportForRxService Patient Export for Rx Service]]
[[PatientVisitsByProvider Patient Visits By Provider]]
[[PatientsByProviderAndCategory Patients by Provider and Category]]
[[PatientsByRenderingProvider Patients By Rendering Provider]]
[[PatientsSeenInPeriodWithInsurance Patients Seen In Period With Insurance And Provider]]
[[CountOfPatientsByProviderWithAndWithoutMedicaid Count Of Patients By Provider With And Without Medicaid]]
[[PatientsWithAnyOfSeveralDiagnosesSeenThisYear Patients with any of Several Diagnoses Seen This Year]]
[[PatientsWithApptTodayAndSigBalanceByProvider Patients with Appointments Today and a Significant Balance, Sorted by Provider]]
[[PatientsWithIdentifyingDataProviderVisitsForSortCodes Patients with Identifying Data, Provider, and Visit Count for Specified SortCodes]]
[[PatientsWithUnappliedAndBalance Patients with Unapplied Payments and Outstanding Balances]]
[[PatientsWithSchedulerAndTransactionScreenWarnings Patients with Scheduler and Transaction Screen Warnings]]
[[PatientsWithSpecifiedDiagnosisInAnyPositionByProvider Patients with Diagnosis in Any Position by Provider]]
[[PatientsWithSpecifiedDiagnosisIntakeDateAndLastDateOfService Patients With Specified Diagnosis Intake Date And Last Date of Service]]
[[PaymentsByProviderForTwoPeriods Payments By Provider For Two Periods]]
[[PaymentsByServiceAndSortCodeForPeriod Payments by Service and Sort Code for Period]]
[[ProjectedCollectionsForPeriodBySite Projected Collections for Period by Site]]
[[ServiceCountByProviderPtCategSrvCodeForPeriod Service Count By Provider, Patient Category and Service Code For Period]]
[[ServicesForSpecifiedPayorsForPeriod Services For Specified Payors For Period]]
[[SessionDistributionByProvider Session Distribution By Provider]]
[[StaffProductivity Staff Productivity]]
[[TotalAmountInCollections Total Amount In Collections]]
[[TotalCreditsWithoutSortCodesByPrimaryProvider Total Credits Without Sort Codes By Primary Provider]]
[[TreatmentPlanReviewsInNextThirtyDays Treatment Plan Reviews In Next Thirty Days]]
[[WorkingWithUserDefinedFieldDates Working With User-Defined Field Dates]]


== New query pages are best created by cloning our standard query format page, using the link below. When the clone form appears, just replace page name with a valid wiki page name in the appropriate field, put in an appropriate note (such as "contributed by..."), check the box to open the page for edit, and click the CLONE button. [[http://www.sosoft.com/querywiki/wikka.php?wakka=NewQuery/clone Click here to add a NEW QUERY]] or even easier, just email your query to querywiki@sosoft.com and we'll take it from there.==