SQL: Insurance Aging by Insurance Company
About This SQL provides you with aging of all balances, grouped by payer and aging bucket (e.g. 0-30, 31-60, etc). Insurance balances and patient balances are shown separately. Caveats Aging dates from the date of service for insurance balances...
SQL: Primary Contact Information
This report displays all Primary Family Contacts (or Family Contacts with a sort of 1) and their information as entered into OP.
SQL: Childhood Immunization (Combo 10)
About This report looks for active patients who are (on the run date of the report) between the ages of 1.8 years (that is 21.6 months) and not yet 2 years and looks to see whether they pass or fail. A sample image of this SQL report run in the D...