Grant-to-Impact Data Model
Link funding to delivery through stable identifiers while preserving the difference between costs, activities, outputs and outcomes.
Method And Expected Result
Aggregate expenses and observations separately to the agreed activity or programme grain before joining totals. Joining every expense to every participant can multiply costs. Protect beneficiary identities and retain definition versions.
Worked planning examples, not customer performance results. Changes stay in this page until exported; reloading resets them. Keep sensitive personal information out of this planning tool.
Working Sheet
| Object | Primary key | Linked object | Relationship | Required evidence |
|---|---|---|---|---|
| Award | award_id | Budget version | One award has versioned budgets | Agreement and amendments |
| Purchase | order_id | Award and activity | Many orders can support one activity | Approval and coding |
| Expense | entry_id | Order and award | One posting consumes relevant commitment | Invoice and posting |
| Activity | activity_id | Programme | Activities belong to an approved programme | Delivery record |
| Observation | observation_id | Activity and indicator | Many observations use one definition version | Source and acceptance |
| Indicator | indicator_id | Definition version | Output or outcome with stated denominator | Method and reviewer |
The Excel toolkit includes the Grant impact model worksheet for this resource. CSV exports contain current values; Excel retains the calculator formulas.
