update_tables.pl looks at request.created_at date and left-joins request_followup and pack_dispatch so all outreach requests included, not just when follow-up option and pack dispatch date decided; added session: Cookie to config file - was default for dev but not production; included status = reported to packs.tt request_status.match list - no requests now fail to match a pack status definition
update_tables.pl - update patient_access table; add registered date to last report display; replace :3000 with :8000 for dev env (previously removed port so relied on fastcgi running)
provide switch to patient_access_demo db using command-line param; requires dynamic loading of patient cols (so Model::SQL gets access to dbix)
7 years ago
README.md
Outreach patient access
=======================
* default db = outreach_patient_access - updated on LTH149890 daily by cron (bin/update_tables.pl)
* alternative 'patient_access_demo' database loaded using command-line param:
dbname=patient_access_demo plackup -p xxxx bin/app.psgi
patient_access_demo users (email/nhs_number):
* user1@email.net/1111111111 : Walter MELON : Next assessment is due on dd.Mon.yyyy [today + 2d]
* user2@email.net/2222222222 : Justin CASE : A pack was sent on 21.May.2015 [xx days ago] but has not been received.
* user3@email.net/3333333333 : Orsen CART : A pack was received on 12.May.2015 and initial results indicate that no urgent action is required.
* user4@email.net/4444444444 : Hazel NUTT : A pack was received on 13.May.2015 and laboratory tests have been initiated.
* user5@email.net/5555555555 : Sandy SHORE : A pack was sent on dd.Mon.yyyy [3 days ago]
* user6@email.net/6666666666 : Rose PETAL : Return to clinic
* login username = email address, patient NHS number or prefix 'OUT' + patient.id (requires >= 2-digit patient id so not for demo)
* login password = 'outreach' for default outreach_patient_access, user-part of email (user1, user2, etc) for patient_access_demo, but not required for dev env
Pack status rules:
IF request_status = complete
IF pack_due >= today
Next assessment is due on <date>
ELSIF pack_sent < today;
A pack was sent on <date> [<days> ago]
IF > 7 days
but has not been received. Please call us to discuss.
ELSIF pack_due AND NOT pack_sent
Pack was due for dispatch on <date> but has not been sent. Please call us to discuss.
ELSE # ? no pack_due date ?
<outcome eg return-to-clinic>
ELSIF flow AND outreach data
A pack was received on <date> and initial results indicate that no urgent action is required.
It may take three weeks to obtain all the laboratory test results but we will contact your GP
if there are any issues.
ELSIF request_status = new, screened or reported
A pack was received on <date> and laboratory tests have been initiated.
ELSE
** UNKNOWN RECORD STATUS - CHECK DETAILS **
