TA3 -- Data Model




Business Process Model

Our business process model is the admission of a patient for skin and risk assessment, performed by a nurse. Various tests are given by the nurses, and the results are charted electronically. Based upon the results, treatment is provided accordingly and it will be determined if the patient needs a special mattress to prevent further skin breakdown. The patient's insurance is billed for the care, and if needed the speciality mattress. If a special mattress is needed, the patient and nurse need to sign off on the mattress. The nurse checks daily on the patient to see if there is anymore skin breakdown. The one of the three tables that would be related to this would be, a special ID number for each patient to keep them organized, and keep confidentiality. Using a program such as SQL can enable you to organize patient data via ID number or room number. The second table would be for the insurance company to keep track of billing and the money for the patient. This table would also include how much insurance is covered versus how much the patient needs to pay out of pocket. Using Excel to create these tables gives you an advantage as you can add different lines of information depending on the type of service, type of insurance, hospital, etc. The last table would be for scheduling, when patients need to been seen, and when doctors and nurses are working. You can use this format for any scheduling whether it's strictly for patients or strictly for the staff. In our example we've blended those two so a nurse or physician may see particular patients that are in need of wound care on their rounds.


Tables:

 1. Patient ID Information via SQL:

Patient Information


2. Insurance Account Information via Google Docs/Excel:


Wound Care Accounts
Patient IDCoveredPaidDue
1140480%$450$0
4412390%$250$150
3240585%$500$80
4430215%$1,300$540
6570875%$698$412

3. Nurse/Patient Schedule via Google Docs/Excel:

Nurse/Physician Shifts
Employee Schedule Feb 2018
Shift Details
EmployeeDuration Days of WeekPatient/RoomWound Care (Y/N)
Tina, RN12 hoursM, W, FJeff D./1202Y
Wendy, RN12 hoursSa, T, ThuMichael F./1302Y
John, RN18 hoursM, W, FSamantha R./1215Y
James, MD16 hoursW, Thu, FThomas P./1310Y
Frank, RN12 hoursF, M, ThuTrixie B./1212Y

Comments

Post a Comment

Popular posts from this blog

TA4 -- Disruptive Innovation

Disruptive Innovation If a patient has skin breakdown or ulcers, then nurses will put in an order for a specialty mattress. Before the nurses can do this though, they must ask for a consult from wound care. Sometimes, there are only two people from wound care working, and if they have to handle patients all over the whole hospital and sometimes a consult won’t be able to happen for hours. This can be extremely frustrating because the patient is in pain and unfortunately the nurse can’t order the mattress until wound care comes. This is a huge disruption because nurses are very busy and have many patients, so when wound care finally comes, whether that be minutes or hours later, the nurse must drop everything she is doing and go in the room with them. Based on the process model that we have designed, this is a good disruptive idea. In order to get tasks done and patients taken care of in a timely manner, wound care must be available. Finding this disruptive idea gives us some
Read more

Business Process and Flow

Image
Business Process: Ordering a mattress for a patients with skin breakdown on admission/ acquiring it during stay 1.  Please describe a business process Upon admission of a patient a skin assessment and risk assessment is done by the nurse. The assessment involves a patient mobility test, excess moisture test, and a check of nutritional status. Triggers are in the charting system, which is electronic, including what will trigger the need for intervention which includes ordering a speciality mattress to avoid further skin breakdown. If the patient already has skin breakdown then the nurse will call down the wound care team. The wound care team will come down and assess the situation and decide which mattress they will order. The patient's insurance is billed for the rental and then the bed is brought to the nurse who then signs for it. The nurse must put the patient on the mattress and then chart it on the risk assessment. They check the skin everyday
Read more