Organic Certification Compliance Workflow

Start of the Workflow/Process.

Create a new entry in the 'Compliance Application' data model with farmer/producer details.

Fetch existing land usage and soil history entries from the 'Farm Land' data model.

Generate a standardized checklist entry linked to the application for organic standards verification.

Create a task for the 'Audit Team' to perform an on-site physical inspection of the farm.

Update the Compliance Application entry with results, photos, and notes from the field inspector.

Retrieve all entries from the 'Input Logs' data model to verify no prohibited substances were used.

Execute a formula based on the number of failed checklist items and severity of findings.

Update the application entry with the calculated risk score (High/Medium/Low).

Create a task for the 'Compliance Officer' to review and decide on corrective actions.

Aggregate the 'Hectares' property from all linked Land entries to verify total organic scope.

Update the application status to 'Approved', 'Pending Correction', or 'Rejected'.

Send an email to the farmer/producer contact address with the audit results.

Create a new entry in the 'Certificates' data model containing the valid period and scope.

Create a summary report for regulatory bodies based on the processed application data.

Delete or move entries from the 'Active Applications' model that have been rejected and finalized.

End of the Workflow/Process.