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. John
>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: [EMAIL PROTECTED] > > >-- >To UNSUBSCRIBE, email to [EMAIL PROTECTED] >with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
