In looking at their "test drive", it occurs to me that they may, in 
addition to everything listed below, be HIPAA compliant.  That would be 
very good.

>SQL Clinic Version 1.0.0 is now available at
>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
>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: [EMAIL PROTECTED]
>with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to