Field Reference — Reporting

Report Fields

Field	Type	Required	Description
id	Integer	Auto	Unique identifier
engagement_id	Integer	Optional	Parent engagement (null for portfolio reports)
title	String	✅	Report title
template_id	Integer	Optional	Report template reference
template_version	Integer	Optional	Template version used
cover_title	String	Optional	Cover page title
cover_date	String	Optional	Cover page date
confidentiality_level	String	Auto	Default: "Confidential"
executive_summary	Text	Optional	Executive summary narrative
introduction	Text	Optional	Introduction section
objectives	JSON Array	Optional	List of audit objectives
scope	Text	Optional	Scope description
overall_rating	String	Optional	Satisfactory / Needs Improvement / Unsatisfactory
sections_json	JSON Array	Optional	Custom sections structure
conclusion	Text	Optional	Conclusion narrative
status	String	Auto	DRAFT, REVIEW, APPROVED, ISSUED
created_at	DateTime	Auto	Creation timestamp
generated_at	DateTime	Auto	When AI generated content
exported_at	DateTime	Auto	Last PDF export time
issued_at	DateTime	Auto	When officially issued

Report Version Fields

Field	Type	Description
id	Integer	Unique identifier
report_id	Integer	Parent report
version_number	Integer	Sequential version
content_snapshot	String	Full content snapshot (JSON/HTML)
created_at	DateTime	Version creation time
created_by_id	String	User who created the version

Report Approval Fields

Field	Type	Description
id	Integer	Unique identifier
report_id	Integer	Parent report
approver_id	String	Approver user ID
role	String	Approver role (CAE, Manager)
status	String	PENDING, APPROVED, REJECTED
approved_at	DateTime	Decision timestamp
comments	String	Approval/rejection comments

Status Transitions

DRAFT → REVIEW → APPROVED → ISSUED
         ↑          |
         └── (rejected/revisions)