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)
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 **