Transcript: Medical Records Medical Records Database Overview Dziwulski, Christopher Robert Jeffers, Eric James Patil, Sagar Jagannath Tran, Tuyet Bach Zheng, Sheng Estimated Roles Vs. Actual Roles worked as a group assigned roles as we went Changes need to be made for different versions of SQL Team approach is much more effictive Christopher Dziwulski – Database Implementer, Reporting needs/OLAP Eric Jeffers – Data Modeler, Developer/Programmer Sagar Patil – Analyst, Developer/Programmer Vicki Tran – Public Relations, Project Manager/Team Leader Sheng Zheng – Designer, Reporting needs/OLAP Used for record keeping, personnel (i.e. doctors, nurses, patients), communicating with other medical facilities, etc. Help operations run more efficiently. Will encompass all aspects of a patient care: hospital visits, doctor visits, and medical treatments. Entities: patients, doctors, nurses, prescriptions, hospitals, clinics, treatments and others. Actual Roles Lesson Learned Database is complexed and difficult to implement Going back and forth with SDLC steps Presented By: Group 9 Estimated Roles
Transcript: Insurance The salary of doctors who take medical record information is $156,000 to around $315,000. Salary could range up to as high as 400,000, but it all depends on which job. Thank You! BY: Taran Whitfield & Zaire Hicks In many surveys employees explained that the EMR(Electronic Medical Records) has been a major help since creation of medical records. This small Device, which is created in excel, has created satisfaction towards the medical department. Many facilities still audit nursing and physician documentation by using paper forms. Hospitals also use Excel Dashboards that is created by non-technical administrators to help monitor health care activities. The EMR stands for Electronic Medical Records. This is a online Data base that keeps up with the records of patients that come in and out of medical facilities. Instead of paper medical records employees can now use computers. EMR For the Better Hospital Facilities Excel Spreadsheets Medical Records The EMR Salary Many patients read insurance coverage reports. These reports help them to keep track of their medical insurance records; Insurance coverage reports are beneficial because this helps many people to keep track of where they are financially. Spreadsheets are computer programs that stimulates a business and scientific worksheets and performs the necessary calculations when data is entered and/or changed. Doctors use this to keep track of the records of the patients who they are taking care of. 62 ECG bpm
Transcript: In the 1960s, a physician named Lawrence L. Weed first described the concept of computerized or electronic medical records. Weed described a system to automate and reorganize patient medical records to enhance their utilization and thereby lead to improved patient care. In 1970, the POMR was used in a medical ward of the Medical Center Hospital of Vermont for the first time. At this time, touchscreen technology had been incorporated into data entry procedures Electronic health records Today, in the United States, we all live in an age of technology and science. The use of technology and science has revolutionized our way of life. There are few things in history that have influenced our lives more than a computer. Today, there cannot be any field that is absent of the influence of computer applications. From farming to rocket science, computers have a huge role to play. The use of the computer has been on the increase for some time in many fields. Medicine is one of the many fields that have made tremendous strides in the twentieth century due to the advent of computers. Electronic health records (EHRs) are changing medical assistants' jobs. More and more physicians are adopting EHRs, moving all their patient information online. Assistants need to learn the EHR software that their office uses. Medical assistants take and record patients’ personal information. They must be able to keep that information confidential and discuss it only with other medical personnel who are involved in treating the patient. What do they Do? Medical assistants typically do the following: Take patient history and measure vital signs Help the physician with patient examinations Give patient injections as directed by the physician Schedule patient appointments Prepare blood for laboratory tests History of Electronic Medical Records How have Medical records Helped The Health Field Medical Records
Transcript: By:LIZETH Medical Records OUR COMPANY OUR COMPANY IN DETAIL Introduction Medical Records and Documentation play a big role providing quality for patient care. TREATMENTS TIME LOCATION LOCATION STAFF Doctor's Name Nurse’s Name STAFF Nurse’s Name Doctor's Name Nurse’s Name Nurse’s Name PRODUCTS & SERVICES PRODUCTS & SERVICES PRODUCTS PRODUCTS IMPORTANT PRODUCT FEATURES 1 IMPORTANT PRODUCT FEATURES 1 IMPORTANT PRODUCT FEATURES 2 IMPORTANT PRODUCT FEATURES 2 IMPORTANT PRODUCT FEATURES 3 IMPORTANT PRODUCT FEATURES 3 SERVICES SERVICES IMPORTANT PRODUCT FEATURES 1 IMPORTANT PRODUCT FEATURES 1 IMPORTANT PRODUCT FEATURES 2 IMPORTANT PRODUCT FEATURES 2 IMPORTANT PRODUCT FEATURES 3 IMPORTANT PRODUCT FEATURES 3 HISTORY HISTORY NOW 2010 2008 2015 TESTIMONIALS TESTIMONIALS STORY 1 STORY 1 STORY 2 STORY 2
Transcript: Example of a Jeopardy Template By: Laken Feeser and Rachel Chapman When creating without a template... http://www.edtechnetwork.com/powerpoint.html https://www.thebalance.com/free-family-feud-powerpoint-templates-1358184 Example of a Deal or No Deal Template PowerPoint Game Templates There are free templates for games such as jeopardy, wheel of fortune, and cash cab that can be downloaded online. However, some templates may cost more money depending on the complexity of the game. Classroom Games that Make Test Review and Memorization Fun! (n.d.). Retrieved February 17, 2017, from http://people.uncw.edu/ertzbergerj/msgames.htm Fisher, S. (n.d.). Customize a PowerPoint Game for Your Class with These Free Templates. Retrieved February 17, 2017, from https://www.thebalance.com/free-powerpoint-games-for-teachers-1358169 1. Users will begin with a lot of slides all with the same basic graphic design. 2. The, decide and create a series of questions that are to be asked during the game. 3. By hyper linking certain answers to different slides, the game jumps from slide to slide while playing the game. 4. This kind of setup is normally seen as a simple quiz show game. Example of a Wheel of Fortune Template https://www.teacherspayteachers.com/Product/Wheel-of-Riches-PowerPoint-Template-Plays-Just-Like-Wheel-of-Fortune-383606 Games can be made in order to make a fun and easy way to learn. Popular game templates include: Family Feud Millionaire Jeopardy and other quiz shows. http://www.free-power-point-templates.com/deal-powerpoint-template/ Quick video on template "Millionaire" PowerPoint Games Some games are easier to make compared to others If users are unsure whether or not downloading certain templates is safe, you can actually make your own game by just simply using PowerPoint. add logo here References Example of a Family Feud Template PowerPoint Games are a great way to introduce new concepts and ideas You can create a fun, competitive atmosphere with the use of different templates You can change and rearrange information to correlate with the topic or idea being discussed. Great with students, workers, family, etc. For example: With games like Jeopardy and Family Feud, players can pick practically any answers. The person who is running the game will have to have all of the answers in order to determine if players are correct or not. However, with a game like Who Wants to be a Millionaire, the players only have a choice between answers, A, B, C, or D. Therefore, when the player decides their answer, the person running the game clicks it, and the game will tell them whether they are right or wrong.
Transcript: Healthcare Smart Cards hh References More about smart cards Ahmed, A., Batchelor, D., & Bianchin, L. (2012, September). Smart Card Technology in U.S. Healthcare: Frequently Asked Questions. Retrieved February 16, 2016, from http://www.smartcardalliance.org/resources/pdf/Smart_Card_Technology_in_Healthcare_FAQ_FINAL_096012.pdf Emedikon (Director). (2010, July 7). Benefits of EMR [Video file]. Retrieved February 19, 2016, from Eysenbach, G. (2002, June 24). Recent advances Consumer health informatics. Retrieved February 17, 2016, from http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.304.8652&rep=rep1&type=pdf Electronic Medical Records References Continued One way is through smart cards What is on an EMR? Brian Bauer Denver School of Nursing How are EMR's used today? Benefits of EMR's What are Smart Cards? A smart card is a small card or similar device with an embedded micro processor chip integrated Electronic Medical Records (EMR) is a digital version of a patient's medical records The chip can store and access and exchange data securely with readers systems More Smart Card information EMR's empower consumers by making their personal healthcare information more accessible and allow for better decisions making abilities Medical history Diagnoses Medications Allergies Radiology images Lab and test results Medical Problems Surgeries Insurances Payment Information Smart Card Parts Smart Card information More questions about Smart Cards? Check out this question and answer video series by Open Edge at https://openedgepayments.com/emv/qanda.html How do they work? Learn EHR Basics. (2014, May 21). Retrieved February 19, 2016, from https://www.healthit.gov/providers-professionals/learn-ehr-basics Smart Card Anatomy [Digital image]. (n.d.). Retrieved February 21, 2016, from https://openedgepayments.com/emv/assets/images/smartcardanatomy.png Versatile Security (Director). (2012, June 22). What is a smart card? [Video file]. Retrieved February 21, 2016, from Patient Demographics Allergies Medications Identity Verification
Transcript: Medical Records: Is the history of a medical patient as in medical history, treatments received, diagnosis, and lab results. HIPAA (Health Information Portability & Accountability Act)- It reduces healthcare fraud and abuse, it covers the patients health information by keeping it private and protected. What Is HIPAA? Medical Records By:Jacqueline Andrade Example of Medical Records
Transcript: The system identifies real time issues of patients in handling their medical records and provides a suitable solution. The system simplifies the functioning by digitally storing information pertaining to patients and their ailments. The system identifies two users Doctor and Patient. The role of the doctor is to register the patient, treat him for his ailment. The doctor is provided with a facility to resume treating a patient on his existing ailment or create a new one. The doctor can also view the test reports for an ailment as uploaded by the patient post receiving the reports from the diagnostics lab. Processor : Intel Pentium (PIV 2.2Ghz or higher) Hard Disk : 40 GB hard disk space Ram : 1 Gb Ram Operating System : Windows 32 Bit or higher Programming Environment : Java Database : Oracle Web server : Apache Tomcat Web browsers : Internet Explorer Scripting language : Java Script Database Drivers : Jdbc/Odbc Drivers(Type 1) The module allows the doctors to view the registered patients. A tabulated listing of the patient with the registration details are shown. This module allows the patient to login and view his prescription. The module collects all his existing ailments and prompts him to choose the ailment for which he wants to see his prescription. View Patients Thank You! This module allows the doctor to view reports uploaded by the patient for a particular ailment. The images of the reports are shown to the doctor. Upload Reports The administrator is the core user of the application who maintains other users. View Reports Proposed System: In the proposed system automation of the treatment and having it across a centralized database makes the system easier to handle the documents and maintain them. The patient registers in a hospital and is provided with a unique ID. The hospital uploads the patients prescription and details the test. The diagnostic lab can view the tests to be conducted and perform the test. The pharmacist can view the prescription and issue the medicines. Every document of the patient is associated with his unique id. Irrespective of the hospital the patient goes his records are visible to the doctor of the new hospital. ADMIN PATIENT This module helps the doctor to choose the consulting patient and treat him. The module prompts the doctor needing him to identify the patient as an existing or new patient. For existing patients the ailments are shown and the previous history can be seen. The doctor can proceed to update the prescription. In the case of a new ailment the details are saved into the database The users use the application to register the patient and treat him. EXISTING SYSTEM INTEGRATEDMEDICAL RECORDS MODULES PROPOSED SYSTEM DOCTOR Register Patient The users use the application to view his ailment and test reports. This module allows the user to upload external lab reports. The patient chooses his ailment and uploads the image file. The module allows the patient to upload any number of reports for an ailment. The module allows the doctor to register the patients. Every patient is associated with a unique id. His details such as Name , address and contact number are collected and saved to the database. The present scenario every hospital has their own way of maintaining records. Some record information in files and either give it to the patient or retains them in the hospital. Disadvantages: - All the documents are physically stored. Patient has to carry his record all the time. Possible loss of the file or damage to the documents. Identifying and searching records become complex. When large number of documents or more than one illness is associated with a patient then managing the documents become complex. HARDWARE AND SOFTWARE REQUIREMENTS View Prescription Prescribe Medicine 62 ECG bpm
Description: Storytelling is at the heart of great service. Use this stunning, customizable business presentation template to highlight employees who do exceptional work or position your customers as the heroes of your business.
Description: Catch the eye and engage the imagination with this cool-looking Prezi proposal template. The bold, bright design and highly dynamic theme all but guarantee success for your next sales or marketing proposal. All Prezi presentation templates are easily customized.
Description: Add some color to your quarterly business review with this vibrant business presentation template. The bold visuals in this business template will make your next QBR a memorable one.
Description: The sky’s the limit. Boost your new sales initiative into orbit with an engaging and compelling SKO presentation. This template features a effective sales kickoff theme that makes it easy to be engaging. Like all Prezi SKO templates, it’s fully customizable with your own information.
Now you can make any subject more engaging and memorable