Coflyr · Backend model field catalog

SafetyInvestigation

SafetyManagement.SafetyInvestigations.

20 mapped fieldsUnder development5 field groupsGenerated 2026-10-06

Model class: coflyr.models.safety.SafetyInvestigation
Source: Features/Safety/Reporting/Models/SafetyReport.cs
Table: SafetyManagement.SafetyInvestigations
Review: Under development as of 2026-10-07. Field review remains open.

Every mapped scalar field appears once. Types and nullability come from the current EF model snapshot. Navigation properties and unmapped DTO fields are outside this page. Purpose text is inferred from names and should be checked against the feature workflow.

← All model classes · AMOS Workpackage example

Identity and naming

2 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`InvestigationNumber`	`string`	Required	Records investigation number for this safety investigation.

Relationships and references

4 fields

#	Field	EF type	Storage	Business purpose
1	`IndependentReviewerStaffMemberId`	`Guid?`	Nullable	Selects the related independent reviewer staff member record.
2	`LeadInvestigatorStaffMemberId`	`Guid?`	Nullable	Selects the related lead investigator staff member record.
3	`SafetyReportId`	`Guid`	Required	Selects the related safety report record.
4	`SafetyScopeId`	`Guid`	Required	Selects the related safety scope record.

Status and controls

1 fields

#	Field	EF type	Storage	Business purpose
1	`LegalHold`	`bool`	Required	Indicates whether legal hold applies to this safety investigation.

Audit and revision

2 fields

#	Field	EF type	Storage	Business purpose
1	`SystemAuditId`	`Guid?`	Nullable	Links to system audit history when this model stores the reference.
2	`UpdateId`	`Guid?`	Nullable	Links to the preceding revision or update record.

Other fields

11 fields

#	Field	EF type	Storage	Business purpose
1	`CompletedAt`	`DateTimeOffset?`	Nullable	Records the completed at for this safety investigation.
2	`ContributingFactors`	`string`	Nullable	Records contributing factors for this safety investigation.
3	`FactualSummary`	`string`	Nullable	Records factual summary for this safety investigation.
4	`InvestigationState`	`int`	Required	Records investigation state for this safety investigation.
5	`MethodCode`	`string`	Nullable	Records method code for this safety investigation.
6	`OpenedAt`	`DateTimeOffset?`	Nullable	Records the opened at for this safety investigation.
7	`RecommendationSummary`	`string`	Nullable	Records recommendation summary for this safety investigation.
8	`RetainUntil`	`DateTimeOffset?`	Nullable	Records retain until for this safety investigation.
9	`RetentionCategory`	`string`	Nullable	Records retention category for this safety investigation.
10	`RowVersion` DB: xmin	`uint`	Required	Records row version for this safety investigation.
11	`SafetyConclusion`	`string`	Nullable	Records safety conclusion for this safety investigation.