These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Impact Measurement Platform
- Data model
The tables behind Impact Measurement Platform
Impact Measurement Platform ships with 14 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 14
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Configuration
Organizations own theory of change goals and People. Source mappings attach field rules to a goal.
Operations
Impact programs point to an organization, owner and goal. Outcome observations belong to a program.
Review and evidence
Evidence documents, follow up actions, review decisions and state history refer to the program.
Execution and provenance
Operation runs refer to a program; operation steps belong to a run. Execution attempts refer to a program.
Every table, by feature
- Goals and organizations4
- Impact programs4
- Outcome observations3
- Evidence and follow-up4
- Independent review5
- Execution and provenance6
- Shared and settings1
- Organizations
Agencies, departments and organizations that own theory-of-change goals and impact programs.
- Theory of change goals
Published theory-of-change goals and outcome targets owned by an organization.
Linked to Organizations - Source mappings
Reviewed field mappings and transform rules between source payloads and target fields.
Linked to Theory of change goals - Impact programs
Impact programs recorded for an organization against a theory-of-change goal.
Linked to Organizations, People, Theory of change goals
- Impact programs
Impact programs recorded for an organization against a theory-of-change goal.
Linked to Organizations, People, Theory of change goals - State history
Immutable workflow-written status transition history for each impact program.
Linked to Impact programs, People - Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Impact programs, People - Outcome observations
Observation-level outcome, document and line detail captured against an impact program.
Linked to Impact programs
- Outcome observations
Observation-level outcome, document and line detail captured against an impact program.
Linked to Impact programs - Impact programs
Impact programs recorded for an organization against a theory-of-change goal.
Linked to Organizations, People, Theory of change goals - Source mappings
Reviewed field mappings and transform rules between source payloads and target fields.
Linked to Theory of change goals
- Evidence documents
Uploaded and verified supporting documents and source evidence.
Linked to Impact programs, People - Follow up actions
Assigned outstanding actions, corrections and outstanding requests for an impact program.
Linked to Impact programs, People - Impact programs
Impact programs recorded for an organization against a theory-of-change goal.
Linked to Organizations, People, Theory of change goals - People
Staff, reviewers, owners and assigned team members.
Linked to Organizations
- Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Impact programs, People - Impact programs
Impact programs recorded for an organization against a theory-of-change goal.
Linked to Organizations, People, Theory of change goals - Evidence documents
Uploaded and verified supporting documents and source evidence.
Linked to Impact programs, People - Outcome observations
Observation-level outcome, document and line detail captured against an impact program.
Linked to Impact programs - State history
Immutable workflow-written status transition history for each impact program.
Linked to Impact programs, People
- Operation runs
Workflow-maintained execution runs with operation key, input hash and persisted result reference.
Linked to Impact programs - Operation steps
Ordered steps inside an operation run with input, output and external receipt state.
Linked to Operation runs - Execution attempts
Each recorded attempt to execute an approved action for an impact program.
Linked to Impact programs - State history
Immutable workflow-written status transition history for each impact program.
Linked to Impact programs, People - Follow up actions
Assigned outstanding actions, corrections and outstanding requests for an impact program.
Linked to Impact programs, People - Impact programs
Impact programs recorded for an organization against a theory-of-change goal.
Linked to Organizations, People, Theory of change goals
Keys and references
Each impact programs record has a number and references to Organizations, People and theory of change goals. Outcome observations retain a required source record id and Parent reference. Review decisions record source revision and Reviewer. Operation runs carry operation key and source revision; steps carry a Run reference. These keys let the team follow the reported value back to its source and decision.
Migration order
- Load Organizations and People with stable codes.
- Load theory of change goals under the intended organization, then source mappings where source fields need interpretation.
- Load impact programs with their organization, owner and definition references.
- Load outcome observations, evidence documents and follow up actions under the correct program.
- Load review decisions, state history, operation runs, operation steps and execution attempts only with their original revision and receipt context.
Set up Impact Measurement Platform your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.