Version: 1.0.0-beta

Field Reference — Fieldwork

Complete reference for all fields in the Fieldwork module.

Workpaper Fields

Field	Type	Required	Description
`id`	Integer	Auto	Unique identifier
`engagement_id`	Integer	✅	Parent engagement
`title`	String	✅	Workpaper title
`content`	Text	Optional	Free-form content/narrative
`status`	String	Auto	`DRAFT`, `IN_REVIEW`, `REVIEWED`
`preparer_id`	String	✅	User who created the workpaper
`reviewer_id`	String	Optional	Assigned reviewer

Field	Type	Required	Description
`id`	Integer	Auto	Unique identifier
`workpaper_id`	Integer	✅	Parent workpaper
`description`	String	✅	Test procedure steps
`result_summary`	String	Optional	Test outcome
`is_key_control`	Boolean	Optional	Key control flag (default: false)
`engagement_control_id`	Integer	Optional	Linked engagement control
`ai_execution_id`	String	Optional	AI execution reference

Field	Type	Required	Description
`id`	Integer	Auto	Unique identifier
`filename`	String	✅	Original filename
`s3_key`	String	Auto	MinIO storage key
`mime_type`	String	Auto	File MIME type
`size_bytes`	Integer	Auto	File size
`hash_sha256`	String	Auto	SHA-256 integrity hash
`uploaded_by_id`	String	Auto	Uploader
`uploaded_at`	DateTime	Auto	Upload timestamp
`scan_status`	String	Auto	`PENDING`, `CLEAN`, `INFECTED`
`workpaper_id`	Integer	Optional	Linked workpaper
`engagement_id`	Integer	Optional	Parent engagement

Field	Type	Required	Description
`id`	Integer	Auto	Unique identifier
`workpaper_id`	Integer	✅	Parent workpaper
`comment`	String	✅	Review comment text
`author_id`	String	Auto	Reviewer who created the point
`status`	String	Auto	`OPEN`, `RESOLVED`
`created_at`	DateTime	Auto	When the comment was made
`resolved_at`	DateTime	Auto	When it was resolved

Field	Type	Required	Description
`id`	Integer	Auto	Unique identifier
`workpaper_id`	Integer	✅	Parent workpaper
`user_id`	String	✅	User who signed off
`role`	String	✅	`Preparer` or `Reviewer`
`signed_at`	DateTime	Auto	Signoff timestamp

Field	Type	Description
`id`	Integer	Unique identifier
`workpaper_id`	Integer	Parent workpaper
`version_number`	Integer	Sequential version number
`content_snapshot`	JSON	Full workpaper content at this version
`created_at`	DateTime	Version creation timestamp
`created_by_id`	String	User who created the version
`change_summary`	String	Optional description of what changed

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

OPEN → RESOLVED