Skip to main content
Version: 1.0.0-beta

Field Reference — Fieldwork

Complete reference for all fields in the Fieldwork module.

Workpaper Fields​

FieldTypeRequiredDescription
idIntegerAutoUnique identifier
engagement_idInteger✅Parent engagement
titleString✅Workpaper title
contentTextOptionalFree-form content/narrative
statusStringAutoDRAFT, IN_REVIEW, REVIEWED
preparer_idString✅User who created the workpaper
reviewer_idStringOptionalAssigned reviewer

Test Procedure Fields​

FieldTypeRequiredDescription
idIntegerAutoUnique identifier
workpaper_idInteger✅Parent workpaper
descriptionString✅Test procedure steps
result_summaryStringOptionalTest outcome
is_key_controlBooleanOptionalKey control flag (default: false)
engagement_control_idIntegerOptionalLinked engagement control
ai_execution_idStringOptionalAI execution reference

Evidence Fields​

FieldTypeRequiredDescription
idIntegerAutoUnique identifier
filenameString✅Original filename
s3_keyStringAutoMinIO storage key
mime_typeStringAutoFile MIME type
size_bytesIntegerAutoFile size
hash_sha256StringAutoSHA-256 integrity hash
uploaded_by_idStringAutoUploader
uploaded_atDateTimeAutoUpload timestamp
scan_statusStringAutoPENDING, CLEAN, INFECTED
workpaper_idIntegerOptionalLinked workpaper
engagement_idIntegerOptionalParent engagement

Review Point Fields​

FieldTypeRequiredDescription
idIntegerAutoUnique identifier
workpaper_idInteger✅Parent workpaper
commentString✅Review comment text
author_idStringAutoReviewer who created the point
statusStringAutoOPEN, RESOLVED
created_atDateTimeAutoWhen the comment was made
resolved_atDateTimeAutoWhen it was resolved

Signoff Fields​

FieldTypeRequiredDescription
idIntegerAutoUnique identifier
workpaper_idInteger✅Parent workpaper
user_idString✅User who signed off
roleString✅Preparer or Reviewer
signed_atDateTimeAutoSignoff timestamp

Workpaper Version Fields​

FieldTypeDescription
idIntegerUnique identifier
workpaper_idIntegerParent workpaper
version_numberIntegerSequential version number
content_snapshotJSONFull workpaper content at this version
created_atDateTimeVersion creation timestamp
created_by_idStringUser who created the version
change_summaryStringOptional description of what changed

Status Transitions​

Workpaper Status​

DRAFT → IN_REVIEW → REVIEWED
↑ |
└── (comments unresolved)

Review Point Status​

OPEN → RESOLVED