Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

MPI Duplication Analysis

Analysis

Knowledge Activity: MPI Duplication Analysis (Informatics)

Part 1: Generate the Dataset Using the Queries Tool

Access the EHR queries tool and corresponding dataset under
2: Launch EHR. Click the
New Session button to launch the EHR.

On the Queries tab, select
New to initiate a new query.

· First, Name the query ‘
MPI Duplication Analysis’

· Then enter the following query rule:

Query rule(s): ‘Duplicate Threshold’ equal ‘Y’

· Select
Add rule to add another rule and select
OR as the logic

· Then enter the following second rule:

Query rule(s): ‘Duplicate Threshold’ equal ‘N’

· Select
Query to generate the results. There should be 526 total records. If not, review the screenshot above to ensure your query is setup correctly. If necessary, adjust and re-run the query.

· Select
Export Results to Excel to export your dataset for further analysis.

Part 2: Analyze the Data in Microsoft Excel®

Open the exported file in Microsoft Excel®.

In order to analyze the possible duplicates, use the Sort function.

· Select
Data then
Sort. Enter ‘Duplicate Threshold’ in the Sort by field. Then select ‘Z to A’ for the Order field. Then click
OK.

Those with “Y” (yes) as the Duplicate Threshold will now be listed first in the spreadsheet.

Of those that are possible duplicates (Y’s), group the possible duplicates together for analysis. To do so, build on the previous sort by incorporating the ‘Possible match code’ data.

· Go to
Data then
Sort. Your previous sort parameters will still be listed. Choose
Add level and select ‘Possible match code’ as the column and ‘A to Z’ as the Order then
OK.

The resulting spreadsheet will have the possible duplicate entries grouped together for further review. For example, the possible match code of “C” results are highlighted – a potential duplicate pair requiring further analysis.

Review all possible duplicate matches in the resulting spreadsheet and answer the following questions. Round to the nearest percent when asked for a percentage.

1. How many of the results are possible duplicates?

2. What percentage of the registrations are potential duplicates?

3. How many of the potential duplicate pairs have first name discrepancies? What is the percentage of first name discrepancies in the duplicate pairs?

4. What is the most common cause of first name discrepancies?

5. How many of the potential duplicate pairs have middle name discrepancies? What is the percentage of middle name discrepancies in the duplicate pairs?

6. What is the most common cause of middle name discrepancies?

7. How many of the potential duplicates have last name discrepancies? What is the percentage of last name discrepancies?

8. What is the most common cause of last name discrepancies?

9. How many of the potential duplicates have gender discrepancies?

10. What are the causes of the gender discrepancies?

11. How many of the potential duplicates have DOB discrepancies?

12. What is the most common cause of DOB discrepancies?

13. How many of the potential duplicates have mismatches of MRN?

14. What is the most common cause of mismatched MRN?

15. How many of the potential duplicates have mismatches of SSN?

16. What is the most common cause of mismatched SSN?

Blank and default fields are a common cause of duplicate record creation. Analyze the resulting possible duplicates for blank and default fields. Use the sort function again to determine which employees were responsible for entering the data containing blank or default entries.

· Go to
Data and
Sort

· Delete the existing level based on Possible match code (keep the Duplicate Threshold criteria)

·
Add level and choose ‘Registered By’ as the column then ‘A to Z’ as the Order. Then click
OK.

Of the employees listed below, how many blank or default (MRXXXXXX or XXX-XX-XXXX) entries were each responsible for creating? If there were multiple blank or default entries for one registration, only count that registration once.

17. Dvaughn Lane, LPN

18. Cora Zimmerman, MA

19. Kim Pham, LPN

20. Emily Garcia, MA

21. Clara Rojo, RHIT

22. Wanda Murray, RHIA

23. Tina Lin, HUC

24. Kevin Fanning, MA

25. Who created the most duplicate records by leaving default or blank values in the patient registration data?

Recommendations for decreasing duplicate record formation

After analyzing the Hospital’s duplicate records, you are asked to provide recommendations for improvement. Please review the
MPI Duplicate Resolution resource included under 1: Overview & Resources along with this activity document to assist in answering the questions below.

26. What else could the General Hospital implement to prevent duplicate records from getting created?

27. What are potential negative impacts of duplicate records?

28. What can HIIM professionals do to prevent and manage duplicate records?

29. What is an overlaid record?

30. What is the best way to prevent overlaid records?

31. According to the
Challenges in MPI Duplicate Resolution resource found under 1: Overview & Resources along with this activity document, which of the following is a data-related reason for duplicate records?

a. Lack of data standardization and transposition of the month and date in the DOB

b. Changing demographics and nicknames

c. Default and null values in key identifying fields and lack of data standardization

d. Frequently changing mobile phone numbers

32. What are three strategies suggested by the
Challenges in MPI Duplicate Resolution resource to prevent duplicate records from being formed?

33. List four recommendations to provide to the General Hospital to help prevent duplicate records from being created.

Submit your work

Document your answers directly on this activity document as you complete the activity. When you are finished, save this activity document to your device and upload this activity document with your answers to your Learning Management System (LMS). If you have any questions about submitting your work to your LMS, please contact your instructor.

Learning objectives

1. Identify the types of duplicate records found in an MPI.

2. Analyze common causes for duplicate records.

3. Identify strategies to address and prevent the creation of duplicate records in an MPI.

4. Analyze strategies for the management of information. (4)

5. Recommend compliance of health record content across the health system. (5)

6. Evaluate data dictionaries and data sets for compliance with governance standards. (5)

7. Facilitate training needs for a healthcare organization. (4)

References

AHIMA. Fundamentals for Building a Master Patient Index/Enterprise Master Patient Index.
Journal of AHIMA (Updated September 2010).

Haenke Just, B., Marc, D., Munns, M., & Sandefer, R. (2016).
Why Patient Matching Is a Challenge: Research on Master Patient Index (MPI) Data Discrepancies in Key Identifying Fields. Washington D.C.: AHIMA.

Harris, S., & Houser, S. H. (2018). Double Trouble—Using Health Informatics to Tackle Duplicate Medical Record Issues.
Journal of AHIMA 89, no. 8, 20-23.

EHR Go Knowledge Activity: MPI Duplication Analysis (Informatics) HIK1046.3

Archetype Innovations LLC ©2022 2

image1.png

image2.png

image3.png

image4.png

image5.png

image6.png

image7.png

image8.png

image9.png

image10.png

image11.jpg

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

English homework

LITERATURE PROJECT Below, you will find a list of authors from the ancients to the present. All of these authors are in the textbook, Norton Anthology of World Literature: Pre-1650 and Post-1650, 5th edition, vols. A, B, C, D, E, and F. The page number for each author or work

English homework

Chapter 4 Top Religions (online)  Online Individual Activity: Exploring the Top Religions Objective: To facilitate understanding and appreciation of the world’s major religions through independent research and reflective writing, enhancing critical thinking and respectful engagement with diverse perspectives. Top Religions (by estimated followers): 1. Judaic Culture 2. Christianity 3. Byzatine

English Can someone help me with my English compotition homework?

English  ENC 101 ENGLISH COMPOSITION 1 FINAL EXAM ANSWER SHEET Name ____________________________________ Date _________________ Complete all answers on this answer sheet and upload to Blackboard. Verbs (1-10) 1. 6. 2. 7. 3. 8. 4. 9. 5. 10. Punctuation Marks (1-10) 1. 6. 2. 7. 3. 8. 4. 9. 5. 10.

Health

Program: ​ ​ Logic Model (uses text boxes: add/change boxes and arrows as needed) Situation: Inputs Outputs Activities Participation Outcomes Short Medium Long Assumptions External Factors Rev. 7/09

Nexttt

Redo  Required Readings & Resources Kolbert, J., Crothers, L., & Hughes, T. (2022). Introduction to school counseling: Theory, research, and practice (2nd ed.). ● Chapter 1: “History and Trends in the School Counseling Profession” ● Chapter 2: “Professional Identify of School Counselors and the American School Association National Model (2019)”

Asap please.

Thanks  Required Readings & Resources Kolbert, J., Crothers, L., & Hughes, T. (2022). Introduction to school counseling: Theory, research, and practice (2nd ed.). ● Chapter 6: “Individual Counseling” ● Chapter 7: “Group Counseling” Part A-Discussion Topic: Discussion: Counseling Theories in an Academic Setting Discussion: Counseling Theories in an Academic Setting

ASAP 2

Shankss Required Readings & Resources Kolbert, J., Crothers, L., & Hughes, T. (2022). Introduction to school counseling: Theory, research, and practice (2nd ed.). ● Chapter 8: “Consultation and Collaboration” ● Chapter 9: “Academic Development” Part A-Discussion: Engaging with Students Review the Discussion Requirements for this course before responding to the

ar

Use the following questions as a guide as you work to situate this artwork in its geographical context of production. · What kind of features do the figures display?  What are they wearing on their heads?  What kind of beard does the seated figure have? · How are outlines used

I need help d

Answer these using at least 350 words ● What is the policy, program, or policy proposal, and which community/ies is it intended to benefit? ○ This can be a federal or state policy already in place (WIC or TANNF), a community-based or mutual aid program you know of or are

English Homework

Discussion –  You may pick out one topic of the following to discuss: Collaboration  Strategic Sourcing

I need help j4

General Instructions / Formatting Requirements: 1. Respond to only one of the below prompts 2. State the specific prompt you’re responding to at the top of your paper 3. Break up your response into multiple paragraphs 4. Indent each paragraph 5. Double space 6. Proofread for clarity, grammar and spelling

gc

will need speaker notes Create an 8- to 10-slide PowerPoint presentation discussing your cultural background (in addition, you should include a title slide and reference slide in your presentation). When discussing your culture, consider components of yourself such as race, ethnicity, religion, spiritual heritage, gender, sexual orientation, disabilities, socioeconomic status, traditions,

Play

Assignment posted below Scholars, For your last major writing assignment of the semester, you will compose an original scene of a play. In your scene, you must include the following: • Title of your play • clear stage directions • scene descriptions • a list of characters • engaging dialogue

English Homework

Current event Assignment: Chapter 1 – “The Humanities: An introduction “ Objective:   As we delve into the current chapter, this assignment aims to encourage you to make real-world connections to the material we are studying.  Details:   Each student is required to bring in an item that relates to the current

English Homework

Dr. Huston/ENGL 2331-F2-Spring 2024 2 English 2331 Literary Research Project Guidelines Project Slides due date: Sunday, May 5, no later than 11:30 pm Reminder: Late assignments are not accepted. Purpose: This project is intended to provide students with an opportunity to research and independently explore the life and literature of

assitant needed E Kenniqua

please see attachment In-Class Essay – Spring 2024 · Choose one of the following (numbered) prompts to write an essay paragraph. · Make sure your answer has all the features of a strong essay and is written in complete sentences. · Pay special attention to giving support: examples, names, and