MMHA 6520 Week 3 Data Source Reconciliation Review Example

Health Informatics and Population Health Analytics Walden University Free custom sample in 24 to 48h

This MMHA 6520 Week 3 reconciliation review example compares three places a composite Medicaid plan stores information about members' social needs: clinic screening answers, ICD-10 Z codes on claims and care manager assessments. Walden MMHA 6520 asks MHA students to test whether data sources agree before using them, and the review's central exhibit is a member-level crosswalk of food insecurity status for a composite sample present in all three sources. The pattern is described in words: positive screens rarely produce a Z code, consistent with Truong and colleagues; assessments are richest but cover only members already in care management, citing Kindig and Stoddart; and sources sometimes disagree outright. A passage on instruments, citing Billioux and colleagues on the Accountable Health Communities questions, explains why positives differ by practice. Each source is assigned a role, and Z codes are set aside for now.

CourseMMHA 6520 Health Informatics and Population Health Analytics
WeekWeek 3
Paper typeSocial needs data reconciliation review
LengthAbout 1,030 words, 6 pages
FormatAPA 7 student paper
SchoolWalden University
ProgramMaster of Healthcare Administration (MHA)
UpdatedOctober 2026

Free sample paper for MMHA 6520 Week 3

1

Three Sources, One Member: Reconciling Social Needs Data Across Screenings, Z Codes and Care Manager Assessments

Student Name

Walden University

MMHA 6520: Health Informatics and Population Health Analytics

Instructor Name

Month Day, Year

What this page is doingThe title frames the review around one member seen three ways, which is how the crosswalk is built.
2

Three Sources, One Member: Reconciling Social Needs Data Across Screenings, Z Codes and Care Manager Assessments

Purpose

Riverline Health Plan, a composite Medicaid managed care plan, keeps what it knows about members' social circumstances, whether they have enough to eat, a stable place to live or a way to get to appointments, in three places: screening answers sent by network practices, ICD-10 Z codes on claims, and assessments recorded by the plan's care managers. Leaders want to know how many members have social needs and which members to reach. This review asks whether the three sources agree, what each can and cannot show, and what role each should play. It uses a composite sample of members who appear in all three sources, so the comparison is fair.

What this page is doingThe opening states the question the review answers and why it matters for a plan.
3

The Crosswalk

Table 1 shows twelve members from the composite sample, selected to illustrate the patterns found. Each row records the member's status for food insecurity in each source.

Table 1

Food Insecurity Status by Source, Composite Sample

MemberClinic screeningZ code on claimsCare manager assessmentAgreement
APositiveNonePositiveScreening and assessment agree
BPositiveZ59.4PositiveAll agree
CNegativeNonePositiveDisagree
DPositiveNoneNot assessedPartial
ENot screenedNonePositiveAssessment only
FPositiveNonePositiveScreening and assessment agree
GNegativeNoneNegativeAll agree
HPositiveZ59.4PositiveAll agree
IPositiveNoneNegativeDisagree
JNot screenedNonePositiveAssessment only
KPositiveNoneNot assessedPartial
LNegativeNoneNegativeAll agree

Members and results are composite and illustrative. Z59.4 is the ICD-10-CM code for lack of adequate food. Not assessed means the member was not in care management at the time.

What this page is doingA member-level crosswalk shows disagreement directly, which aggregate counts would hide.
4

The Pattern

Three patterns appear. First, screenings that flag a need are often not followed by a Z code on any claim. In the sample, most members who screened positive for food insecurity had no corresponding code. This matches national findings that Z codes are rarely used, even among hospitalized patients for whom social needs are documented elsewhere (Truong et al., 2020). Coding a social need takes time, rarely affects payment and depends on whether the clinician or coder thinks to do it.

Second, care manager assessments hold the richest detail. They record not only whether a need exists but how severe it is, how long it has lasted and what the member wants to do about it. But assessments exist only for members already in care management, which at Riverline is a small and selected group, typically those with high costs or recent hospital stays. Population health questions concern the whole membership and how outcomes are distributed within it (Kindig & Stoddart, 2003), so a count drawn from this group cannot answer them. A count based on assessments would describe that group, not the plan's membership.

Third, the sources sometimes disagree outright. Member C screened negative at the clinic but described food insecurity to a care manager; member I screened positive but told the care manager the problem had resolved. Disagreement can reflect a change over time, the setting in which the question was asked, or who asked it. A member may be more willing to describe a need to a care manager who has called several times than to answer a form in a waiting room.

What this page is doingThe pattern is described in words rather than rates, since the sample is illustrative.
5

Instruments Differ

Network practices do not all use the same screening questions. Some ask the ten core questions CMS published for its Accountable Health Communities model, which cover five domains from housing to personal safety (Billioux et al., 2017). Others use the two-question Hunger Vital Sign for food, a locally written form or questions built into their electronic record. A positive food screen at one practice may reflect a question about the past twelve months; at another, the past month. When results are pooled, these differences are invisible. Any count drawn from screening data should therefore be reported by instrument, or limited to practices using the same one.

What this page is doingA passage on instruments explains why a positive result does not mean the same thing everywhere.
6

A Role for Each Source

Screenings: prevalence among screened members. Screening data are the best available source for estimating how common a need is, but only among members who were screened, at practices using a known instrument. Reports should state the denominator, members screened, and should not be read as the plan-wide rate, since practices that screen may serve different populations from those that do not.

Care manager assessments: individual outreach. Assessments are the best source for deciding what to do for a particular member, because they include severity, history and the member's own preferences. They should drive referrals and care plans for members in care management.

Z codes: neither, for now. Until coding practice changes, Z codes undercount needs too severely to support either prevalence estimates or outreach. A member without a Z code is not a member without a need. The plan should continue to collect them, since a rise in coding would be useful in itself, and should consider working with high-volume practices to code needs identified in screening.

What this page is doingThe review assigns each source a role rather than choosing a single winner.
7

Recommendations

Three steps follow. First, the informatics team should label every screening-based report with the instrument used and the number of members screened, and should never present screening counts as plan-wide prevalence. Second, care managers should be able to see clinic screening results in the care management system, so that a positive screen prompts a conversation and disagreements like member C's are caught. Third, the plan should ask its five highest-volume practices whether they would adopt a common screening instrument and code positive results, offering technical help with the electronic record build. If that work succeeds, Z codes could become a useful source within a few years; for now, the plan should not rely on them.

What this page is doingRecommendations follow from the roles, each with a practical step.
8

Limits of This Review

The composite sample includes only members present in all three sources, which excludes most of the membership: members never screened, never in care management or never billed with a Z code. The patterns found here describe how the sources relate for those members, not how common needs are. The review also covers one need, food insecurity; agreement may differ for housing, where questions are more standardized, or for interpersonal safety, where members may be reluctant to answer at all.

What this page is doingThe review names its own limits.
9

References

Billioux, A., Verlander, K., Anthony, S., & Alley, D. (2017). Standardized screening for health-related social needs in clinical settings: The Accountable Health Communities screening tool. NAM Perspectives. https://doi.org/10.31478/201705b

Kindig, D., & Stoddart, G. (2003). What is population health? American Journal of Public Health, 93(3), 380-383. https://doi.org/10.2105/AJPH.93.3.380

Truong, H. P., Luke, A. A., Hammond, G., Wadhera, R. K., Reidhead, M., & Joynt Maddox, K. E. (2020). Utilization of social determinants of health ICD-10 Z-codes among hospitalized patients in the United States, 2016-2017. Medical Care, 58(12), 1037-1043. https://doi.org/10.1097/MLR.0000000000001418

MMHA 6520 Week 3 instructions, in plain terms

Reconciliation reviews ask you to compare data sources that claim to measure the same thing. Choose one measure and a sample of individuals who appear in every source, so the comparison is fair. Show agreement and disagreement at the individual level, in a table, rather than only as totals. Describe the patterns you see and explain plausible reasons for each, citing evidence where it exists. Check whether the sources even use the same definitions or instruments. Then assign each source a role suited to its strengths, such as estimating prevalence or guiding outreach, and say plainly where a source should not be used yet. Close with practical steps and the limits of your own sample.

How this MMHA 6520 Week 3 example is built

The purpose section names the three sources and the questions leaders ask of them. Table 1 lists twelve composite members with their status in each source and whether the sources agree. The pattern section describes missing Z codes, citing Truong and colleagues, assessment coverage limited to care management members, citing Kindig and Stoddart, and two outright disagreements with possible explanations. The instruments section explains that practices use different screening questions, citing Billioux and colleagues. A roles section assigns screenings to prevalence among the screened, assessments to individual outreach and Z codes to neither for now. Recommendations cover labeling reports, sharing screenings with care managers and working with high-volume practices.

Reading the MMHA 6520 Week 3 rubric

Reconciliation reviews are graded on rigor and judgment. A member-level comparison that makes agreement and disagreement visible earns the first share. Explaining patterns with plausible mechanisms, and with evidence where available, earns the largest share. Attention to instruments and definitions shows methodological care that graders reward. Assigning roles to each source, rather than declaring one source the winner, demonstrates practical judgment. Honest statements about where a source should not be used are credited. Recommendations must follow from the findings. The review's own limits, especially sample selection, should be named. Tables and APA references matter less. Reviewers also check that the sample's selection is described, since a crosswalk limited to members in all three sources cannot speak for the whole membership.

MMHA 6520 Week 3 help from the desk

Students often compare totals across sources and conclude that one is right. Compare individuals instead, because totals can match while the people behind them differ. Look for reasons behind each disagreement: timing, setting, who asked and how. Check whether every source used the same question; often they did not. Resist using a source simply because it is easy to pull, as Z codes are. Give each source a job it can do well. Say who your sample leaves out. Make recommendations that someone could start next month. We can reconcile data sources for a measure your organization reports, using a sample from its own records.

Get a MMHA 6520 Week 3 example written to your instructions

Attach the Week 3 prompt and rubric and note whether your section wants data quality, governance or both; the review is scoped to match and returns in 24-48h, free the first time. Its members and screenings are imaginary; the desk never asks for claims extracts or screening files from the place you work.

More MMHA 6520 papers and MHA samples

MMHA 6520 Week 3 questions, answered

Where can I find a free MMHA 6520 Week 3 sample paper?

The reconciliation review and its member crosswalk are free to read on this page.

Which sources does the MMHA 6520 Week 3 review compare?

Clinic screening answers, Z codes on claims and care manager assessments, for food insecurity.

Why do Z codes undercount social needs?

Coding a social need takes time, rarely affects payment and depends on whether anyone thinks to do it.

Why can screening results not be pooled across practices?

Practices use different instruments and time frames, so a positive result does not mean the same thing everywhere.

What role does each source get?

Screenings for prevalence among screened members, assessments for individual outreach and Z codes for neither until coding improves.