Join on the identifier, inspect the provenance.
Names drift and abbreviations collide. A stable agency ID is the primary key, while the legal instrument, registry status, and file source remain part of the evidence trail.
Public money needs a real recipient.
Join appropriation IDs to a legal-entity register before treating a budget line as verified. Missing records create a review obligation, not an automatic fraud verdict.
APPROPRIATIONS CSV0 rows
ENTITY REGISTRY CSV0 rows
Illustrative data only. No live Nigerian budget or legal registry is queried.
Allocation trail
Reconcile the two supplied files.
ALLOCATIONS0
ACTIVE MATCHES0
REVIEW LINES0
REVIEW EXPOSURE₦0
WAITINGNo join yet-Match reasons appear here.A registry match can establish consistency between supplied files; it cannot establish release, procurement, performance, or lawful spending.
Unmatched
No supplied registry row shares the allocation ID. The full line amount remains exposed to entity-verification review.
Inactive
The ID exists but the supplied record is not active. This is a distinct review reason, not proof of misconduct.
Active match
The supplied files agree on an active entity. That clears this join test only; spending controls still apply.