Provide a notification service for AICIS inventory updates

[Mike Dewhirst]

Tickets #72 and #73 deliver targeted change to AICIS listing notes but without a final notification to users there will be no benefit.

This ticket produces an email to a specific address to notify those changes when they happen.

[Mike Dewhirst]

"When they happen" is a no-brainer. However, people change focus or take long service leave or maternity leave. Also, destination mailboxes sometimes become unresponsive. Email messages can be missed.

Therefore - the notification must be aimed at the end-point of the process. That is, the fact that a particular change has been acknowledged by the Chemintro user. From a QA perspective that is straight down the line. "Undercarriage down?" ... "Three greens Captain!"

Listing notes with (and with changed) obligations are created with the 'Not yet acknowledged' flag so that is the end-point to be used. The notified user - or really anyone - removing 'Not yet' is our 'three greens'.

We notify change as follows:

• When it happens
• Quarterly thereafter if the end-point still exists

A later enhancement will be a corporate preference for more or less frequent reminders than quarterly.

[Mike Dewhirst]

This enhancement is now deployed and runs automatically every day. It applies to all notes carrying the words 'Not yet acknowledged' hence our adoption of the abbreviation NYA.

We now have some new fields in Division (and Company) records for users to manage their (NYA) notifications:

• Regulatory affairs email (also in Company)

If omitted, the Company Regulatory affairs email will be used for notifications. If that is omitted as well, the notification service is disabled or switched off.

A user with the Manager role can edit those Company/Division fields. Admin users can assign roles to themselves or other users.

We did consider using an existing user's email address, perhaps in the Author role, but decided we should be more explicit than that.

• NYA reminded

This is a date field (UTC) which is auto-set when any NYA email is sent to the Regulatory affairs email address for this Division.

Whenever this date is set, the service is paused temporarily for the Division.

If new note is created after that date, or the NYA reminder number of days elapses the next day's service will email any outstanding NYA notifications.

• NYA reminder (also in Company)

This the number of days since the previous Regulatory affairs email reminder was sent that the notification service should be re-enabled for that Division.

If omitted, the Company setting will be used. If neither is set, reminders will be 13 weeks (91 days) apart. Settings from zero to 7 mean 7.