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)

added nhs_net requirement to email validation; report notification help documentation

report notification admin functions

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 genomics_2016_1222.xsd to original, added new xsd; replave UCLH reporting SOP; updated some tests with year change or change of html tag

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

replaced foswiki with static pdfs for reporting sop; updated contacts for 2 cron scripts

adapted cml_rq_pcr_monitoring.pl to optionally load PDS data from storage - for use when script fails, to save having to repeat PDS queries; new Genomics cancer dataset tests

added exempted nhs_numbers to cml_rq_pcr_monitoring.pl; added patient_demographic_history entry

switched to Local::DB for live to use insert_or_update method; moved update_patient_demographics to own sub due to increased complexity - need insert_or_update method; bugfix for initial cml patients query - needs additional 'undef' on pd.status or has same effect as inner join instead of left join

added PDS query for live/dead status to cml_rq_pcr_monitoring.pl - TODO: update patient_demographics table

new script cml_rq_pcr_notifications; first part of new outreach_cml_prescription function; bugfix for occasional app error; updated contact details for genomics notifications; amended wording on new user registration msg

activated apparent_sender = no-reply@hmds.info to avoid rejection of messages from non-existent domain; adapted yearly register_and_error_log.pl to use same tt as monthly version; a failed cytogenetics result is now more verbose so cytogenetics_failed query needs to look for 'failed' as an rlike

added diagnosis context warnings as static view for non-admin users - moved common code to C::Roles::Misc; appended new International Scale result to imatinib tt; adapted Imatinib chart to handle change to International Standard of reporting scheduled for mid-2017; HTS myeloid sequencing set to chargeable outside Y&H region; added Genomcis consent date to Consent update section & added new menu option; email address change for PNH service