To maintain the accuracy of the database, we need to automatically have the system regularly verify the data. We will accomplish this with a weekly task that emails all program runners who's program has not been updated in 2 months or more, and asks them if the data is still up to date.
These emails though contain two magic links which say "This is up to date" and "I want to edit this". When you click them it takes updates the database and the last edited time.
If the program runner doesn't respond in a week, then the alert should be escalated to a database manager in the city.
If the city manager doesn't within a week then the program should be de-listed, and the alert should be escalated to a country manager.
if the country manager doesn't respond within two weeks, then an alert should be sent to a system administrator.
To maintain the accuracy of the database, we need to automatically have the system regularly verify the data. We will accomplish this with a weekly task that emails all program runners who's program has not been updated in 2 months or more, and asks them if the data is still up to date.
These emails though contain two magic links which say "This is up to date" and "I want to edit this". When you click them it takes updates the database and the last edited time.