What's New In SQL Clinic 4.1.1: Broken GRANT scripts in /install-unix patched. This affects ONLY postgreSQL installations, mySQL is unaffected. - pg_grant.sql - pg_grant_seq.sql To patch a production version of 4.1.0: cd into the install-unix directory and run: psql clinic < pg_grant_seq.sql where clinic = the name of your backend database If you upgraded from 4.0.0 using the upgrade scripts you should have no problem although running the above grant script will not harm anything if you want to do so. What's New In SQL Clinic 4.1.0: * Client Legal History module added to Client Registry. Data accessed by several scripts. print_legal_history() added to: Comprehensive Assessment, Special Care Assessment, DSM IV Diagnosis, Face Sheet, and Face Sheet Editor. * Database Lock Feature added (db_lock table) enabling DBAs to lock database while performing backups and other routine maintenance (vacuum, etc.) * Double Electronic Signature (ESOF) implemented in numerous clinical records enabling author and supervisor to co-sign. * Medicaid Billing Log added for tracking efforts to resolve denials, including contact with Medicaid, staff interventions (escorting clients to MC office, etc.) and related issues. * Six fields added to Progress Notes (describing client's presentation): mood_affect, thought_process, motor_activity, behavior, medical_condition, substance_use, and presentation. * Referral tracking expanded: new table ("referral_source") records authoriative source of referral data, including email, phone, and fax contact info and agency website. * Referral Outreach Log added to track efforts at soliciting referrals. * Rent Change tracking module added to aid in rent collection efforts. * Timestamp value added to a number of clinical records - both automated and user defined stamps (to track time record was entered AND time of client contact, etc.) * Update tracking added to clinical records (user ID and date of modification). Minor changes: * tracker table renamed mpi (MPI or Master Patient Index). * Red subject line added to My Messages for auto-generated alert (emergency) email. * Reporting unit name now stored in Progress Note table, in case unit_id is reused after a unit is decertified or undergoes a name change. * End Time (field 'end_time VARCHAR(8)') added to unit_firedrill table. * Three unused tables (tx_assess_archive, tx_goals_archive and tx_plan_archive) dropped, removed from calling routines (primarily in the Client Registry). * User login and password fields expanded to 16 characters. Numerous Bug Fixes: (see details)... --------------------------------------------------------------------------------------------------- Details: [ agency ] agency_log.cgi: #### 2011-07-25 unterminated print() in print_all() fixed incident_report.cgi: #### 2011-07-01 timestamp added -- time_select set via call to SQLClinic::time_stamp() [ assessment ] client_admit_plan.cgi: #### 2011-06-16 timestamp added -- time_select param and call to SQLClinic::time_stamp() client_admit_plan.cgi: #### 2011-06-30 client_id added to time_stamp() call to compensate for non-unique rec_ids client_assess_alert.cgi: #### 2011-06-16 timestamp added client_assess_alert.cgi: #### 2011-09-15 double esof (esof and esof_super) implemented client_assess_develop.cgi: #### 2011-06-16 timestamp added client_assess_develop.cgi: #### 2011-09-15 double esof (esof and esof_super) implemented client_assess_medical.cgi: #### 2011-06-16 timestamp added client_assess_medical.cgi: #### 2011-09-15 double esof (esof and esof_super) implemented client_assess_mental.cgi: #### 2011-04-06 Fixed missing Chart ID in view/print client_assess_mental.cgi: #### 2011-06-16 timestamp added client_assess_mental.cgi: #### 2011-09-15 double esof (esof and esof_super) implemented client_assess_note.cgi: #### 2011-04-06 Fixed missing Chart ID in view/print client_assess_note.cgi: #### 2011-06-16 timestamp added client_assess_note.cgi: #### 2011-09-15 double esof (esof and esof_super) implemented client_assess_person.cgi: #### 2011-04-06 Missing Chart ID in view/print is due to missing placement record client_assess_person.cgi: #### 2011-06-16 timestamp added client_assess_person.cgi: #### 2011-09-15 double esof (esof and esof_super) implemented client_assess_social.cgi: #### 2011-04-06 Missing Chart ID in view/print is due to missing placement record client_assess_social.cgi: #### 2011-06-16 timestamp added client_assess_social.cgi: #### 2011-09-15 double esof (esof and esof_super) implemented client_family_nuclear.cgi: #### 2011-06-16 timestamp added client_family_origin.cgi: #### 2011-06-16 timestamp added client_functional.cgi: #### 2011-06-16 timestamp added client_pain_assessment.cgi: #### 2011-06-16 timestamp added client_special_care.cgi: #### 2011-04-14 Added print_legal_history subroutine client_special_care.cgi: #### 2011-06-16 timestamp added client_special_care.cgi: #### 2011-07-01 unit update failing -- bug fixed comprehensive_assessment.cgi: #### 2011-04-14 Added print_legal_history subroutine comprehensive_assessment.cgi: #### 2011-09-16 Revision of print_record() (new features, layout), print_menu() added comprehensive_assessment_sign.cgi: #### 2011-04-06 Fixed missing Chart ID in view/print comprehensive_assessment_sign.cgi: #### 2011-06-16 timestamp added comprehensive_tenant.cgi: #### 2011-06-16 timestamp added [ billing ] legacy_medicaid_charge_editor.cgi: #### 2011-04-06 Cast added to 2 queries: WHERE CAST (billing_period_code AS INTEGER) < 999 legacy_medicaid_charge_editor.cgi: #### 2011-04-06 $credit set to 0 (zero) if null to stop numeric fatal medicaid_charge_generator.cgi: #### 2011-05-17 POD data added medicaid_charge_generator.cgi: #### 2011-09-02 Arbitrary Date Adjustment for Medicaid (Increment Charge Month) Added medicaid_charge_generator.cgi: #### 2011-09-02 sprintf() used to pad $billing_id to six integers medicaid_log.cgi: #### 2011-09-12 New Script [ charting ] client_medication.cgi: #### 2011-06-23 timestamp added client_medication_mica.cgi: #### 2011-06-23 timestamp added client_physical.cgi: #### 2011-06-23 timestamp added client_treaters.cgi: #### 2011-04-04: do_query_comment() added to send out nag mail client_treaters.cgi: #### 2011-06-23 timestamp added diagnosis_dsm4.cgi: #### 2011-04-06 up_date, up_date_by fields added for QI diagnosis_dsm4.cgi: #### 2011-06-30 timestamp added -- time_select param and call to SQLClinic::time_stamp() diagnosis_dsm4.cgi: #### 2011-06-30 client_id added to time_stamp() call to compensate for non-unique rec_ids diagnosis_manual.cgi: #### 2011-04-06 up_date, up_date_by fields added for QI diagnosis_manual.cgi: #### 2011-06-30 timestamp added -- time_select param and call to SQLClinic::time_stamp() diagnosis_manual.cgi: #### 2011-06-30 client_id added to time_stamp() call to compensate for non-unique rec_ids discharge_plan.cgi: #### 2011-06-30 timestamp added -- time_select param and call to SQLClinic::time_stamp() discharge_plan.cgi: #### 2011-06-30 client_id added to time_stamp() call to compensate for non-unique rec_ids discharge_summary.cgi: #### 2011-06-30 timestamp added -- time_select param and call to SQLClinic::time_stamp() discharge_summary.cgi: #### 2011-06-30 client_id added to time_stamp() call to compensate for non-unique rec_ids group_note.cgi: #### 2011-04-06 Fixed broken Search For Group Notes By Date Range group_note.cgi: #### 2011-06-30 timestamp added inpatient.cgi: #### 2011-04-06 Fixed Hospitalization History comments section (moved eob @data to @er) inpatient.cgi: #### 2011-06-30 timestamp added -- time_select param and call to SQLClinic::time_stamp() inpatient.cgi: #### 2011-06-30 client_id added to time_stamp() call to compensate for non-unique rec_ids inpatient_eob.cgi: #### 2011-06-30 timestamp added -- time_select param and call to SQLClinic::time_stamp() inpatient_eob.cgi: #### 2011-06-30 client_id added to time_stamp() call to compensate for non-unique rec_ids medical_status.cgi: #### 2011-06-30 timestamp added -- time_select param and call to SQLClinic::time_stamp() progress_note.cgi: #### 2011-03-10 unit_name now saved as a string in case entry in unit_sites changes. progress_note.cgi: #### 2011-06-30 timestamp added -- time_select param and call to SQLClinic::time_stamp() progress_note_archive.cgi: #### 2011-06-30 timestamp fields added to INSERT INTO .. SELECT query release_of_information.cgi: #### 2011-07-05 timestamp added tenant_plan.cgi: #### 2011-06-30 timestamp added -- time_select param and call to SQLClinic::time_stamp() treatment_goal.cgi: #### 2011-06-30 timestamp added -- time_select param and call to SQLClinic::time_stamp() treatment_plan.cgi: #### 2011-06-30 timestamp added -- time_select param and call to SQLClinic::time_stamp() [ dba ] user_account.cgi: #### 2011-07-08 login and password fields expanded to 16 characters [ finance ] client_account.cgi: #### 2011-07-05 timestamp added client_authorization.cgi: #### 2011-07-05 timestamp added -- time_select set via call to SQLClinic::time_stamp() [ homeless ] hud_hmis_csv_format.cgi: #### 2011-04-15 bug fix - tx_assessment.start_date produced errors, using client_placement.start_date program_outcome.cgi: #### 2011-03-28 CAST() function added to post_menu() query. service_event.cgi: #### 2011-07-01 timestamp added -- time_select set via call to SQLClinic::time_stamp() [ oasas ] admission_note.cgi: #### 2011-07-05 timestamp added discharge_plan.cgi: #### 2011-07-05 timestamp added progress_note.cgi: #### 2011-03-10 unit_id now saved (in addition to unit_name - for compatibility purposes) progress_note.cgi: #### 2011-07-05 timestamp added psycho_social.cgi: #### 2011-07-05 timestamp added service_plan.cgi: #### 2011-07-05 timestamp added service_plan_initial.cgi: #### 2011-07-05 timestamp added service_plan_review.cgi: #### 2011-07-05 timestamp added [ personnel ] personnel.cgi: #### 2011-07-01 timestamp added -- time_select param and call to SQLClinic::time_stamp() personnel.cgi: #### 2011-07-07 job_title textfield replaced with scrolling_list and an array of values personnel.cgi: #### 2011-07-08 login and password fields expanded to 16 characters personnel_merge.cgi: #### 2011-04-28 tx_assess_archive, tx_goals_archive, tx_plan_archive calls removed [ property ] disaster_drill.cgi: #### 2011-07-05 timestamp added -- time_select set via call to SQLClinic::time_stamp() fire_drill.cgi: #### 2011-03-28 end_time added fire_drill_short.cgi: #### 2011-03-28 end_time added room_inspection.cgi: #### 2011-07-05 timestamp added -- time_select set via call to SQLClinic::time_stamp() safety_checklist.cgi: #### 2011-07-05 timestamp added -- time_select set via call to SQLClinic::time_stamp() [ registry ] client_demographics.cgi: #### 2011-06-21 timestamp added client_emergency_contact.cgi: #### 2011-04-04 do_query_comment() added to send out nag mail client_emergency_contact.cgi: #### 2011-06-21 timestamp added client_employment.cgi: #### 2011-06-21 timestamp added client_entitlements.cgi: #### 2011-06-21 timestamp added client_entitlements.cgi: #### 2011-09-21 duplicate records error trapping added to post_form() and print_record() client_facesheet.cgi: #### 2011-04-14 Added print_legal_history subroutine client_facesheet_editor.cgi: #### 2011-04-14 Added print_legal_history subroutine client_legal_history.cgi: #### 2011-04-04 New script based loosely on the NYSCRI model client_legal_history.cgi: #### 2011-04-14 Added print_legal_history subroutine client_legal_history.cgi: #### 2011-06-21 timestamp added client_merge.cgi: #### 2011-04-28 tx_assess_archive, tx_goals_archive, tx_plan_archive calls removed client_placement_editor.cgi: #### 2011-06-02 post_search() sub removed, get_client() modified to return an array client_referral.cgi: #### 2011-06-21 timestamp added client_referral.cgi: #### 2011-09-08 font12 class used in post_form() sub client_referral.cgi: #### 2011-09-08 source of referral (agency) now points to referral_source table client_referral_note.cgi: #### 2011-06-21 timestamp added client_registry.cgi: #### 2011-04-28 tx_assess_archive, tx_goals_archive, tx_plan_archive calls removed client_registry.cgi: #### 2011-06-21 timestamp added client_search.cgi: #### 2011-04-28 bug fix: tracker -> mpi (missed this one on 5 April) master_person_index.cgi: #### 2011-04-28 tx_assess_archive, tx_goals_archive, tx_plan_archive calls removed master_person_index.cgi: #### 2011-07-01 dob quality code updated to HUD 3.1 spec omh_directory.cgi: #### 2011-07-20 New script referral_outreach_log.cgi: #### 2011-07-06 New Script referral_source.cgi: #### 2011-07-15 Search By Agency Name added to post_menu() referral_source.cgi: #### 2011-09-13 permissions loosened for viewer (from secure_adm to secure_clinic) referral_source_search.cgi: #### 2011-09-13 switched from referral table to referral_source, added url and email links [ rent ] client_rent.cgi: #### 2011-07-01 timestamp added -- entered via INSERT query client_rent_active.cgi: #### 2011-07-01 timestamp added -- entered via INSERT query client_rent_change.cgi: #### 2011-03-30 This is new code, new table created for Version 4.1.0 client_rent_rapid.cgi: #### 2011-07-01 timestamp added -- entered via INSERT query [ reports ] bed_days.cgi: #### 2011-04-26 $start and $end DATE variables intialized to dates rather than '0' bed_days.cgi: #### 2011-09-09 $sth2->finish() moved to correct location in loop, quieting error log census_hmis.cgi: #### 2011-09-21 New Code enrollment.cgi: #### 2011-09-28 Broken table aliasing in main query fixed managed_care.cgi: #### 2011-08-18 New Script based on census.cgi medicaid_recipient.cgi: #### 2011-07-07 Minor error patched (column headers a and b swapped) medicaid_recipient.cgi: #### 2011-07-07 track_id clause added to predicate for client_diagnosis queries referral_homeless.cgi: #### 2011-04-06 Fixed view/update scroll errors (bad params for client_referral.cgi, now uses "select") referral_source.cgi: #### 2011-06-03 broken predicate clause on main query fixed (stray table alias removed) referral_source_search.cgi: #### 2011-08-08 New Script based on /referral/referral_source.cgi data entry routine. special_care.cgi: #### 2011-03-16 report now shows ALL assessments, incl. those done prior to admission. [ respite ] respite_event.cgi: #### 2011-04-06 Fixed (added) missing hidden fields in call to View All respite_event_log.cgi: #### 2011-07-01 timestamp added -- time_select param and call to SQLClinic::time_stamp() [ setup ] certified_beds.cgi: #### 2011-08-05 missing date_check(\$inventory_type_date) in do_query_add() fixed. [ tools ] find_ip.cgi: #### 2011-03-16 this is a new tool, it prints the remote user's IP, no login required. my_messages.cgi: #### 2011-07-07 -class=>"font12" added to inbox/saved/sent anchors my_messages_no_auto.cgi: #### 2011-07-07 -class=>"font12" added to inbox/saved/sent anchors [ transport ] medicaid_transport_charge.cgi: #### 2011-04-06 Fixed broken links in @links array