New Features In SQL Clinic 4.0.0 ADMINISTRATIVE FEATURES (AGENCY MENU): * Broadcast E-mail now uses internal messaging system instead of external email addresses. * Agency Calendar announces upcoming events - also pops up on login. * Staff Directory now contains exhaustive contact info (see entry in TOOLS). * Agency Policy Manual and Forms Database - search function added to main menu. * Agency Policy Manual and Forms Database - save as function added. * Unit Log alert scanner improved - keyword exception function added. ASSESSMENTS * Comprehensive Assessment: a Person Centered Planning section was added. * Functional Assessment: streamlined - individual entries rather than menu selection reduces clutters and shorter print outs. DBA Utilities * An expanded DBA utilities menu includes all access to internal log entries, user accounts, and a SQL Clinic programmers reference guide. * Scheduled Tasks directory contains perl scripts to be run by cron - this allows automated reports to run at user selected intervals. * A Backup Directory was created and populated with sample scripts to automate backups and email backup notification - this directory can be protected by apache htacess restrictions. GENERAL * A Print Button was added to all scripts - this makes for smoother/cleaner printing, less steps to get to a printable document. * Remove/Update options were added to scripts - access restricted to privileged users. * Scrolling lists replaced drop down menus, making for easier record searches. * Search boxes allow narrowing of searches - less clutter. HELP * Help files were expanded and integrated into the database backend (previously help files were static html) - files can now be edited by privileged users. * Help Search function added to all scripts - a link (light blue, lower left) with context sensitive search terms is embedded in each screen. HUD/DHS MODULE * HUD/DHS module completed and used for data uploads in NYC ("see Homeless Services"). This module will be useful for any agency that interacts with HUD. * All embedded HUD HMIS data elements can be edited by modifying the HUD.pm module in the /clinic-4.0.0/homeless/ directory. REPORTS * Perl format reporting was replaced with a printer friendly design - less steps, better output. * New Reports: - Active Client Data (all active clients/admits/discharges) sorted by age. - Clients Served Annual Report (bed days with cumulative inpt information). - Clozaril Report. - Diagnosis Report (by unit). - Medical Information Report. - Quick Census - one click for all units (popups must be enabled). SECURITY * New privileges system assigns permissions on a task specific basis. * Personnel and Billing sections require permissions for data access. * Update/Remove functions added to all scripts - privileges required. * "Client Access" feature: individual clients can have DENY ALL (ALLOW $x) restrictions TOOLS * Personal productivity tools are now fully integrated - each tool has a toolbar (top of screen) linking it to other tools. * Address Book has been rewritten to allow for gmail contact uploads. * Links in left hand menu are now user defined (via standard interface). * My Messages (internal messaging system) has replaced external email (for HIPAA compliance and to eliminate the Mail::Sender dependency). * Personal Reminders, Unit Logs and Work Order have all been reworked. * A Staff Directory now contains exhaustive contact info including: - who's logged in / daily login records - links to internal and external staff email addresses - unit, unit supervisor and unit mentor contact information - phone, fax and intercom as well as email. * Unit Log enters progress notes on demand, teeing output. * Vacation Request function added. HELP * The /clinic-4.0.0/doc/ directory has detailed installation-related help files. * Every script (*.cgi -- AND *.pl in the scheduled-tasks directory) has an embedded pod section designed to help developers. To access pod from the command line simply run $ file_name.cgi --help * To access the POD information from a web browser run /clinic-4.0.0/dba/developer_help.cgi NUMEROUS BUG FIXES have been effected as Version 4 moved from alpha to beta and now to release candidate level code. Discontinued ------------ * bin directory removed (java_date function no longer used) * Oracle support discontinued (SQL Clinic supports only Free Software databases).