Coflyr · Backend model field catalog

SafetyReport

SafetyManagement.SafetyReports.

41 mapped fieldsUnder development7 field groupsGenerated 2026-10-06

Model class: coflyr.models.safety.SafetyReport
Source: Features/Safety/Reporting/Models/SafetyReport.cs
Table: SafetyManagement.SafetyReports
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

3 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`ReportNumber`	`string`	Required	Records report number for this safety report.
3	`Title`	`string`	Required	Records title for this safety report.

Relationships and references

12 fields

#	Field	EF type	Storage	Business purpose
1	`AircraftTailId`	`Guid?`	Nullable	Selects the related aircraft tail record.
2	`AtaId`	`Guid?`	Nullable	Selects the related ata record.
3	`DefectDamageReportId`	`Guid?`	Nullable	Selects the related defect damage report record.
4	`DuplicateOfReportId`	`Guid?`	Nullable	Selects the related duplicate of report record.
5	`FacilityId`	`Guid?`	Nullable	Selects the related facility record.
6	`FlightLogId`	`Guid?`	Nullable	Selects the related flight log record.
7	`InvestigatorStaffMemberId`	`Guid?`	Nullable	Selects the related investigator staff member record.
8	`MaintenanceControlEventId`	`Guid?`	Nullable	Selects the related maintenance control event record.
9	`SafetyScopeId`	`Guid`	Required	Selects the related safety scope record.
10	`SourceOccurrenceReference`	`string`	Nullable	Records source occurrence reference for this safety report.
11	`TechnicalCaseManagerId`	`Guid?`	Nullable	Selects the related technical case manager record.
12	`WorkorderMasterId`	`Guid?`	Nullable	Selects the related workorder master record.

Status and controls

1 fields

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

Dates and timing

1 fields

#	Field	EF type	Storage	Business purpose
1	`OccurrenceTimeZone`	`string`	Nullable	Records the occurrence time zone for this safety report.

Descriptions and details

1 fields

#	Field	EF type	Storage	Business purpose
1	`DispositionReason`	`string`	Nullable	Records disposition reason for this safety report.

Audit and revision

4 fields

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

Other fields

19 fields

#	Field	EF type	Storage	Business purpose
1	`CategoryCode`	`string`	Nullable	Records category code for this safety report.
2	`Channel`	`int`	Required	Records channel for this safety report.
3	`ClosedAt`	`DateTimeOffset?`	Nullable	Records the closed at for this safety report.
4	`CommunicationMediumCode`	`string`	Nullable	Records communication medium code for this safety report.
5	`Confidentiality`	`int`	Required	Records confidentiality for this safety report.
6	`ImmediateContainment`	`string`	Nullable	Records immediate containment for this safety report.
7	`InvestigationConclusion`	`string`	Nullable	Records investigation conclusion for this safety report.
8	`Narrative`	`string`	Required	Records narrative for this safety report.
9	`OccurredAt`	`DateTimeOffset?`	Nullable	Records the occurred at for this safety report.
10	`ReceivedAt`	`DateTimeOffset?`	Nullable	Records the received at for this safety report.
11	`ReportState`	`int`	Required	Records report state for this safety report.
12	`ReporterFeedback`	`string`	Nullable	Records reporter feedback for this safety report.
13	`RetainUntil`	`DateTimeOffset?`	Nullable	Records retain until for this safety report.
14	`RetentionCategory`	`string`	Nullable	Records retention category for this safety report.
15	`RowVersion` DB: xmin	`uint`	Required	Records row version for this safety report.
16	`SourceCreatedAt`	`DateTimeOffset?`	Nullable	Records the source created at for this safety report.
17	`SourceSystemCode`	`string`	Nullable	Records source system code for this safety report.
18	`SubmissionKey`	`string`	Nullable	Records submission key for this safety report.
19	`TaxonomyVersion`	`string`	Nullable	Records taxonomy version for this safety report.