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=<db> or init.d script (see app.pl): DBNAME=patient_access_demo plackup -p xxxx bin/app.psgi * note: ENV param = "DBNAME", app config param = "db_name" * can also be run using live hilis4 & outreach db's - change queries in SQL.pm and config db_name to outreach , also don't need dbix() in SQL.pm if using hilis4/outreach - don't need get_cols() * pack status of all patients can be viewed using t/all_patients.t with DBNAME env param set to live database --------------------------------------------------------------------------------- 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 = one of 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 (not required for dev env) * to test email, set MY_EMAIL_SENDER_TRANSPORT env param (see Routes POD), or include 'fail' in email addr (sets TestFail transport), or for live SMTP include an smtp config hash in config_local.yml, eg: --- smtp: host: 'smtp.host.server' sasl_username: 'user@host.server' sasl_password: 'testing_invalid' # to trigger failure msg timeout: 10 # so that patient doesn't wait too long for response --------------------------------------------------------------------------------- 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 (not default date 1999-01-01) 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 ? Pack dispatch not scheduled: <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 **