Coflyr · Maintenance framework

Workorder fields by business purpose

Current Maintenance.WorkorderMaster columns grouped for business review.

162 mapped fields, each listed once11 business groupsGenerated 2026-10-05

Workorder · Workpackage · Workorder group

Business group 1

Identity, kind, and numbers

5 fields

#	Field	Model type	Business purpose
1	`Id`	Guid Required	Stable identifier for this record.
2	`EntityType`	WorkorderEntityType Required	Distinguishes a Workorder from a WorkorderGroup record.
3	`WorkorderNo`	string Required	Coflyr business number for the workorder or group.
4	`WorkorderSequence`	int Required	Stores the workorder sequence for this header.
5	`WorkorderType`	string Required	Stores the workorder type for this header.

Business group 2

Source, parent, and reference links

10 fields

#	Field	Model type	Business purpose
1	`ElbReference`	string? Nullable	Electronic logbook or tech-log reference required for Electronic Logbook issue and associated with the TL link.
2	`HeaderReference`	string? Nullable	Stores the header reference for this header.
3	`IssueSource`	string? Nullable	Names the primary source or workflow that issued the record.
4	`IssueSourceRecordId`	Guid? Nullable	Identifies a single issuing source record; the model still retains this link.
5	`IssueSourceReference`	string? Nullable	Human-readable reference for the issuing source.
6	`MetadataExportReference`	string? Nullable	Stores the metadata export reference for this header.
7	`ParentWorkorderId`	Guid? Nullable	Links a workorder to its parent workorder when one exists.
8	`TaskReferenceRemarks`	string? Nullable	Free-text notes about the task reference supplied when issuing the workorder; currently stored but not used by execution rules.
9	`WorkTemplateId`	Guid? Nullable	Selected work template used to prepare work steps.
10	`WorkpackageId`	Guid? Nullable	Links a workorder to its workpackage.

Business group 3

Aircraft, component, and configuration

16 fields

#	Field	Model type	Business purpose
1	`AircraftOperator`	string? Nullable	Stores the aircraft operator for this header.
2	`AircraftRegistration`	string? Nullable	Stores the aircraft registration for this header.
3	`AircraftTailId`	Guid? Nullable	Links to the selected aircraft tail record.
4	`AtaId`	Guid? Nullable	Selects the ata record.
5	`ComponentProductionGroupName`	string? Nullable	Descriptive production group name for the component package.
6	`ConfigurationMasterId`	Guid? Nullable	Selects the configuration master record.
7	`IsRemovedServiceable`	bool Required	Indicates that a serviceable component is being removed from the source aircraft or component.
8	`IsRotable`	bool Required	Indicates that the component is a rotable item.
9	`PartId`	Guid? Nullable	Selects the part record.
10	`RotableId`	Guid? Nullable	Selects the rotable record.
11	`SerialNumber`	string? Nullable	Stores the serial number for this header.
12	`SerialNumberUnknown`	bool Required	Indicates that the component serial or batch number is unknown.
13	`SerialOrBatchNumber`	string Required	Stores the serial or batch number for this header.
14	`StockItemId`	Guid? Nullable	Selects the stock item record.
15	`UnknownPartNumber`	string? Nullable	Stores the unknown part number for this header.
16	`WorkorderAssetType`	WorkpackageAssetType Required	Aircraft or Component context stored for this workorder header.

Business group 4

People, partners, and organizations

19 fields

#	Field	Model type	Business purpose
1	`AccessGroup`	string? Nullable	Stores the access group for this header.
2	`AircraftOperatorPartnerId`	Guid? Nullable	Links to the selected aircraft operator partner record.
3	`ArrivalAirport`	string? Nullable	Stores the arrival airport for this header.
4	`ClosingStation`	string? Nullable	Stores the closing station for this header.
5	`Department`	string? Nullable	Stores the department for this header.
6	`DepartmentId`	Guid? Nullable	Links to the selected department record.
7	`DepartureAirport`	string? Nullable	Stores the departure airport for this header.
8	`FacilityId`	Guid? Nullable	Links to a facility in the internal facility directory.
9	`FacilityReference`	string? Nullable	Human-readable or external facility reference.
10	`FacilityType`	FacilityType? Nullable	Classifies the facility.
11	`FailureConfirmedByStaffId`	Guid? Nullable	Staff member who confirmed the reported failure.
12	`IsCustomerComponent`	bool Required	Records whether customer component applies.
13	`IssueStation`	string? Nullable	Records whether issue station applies.
14	`IssuerSignature`	string? Nullable	Records whether issuer signature applies.
15	`IssuerStaffId`	Guid? Nullable	Links to the selected issuer staff record.
16	`PlannedStation`	string? Nullable	Stores the planned station for this header.
17	`RegulatoryAuthorityBusinessPartnerId`	Guid? Nullable	Business Partner record selected as the regulatory authority.
18	`Responsible`	string? Nullable	Stores the responsible for this header.
19	`ResponsibleStaffId`	Guid? Nullable	Selects the responsible staff record.

Business group 5

Planning, dates, and counters

31 fields

#	Field	Model type	Business purpose
1	`ActManHours`	float? Nullable	Stores the act man hours for this header.
2	`ActualCompletionDate`	DateTime? Nullable	Records the actual completion date.
3	`ActualEndDate`	DateTime? Nullable	Records the actual end date.
4	`ActualStartDate`	DateTime? Nullable	Records the actual start date.
5	`ActualTurnaroundHours`	decimal? Nullable	Records actual turnaround hours for this header.
6	`AdministrativeCloseDate`	DateTime? Nullable	Records the administrative close date.
7	`ClosingDate`	DateTime? Nullable	Records the closing date.
8	`ClosingTAC`	float? Nullable	Stores the closing tac for this header.
9	`ClosingTAH`	TimeSpan? Nullable	Stores the closing tah for this header.
10	`CrsReleaseDate`	DateTime? Nullable	Records the crs release date.
11	`DeliveryDate`	DateTime? Nullable	Records the delivery date.
12	`DueDate`	DateTime Required	Records the due date.
13	`DueTAC`	float? Nullable	Stores the due tac for this header.
14	`DueTAH`	TimeSpan? Nullable	Stores the due tah for this header.
15	`EstManHours`	float? Nullable	Stores the est man hours for this header.
16	`EstimatedGroundTimeHours`	decimal? Nullable	Stores the estimated ground time hours for this header.
17	`FlightArrivalDate`	DateTime? Nullable	Records the flight arrival date.
18	`InactivatedDate`	DateTime? Nullable	Records the inactivated date.
19	`IssueDateTime`	DateTime? Nullable	Records whether issue date time applies.
20	`LastTransferDate`	DateTime? Nullable	Records the last transfer date.
21	`NotPerformedDate`	DateTime? Nullable	Records the not performed date.
22	`OpenedDate`	DateTime? Nullable	Records the opened date.
23	`OtherDue`	float? Nullable	Stores the other due for this header.
24	`PaperworkReceivedDate`	DateTime? Nullable	Records when paperwork received date occurs.
25	`WorkorderPlannedEndDate`	DateTime Required	Planned date and time for completing the workorder.
26	`PlannedOtherDue`	float Required	Stores the planned other due for this header.
27	`PlannedOtherDueUnitId`	Guid? Nullable	Selects the measurement unit for the planned other-due counter.
28	`PlannedStartDate`	DateTime? Nullable	Records the planned start date.
29	`PlannedTAC`	float Required	Stores the planned tac for this header.
30	`PlannedTAH`	TimeSpan Required	Stores the planned tah for this header.
31	`PlannedTurnaroundHours`	decimal? Nullable	Records planned turnaround hours for this header.

Business group 6

Work content, scope, and requirements

12 fields

#	Field	Model type	Business purpose
1	`Classification`	string? Nullable	Stores the classification for this header.
2	`DefectClassification`	string? Nullable	Stores the defect classification for this header.
3	`FailureDescription`	string? Nullable	Stores the failure description for this header.
4	`FeedbackRequest`	bool Required	Records whether feedback request applies.
5	`IsAdministrativeServiceTask`	bool Required	Records whether administrative service task applies.
6	`LastTransferReason`	string? Nullable	Stores the last transfer reason for this header.
7	`ProjectNo`	string? Nullable	Stores the project no for this header.
8	`TechAssistanceRequested`	bool Required	Stores the tech assistance requested for this header.
9	`WorkLevel`	string? Nullable	Stores the work level for this header.
10	`WorkScope`	ShopWorkScope Required	Stores the work scope for this header.
11	`WorkorderDescription`	string? Nullable	Stores the workorder description for this header.
12	`WorkpackageDescription`	string? Nullable	Records workpackage description for this header.

Business group 7

Status, release, and approval

22 fields

#	Field	Model type	Business purpose
1	`ApprovalNo`	string? Nullable	Stores the approval no for this header.
2	`WorkorderApprovalStatus`	WorkorderApprovalStatus? Nullable	Tracks the approval status.
3	`CrsApprovalNumber`	string? Nullable	Stores the crs approval number for this header.
4	`CrsName`	string? Nullable	Stores the crs name for this header.
5	`CrsNumber`	string? Nullable	Stores the crs number for this header.
6	`CrsSignature`	string? Nullable	Stores the crs signature for this header.
7	`FailureConfirmed`	bool Required	Records whether the reported component failure was confirmed.
8	`FailureConfirmedAt`	DateTime? Nullable	Records the failure confirmed at.
9	`IsAdministrativelyClosed`	bool Required	Records whether administratively closed applies.
10	`IsCrsReleased`	bool Required	Records whether crs released applies.
11	`IsInactiveWorkorder`	bool Required	Records whether inactive workorder applies.
12	`IsNotPerformed`	bool Required	Records whether not performed applies.
13	`NotPerformedReason`	string? Nullable	Stores the not performed reason for this header.
14	`ReleaseSign`	string? Nullable	Stores the release sign for this header.
15	`ReleasedToService`	bool Required	Records released to service for this header.
16	`ReturnType`	ComponentReturnType Required	Component return workflow: Open Loop, Closed Loop, or Turnaround.
17	`RoutingStatus`	ComponentRoutingStatus Required	Current movement state as the component travels between shops.
18	`ShopStatus`	ShopWorkOrderStatus Required	Tracks the shop status.
19	`ShopcardCollectionStatus`	ShopcardCollectionStatus Required	Tracks shopcard collection status in the workflow.
20	`WorkPerformedAtIssue`	bool? Nullable	Stores the work performed at issue for this header.
21	`WorkorderStatus`	string Required	Tracks the shared workorder lifecycle code (O/I/C/X).
22	`WorkpackageStatus`	ComponentWorkpackageStatus Required	Tracks the component workpackage production and release lifecycle.

Business group 8

Flight and operational context

15 fields

#	Field	Model type	Business purpose
1	`ArrivalAirportId`	Guid? Nullable	Links to the selected arrival airport record.
2	`DepartureAirportId`	Guid? Nullable	Links to the selected departure airport record.
3	`FlightDepartureDateTime`	DateTime? Nullable	Records when flight departure date time occurs.
4	`FlightLogId`	Guid? Nullable	Selected flight log for the workorder flight context.
5	`FlightNumber`	string? Nullable	Stores the flight number for this header.
6	`HasOperationalConsequence`	bool Required	Records whether operational consequence applies.
7	`IsAccidentRelated`	bool Required	Records whether accident related applies.
8	`IsElbLeading`	bool Required	Records whether elb leading applies.
9	`IsElbWorkorder`	bool Required	Records whether elb workorder applies.
10	`IsIncidentRelated`	bool Required	Records whether incident related applies.
11	`PlannedDepartureDateTime`	DateTime? Nullable	Records when planned departure date time occurs.
12	`RequiresRampActivity`	bool Required	Records whether ramp activity applies.
13	`RequiresTaxi`	bool Required	Records whether taxi applies.
14	`RequiresWeightAndBalance`	bool Required	Records whether weight and balance applies.
15	`ShopArrivalDate`	DateTime? Nullable	Records when shop arrival date occurs.

Business group 9

Commercial and external orders

5 fields

#	Field	Model type	Business purpose
1	`CommercialQuotationReference`	string? Nullable	Quotation reference captured as text while quotation integration is under development.
2	`ExternalWorkorderReference`	string? Nullable	Reference supplied by the external workorder owner or vendor.
3	`ExternalWorkorderType`	ExternalWorkorderNumberType? Nullable	Classifies the external workorder source as Customer, Maintenance Provider, Vendor, or Other.
4	`IsNotContracted`	bool Required	Records whether not contracted applies.
5	`Quantity`	decimal Required	Quantity of parts or units covered by the record.

Business group 10

Special classifications and controls

26 fields

#	Field	Model type	Business purpose
1	`ClosingStationId`	Guid? Nullable	Links to the selected closing station record.
2	`CorrosionLevel`	int? Nullable	Stores the corrosion level for this header.
3	`CriticalEventId`	Guid? Nullable	Associated critical maintenance event.
4	`HandedOverToProduction`	bool Required	Records handed over to production for this header.
5	`HeaderAreaCode`	string? Nullable	Stores the header area code for this header.
6	`HeaderPanelCode`	string? Nullable	Stores the header panel code for this header.
7	`HeaderSpecialCode`	string? Nullable	Stores the header special code for this header.
8	`HeaderZoneCode`	string? Nullable	Stores the header zone code for this header.
9	`IsAogRisky`	bool Required	Records whether aog risky applies.
10	`IsCorrosion`	bool Required	Records whether corrosion applies.
11	`IsCriticalPackage`	bool Required	Indicates whether critical package applies.
12	`IsManagedComponent`	bool Required	Records whether managed component applies.
13	`IsOccurrenceReport`	bool Required	Records whether occurrence report applies.
14	`IsStructuralDamage`	bool Required	Records whether structural damage applies.
15	`IsStructuralRepairItem`	bool Required	Records whether structural repair item applies.
16	`IsWatchItem`	bool Required	Records whether watch item applies.
17	`WorkorderIssueMethod`	WorkorderIssueMethod? Nullable	Records whether issue method applies.
18	`IssueStationId`	Guid? Nullable	Links to the selected issue station record.
19	`PaperworkPending`	bool Required	Records paperwork pending for this header.
20	`PlannedStationId`	Guid? Nullable	Links to the selected planned station record.
21	`PriorityCode`	ComponentWorkpackagePriority? Nullable	Selected component workpackage priority: Very Urgent, Urgent, Normal, Not Urgent, or Nice to Have.
22	`RequiresEngineChange`	bool Required	Records whether engine change applies.
23	`Restricted`	bool Required	Stores the restricted for this header.
24	`WorkorderRoutineCheckType`	WorkorderRoutineCheckType? Nullable	Stores the routine check type for this header.
25	`StationId`	Guid? Nullable	Selects the station from the station lookup.
26	`StationReference`	string? Nullable	Human-readable station reference for the workorder.

Business group 11

Printing, metadata, and audit

1 fields

#	Field	Model type	Business purpose
1	`UpdateId`	Guid? Nullable	Links this record to the prior revision.