Project
**Note: This is the basic version of the project. In this project you will connect to an already existing database for your app. If you want to also learn to create your own database for your apps then click here. Note though that you still need to complete this basic project before you get started on the advanced one, so that you actually have the app when creating the database.
This project is about a BI Application for monitoring patient care delivery across the community. The health authority in your region has set up a committee responsible for developing an accountable palliative care system across the region. A key priority for the committee is to maximize access to palliative care services by different healthcare facilities -hospitals, family health teams, community services, etc.- To monitor this goal the committee has requested you to develop a BI application that allows for tracking of all patient referrals by healthcare facility so appropriate management of palliative care cases across the community can be provided.
This part includes creating:
- App basic login
- Navigation bar
- User profiles (Team members)
A patient diagnosed with a chronic condition by any of the healthcare providers across the community is referred to a Community Care Access Centre (CCAC) for future treatment of his/her condition. The nurse at the CCAC will create a new patient record with information that includes patient name, diagnosis, gender, referral date, referral facility, patient status, decease date and whether or not the patient visited the Emergency Room (ER) for a reason related to his/her chronic condition during the last two weeks of life. Based on the information logged by the nurse(s) at the CCAC, the admin at the healthcare authority will be able to run a report that provides with insights on yearly referrals by facility. This will allow the health authority to review/adjust its strategy, i.e. promote education among healthcare personnel at the various facilities, in order to maximize the use of palliative care services in the community.
The health authority has identified two main user roles of the hospital app with levels of access and privileges as follows:
a. Administrator: (Username: admin, Password: admin)
- Have access to old patient records, report and team members.
- Can add new patients.
- Can add/edit new/existing team member.
b. Nurse: (Username: nurse, Password: nurse)
- Have access to old patient records and team members.
- Can add new patients.
- Can edit only his/her user profile in team members.
Note: The application database hospital is already created in the server for this project. Add database changes as appropriate in your context.xml.
Screenshot of the Hospital login page:
- Get Started
- Create a Login/Team members for your App
- Create a Basic Quickforms App
- Add Navigation to your App
When a CCAC nurse receives a new patient referral or patient status update, the nurse logs into the BI app to create/update the patient's profile. Similarly, when the administrator at the regional healthcare authority needs to review referrals by facility in the community, he/she will login into the hospital BI app by entering the username and password in the login screen.
- On successful login, the admin or nurse have access to old patients records. Use getTableDisplay to show records in the table summary as shown below.
Note: Make sure to define the navigation bar according to each user role level of access.
- A 'New Patient Form' (registrationForm) is used to record patient details and identify what facility in the community referred the patient for community care services. FACT TABLE NAME : referrals. Also, this form is used to indicate whether or not the patient visited the ER in the last two weeks of life. The data fields for this form as well as field data type are described below.
| Field | Type |
|---|---|
| PatientName (For Patient Name) | Text |
| Diagnosis (For Diagnosis) | Select |
| Gender (For Gender) | Select |
| ReferralDate (For Referral Date) | Date |
| RefSector (For Referral Facility) | Select |
| Status (For Status: Active, deceased and discharged) | Select |
| DeceasedDate (For Deceased Date) | Date |
| ER2WeeksPrior(For ER2WeeksPrior- Means was the aptient alloted the Emergency Room 2 weeks Prior to death) | Check box |
| Register | Button |
| Back | Button |
Screenshot of the New Patient Form:
Note: Make sure to use fact table referrals to save patient's data submitted through the form into the database.
- Users assigned to an admin role can view team members table summary and will be able to add/edit team members user accounts.
Screenshot of Team Members-Admin:
- Users assigned to a nurse user role can view team members table summary and edit their own user accounts.
Screenshot of Team Members-Nurse:
This part of the project involve the creation of a graph report and corresponding table report to your hospital app. Also a filter control is needed to provide admin users the flexibility to filter data by referral sector, status and/or year.
The administrator at the regional health authority will run frequent reports to get insights on the total number of referrals by facility received at CCAC yearly.
(A) Generate a report graph and corresponding table report that shows total referrals by facility by year.
Screenshot of Referral Facility Report:
Notes:
- Use getReferralsGraph to generate the graph report.
- Use query name getReferralsTable to generate the table report.
(B) Add filter to your report graph and table. Filter by Referral Sector Type (Note: Give name as RefSector), status and year
Screenshot of report Filter:
You can refer to the App Checklist page to confirm that you have created all the required files.