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.
- Land Acquisition Tracker
- Data model
The tables behind Land Acquisition Tracker
Land Acquisition Tracker 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
Parcel work
Acquisition parcels is the case record; due diligence checks and follow up actions carry observations and assigned work.
Evidence and review
Evidence documents, review decisions and state history explain what was seen, decided and changed.
Execution
Operation runs, operation steps and execution attempts retain the action trace.
Configuration
Organizations, People, Landowners and source mappings provide ownership and definition context.
Every table, by feature
- Parcel workspace5
- Due diligence4
- Independent review5
- Transfer and execution4
- Follow-up and correction5
- Configuration and oversight6
- Shared and settings1
- Acquisition parcels
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Landowners - Landowners
Published service definitions, programmes and entitlements offered by an organization.
Linked to Organizations - Organizations
Agencies, departments and service organizations that own public services and cases.
- People
Staff, officers, reviewers and assigned team members.
Linked to Organizations - State history
Immutable workflow-written status transition history for each case.
Linked to Acquisition parcels, People
- Due diligence checks
Observation-level requirement, document and line detail captured against a service application.
Linked to Acquisition parcels - Evidence documents
Uploaded and verified supporting documents and source evidence.
Linked to Acquisition parcels, People - Acquisition parcels
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Landowners - Follow up actions
Assigned outstanding actions, corrections and outstanding requests for a case.
Linked to Acquisition parcels, People
- Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Acquisition parcels, People - Acquisition parcels
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Landowners - People
Staff, officers, reviewers and assigned team members.
Linked to Organizations - Evidence documents
Uploaded and verified supporting documents and source evidence.
Linked to Acquisition parcels, People - Due diligence checks
Observation-level requirement, document and line detail captured against a service application.
Linked to Acquisition parcels
- Operation runs
Workflow-maintained execution runs with operation key, input hash and persisted result reference.
Linked to Acquisition parcels - 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 a service application.
Linked to Acquisition parcels - Acquisition parcels
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Landowners
- Follow up actions
Assigned outstanding actions, corrections and outstanding requests for a case.
Linked to Acquisition parcels, People - Acquisition parcels
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Landowners - Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Acquisition parcels, People - State history
Immutable workflow-written status transition history for each case.
Linked to Acquisition parcels, People - Operation runs
Workflow-maintained execution runs with operation key, input hash and persisted result reference.
Linked to Acquisition parcels
- Landowners
Published service definitions, programmes and entitlements offered by an organization.
Linked to Organizations - Source mappings
Reviewed field mappings and transform rules between source payloads and target fields.
Linked to Landowners - Organizations
Agencies, departments and service organizations that own public services and cases.
- People
Staff, officers, reviewers and assigned team members.
Linked to Organizations - Acquisition parcels
Requests, applications and cases submitted for a public service.
Linked to Organizations, People, Landowners - State history
Immutable workflow-written status transition history for each case.
Linked to Acquisition parcels, People
Keys and references
The parcel Number and parcel identifier help people identify the case. Child records link through Parent or Source; the review decision also stores source revision. Operation steps link to operation runs through Run. The operation key connects execution traces to the relevant action. Keep these references intact during migration so a reviewer can follow the complete case.
Migration order
- Organizations and people. Establish owning organizations and named staff.
- Landowner definitions. Add codes, effective dates and policy references; review source mappings where used.
- Parcel cases. Import case numbers, owners, definitions and milestone dates.
- Supporting work. Connect checks, evidence documents and follow-up actions to their parcel.
- Decisions and trace. Bring over revision-specific review decisions, state history and execution references where available.
Set up Land Acquisition Tracker your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.