Coflyr · Backend model field catalog

TechnicalDelayRecord

public.TechnicalDelayRecords.

37 mapped fields8 field groupsGenerated 2026-10-06

Model class: coflyr.features.maintenancecontrol.delays.models.TechnicalDelayRecord
Source: Features/MaintenanceControl/Delays/Models/TechnicalDelayRecord.cs
Table: public.TechnicalDelayRecords
Review: Not marked

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

4 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`DelayRecordNumber`	`string`	Required	Records delay record number for this technical delay record.
3	`FlightNumber`	`string`	Required	Records flight number for this technical delay record.
4	`MaintenanceControlEventNumber`	`string`	Nullable	Records maintenance control event number for this technical delay record.

Relationships and references

5 fields

#	Field	EF type	Storage	Business purpose
1	`AircraftTailId`	`Guid`	Required	Selects the related aircraft tail record.
2	`AtaId`	`Guid?`	Nullable	Selects the related ata record.
3	`DeferredDefectRecordId`	`Guid?`	Nullable	Selects the related deferred defect record record.
4	`ExternalOpsRecordId`	`string`	Nullable	Selects the related external ops record record.
5	`WorkorderId`	`Guid?`	Nullable	Selects the related workorder record.

Status and controls

9 fields

#	Field	EF type	Storage	Business purpose
1	`AetDifferenceDetected`	`bool`	Required	Indicates whether aet difference detected applies to this technical delay record.
2	`FlightPerformed`	`bool`	Required	Indicates whether flight performed applies to this technical delay record.
3	`IsAog`	`bool`	Required	Indicates whether aog applies to this technical delay record.
4	`IsAvoidable`	`bool`	Required	Indicates whether avoidable applies to this technical delay record.
5	`IsChargeable`	`bool`	Required	Indicates whether chargeable applies to this technical delay record.
6	`IsInitial`	`bool`	Required	Indicates whether initial applies to this technical delay record.
7	`IsManuallyChanged`	`bool`	Required	Indicates whether manually changed applies to this technical delay record.
8	`ReviewStatus`	`int`	Required	Tracks the review status of this technical delay record.
9	`UseForStatistics`	`bool`	Required	Indicates whether use for statistics applies to this technical delay record.

Dates and timing

1 fields

#	Field	EF type	Storage	Business purpose
1	`DelayDate`	`DateTime`	Required	Records the delay date for this technical delay record.

Amounts and measurements

1 fields

#	Field	EF type	Storage	Business purpose
1	`DelayDurationMinutes`	`int`	Required	Records delay duration minutes for this technical delay record.

Descriptions and details

4 fields

#	Field	EF type	Storage	Business purpose
1	`ConsequenceReasonCode`	`string`	Nullable	Records consequence reason code for this technical delay record.
2	`ConsequenceReasonGroupCode`	`string`	Nullable	Records consequence reason group code for this technical delay record.
3	`OperationalDescription`	`string`	Nullable	Records operational description for this technical delay record.
4	`RootCauseDescription`	`string`	Nullable	Records root cause description for this technical delay record.

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	`ArrivalAirportCode`	`string`	Nullable	Records arrival airport code for this technical delay record.
2	`CorrectiveActionTaken`	`string`	Nullable	Records corrective action taken for this technical delay record.
3	`DefectSummary`	`string`	Required	Records defect summary for this technical delay record.
4	`DelayCategory`	`int`	Required	Records delay category for this technical delay record.
5	`DepartureAirportCode`	`string`	Nullable	Records departure airport code for this technical delay record.
6	`DepartureAt`	`DateTime?`	Nullable	Records the departure at for this technical delay record.
7	`EventInformation`	`string`	Nullable	Records event information for this technical delay record.
8	`ExternalOpsState`	`int`	Required	Records external ops state for this technical delay record.
9	`ExternalOpsSystemCode`	`string`	Nullable	Records external ops system code for this technical delay record.
10	`InterruptionCode`	`string`	Nullable	Records interruption code for this technical delay record.
11	`StationCode`	`string`	Required	Records station code for this technical delay record.