Skip to main content
Version: 1.0.0-beta

Field Reference — Findings

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

Finding Fields​

FieldTypeRequiredDescription
idIntegerAutoUnique identifier
engagement_idInteger✅Parent engagement (foreign key)
workpaper_idIntegerOptionalLinked workpaper where finding originated
titleString✅Short descriptive title
descriptionText✅Condition — what was observed
criteriaTextOptionalCriteria — what was expected (standard, policy)
causeTextOptionalCause — why the condition exists
effectTextOptionalEffect — impact or risk
recommendationTextOptionalRecommendation — suggested corrective action
severityString✅Critical, High, Medium, Low (default: Medium)
statusStringAutoDRAFT, MANAGEMENT_RESPONSE, FINAL, CLOSED
created_atDateTimeAutoTimestamp of creation
closed_atDateTimeAutoTimestamp when finding was closed
created_by_idStringAutoUser who created the finding
ai_execution_idStringOptionalReference to AI execution that generated the draft

Finding Version Fields​

FieldTypeDescription
idIntegerUnique identifier
finding_idIntegerParent finding
version_numberIntegerSequential version number
content_snapshotJSON (String)Full JSON dump of finding state at this version
created_atDateTimeWhen this version was created
created_by_idStringUser who made the change

Action Plan Fields​

FieldTypeRequiredDescription
idIntegerAutoUnique identifier
finding_idInteger✅Parent finding (foreign key)
descriptionString✅What corrective action is required
owner_idString✅User responsible for implementing the action
due_dateDate✅Target completion date
statusStringAutoOPEN, IMPLEMENTED, VERIFIED, CLOSED, OVERDUE
created_atDateTimeAutoTimestamp of creation
completion_dateDateTimeOptionalWhen the action was actually completed

Follow-Up Test Fields​

FieldTypeRequiredDescription
idIntegerAutoUnique identifier
finding_idInteger✅Finding being re-tested
test_descriptionText✅What follow-up test procedure was performed
resultText✅Outcome of the follow-up test
conclusionString✅Pass, Fail, Partial
tested_by_idStringAutoAuditor who performed the test
tested_atDateTimeAutoWhen the test was executed
evidence_filesRelationOptionalLinked evidence proving the result

Remediation Evidence Fields​

FieldTypeDescription
idIntegerUnique identifier
action_plan_idIntegerParent action plan
evidence_filesRelationLinked 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)