2027 A Duplicate Record Review Worksheet: A Healthcare Administration Student Portfolio Project
Co-Founder and Chief Data Scientist
A duplicate patient record can split important information across charts, while an incorrect merge can put someone else's information in a chart. A duplicate record review worksheet lets healthcare administration students demonstrate how they would investigate that risk without making unauthorized changes.
This guide shows you how to build a privacy-conscious portfolio project, explain your decisions, and use the work to evaluate healthcare administration, health information management, and graduate business programs. It is designed for students and career changers who need a credible project - not just another credential - to show employers what they can do.
Key Things You Should Know
- A strong worksheet records the evidence for each suspected duplicate, an uncertainty level, and a recommended escalation; it does not automatically merge records.
- Use synthetic cases in a public portfolio. Real patient information belongs only in an authorized, secure training or workplace environment.
- Choose education by the job you want: health information management teaches record integrity more directly, while an MHA or healthcare-focused MBA emphasizes organizational decisions.
What is a duplicate record review worksheet in healthcare administration?
A duplicate record review worksheet is a structured document for examining whether two or more patient records may refer to the same person. It captures why the records were flagged, which permitted identifiers were compared, what conflicts remain, and who should decide the next step. It is a review aid, not permission to merge charts.
Duplicate records can arise from registration errors, name changes, inconsistent data entry, or records created at separate encounters. The opposite error - a mistaken merge of two people's records - can be just as serious. Administrative reviewers therefore need a documented way to distinguish a likely duplicate from a possible match that needs further investigation.
The project sits at the boundary between healthcare administration and health information management (HIM). Students interested in working directly with patient identity and record integrity can examine online CAHIIM-accredited programs for health information careers rather than assuming that every healthcare administration degree offers equivalent HIM training.
How does this portfolio project teach healthcare information management skills?
The project turns a general claim such as "I understand data quality" into evidence of a process. A student must define a review rule, compare permitted information consistently, recognize conflicting evidence, document uncertainty, and route a case to an authorized decision-maker. Those habits matter in registration, HIM, quality improvement, and operations work.
For a useful portfolio artifact, prepare a blank worksheet, a small set of wholly fictional cases, completed reviews, and a brief explanation of the rules you applied. Have an instructor or qualified workplace supervisor critique whether your reasoning supports each recommendation. If you are planning when to begin a degree, flexible start dates for healthcare administration bachelor's study may help you schedule coursework, but check when the program actually offers relevant projects and faculty feedback.
Do not place real names, dates of birth, medical record numbers, screenshots, or other patient information in a public portfolio. Removing a name alone does not necessarily make a case safe to publish. Use synthetic data for public demonstrations; handle workplace records only under organizational policy and applicable privacy requirements.
What education and training prepare students for healthcare administration careers?
The best preparation depends on the responsibility you want. An associate degree or certificate may support an entry-level registration or records role. A bachelor's degree in healthcare administration develops broader operational knowledge, while HIM programs focus more directly on record governance and information practices. An MHA emphasizes management in healthcare organizations; an MBA provides a broader business core, with healthcare content depending on the actual curriculum.
For a student already working in registration or records, experience with approved identity-resolution procedures may be more useful immediately than another degree. A career changer should look for supervised projects or internships that provide healthcare context. Students starting at a community college can review healthcare administration transfer pathways explained before committing to courses that may not count toward a bachelor's degree.
A usable worksheet separates observations from decisions. For a public student project, label all cases as synthetic and replace patient identifiers with fictional case codes. The table below shows fields that make the reviewer's reasoning visible without publishing personal information.
| Field | What it records | Why it matters |
| Case and candidate record codes | Fictional references for the records under review | Keeps the review traceable without displaying identities |
| Reason for flag | The possible match that initiated review | Distinguishes an alert from a confirmed duplicate |
| Comparison and conflicts | Which approved identifiers agree, differ, or are unavailable | Prevents a single matching field from deciding the case |
| Evidence source and reviewer | Where permitted information came from and who assessed it | Supports an auditable review |
| Assessment and next step | Likely duplicate, inconclusive, or unlikely match; referral for authorized review | Separates a recommendation from a record change |
For each fictional case, state what additional evidence would resolve uncertainty and which role would receive the referral. If you hope to build the project in a degree program, compare assignments and internship access - not just school names - among institutionally accredited colleges with online healthcare administration degrees.
Both formats can teach record-review concepts. The difference for this project is how readily you can obtain feedback, practice approved workflows, and access supervised healthcare settings. An online program can suit a working student, but "online" does not establish whether classes are asynchronous, whether group meetings are scheduled, or whether an internship must be completed locally.
Campus study may make in-person collaboration and local employer introductions easier; it can also impose commuting and fixed-schedule costs. Online study can reduce travel while requiring the student to arrange practical experience more deliberately. Ask each program who evaluates portfolio work, whether students use synthetic records or controlled training systems, and how placements are arranged. The same scheduling questions apply if you later consider online healthcare leadership doctorate pacing options; a faster advertised timeline does not establish that its workload fits your job.
Healthcare administration coursework commonly addresses operations, finance, quality, policy, ethics, leadership, and information systems. For this worksheet, the most relevant assignments connect data quality to patient safety, workflow design, privacy, and accountability. HIM coursework may go deeper into patient identity and health information governance than a general administration curriculum.
At the graduate level, an MHA may offer more healthcare-specific operations work, whereas an MBA generally adds accounting, finance, strategy, and organizational management across industries. Neither degree automatically teaches technical record matching. When you compare online MHA degree programs, inspect course descriptions and applied projects for actual patient-identity or data-governance content rather than inferring it from the degree title.
Requirements vary by school and degree level. Undergraduate applicants generally need the school's required prior education and application materials; transfer applicants also need a credit evaluation. Graduate programs typically review a bachelor's degree and academic record and may request a résumé, statement, recommendations, or interview. Tests, prerequisites, and work-experience rules are program-specific - not universal requirements for completing this worksheet.
Students without healthcare employment should distinguish admission eligibility from preparation for a particular job. Relevant projects and supervised experience can help address a context gap even when a program does not require prior industry work. Review health administration graduate programs and work experience requirements, then confirm current rules directly with each school before applying.
Completion time depends on the credential, transfer credits, enrollment intensity, and any internship or capstone. A student who needs only a portfolio project may be better served by an existing course or approved workplace assignment than by enrolling in a new degree. If a graduate credential fits a broader career goal, shorter graduate pathways in healthcare management are worth comparing against standard-paced options - but a shorter calendar does not mean less work.
For a meaningful cost comparison, obtain each program's current tuition basis, required credits, mandatory fees, materials costs, and any travel or placement expenses. Then account for employer assistance, transfer credit, and the work hours you might give up. Do not treat tuition alone as the total cost or borrow for an MBA solely to produce a worksheet that can be completed through lower-cost training.
A worksheet can support applications for registration, patient access, records-quality, or HIM-adjacent roles when paired with the skills and experience an employer requests. Progression toward data-quality supervision or healthcare operations management usually requires demonstrated workplace judgment; a portfolio artifact or degree alone does not confer authority to resolve patient identities.
For broad context, the U.S. Bureau of Labor Statistics reports a $126,520 median annual wage for management occupations in May 2025. That figure covers management jobs across industries - not entry-level healthcare roles, healthcare administration graduates, or people who complete this project. Use pay information for the specific occupation and location you seek when weighing further education.
Some experienced administrators consider doctoral study for research, teaching, or senior leadership development. Compare that goal with the time and financing involved in shorter doctoral pathways in healthcare administration; doctoral study is not a routine prerequisite for record-review or entry-level administration work.
Which accreditations and certifications support healthcare administration careers?
Check institutional accreditation first because it applies to the college or university, not automatically to each healthcare program. Specialized accreditation answers a different question: CAHIIM is relevant when evaluating qualifying HIM education, while CAHME is relevant to qualifying graduate healthcare management education. Neither designation, by itself, proves that a particular course teaches duplicate-record review.
Before paying for a graduate program, verify its current program-level status and examine its curriculum and practical requirements. Students considering an MHA can use guidance on selecting an online CAHME-accredited graduate program as a starting point, then confirm details with the program and accreditor. Professional certifications may be useful for particular HIM or management roles, but eligibility and employer preferences vary; choose one only after identifying the work you intend to do.
Other Things You Should Know About Healthcare Administration
Yes, if the version you share uses entirely synthetic cases and contains no workplace-confidential material. Ask a supervisor before describing an employer's internal procedures or tools.
Only if you can explain its rules and limitations. A simple, documented assessment is more useful than an unexplained score that implies false certainty.
The authorized personnel designated by the healthcare organization's policies make that decision. A student worksheet should recommend review, not perform or approve a merge.
Explain one fictional ambiguous case, the conflicting evidence you noticed, and why you escalated it. That demonstrates judgment more clearly than claiming you "fixed" duplicate records.
- Summary of the HIPAA Privacy Rule | hhs.gov https://www.hhs.gov/hipaa/for-professionals/privacy/laws-regulations/index.html
- Security Techniques for the Electronic Health Records - PMC https://pmc.ncbi.nlm.nih.gov/articles/PMC5522514/
- Privacy & Security - Health IT Playbook - HealthIT.gov https://playbook.healthit.gov/playbook/privacy-and-security/
- Health Insurance Portability and Accountability Act (HIPAA) Compliance - StatPearls - NCBI Bookshelf https://www.ncbi.nlm.nih.gov/books/NBK500019/
- Policy & Guidelines for Physical Security - Yale's HIPAA https://hipaa.yale.edu/security/policy-guidelines-physical-security
- Two Forms of Identification - UTMB Health Resource Center https://www.utmb.edu/health-resource-center/two-forms-of-identification
- Authentic Assessments | University of Illinois Chicago https://teaching.uic.edu/cate-teaching-guides/assessment-grading-practices/authentic-assessments/
- Rubric Best Practices, Examples, and Templates | Teaching Resources https://teaching-resources.delta.ncsu.edu/rubric_best-practices-examples-templates/
- Two Patient Identifiers - Understanding The Requirements https://www.jointcommission.org/en/knowledge-library/support-center/standards-interpretation/standards-faqs/000001463
- Imprivata | Knowledge Hub | Medical Record Overlay https://www.imprivata.com/knowledge-hub/medical-record-overlay
