Clip-and-Save SQL Articles

Articles

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...
SQL: Billing VFC Vaccines for Patient with Commercial Primary and Medicaid Secondary
Overview This report shows all insurance-open claims (defined as those having an insurance balance) which are currently in a queued status that contain a vaccine product code, its charge, and whether this seems legitimate depending on the VFC...