Thomas Good is announcing the availability of SQL Clinic Version 1.0.0 which is now available at:
http://www.sqlclinic.net ‘…The SQL Clinic application suite provides storage and retrieval of clinical data via an easy to use web interface. Designed primarily for providers of psychiatric housing, it is nonetheless ready for use in all settings, including Community Mental Health Centers (CMHCs) and private practice. It is an Open Source product, licensed under the GNU General Public License and may be freely redistributed. Full press release and feature list follows. Update 2/6/02: They now have support contract link on the main page.

SQL Clinic Version 1.0.0 is now available at

http://www.sqlclinic.net

The SQL Clinic application suite provides storage and retrieval of clinical data via an easy to use web interface. Designed primarily for providers of psychiatric housing, it is nonetheless ready for use in all settings, including Community Mental Health Centers (CMHCs) and private practice. It is an Open Source product, licensed under the GNU General Public License and may be freely redistributed. It runs on Linux, the rugged and cost effective networking operating system. It requires the Apache web server, the PostgreSQL database, the Sendmail mail server and Perl 5 – all Open Source products that are available in most modern distributions of Linux (and other Unix implementations as well.)

This is the first non-beta release of the application, which has been used in a production environment at Saint Vincent Catholic Medical Centers for the past 3 years. There are many improvements over earlier releases.

Previous public releases (beta) are also available at www.sqlclinic.net. All releases are supported by mailing lists open to the public. Technical support via email is free and commercial support packages are available at very reasonable prices for sites needing assistance with installation, setup and customizations. Users with an interest in programming are invited to join the development team.

The following features make SQL Clinic a valuable tool:

* Built-in Security and Data Access Clearance Levels
* Easy to use Web Based Database Administration Utilities
* Free Technical Support via Public Mailing Lists
* Full Set of Linux Shell Scripts for Experienced DBAs
* JCAHO Compliance
* Thorough Documentation in the form of a Web Based User Guide

* Complete Set of Clinical and Administrative Applications:

– Master Patient Index – allowing parallel data streams based on
unit names/treatment tracks…separate records in various units
and treatment modalities are all linked by a single patient ID.

– Referral Tracking with auto-email notification of census changes.
Comprehensive intake and placement subsystem keeps administrators
informed of any census changes.

– Medicaid Billable Progress Noting – with alert keyword scanning
Each note is scanned for user defined keywords. Matches trigger
*immediate* email notification via user defined mailing lists.
Audit trails track any modification of progress notes, allowing
repair of errors *and* accountability.

– Treatment Planning – with 220 user tunable, Medicaid reimbursible
skill areas – grouped into eleven Medicaid Restorative Services
categories.

– Caseload assignment tracking. Supervisors may view and modify
staff caseloads. Caseload assignments are used to define which
staff receive auto-email notifications when patient physical
examinations are due.

– Medication histories. Utilities for viewing current medications only – or full medication histories.

– Patient demographics. Very comprehensive details about your patients. Family, extended family, other treaters, contacts…Tracking of medical history, developmental history, nutritional needs, spiritual needs. Every facet of the patient that may be relevant to treatment is tracked.

– Full entitlements tracking including Foodstamps, Medicaid, Public Assistance and Social Security benefits.

– Special care monitor for high risk patients. Tracking of substance abuse, gambling abuse, self destructive behavior, legal issues, etc.

– Comprehensive patient assessments with psychosocial summaries, full mental status exams and exhaustive functional assessments. The functional assessment is directly related to the treatment plan. Patients are rated for skill levels in 220 different areas and recorded deficits may be used for treatment plan generation.

– Embedded DSM IV validation table for consistency in clinical records. Patient diagnoses may be entered manually or pulled directly from the embedded DSM IV. Additionally, A DSM IV reference tool is included.

– Numerous Quality Assurance instruments: tx goal attainment tracking, electronic customer satisfaction survey, formal supervision logs, incident tracking, auto-email reminders (patient physicals due, lease expiration, etc.), staff credential tracking, staff training and development logs, chart review tools for administrators, etc.

– Patient Safety utilities for tracking room inspections, fire drills, safety checklists and disaster drills.

– Online policy and procedure manual. A centralized database of all of your policies is easily created and maintained. Accessible from any workstation. Very handy during audits by regulatory bodies.

– Online forms for consistency in administrative records. Easy user generation of new forms via web based utility.

– Human Resource module with online tracking of employee performance evaluation due dates (with auto-email notification.)

– Auto-emailed daily reports: occupancy and patient movement reports, homelessness reports, discharge tracking.

– Staff communication utilities: unit (shift) log with keyword scanning, team notes for clinical rounds/team meeting, community meeting logs, therapeutic group notes, etc.

– Online Work Order subsystem with auto-email notification of order entry and job completion.

– Purchase Order subsystem with an optional SQL Ledger general accounting application. (SL as a module that simply plugs into the /ledger directory of the SQL Clinic source tree.)

– Full Respite Care module. Programs that deal with the frequent role reversals of participants (identified SPMI patient, respite “customer” and respite “companion”.)

– Archival utilities for progress notes and treatment plans. Build a read only data warehouse for your records.

– Personal reminder system and address book. Enter a personal reminder and receive daily email notices for 7 days prior to the event. Record all of your contacts in personal addressbook accessible to only its owner. (Included in the /reminder directory is a shell script that uses the linux pilot-link program to load addressbook data into a palm pilot. The src for pilot-link can be found in each SQL Clinic download, in the /pub directory.)

– Many more!

Feedback is most welcome and we hope you enjoy your SQL Clinic experience!

Thomas Good and Ingo Assenmacher, Project Leaders.
For additional information: info@sqlclinic.net