move lab-test accreditation info from yaml file to database; admin interface to lab-test accreditation; remove flash message about ukas_accredited_tests.yml after new lab-test, replace with redirect if appropriate

log Bristol ICE server HL7 returns to (test) database

Merge branch 'rfc-rfc' again

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

lims.sql - alter table request_forms add column requested_by after user_id

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