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.
- Organic Certification Tracker
- Data model
The tables behind Organic Certification Tracker
Organic Certification Tracker ships with 11 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
- 11
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Scope and parcel
Certification scopes identifies the operation and status; certified parcel boundaries stores surveyed geometry and area.
Quality work
Audits links to a scope; inspection checks links to a scope; Inspections and corrective actions link to audits.
Input trail
Organic input register holds lots, organic input reviews holds scope reviews, and organic input usage links inputs to corrective actions.
People
People links staff to Users and identifies action owners, input reviewers and inspection acceptors.
Every table, by feature
- Certification scopes4
- Parcel boundaries2
- Audits4
- Inspections5
- Corrective actions5
- Organic inputs5
- Shared and settings1
- Certification scopes
Registry of operations and parcels under organic certification: operator, certified hectares, location and certification status.
- Certified parcel boundaries
Surveyed parcel geometry and measured area for each certification scope: Geo JSON, survey date and surveyed hectares.
Linked to Certification scopes - Audits
Organic certification audits through a planned-to-closed lifecycle, with certification scope, standard, planned and completed dates.
Linked to Certification scopes - Corrective actions
Assigned corrective work items raised from audit findings, with owner, due date and implementation status.
Linked to Certification scopes, Audits, People
- Certified parcel boundaries
Surveyed parcel geometry and measured area for each certification scope: Geo JSON, survey date and surveyed hectares.
Linked to Certification scopes - Certification scopes
Registry of operations and parcels under organic certification: operator, certified hectares, location and certification status.
- Audits
Organic certification audits through a planned-to-closed lifecycle, with certification scope, standard, planned and completed dates.
Linked to Certification scopes - Certification scopes
Registry of operations and parcels under organic certification: operator, certified hectares, location and certification status.
- Inspections
Completed inspections with inspected date, quantity, result and accepting reviewer.
Linked to Audits, People - Corrective actions
Assigned corrective work items raised from audit findings, with owner, due date and implementation status.
Linked to Certification scopes, Audits, People
- Inspection checks
Individual inspection checks captured against an audit, with check type, measurement and notes.
Linked to Certification scopes - Inspections
Completed inspections with inspected date, quantity, result and accepting reviewer.
Linked to Audits, People - Audits
Organic certification audits through a planned-to-closed lifecycle, with certification scope, standard, planned and completed dates.
Linked to Certification scopes - Certification scopes
Registry of operations and parcels under organic certification: operator, certified hectares, location and certification status.
- People
Farm staff, operators, reviewers and managers with their authenticated user account and role title
Linked to Users
- Corrective actions
Assigned corrective work items raised from audit findings, with owner, due date and implementation status.
Linked to Certification scopes, Audits, People - Audits
Organic certification audits through a planned-to-closed lifecycle, with certification scope, standard, planned and completed dates.
Linked to Certification scopes - Certification scopes
Registry of operations and parcels under organic certification: operator, certified hectares, location and certification status.
- People
Farm staff, operators, reviewers and managers with their authenticated user account and role title
Linked to Users - Organic input usage
Recorded input usage drawing from the organic input register, linked to the corrective action and its applied date.
Linked to Organic input register, Corrective actions
- Organic input register
Register of approved input materials with lot number, unit, quantity on hand and approval expiry.
- Organic input reviews
Reviews of an input material against a certification scope, with reviewer, review date, quantity and unit.
Linked to Certification scopes, People - Organic input usage
Recorded input usage drawing from the organic input register, linked to the corrective action and its applied date.
Linked to Organic input register, Corrective actions - Corrective actions
Assigned corrective work items raised from audit findings, with owner, due date and implementation status.
Linked to Certification scopes, Audits, People - Certification scopes
Registry of operations and parcels under organic certification: operator, certified hectares, location and certification status.
Keys and references
Most records have an Id; Users instead has the User reference listed in its table. The key operational references are certification scope on the survey, audit, check, review and action; Audit on the inspection and action; Owner on the action; and Input and corrective action on applied use. The accepting reviewer and input reviewer reference People.
Migration order
- Create Users and People, then check active identities.
- Import certification scopes and organic input register.
- Link certified parcel boundaries and Audits to their scopes.
- Add inspection checks, Inspections and organic input reviews.
- Add corrective actions and then organic input usage.
Set up Organic Certification Tracker your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.