Why Two Departments at the Same University Can't Agree How Many Students They Have

A question that sounds like it should have one answer

"How many active students do we have right now" feels like a simple count. Ask three different departments at the same institution, pulling from the same underlying student records, and it's genuinely common to get three different real numbers, none of them a mistake, each one internally correct by the definition that department actually uses.

graph TD
    A[Same Student Roster] --> B[Registrar:<br/>enrolled in credits]
    A --> C[Financial Aid:<br/>tuition paid]
    A --> D[Advising:<br/>attended recently]
    B --> E[One real number]
    C --> F[A different real number]
    D --> G[A third real number]

The same six students, three real definitions

students = pd.DataFrame([
    {"student_id": "S001", "enrolled_credits": 12, "tuition_paid": True,  "attended_last_week": True},
    {"student_id": "S002", "enrolled_credits": 3,  "tuition_paid": True,  "attended_last_week": False},
    {"student_id": "S003", "enrolled_credits": 0,  "tuition_paid": True,  "attended_last_week": False},
    {"student_id": "S004", "enrolled_credits": 15, "tuition_paid": False, "attended_last_week": True},
    {"student_id": "S005", "enrolled_credits": 6,  "tuition_paid": True,  "attended_last_week": True},
    {"student_id": "S006", "enrolled_credits": 9,  "tuition_paid": False, "attended_last_week": False},
])

Six students, every field genuinely real and correct, nothing miskeyed or missing. A part-time student who paid but stopped attending. A student who paid last term but isn't enrolled in anything this term. A student actively attending who hasn't paid tuition yet.

Three real counts, from the same six rows

registrar_count = (students["enrolled_credits"] > 0).sum()
financial_aid_count = (students["tuition_paid"] == True).sum()
advising_count = (students["attended_last_week"] == True).sum()

Registrar's 'active students' (enrolled in credits): 5
Financial Aid's 'active students' (tuition paid):     4
Advising's 'active students' (attended last week):    3

Total students in the roster: 6

Three genuinely different numbers, 5, 4, and 3, computed from the exact same six real students. Nobody made an error. Each department's query correctly answers the question that department actually needs answered for its own work, enrolled-in-credits for the Registrar, paid-tuition for Financial Aid, currently-attending for Advising. The disagreement isn't a bug in any one query. It's three real, valid, different definitions of "active," none of them labeled as such anywhere a leadership dashboard would show them side by side.

Why this is a real, common finding, not a contrived one

Ask a room full of people from different departments at almost any institution "how many active students do we have," and getting genuinely different numbers back is a documented, common pattern, not a rare failure. Higher-education data quality research names this directly: different groups within the same institution routinely give different answers to the same basic question, because each group's definition was built to serve its own operational need, never reconciled against the others (EdTech Magazine, Higher Ed Dive).

Where this actually costs something

Not in any single department's own reporting, each one is internally consistent and correct for its own purpose. The real cost shows up the moment two numbers meet in the same room: a board presentation citing "enrollment" pulled from one department, a budget projection built on a different department's version, a state compliance report needing a number that matches neither. Nobody notices the definitions diverged until the totals don't reconcile, and by then it's a credibility problem in a meeting, not a five-minute fix in a query.

What actually fixes it

Not forcing every department onto one shared definition, Financial Aid genuinely needs "has this student paid," and that's a real, legitimate business question distinct from enrollment status. What fixes it is naming the definitions explicitly, "active (enrolled)," "active (paid)," "active (attending)," as clearly labeled, distinct metrics, documented once in a shared place, so a report can say precisely which one it means instead of everyone assuming their own definition is simply "the" number.

The takeaway

Three different, real counts from the same six students isn't a data quality bug to hunt down and eliminate. It's what happens by default when multiple departments each build their own reasonable definition of "active" without ever comparing notes. The fix isn't fewer definitions, it's making the definitions visible, named, and impossible to accidentally conflate the next time two numbers end up in the same slide.