Project Template

Team Name

PDX

Timeline

Fall 2018 – Spring 2019

Students

  • Brian Jimenez
  • Bryan Tu
  • Jose Cervantes
  • Michael Vu
  • Giannina Pachas

Sponsor

PDX

 

Background

The business case is the need of an easy way customers can interact with their pharmacies for their own specific needs. An example in the real world is that if someone needed to refill their prescription, they would need to call the place or go in person to refill it and pick it up. There can be many problems with this as employees could be busy at the place, or there isn’t enough time on the customer side to order it in person. This is a big time problem for customers, and a solution is needed. With an application built that is connected to existing services by PDX, this could all be done in a matter of minutes compared to driving to the pharmacy or going through a call center. Our sponsor, PDX, has shared the same business case to us, and we are working together to create a solution to this existing problem. With he new updated application that will be included in their software that can be now be given to existing pharmacies using PDX software already. This will make it a lot easier on customer’s to achieve what they need.

Project Requirements

  • Demonstrate the ability to see prescriptions for a given patient
    • Show me the prescriptions that have not been picked up
    • Show me the prescriptions that have been picked up
    • Show me the prescriptions that have been canceled
    • Show me the store for a previously filled Rx.
    • Show me a prescription that has been transferred to another pharmacy in the chain
    • Show me a prescription that has been transferred outside the chain
  • Demonstrate the ability to lookup a patient
    • Show me how to lookup a patient by first name and last name
    • Show me how to lookup a patient by phone
    • Show me how to lookup a patient by birthdate
    • Show me how to lookup a patient by rx number
    • Show me how to confirm the correct patient has been retrieved by reviewing name, address, DOB and gender
  • Demonstrate the ability to update a patient’s information
    • Show me how to update the patients address
    • Show me how to update the patient’s preferences of call, text, email
  • Demonstrate the ability to see information about an Rx
    • Show me the rx expiration date
    • Show me the quantity being filled
    • Show me the remaining quantity
    • Show me the date the last Rx was filled
    • Show me how the Rx entered the system
    • Show me how many refills are remaining
    • Show me the prescriber who prescribed the Rx
    • Show me an Rx is ready to picked up
    • Show me an Rx that is not ready to be picked up
    • Show me the remaining steps needed when an Rx is not ready to be picked up
    • Show me the pharmacy that is filling the Rx

System Overview

Client will be able to interact with our web application2. Service will be created, and micro services also if needed3. Front-end and back-end will be load balanced if cost is an issue, so one server will be utilized instead of multiple servers for each deployment4.  Proxy will be created for security purposes so only authorized users will be able access the services5. Database instance will be on an in dependent server that is already existing

Results

http://ec2-18-217-104-122.us-east-2.compute.amazonaws.com:5004/

Future Work

  • Demonstrate the ability to submit a refill
    • Show me how to submit a refill
    • Show me a refill cannot be submitted when no refills exist
    • Show me a refill cannot be submitted when the Rx has expired
  • Demonstrate the ability to submit a transfer to another store in the chain using the store number
    • Show me how to submit a transfer to another store in the chain.
  • Google home and Alexa integration

Project Files

Project Charter project_charter_latex-2f8pil9

System Requirements Specification system_requirements_specification_latex-siqy1j

Architectural Design Specification architectural_design_specification_latex-2ixfje9

Detailed Design Specification detailed_design_specification_latex (1)-16wsrjr

Demo http://ec2-18-217-104-122.us-east-2.compute.amazonaws.com:5004/

 

chenc4