fix test script failures - column_types & missing default date on db col

final tidy-up prior to deployment

increased max length of error code to 4 chars; updated genomics_cancer_v3 with v3.2 changes (incomplete); amended date & datetime placeholders on results entry page to match expected data format; updated Makefile.PL & module_build.pl

genomics v3.2 updates (HaemOnc); added department to email_contacts table unique key

new simple SQL search field family ID - genomics db only

adapted Fluidx vials simple SQL search to use combined request_storage & request_lab_test_results tables, using new view request_storage_view - for Genomics only

updated report_notification table definition; updated tests to cope with clinical_details now required field (unless confif override); inserted error_clinical_details in tt

added ability for user to update report status (new/all) for report notifications; request_details (clinical details field) is an optional or required field delegated to config; mail_rports.pl now replaced by email_reports for UCLH & Leeds; preserve line-breaks for patient notes display

bug fixes for report_available_notification.pl - col names used in data retrieval query need to match request_notification table (ie use aliases); adapted script to use Getopt::Std & changed to same units as ; changed request_notification table to MyISAM (doesn't need FK constraint)

cgiapp_prerun() skips redirect for report notification request; new report_notification search function; function for user to register for report notifications; moved DBIxSimple::dump_query to Local::Utils for sharing with Local::DB; get_practitioner_by_code() now shared with report_notification so loads speculatively; replaced report_available_notification.pl queries with new Local::DB::insert_or_update_if_greater

first draft of report notification function - need to determine how to match requests with notification recipients

adapted email_contacts table to accept department code and report status values (setup/schema/email_reports.sql); redesigned mail_reports.pl -> email_reports.pl to allow multiple departments per hospital/organisation (not supported by mail_reports), and department and report status info now derived from email_contacts tbl, not hard-coded into script; reverted referrer_department => {updated some tests with year change or change of html tag

reports display author & timestamp of result summary and amended comment; new result_summary.user_id field; new disgnostic terms for ngs_myeloid list; removed non-consented patients from genomics SLF worklist; extraction worksheet edits

amended genomics_xml.pl script to overwrite unit number if it doesn't match expected participant_id; bugfixes and updates to test scripts

new storage location for storage racks; removed 'definitive report available online' statement from outreach reports; amended outreach_patients view for PatientAccess patient index