Miami Dade College Databases in a Healthcare Setting Discussion
INTRODUCTIONIn this task, you will analyze and resolve duplicates and errors within a master patient index (MPI) in preparation for implementation into a health information exchange (HIE). Additionally, you will evaluate the quality of a data dictionary and create a presentation to summarize your findings.The purpose of this task is to pull healthcare data, analyze the data, and organize the data into a data dictionary within a database, duties often associated with healthcare analysis and health information management (HIM).SCENARIOYou are a new graduate working at Wizer Hospital as an HIM analyst. You have been asked to compile data into a database for leadership so they can quickly and efficiently pull reports. You have been given an Excel spreadsheet and asked to analyze the data and evaluate a data dictionary. As you are preparing the data, you notice several duplicates and errors within the MPI files that were pulled from the electronic health record (EHR). Ensuring that the data from the MPI files and data dictionary is accurate and that all duplicates are resolved is critical for the facility as they move forward with HIE implementation and interoperability.REQUIREMENTSA. Refer to the attached “Master Patient Index” to do the following:1. Identify three duplicate patients.2. Identify three errors in the data.B. Refer to the attached “Sample Data Dictionary” supporting document to do the following:1. Identify three missing elements from the data dictionary.2. Evaluate whether the data dictionary contains the required elements to meet interoperability standards.C. Create a presentation about how inaccurate data impacts the ability to share healthcare information with other organizations by doing the following:1. Summarize your findings from parts A1 and A2.2. Summarize your findings from parts B1 and B2.3. Describe a process improvement plan for data entry to ensure patient identification, including the following: the problem statement, the sources where the data errors could have originated, a plan that addresses the steps needed to correct the data errors, a plan that addresses what to do if a duplicate cannot be corrected, a plan that addresses ongoing maintenance of duplicates, a plan that addresses the problem statementD. Acknowledge sources, using APA-formatted in-text citations and references, for content that is quoted, paraphrased, or summarized.E. Demonstrate professional communication in the content and presentation of your submission.File RestrictionsFile name may contain only letters, numbers, spaces, and these symbols: ! - _ . * ' ( )File size limit: 200 MBFile types allowed: doc, docx, rtf, xls, xlsx, ppt, pptx, odt, pdf, txt, qt, mov, mpg, avi, mp3, wav, mp4, wma, flv, asf, mpeg, wmv, m4v, svg, tif, tiff, jpeg, jpg, gif, png, zip, rar, tar, 7zRUBRICA1. DUPLICATE PATIENTS:NOT EVIDENT3 patients are not identified.APPROACHING COMPETENCE3 patients are identified, but 1 or more of the patients is not a duplicate.COMPETENT3 patients are each accurately identified as a duplicate.A2. ERRORS IN DATA:NOT EVIDENT3 errors in data are not identified.APPROACHING COMPETENCEN/ACOMPETENT3 errors in data are identified.B1. REQUIRED ELEMENTS OF THE DATA DICTIONARY:NOT EVIDENT3 missing elements are not identified.APPROACHING COMPETENCEN/ACOMPETENT3 missing elements are identified.B2. ELEMENTS OF INTEROPERABILITY OF DATA:NOT EVIDENTAn evaluation is not provided.APPROACHING COMPETENCEThe evaluation does not accurately conclude whether the data dictionary does or does not contain the required elements to meet interoperability standards. COMPETENTThe evaluation accurately concludes whether the data dictionary does or does not contain the required elements to meet interoperability standards.C1. SUMMARY OF FINDINGS FROM A1 AND A2:NOT EVIDENTA summary is not provided.APPROACHING COMPETENCEThe summary does not accurately describe the findings from parts A1 and A2, or the summary is incomplete.COMPETENTThe summary accurately and completely describes the findings from both part A1 and A2.C2. SUMMARY OF FINDINGS FROM B1 AND B2:NOT EVIDENTA summary is not provided.APPROACHING COMPETENCEThe summary does not accurately describe the findings from parts B1 and B2, or the summary is incomplete.COMPETENTThe summary accurately and completely describes the findings from parts B1 and B2.C3. PROCESS IMPROVEMENT PLAN:NOT EVIDENTA process improvement is not provided.APPROACHING COMPETENCEThe description does not appropriately identify a process improvement plan for data entry that ensures patient identification or does not include each of the given points.COMPETENTThe description appropriately identifies a process improvement plan for data entry that ensures patient identification, including each of the given points.D. APA SOURCES:NOT EVIDENTThe submission does not include in-text citations and references according to APA style for content that is quoted, paraphrased, or summarized.APPROACHING COMPETENCEThe submission includes in-text citations and references for content that is quoted, paraphrased, or summarized but does not demonstrate a consistent application of APA style.COMPETENTThe submission includes in-text citations and references for content that is quoted, paraphrased, or summarized and demonstrates a consistent application of APA style.E. PROFESSIONAL COMMUNICATION:NOT EVIDENTContent is unstructured, is disjointed, or contains pervasive errors in mechanics, usage, or grammar. Vocabulary or tone is unprofessional or distracts from the topic.APPROACHING COMPETENCEContent is poorly organized, is difficult to follow, or contains errors in mechanics, usage, or grammar that cause confusion. Terminology is misused or ineffective.COMPETENTContent reflects attention to detail, is organized, and focuses on the main ideas as prescribed in the task or chosen by the candidate. Terminology is pertinent, is used correctly, and effectively conveys the intended meaning. Mechanics, usage, and grammar promote accurate interpretation and understanding.