Field Reference — Findings

Complete reference for all fields in the Findings module, derived from the data model.

Finding Fields

Field	Type	Required	Description
id	Integer	Auto	Unique identifier
engagement_id	Integer	✅	Parent engagement (foreign key)
workpaper_id	Integer	Optional	Linked workpaper where finding originated
title	String	✅	Short descriptive title
description	Text	✅	Condition — what was observed
criteria	Text	Optional	Criteria — what was expected (standard, policy)
cause	Text	Optional	Cause — why the condition exists
effect	Text	Optional	Effect — impact or risk
recommendation	Text	Optional	Recommendation — suggested corrective action
severity	String	✅	Critical, High, Medium, Low (default: Medium)
status	String	Auto	DRAFT, MANAGEMENT_RESPONSE, FINAL, CLOSED
created_at	DateTime	Auto	Timestamp of creation
closed_at	DateTime	Auto	Timestamp when finding was closed
created_by_id	String	Auto	User who created the finding
ai_execution_id	String	Optional	Reference to AI execution that generated the draft

Finding Version Fields

Field	Type	Description
id	Integer	Unique identifier
finding_id	Integer	Parent finding
version_number	Integer	Sequential version number
content_snapshot	JSON (String)	Full JSON dump of finding state at this version
created_at	DateTime	When this version was created
created_by_id	String	User who made the change

Action Plan Fields

Field	Type	Required	Description
id	Integer	Auto	Unique identifier
finding_id	Integer	✅	Parent finding (foreign key)
description	String	✅	What corrective action is required
owner_id	String	✅	User responsible for implementing the action
due_date	Date	✅	Target completion date
status	String	Auto	OPEN, IMPLEMENTED, VERIFIED, CLOSED, OVERDUE
created_at	DateTime	Auto	Timestamp of creation
completion_date	DateTime	Optional	When the action was actually completed

Follow-Up Test Fields

Field	Type	Required	Description
id	Integer	Auto	Unique identifier
finding_id	Integer	✅	Finding being re-tested
test_description	Text	✅	What follow-up test procedure was performed
result	Text	✅	Outcome of the follow-up test
conclusion	String	✅	Pass, Fail, Partial
tested_by_id	String	Auto	Auditor who performed the test
tested_at	DateTime	Auto	When the test was executed
evidence_files	Relation	Optional	Linked evidence proving the result

Remediation Evidence Fields

Field	Type	Description
id	Integer	Unique identifier
action_plan_id	Integer	Parent action plan
evidence_files	Relation	Linked evidence files (via Evidence model)

Status Transitions

Finding Status

DRAFT → MANAGEMENT_RESPONSE → FINAL → CLOSED
         ↑                      |
         └── (returned for revision)

Action Plan Status

OPEN → IMPLEMENTED → VERIFIED → CLOSED
  |                     |
  → OVERDUE             → OPEN (verification failed)