Coflyr · Header consolidation review
WorkorderMaster
Renamed from WorkpackageOrder; previously reviewed as Workorder. One work header model for parent and child workorders.
Reviewed · HTML proposal. Legacy WorkpackageMaster and former WorkorderMaster definitions are Deprecated. Parent WorkorderMaster rows perform the package role; child rows link through ParentWorkorderId. Backend and physical database adoption remain pending implementation.
Model index · Parent/child design and adoption
139 proposed unified fields73 dropped fields retained for review9 fields reviewedCurrent backend: 110 common + 71 package + 53 order table columns
Parent and child ownership
WorkorderMaster (parent, ParentWorkorderId = null)
└─ WorkorderMaster (child, ParentWorkorderId = parent.Id)
└─ WorkStepParent and child rows have distinct IDs, numbers, status, dates, asset context and approval values. Planning, collection, handover, closure and release operate on the parent scope; executable tasks and WorkSteps belong to children. Parent closure must account for all children.
Field review inventory
Prior rename, merge and removal decisions are retained. Dropped fields stay visible with their types, source definitions and review decisions; they are excluded from the proposed unified field count. Remaining source fields are carried forward for continued review; this inventory is not a verified deployed schema count. ComponentPartNumber is replaced by PartId; WorkorderRoutineCheckType remains Dropped; WorkpackageId is replaced by ParentWorkorderId membership.
| Field | Proposed type | Nullability | Purpose | Source definitions | Review decision |
|---|---|---|---|---|---|
AccessGroupDemartment | String | Nullable | Access-group/department label for the owning header. The text alone does not enforce access permissions. | WorkorderMaster.AccessGroup | Reviewed |
ActManHours | Single? | Nullable | Recorded actual maintenance labor hours for the owning header. | WorkpackageOrder.ActManHours | Reviewed |
ActualCompletionDate | DateTime? | Nullable | Recorded completion date and time for the owning header. | WorkpackageOrder.ActualCompletionDate | Reviewed |
ActualEndDate | DateTime? | Nullable | Actual end date and time of work for the owning header. | WorkpackageOrder.ActualEndDate | Reviewed |
ActualStartDate | DateTime? | Nullable | Actual start date and time of work for the owning header. | WorkpackageOrder.ActualStartDate | Reviewed |
ActualTurnaroundHours | Decimal? | Nullable | Recorded actual turnaround duration in hours for the owning maintenance header. | WorkpackageOrder.ActualTurnaroundHours | Reviewed |
AdministrativeCloseDate | DateTime? | Nullable | Date and time the owning header was administratively closed. | WorkpackageOrder.AdministrativeCloseDate | Reviewed |
AircraftDetails | String | Nullable | Aircraft details text for the owning header, renamed from AircraftOperator. Preserve existing text values during implementation. | WorkorderMaster.AircraftOperator | Rename pending complete review |
AircraftOperatorPartnerId | Guid? | Nullable | Lookup to the aircraft operator BusinessPartner for the owning header; move AircraftOperatorPartner relationship with this ID. | WorkorderMaster.AircraftOperatorPartnerId | Move pending complete review |
AircraftPosition | String | Nullable | Replace this free-text field with ConfigurationMasterId and ConfigurationId UUID lookups in unified WorkorderMaster. ConfigurationId selects a functional position belonging to the selected configuration master. Resolve existing text through an explicit mapping during later implementation; backend and DB changes remain deferred. | WorkpackageMaster.AircraftPosition | Dropped |
AircraftRegistration | String | Nullable | Drop the stored registration text from unified WorkorderMaster. Use the existing AircraftTailId aircraft lookup for identification. Backend/database removal pending complete review. | WorkorderMaster.AircraftRegistration | Dropped |
AircraftTailId | Guid? | Nullable | Lookup to AircraftTail for the owning header; move the AircraftTail relationship with this ID. | WorkorderMaster.AircraftTailId | Move pending complete review |
ApprovalNo | String | Nullable | Single shared nullable approval-number field replacing the duplicate WorkorderMaster and WorkpackageMaster property definitions. Each owning package/order keeps its own approval value in its own WorkpackageOrder row. | WorkorderMaster.ApprovalNo, WorkpackageMaster.ApprovalNo | Merge and move pending complete review |
ApprovalRequestedDate | DateTime? | Nullable | Carry the existing ApprovalRequestedDate field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageMaster.ApprovalRequestedDate | Carry forward; detailed semantics pending review |
ApprovalRequestedStaffId | Guid? | Nullable | Nullable UUID lookup to StaffMember who requested approval for the owning work header. Replaces the free-text ApprovalRequestedBy field; display the selected staff member's code/name. Reconcile existing requester text to staff records during later implementation. | WorkpackageMaster.ApprovalRequestedBy | Replace with staff lookup; backend / DB adoption pending |
ArrivalAirportId | Guid? | Nullable | Nullable UUID lookup to AirportCodeMaster for the arrival airport of the owning work header. Replaces free-text ArrivalAirport and merges with the existing ArrivalAirportId lookup; display the selected airport code/name through ArrivalAirportReference. Reconcile legacy airport text and any differing existing ID before later backend/database adoption. | WorkpackageOrder.ArrivalAirport, WorkorderMaster.ArrivalAirportId | Reviewed |
AssignedTechnicianStaffId | Guid? | Nullable | Assigned technician staff lookup for the owning work header; move its lookup relationship with this ID. Each owning package/order retains its own value. | WorkpackageMaster.AssignedTechnicianStaffId | Move pending complete review |
AtaChapterStd | String | Nullable | Drop AtaChapterStd from the unified WorkorderMaster proposal; backend/database removal deferred until complete project review. | WorkpackageMaster.AtaChapterStd | Dropped |
AtaId | Guid? | Nullable | Carry the existing AtaId field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.AtaId | Reviewed |
AutoGenerated | Boolean | Required | Provide a Generate workorder number button beside WorkorderNo. Clicking it requests a number from the shared numbering service and inserts the generated value into WorkorderNo. This is a UI action proposal; frontend/backend implementation and the final disposition of the existing AutoGenerated Boolean remain pending complete review. | WorkpackageMaster.AutoGenerated | Create button to insert autogenerated workorder number; implementation pending |
Classification | WorkorderClassification? { Unspecified, HeavyBaseMaintenance, LineMaintenance, Hidden, LightMaintenance } | Nullable | Shared maintenance classification for the owning package/order. Use the existing aircraft-package categories; preserve legacy labels Unspecified, Heavy/Base Maint., Line Maint., Hidden and Light Maint. when mapping existing records. | WorkpackageMaster.Classification, WorkorderMaster.Classification | Move and enum conversion pending complete review |
ClosingDate | DateTime? | Nullable | Carry the existing ClosingDate field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.ClosingDate | Carry forward; detailed semantics pending review |
ClosingStation | String | Nullable | Drop ClosingStation from the unified WorkorderMaster HTML proposal; backend/database removal deferred until complete project review. | WorkpackageOrder.ClosingStation | Dropped |
ClosingStationId | Guid? | Nullable | Closing station lookup for the owning header; move ClosingStationReference with this ID. | WorkorderMaster.ClosingStationId | Move pending complete review |
ClosingTAC | Single? | Nullable | Carry the existing ClosingTAC field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.ClosingTAC | Carry forward; detailed semantics pending review |
ClosingTAH | TimeSpan? | Nullable | Carry the existing ClosingTAH field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.ClosingTAH | Carry forward; detailed semantics pending review |
CommercialQuotationReference | String | Nullable | Carry the existing CommercialQuotationReference field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.CommercialQuotationReference | Carry forward; detailed semantics pending review |
ComplyWithMaintenanceTaskId | Guid? | Nullable | Nullable UUID lookup to MaintenanceTask identifying the particular maintenance task this workorder is intended to comply with. Select through a searchable dropdown showing TaskCode and TaskTitle, filtered to tasks applicable to the selected aircraft/component and maintenance programme where available. Replaces InitialDueAircraftType, InitialDueCheckOnlyActive and InitialDueCheckType; aircraft-type and eligibility filters belong to the lookup rather than stored header fields. Null means no maintenance-task compliance link. Selection establishes the task reference only; asset-specific due-limit resolution and recording task compliance on completion require separately reviewed implementation. Reconcile legacy check/type text to real task records before backend/database adoption; do not assign a task from text alone. | WorkpackageMaster.InitialDueAircraftType, WorkpackageMaster.InitialDueCheckOnlyActive, WorkpackageMaster.InitialDueCheckType | Replace initial-due fields with maintenance-task dropdown lookup; backend / DB adoption pending |
ConfigurationId | Guid? | Nullable | UUID lookup to Configuration selecting the functional position within the chosen configuration master. Replaces free-text AircraftPosition. A selected position requires ConfigurationMasterId and must belong to that master; display its functional position code and name. | WorkpackageMaster.AircraftPosition | Replace AircraftPosition; backend / DB adoption pending |
ConfigurationMasterId | Guid? | Nullable | UUID lookup to ConfigurationMaster defining the configuration context for the owning work header. Reuse the existing master lookup with ConfigurationId instead of free-text AircraftPosition. When a position is selected, its master must match this lookup. | WorkpackageOrder.ConfigurationMasterId | Lookup; backend / DB adoption pending |
CorrosionLevel | Int32? | Nullable | Remove CorrosionLevel from the work header proposal and define it on CriticalEvent instead. Backend/database adoption deferred until complete project review. | WorkpackageOrder.CorrosionLevel | Dropped Moved to CriticalEvent.CorrosionLevel |
CriticalEventId | Guid? | Nullable | Carry the existing CriticalEventId field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.CriticalEventId | Carry forward; detailed semantics pending review |
CrsApprovalNumber | String | Nullable | Drop CrsApprovalNumber from the unified WorkorderMaster HTML proposal; backend/database removal deferred until complete project review. | WorkpackageOrder.CrsApprovalNumber | Dropped |
CrsName | String | Nullable | Drop CrsName from the unified WorkorderMaster HTML proposal; backend/database removal deferred until complete project review. | WorkpackageOrder.CrsName | Dropped |
CrsNumber | String | Nullable | Drop CrsNumber from the unified WorkorderMaster HTML proposal; backend/database removal deferred until complete project review. | WorkpackageOrder.CrsNumber | Dropped |
CrsReleaseDate | DateTime? | Nullable | Drop CrsReleaseDate from the unified WorkorderMaster HTML proposal; backend/database removal deferred until complete project review. | WorkpackageOrder.CrsReleaseDate | Dropped |
CrsSignature | String | Nullable | Drop CrsSignature from the unified WorkorderMaster HTML proposal; backend/database removal deferred until complete project review. | WorkpackageOrder.CrsSignature | Dropped |
DefectClassification | String | Nullable | Drop DefectClassification from the unified WorkorderMaster HTML proposal; backend/database removal deferred until complete project review. | WorkpackageOrder.DefectClassification | Dropped |
DeliveryDate | DateTime? | Nullable | Carry the existing DeliveryDate field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.DeliveryDate | Carry forward; detailed semantics pending review |
Department | String | Nullable | Drop Department from the unified WorkorderMaster HTML proposal; backend/database removal deferred until complete project review. | WorkpackageMaster.Department, WorkorderMaster.Department | Dropped |
DepartmentId | Guid? | Nullable | Drop DepartmentId from the unified WorkorderMaster HTML proposal; backend/database removal deferred until complete project review. | WorkpackageMaster.DepartmentId, WorkorderMaster.DepartmentId | Dropped |
DepartureAirport | String | Nullable | Drop DepartureAirport from the unified WorkorderMaster HTML proposal; backend/database removal deferred until complete project review. | WorkpackageOrder.DepartureAirport | Dropped |
DepartureAirportId | Guid? | Nullable | Departure airport lookup for the owning header; move DepartureAirportReference with this ID. | WorkorderMaster.DepartureAirportId | Move pending complete review |
DueDate | DateTime | Required | Carry the existing DueDate field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.DueDate | Carry forward; detailed semantics pending review |
DueTAC | Single? | Nullable | Carry the existing DueTAC field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.DueTAC | Carry forward; detailed semantics pending review |
DueTAH | TimeSpan? | Nullable | Carry the existing DueTAH field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.DueTAH | Carry forward; detailed semantics pending review |
ElbReference | String | Nullable | Drop ElbReference from the unified WorkorderMaster HTML proposal. Backend/database removal remains deferred until complete project review. | WorkpackageOrder.ElbReference | Dropped |
EntityType | WorkorderEntityType { Workpackage, Group, Workorder } | Required | Current record-kind enum retained for review. During implementation, use an explicit parent/executable role and map legacy package/group/order values; do not infer the role solely from whether children currently exist. | WorkorderMaster.EntityType | Carry forward; detailed semantics pending review |
EstManHours | Single? | Nullable | Carry the existing EstManHours field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.EstManHours | Carry forward; detailed semantics pending review |
EstimatedEndDate | DateTime? | Nullable | Estimated completion date/time for the owning work header. Each package/order retains its own value. | WorkpackageMaster.EstimatedEndDate | Move pending complete review |
EstimatedGroundTimeHours | Decimal? | Nullable | Carry the existing EstimatedGroundTimeHours field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.EstimatedGroundTimeHours | Carry forward; detailed semantics pending review |
EstimatedStartDate | DateTime? | Nullable | Estimated start date/time for the owning work header. Each package/order retains its own value. | WorkpackageMaster.EstimatedStartDate | Move pending complete review |
ExternalWorkNumber | String | Nullable | External/customer-provided work number for the owning work header. Renamed from CustomerWorkpackageNumber; preserve existing nullable text values during later adoption. | WorkpackageMaster.CustomerWorkpackageNumber | Rename pending complete review |
ExternalWorkReference | String | Nullable | External work reference for the owning work header; remains independent of the generated internal workorder number. Backend/database rename pending complete review. | WorkorderMaster.ExternalWorkorderReference | Renamed from ExternalWorkorderReference · implementation pending |
ExternalWorkType | ExternalWorkorderNumberType? { Customer, MaintenanceProvider, Vendor, Other } | Nullable | Nullable classification of the external work reference: Customer, MaintenanceProvider, Vendor or Other. Renamed from ExternalWorkorderNoType. Backend/database rename pending complete review. | WorkpackageMaster.ExternalWorkorderNoType | Renamed from ExternalWorkorderNoType · implementation pending |
ExternalWorkorderNo | String | Nullable | Drop ExternalWorkorderNo from the unified WorkorderMaster HTML proposal. Backend/database removal pending complete project review. | WorkpackageMaster.ExternalWorkorderNo | Dropped |
ExternalWorkorderType | ExternalWorkorderNumberType? { Customer, MaintenanceProvider, Vendor, Other } | Nullable | Drop ExternalWorkorderType from the unified WorkorderMaster HTML proposal. Backend/database removal pending complete project review. | WorkorderMaster.ExternalWorkorderType | Dropped |
ExternalWorkpackageNumber | String | Nullable | Drop ExternalWorkpackageNumber from the unified WorkorderMaster HTML proposal. Backend/database removal pending complete project review. | WorkpackageMaster.ExternalWorkpackageNumber | Dropped |
ExternalWorkpackageNumberType | ExternalWorkpackageNumberType? { Customer, MaintenanceProvider, Vendor, Other, Shop } | Nullable | Drop ExternalWorkpackageNumberType from the unified WorkorderMaster HTML proposal. Backend/database removal pending complete project review. | WorkpackageMaster.ExternalWorkpackageNumberType | Dropped |
FacilityId | Guid? | Nullable | Lookup to Facility. The shared relationship uses Restrict on deletion, retaining the existing package rule. | WorkpackageOrder.FacilityId | Carry forward; detailed semantics pending review |
FacilityReference | String | Nullable | Carry the existing FacilityReference field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.FacilityReference | Carry forward; detailed semantics pending review |
FacilityType | FacilityType? { Hangar, Workshop, Warehouse, Office, Apron, Gate, TrainingCentre, Administrative, Classroom, SimulationCentre, TrainingRoom, MeetingRoom, Other } | Nullable | Carry the existing FacilityType field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.FacilityType | Carry forward; detailed semantics pending review |
FailureConfirmed | Boolean | Required | Use a valid WorkStep FailureConfirmation execution entry as confirmation evidence; remove the independently editable Boolean and preserve unresolved historical flags. HTML review decision; backend / database adoption pending complete review. | WorkpackageOrder.FailureConfirmed | Dropped Moved to WorkStep.EntryType |
FailureConfirmedAt | DateTime? | Nullable | Remove FailureConfirmedAt as a separate WorkStep field. Reuse ActionEndDate on a dedicated FailureConfirmation execution entry linked to the owning WorkStep. Preserve who confirmed the failure and when without overwriting the executable step, allocation or certification records. Backend/database adoption deferred. | WorkpackageOrder.FailureConfirmedAt | Dropped Moved to WorkStep.FailureConfirmedAt |
FailureConfirmedByStaffId | Guid? | Nullable | Remove FailureConfirmedByStaffId as a separate WorkStep field. Reuse StaffMemberId on a dedicated FailureConfirmation execution entry linked to the owning WorkStep. Preserve who confirmed the failure and when without overwriting the executable step, allocation or certification records. Backend/database adoption deferred. | WorkpackageOrder.FailureConfirmedByStaffId | Dropped Moved to WorkStep.FailureConfirmedByStaffId |
FailureDescription | String | Nullable | Remove FailureDescription as a separate WorkStep field. Reuse ActionText on the linked FailureConfirmation entry, preserving legacy failure text and the main step instructions. Backend/database adoption deferred. | WorkpackageOrder.FailureDescription | Dropped Moved to WorkStep.FailureDescription |
FeedbackRequest | Boolean | Required | Requests feedback from the flight or cabin crew about this workorder, for example whether an intermittent fault recurs after maintenance. True means feedback is requested; false means no feedback request, and is the default. Required Boolean means a true/false value is stored, not that every workorder requires feedback. This records the request only; it does not indicate that feedback was received or that a failure was confirmed or resolved. The issue-form checkbox saves this flag. Dedicated notification, response tracking and closure validation tied to this flag were not found in the current implementation. | WorkpackageOrder.FeedbackRequest | Purpose clarified; field review pending |
FinancialProjectReference | String | Nullable | Financial project reference for the owning work header. Each owning package/order retains its own value. | WorkpackageMaster.FinancialProjectReference | Move pending complete review |
FlightArrivalDate | DateTime? | Nullable | Carry the existing FlightArrivalDate field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.FlightArrivalDate | Carry forward; detailed semantics pending review |
FlightDateTime | DateTime? | Nullable | Associated flight date/time for the owning work header; retain existing flight-link/snapshot review decisions for implementation. Each package/order retains its own value. | WorkpackageMaster.FlightDateTime | Move pending complete review |
FlightDepartureDateTime | DateTime? | Nullable | Flight departure date/time for the owning header. | WorkorderMaster.FlightDepartureDateTime | Move pending complete review |
FlightLogId | Guid? | Nullable | Carry the existing FlightLogId field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.FlightLogId | Carry forward; detailed semantics pending review |
FlightNumber | String | Nullable | Carry the existing FlightNumber field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.FlightNumber | Carry forward; detailed semantics pending review |
HandedOverToProduction | Boolean | Required | Whether the owning header has been handed over to production. Each package/order keeps its own value. | WorkpackageMaster.HandedOverToProduction, WorkorderMaster.HandedOverToProduction | Move pending complete review |
HasOperationalConsequence | Boolean | Required | Carry the existing HasOperationalConsequence field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.HasOperationalConsequence | Carry forward; detailed semantics pending review |
HeaderAreaCode | String | Nullable | Drop HeaderAreaCode from WorkorderMaster and move/merge it into WorkStep.HeaderAreaCode. Backend/database changes pending complete review. | WorkpackageOrder.HeaderAreaCode | Dropped Moved to WorkStep.HeaderAreaCode |
HeaderPanelCode | String | Nullable | Drop HeaderPanelCode from WorkorderMaster and move/merge it into WorkStep.HeaderPanelCode. Backend/database changes pending complete review. | WorkpackageOrder.HeaderPanelCode | Dropped Moved to WorkStep.HeaderPanelCode |
HeaderReference | String | Nullable | Drop HeaderReference from WorkorderMaster and move/merge it into WorkStep.HeaderReference. Backend/database changes pending complete review. | WorkpackageOrder.HeaderReference | Dropped Moved to WorkStep.HeaderReference |
HeaderSpecialCode | String | Nullable | Merge the former header/reference code into WorkStep.SpecialCode; preserve distinct contextual codes and reconcile conflicts explicitly. HTML review decision; backend / database adoption pending complete review. | WorkpackageOrder.HeaderSpecialCode | Dropped Moved to WorkStep.SpecialCode |
HeaderZoneCode | String | Nullable | Drop HeaderZoneCode from WorkorderMaster and move/merge it into WorkStep.HeaderZoneCode. Backend/database changes pending complete review. | WorkpackageOrder.HeaderZoneCode | Dropped Moved to WorkStep.HeaderZoneCode |
HumanStaffId | Guid? | Nullable | Drop the HumanStaffId issuer-staff lookup from the unified WorkorderMaster HTML proposal. The earlier merger of IssuerStaffId and package issuer-name fields into this lookup is superseded. Backend/database removal remains pending complete project review. | WorkpackageMaster.IssuerFamilyName, WorkpackageMaster.IssuerFirstName, WorkorderMaster.IssuerStaffId | Dropped |
Id | Guid | Required | Primary key of one parent or child WorkorderMaster. Preserve existing package/order IDs where unique; reconcile cross-table collisions and all incoming references before adoption. | WorkpackageOrder.Id, WorkpackageMaster.Id, WorkorderMaster.Id | Carry forward; detailed semantics pending review |
InactivatedDate | DateTime? | Nullable | Carry the existing InactivatedDate field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.InactivatedDate | Carry forward; detailed semantics pending review |
InboundFlightNumber | String | Nullable | Inbound flight number associated with the owning work header. Each package/order retains its own value. | WorkpackageMaster.InboundFlightNumber | Move pending complete review |
InitialDueAircraftType | String | Nullable | Drop InitialDueAircraftType from the unified WorkorderMaster proposal; replaced by the ComplyWithMaintenanceTaskId lookup. Backend/database adoption pending complete review. | WorkpackageMaster.InitialDueAircraftType | Dropped Replaced by ComplyWithMaintenanceTaskId |
InitialDueCheckOnlyActive | Boolean | Required | Drop InitialDueCheckOnlyActive from the unified WorkorderMaster proposal; replaced by the ComplyWithMaintenanceTaskId lookup. Backend/database adoption pending complete review. | WorkpackageMaster.InitialDueCheckOnlyActive | Dropped Replaced by ComplyWithMaintenanceTaskId |
InitialDueCheckType | String | Nullable | Drop InitialDueCheckType from the unified WorkorderMaster proposal; replaced by the ComplyWithMaintenanceTaskId lookup. Backend/database adoption pending complete review. | WorkpackageMaster.InitialDueCheckType | Dropped Replaced by ComplyWithMaintenanceTaskId |
IsAccidentRelated | Boolean | Required | Carry the existing IsAccidentRelated field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.IsAccidentRelated | Carry forward; detailed semantics pending review |
IsAdministrativeServiceTask | Boolean | Required | Carry the existing IsAdministrativeServiceTask field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.IsAdministrativeServiceTask | Carry forward; detailed semantics pending review |
IsAdministrativelyClosed | Boolean | Required | Carry the existing IsAdministrativelyClosed field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.IsAdministrativelyClosed | Carry forward; detailed semantics pending review |
IsAogRisky | Boolean | Required | Drop IsAogRisky from the unified WorkorderMaster HTML proposal and move it to CriticalEvent.IsAogRisky. Backend/database changes pending complete review. | WorkorderMaster.IsAogRisky | Dropped Moved to CriticalEvent.IsAogRisky |
IsCorrosion | Boolean | Required | Drop IsCorrosion from the unified WorkorderMaster HTML proposal and move it to CriticalEvent.IsCorrosion. Backend/database changes pending complete review. | WorkpackageOrder.IsCorrosion | Dropped Moved to CriticalEvent.IsCorrosion |
IsCriticalPackage | Boolean | Required | Drop IsCriticalPackage from the unified WorkorderMaster HTML proposal and move it to CriticalEvent.IsCriticalPackage. Backend/database changes pending complete review. | WorkorderMaster.IsCriticalPackage | Dropped Moved to CriticalEvent.IsCriticalPackage |
IsCrsReleased | Boolean | Required | Drop IsCrsReleased from the unified WorkorderMaster HTML proposal. Backend/database removal remains pending complete project review. | WorkpackageOrder.IsCrsReleased | Dropped |
IsCustomerComponent | Boolean | Required | Carry the existing IsCustomerComponent field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.IsCustomerComponent | Carry forward; detailed semantics pending review |
IsElbLeading | Boolean | Required | Drop IsElbLeading from the unified WorkorderMaster HTML proposal. Backend/database removal remains pending complete project review. | WorkpackageOrder.IsElbLeading | Dropped |
IsElbWorkorder | Boolean | Required | Drop IsElbWorkorder from the unified WorkorderMaster HTML proposal. Backend/database removal remains pending complete project review. | WorkpackageOrder.IsElbWorkorder | Dropped |
IsInactiveWorkorder | Boolean | Required | Drop IsInactiveWorkorder from the unified WorkorderMaster HTML proposal. Backend/database removal remains pending complete project review. | WorkpackageOrder.IsInactiveWorkorder | Dropped |
IsIncidentRelated | Boolean | Required | Drop IsIncidentRelated from the unified WorkorderMaster HTML proposal and move it to CriticalEvent.IsIncidentRelated. Backend/database changes pending complete review. | WorkpackageOrder.IsIncidentRelated | Dropped Moved to CriticalEvent.IsIncidentRelated |
IsLiveBookingActive | Boolean | Required | Drop IsLiveBookingActive from the unified WorkorderMaster HTML proposal and move it to WorkStep.IsLiveBookingActive. Backend/database changes pending complete review. | WorkpackageMaster.IsLiveBookingActive | Dropped Moved to WorkStep.IsLiveBookingActive |
IsManagedComponent | Boolean | Required | Indicates managed-component handling for the owning work header. | WorkorderMaster.IsManagedComponent | Move pending complete review |
IsNotContracted | Boolean | Required | Carry the existing IsNotContracted field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.IsNotContracted | Carry forward; detailed semantics pending review |
IsNotPerformed | Boolean | Required | Carry the existing IsNotPerformed field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.IsNotPerformed | Carry forward; detailed semantics pending review |
IsOccurrenceReport | Boolean | Required | Drop IsOccurrenceReport from the unified WorkorderMaster HTML proposal and move it to CriticalEvent.IsOccurrenceReport. Backend/database changes pending complete review. | WorkpackageOrder.IsOccurrenceReport | Dropped Moved to CriticalEvent.IsOccurrenceReport |
IsRemovedServiceable | Boolean | Required | Drop IsRemovedServiceable from the unified WorkorderMaster HTML proposal and move it to WorkStep.IsRemovedServiceable. Backend/database changes pending complete review. | WorkorderMaster.IsRemovedServiceable, WorkpackageMaster.RemovedInServiceableCondition | Dropped Moved to WorkStep.IsRemovedServiceable |
IsRotable | Boolean | Required | Carry the existing IsRotable field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.IsRotable | Carry forward; detailed semantics pending review |
IsStructuralDamage | Boolean | Required | Drop IsStructuralDamage from the unified WorkorderMaster HTML proposal and move it to CriticalEvent.IsStructuralDamage. Backend/database changes pending complete review. | WorkpackageOrder.IsStructuralDamage | Dropped Moved to CriticalEvent.IsStructuralDamage |
IsStructuralRepairItem | Boolean | Required | Drop IsStructuralRepairItem from the unified WorkorderMaster HTML proposal. Backend/database removal remains pending complete project review. | WorkpackageOrder.IsStructuralRepairItem | Dropped |
IsWatchItem | Boolean | Required | Carry the existing IsWatchItem field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.IsWatchItem | Carry forward; detailed semantics pending review |
IssueDateTime | DateTime? | Nullable | Carry the existing IssueDateTime field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.IssueDateTime | Carry forward; detailed semantics pending review |
IssueMethod | WorkorderIssueMethod? { System, Template, ElectronicLogbook, PrePrinted, Finding, ScheduledFollowUp } | Nullable | Shared creation/issue method for the owning workpackage or workorder. Replaces WorkorderIssueMethod and WorkpackageIssueMethod; preserve the issueMethod JSON key and store the enum by name. | WorkpackageMaster.WorkpackageIssueMethod, WorkorderMaster.WorkorderIssueMethod | Move pending complete review |
IssueSource | String | Nullable | Carry the existing IssueSource field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.IssueSource | Carry forward; detailed semantics pending review |
IssueSourceRecordId | Guid? | Nullable | Carry the existing IssueSourceRecordId field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.IssueSourceRecordId | Carry forward; detailed semantics pending review |
IssueSourceReference | String | Nullable | Carry the existing IssueSourceReference field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.IssueSourceReference | Carry forward; detailed semantics pending review |
IssueStation | String | Nullable | Carry the existing IssueStation field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.IssueStation | Carry forward; detailed semantics pending review |
IssueStationId | Guid? | Nullable | Issue station lookup for the owning header; move IssueStationReference with this ID. | WorkorderMaster.IssueStationId | Move pending complete review |
IssuerSignature | String | Nullable | Carry the existing IssuerSignature field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.IssuerSignature | Carry forward; detailed semantics pending review |
LastTransferDate | DateTime? | Nullable | Carry the existing LastTransferDate field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.LastTransferDate | Carry forward; detailed semantics pending review |
LastTransferReason | String | Nullable | Carry the existing LastTransferReason field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.LastTransferReason | Carry forward; detailed semantics pending review |
LiveBookingStartedAt | DateTime? | Nullable | Drop LiveBookingStartedAt from the unified WorkorderMaster HTML proposal and move it to WorkStep.LiveBookingStartedAt. Backend/database changes pending complete review. | WorkpackageMaster.LiveBookingStartedAt | Dropped Moved to WorkStep.LiveBookingStartedAt |
LiveBookingStoppedAt | DateTime? | Nullable | Drop LiveBookingStoppedAt from the unified WorkorderMaster HTML proposal and move it to WorkStep.LiveBookingStoppedAt. Backend/database changes pending complete review. | WorkpackageMaster.LiveBookingStoppedAt | Dropped Moved to WorkStep.LiveBookingStoppedAt |
MaintenanceProgramId | Guid? | Nullable | Maintenance program lookup for the owning work header; move its lookup relationship with this ID. Each owning package/order retains its own value. | WorkpackageMaster.MaintenanceProgramId | Move pending complete review |
MaintenanceProvider | String | Nullable | Carry the existing MaintenanceProvider field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageMaster.MaintenanceProvider | Carry forward; detailed semantics pending review |
MaintenanceProviderBusinessPartnerId | Guid? | Nullable | Maintenance provider BusinessPartner lookup for the owning work header; move its lookup relationship with this ID. Each owning package/order retains its own value. | WorkpackageMaster.MaintenanceProviderBusinessPartnerId | Move pending complete review |
MetadataExportReference | String | Nullable | Metadata export reference for the owning header. | WorkorderMaster.MetadataExportReference | Move pending complete review |
NotPerformedDate | DateTime? | Nullable | Carry the existing NotPerformedDate field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.NotPerformedDate | Carry forward; detailed semantics pending review |
NotPerformedReason | String | Nullable | Carry the existing NotPerformedReason field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.NotPerformedReason | Carry forward; detailed semantics pending review |
OpenedDate | DateTime? | Nullable | Carry the existing OpenedDate field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.OpenedDate | Carry forward; detailed semantics pending review |
OperatorBusinessPartnerId | Guid? | Nullable | Operator BusinessPartner lookup for the owning work header; move its lookup relationship with this ID. Keep the current name separately from AircraftOperatorPartnerId pending a specific consolidation decision. Each owning package/order retains its own value. | WorkpackageMaster.OperatorBusinessPartnerId | Move pending complete review |
OtherDue | Single? | Nullable | Carry the existing OtherDue field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.OtherDue | Carry forward; detailed semantics pending review |
OutboundFlightNumber | String | Nullable | Outbound flight number associated with the owning work header. Each owning package/order retains its own value. | WorkpackageMaster.OutboundFlightNumber | Move pending complete review |
PaperworkPending | Boolean | Required | Whether paperwork remains outstanding for the owning header. | WorkorderMaster.PaperworkPending | Move pending complete review |
PaperworkReceivedDate | DateTime? | Nullable | Date/time the outstanding paperwork was received for the owning header. | WorkorderMaster.PaperworkReceivedDate | Move pending complete review |
PaperworkStatus | WorkpackagePaperworkStatus { NotTracked, Pending, Received } | Required | Carry the existing PaperworkStatus field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageMaster.PaperworkStatus | Carry forward; detailed semantics pending review |
ParentWorkorderId | Guid? | Nullable | Nullable self-reference to WorkorderMaster.Id. Parent/package-role rows have no parent; executable children point to their parent WorkorderMaster. Migrate the former WorkpackageId membership and reconcile existing parent links; reject cycles and self-parenting. | WorkpackageMaster.ParentWorkorderId, WorkorderMaster.ParentWorkorderId | Move pending complete review |
PartId | Guid? | Nullable | Lookup to PartMaster. Display the component part number from the selected part. Replaces the separate ComponentPartNumber text after complete review. | WorkpackageOrder.PartId | Carry forward; detailed semantics pending review |
PerformedAtIssue | Boolean? | Nullable | Whether the work had already been performed when the header was issued. | WorkorderMaster.WorkPerformedAtIssue | Move pending complete review |
PlannedDate | DateTime | Required | Required planned date for the owning work header. Each package/order retains its own value. | WorkpackageMaster.PlannedDate | Move pending complete review |
PlannedDepartureDateTime | DateTime? | Nullable | Planned departure date/time for the owning header. | WorkorderMaster.PlannedDepartureDateTime | Move pending complete review |
PlannedEndDate | DateTime? | Nullable | Single planned completion date/time for the owning package/order, replacing WorkpackagePlannedEndDate and WorkorderPlannedEndDate. Shared storage is nullable to preserve optional package dates; retain required-date validation for workorders. Preserve existing PlannedEndDate column and plannedEndDate JSON semantics and reconcile mappings during implementation. | WorkpackageMaster.WorkpackagePlannedEndDate, WorkorderMaster.WorkorderPlannedEndDate | Merge and move pending complete review |
PlannedOtherDue | Single | Required | Carry the existing PlannedOtherDue field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.PlannedOtherDue | Carry forward; detailed semantics pending review |
PlannedOtherDueUnitId | Guid? | Nullable | Lookup to MeasureUnit for the planned other-due limit; move PlannedOtherDueUnit relationship with this ID. | WorkorderMaster.PlannedOtherDueUnitId | Move pending complete review |
PlannedStartDate | DateTime? | Nullable | Carry the existing PlannedStartDate field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.PlannedStartDate | Carry forward; detailed semantics pending review |
PlannedStation | String | Nullable | Carry the existing PlannedStation field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.PlannedStation | Carry forward; detailed semantics pending review |
PlannedStationId | Guid? | Nullable | Planned station lookup for the owning header; move PlannedStationReference with this ID. | WorkorderMaster.PlannedStationId | Move pending complete review |
PlannedTAC | Single | Required | Carry the existing PlannedTAC field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.PlannedTAC | Carry forward; detailed semantics pending review |
PlannedTAH | TimeSpan | Required | Carry the existing PlannedTAH field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.PlannedTAH | Carry forward; detailed semantics pending review |
PlannedTurnaroundHours | Decimal? | Nullable | Carry the existing PlannedTurnaroundHours field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.PlannedTurnaroundHours | Carry forward; detailed semantics pending review |
PlanningEndDate | DateTime? | Nullable | Planning end date/time for the owning work header. Each package/order retains its own value. | WorkpackageMaster.PlanningEndDate | Move pending complete review |
PriorityCode | ComponentWorkpackagePriority? { VeryUrgent, Urgent, Normal, NotUrgent, NiceToHave } | Nullable | Carry the existing PriorityCode field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.PriorityCode | Carry forward; detailed semantics pending review |
ProductionDepartmentId | Guid? | Nullable | Nullable UUID lookup to Department identifying the production department responsible for the work header. Display the selected department code/name. Replaces ComponentProductionGroupName in this proposal using the agreed name ProductionDepartmentId. Map legacy text to the responsible department during later adoption; component capability-group records remain independently defined. | WorkpackageOrder.ComponentProductionGroupName | Replace with production department lookup; backend / DB adoption pending |
ProjectNo | String | Nullable | Carry the existing ProjectNo field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.ProjectNo | Carry forward; detailed semantics pending review |
Quantity | Decimal | Required | Carry the existing Quantity field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.Quantity | Carry forward; detailed semantics pending review |
RegulatoryAuthorityBusinessPartnerId | Guid? | Nullable | Carry the existing RegulatoryAuthorityBusinessPartnerId field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.RegulatoryAuthorityBusinessPartnerId | Carry forward; detailed semantics pending review |
ReleaseSign | String | Nullable | Drop ReleaseSign from the unified WorkorderMaster HTML proposal and move it to WorkStep.ReleaseSign. Backend/database changes pending complete review. | WorkpackageOrder.ReleaseSign | Dropped Moved to WorkStep.ReleaseSign |
ReleasedToService | Boolean | Required | Use authoritative scoped release/sign records, with WorkStep.WorkStatus reflecting validated release. The proposed WorkStep.ReleasedToService Boolean is also Dropped; preserve legacy flags and reconcile them against evidence. HTML review decision; backend / database adoption pending complete review. | WorkpackageMaster.ReleasedToService, WorkorderMaster.ReleasedToService | Dropped |
RemovedInServiceableCondition | Boolean | Required | Drop RemovedInServiceableCondition from the unified WorkorderMaster proposal and merge it into WorkStep.IsRemovedServiceable, preserving the existing required Boolean and default false. Reconcile differing legacy values during backend/database adoption after complete review. | WorkpackageMaster.RemovedInServiceableCondition | Dropped Moved to WorkStep.IsRemovedServiceable |
RequiredConditionId | Guid? | Nullable | Required condition lookup for the owning work header; move its lookup relationship with this ID. Each owning package/order retains its own value. | WorkpackageMaster.RequiredConditionId | Move pending complete review |
RequiresEngineChange | Boolean | Required | Drop RequiresEngineChange from the unified WorkorderMaster proposal. The earlier move to WorkStep is superseded: move this requirement to CriticalEvent.RequiresEngineChange and select it through WorkStep.CriticalEventId. Backend/database adoption remains pending complete review. | WorkpackageOrder.RequiresEngineChange | Dropped Moved to CriticalEvent.RequiresEngineChange |
RequiresRampActivity | Boolean | Required | Drop RequiresRampActivity from the unified WorkorderMaster proposal. The earlier move to WorkStep is superseded: move this requirement to CriticalEvent.RequiresRampActivity and select it through WorkStep.CriticalEventId. Backend/database adoption remains pending complete review. | WorkpackageOrder.RequiresRampActivity | Dropped Moved to CriticalEvent.RequiresRampActivity |
RequiresTaxi | Boolean | Required | Drop RequiresTaxi from the unified WorkorderMaster proposal. The earlier move to WorkStep is superseded: move this requirement to CriticalEvent.RequiresTaxi and select it through WorkStep.CriticalEventId. Backend/database adoption remains pending complete review. | WorkpackageOrder.RequiresTaxi | Dropped Moved to CriticalEvent.RequiresTaxi |
RequiresWeightAndBalance | Boolean | Required | Drop RequiresWeightAndBalance from the unified WorkorderMaster proposal. The earlier move to WorkStep is superseded: move this requirement to CriticalEvent.RequiresWeightAndBalance and select it through WorkStep.CriticalEventId. Backend/database adoption remains pending complete review. | WorkpackageOrder.RequiresWeightAndBalance | Dropped Moved to CriticalEvent.RequiresWeightAndBalance |
ReservedFacilityId | Guid? | Nullable | Reserved facility lookup for the owning work header; move its lookup relationship with this ID. Each owning package/order retains its own value. | WorkpackageMaster.ReservedFacilityId | Move pending complete review |
Responsible | String | Nullable | Responsible person/team text for the owning header; the existing ResponsibleStaffId lookup remains separately documented. | WorkorderMaster.Responsible | Move pending complete review |
ResponsibleStaffId | Guid? | Nullable | Carry the existing ResponsibleStaffId field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.ResponsibleStaffId | Carry forward; detailed semantics pending review |
Restricted | Boolean | Required | Carry the existing Restricted field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.Restricted | Carry forward; detailed semantics pending review |
ReturnType | ComponentReturnType { OpenLoop, ClosedLoop, Turnaround } | Required | Drop ReturnType from the current unified WorkorderMaster HTML proposal and revisit its component-return workflow purpose during later review. Backend/database removal remains pending complete project review. | WorkpackageOrder.ReturnType | Dropped Later review |
RotableId | Guid? | Nullable | Nullable UUID lookup to RotableMaster for the owning header's aircraft airframe or component, according to its aircraft/component context. Renamed from AirframeRotableId and consolidated with the existing RotableId lookup. Preserve aircraft/airframe validation and reconcile differing legacy lookup values before implementation. | WorkpackageOrder.RotableId, WorkpackageMaster.AirframeRotableId | Rename and merge; backend / DB adoption pending |
RoutingStatus | ComponentRoutingStatus { AtCurrentShop, AwaitingRoute, InTransit, Arrived } | Required | Drop RoutingStatus from the unified WorkorderMaster HTML proposal and move it to WorkStep.RoutingStatus. Backend/database changes pending complete review. | WorkpackageMaster.RoutingStatus, WorkorderMaster.RoutingStatus | Dropped Moved to WorkStep.RoutingStatus |
SerialNumber | String | Nullable | Single nullable serial-number text field for the owning work header. Rename WorkpackageMaster.ComponentSerialNumber to SerialNumber and merge its property definition with WorkorderMaster.SerialNumber in WorkorderMaster. Each package/order retains its own serial-number value. Existing asset lookup and snapshot-review decisions remain separately documented. | WorkorderMaster.SerialNumber, WorkpackageMaster.ComponentSerialNumber | Rename, merge and move pending complete review |
SerialNumberUnknown | Boolean | Required | Carry the existing SerialNumberUnknown field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.SerialNumberUnknown | Carry forward; detailed semantics pending review |
SerialOrBatchNumber | String | Required | Carry the existing SerialOrBatchNumber field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.SerialOrBatchNumber | Carry forward; detailed semantics pending review |
ShopArrivalDate | DateTime? | Nullable | Carry the existing ShopArrivalDate field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.ShopArrivalDate | Carry forward; detailed semantics pending review |
ShopFacilityId | Guid? | Nullable | Shop facility lookup for the owning work header; move its lookup relationship with this ID. Each owning package/order retains its own value. | WorkpackageMaster.ShopFacilityId | Move pending complete review |
ShopStatus | ShopWorkOrderStatus { Draft, InProgress, Testing, QualityReview, ApprovedForRelease, Closed, Cancelled } | Required | The earlier WorkStep.ExecutionStatus target is superseded by the single WorkStep.WorkStatus lifecycle; preserve shop/quality history and evidence requirements. HTML review decision; backend / database adoption pending complete review. | WorkpackageMaster.ShopStatus, WorkorderMaster.ShopStatus | Dropped Moved to WorkStep.WorkStatus |
ShopWorkOrderNumber | String | Nullable | Drop ShopWorkOrderNumber from the unified WorkorderMaster HTML proposal. Backend/database changes pending complete review. | WorkpackageMaster.ShopWorkOrderNumber | Dropped |
ShopcardCollectionComplete | Boolean | Required | Drop ShopcardCollectionComplete from the WorkorderMaster proposal. Replace the separate header collection flag with the single WorkStep.ShopcardCollectionStatus design and derive header summaries from applicable steps. Preserve header scope, reconcile legacy flags with per-step evidence, and avoid assigning a header aggregate to every step without validation. Backend/database adoption remains pending complete review. | WorkpackageMaster.ShopcardCollectionComplete | Dropped Moved to WorkStep.ShopcardCollectionStatus |
ShopcardCollectionNeeded | Boolean | Required | Drop ShopcardCollectionNeeded from the WorkorderMaster proposal. Replace the separate header collection flag with the single WorkStep.ShopcardCollectionStatus design and derive header summaries from applicable steps. Preserve header scope, reconcile legacy flags with per-step evidence, and avoid assigning a header aggregate to every step without validation. Backend/database adoption remains pending complete review. | WorkpackageMaster.ShopcardCollectionNeeded | Dropped Moved to WorkStep.ShopcardCollectionStatus |
ShopcardCollectionStatus | ShopcardCollectionStatus { NotRequired, Needed, Complete } | Required | Drop ShopcardCollectionStatus from the unified WorkorderMaster HTML proposal and move it to WorkStep.ShopcardCollectionStatus. Backend/database changes pending complete review. | WorkorderMaster.ShopcardCollectionStatus | Dropped Moved to WorkStep.ShopcardCollectionStatus |
SpecialEquipmentRequest | String | Nullable | Drop SpecialEquipmentRequest from the unified WorkorderMaster HTML proposal and move it to WorkStep.SpecialEquipmentRequest. Backend/database changes pending complete review. | WorkpackageMaster.SpecialEquipmentRequest | Dropped Moved to WorkStep.SpecialEquipmentRequest |
SpecialEquipmentRequest2 | String | Nullable | Drop SpecialEquipmentRequest2 from the unified WorkorderMaster HTML proposal and move it to WorkStep.SpecialEquipmentRequest2. Backend/database changes pending complete review. | WorkpackageMaster.SpecialEquipmentRequest2 | Dropped Moved to WorkStep.SpecialEquipmentRequest2 |
StandardDepartureTime | DateTime? | Nullable | Standard departure date/time for the owning work header. Each package/order retains its own value. | WorkpackageMaster.StandardDepartureTime | Move pending complete review |
StationFrom | String | Nullable | Carry the existing StationFrom field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageMaster.StationFrom | Carry forward; detailed semantics pending review |
StationId | Guid? | Nullable | Carry the existing StationId field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.StationId | Carry forward; detailed semantics pending review |
StationReference | String | Nullable | Carry the existing StationReference field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.StationReference | Carry forward; detailed semantics pending review |
StationTo | String | Nullable | Carry the existing StationTo field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageMaster.StationTo | Carry forward; detailed semantics pending review |
StockItemId | Guid? | Nullable | Carry the existing StockItemId field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.StockItemId | Carry forward; detailed semantics pending review |
SystemAuditId | Guid? | Nullable | Carry the existing SystemAuditId field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageMaster.SystemAuditId | Carry forward; detailed semantics pending review |
TargetCompletionDate | DateTime? | Nullable | Target completion date/time for the owning work header. Each package/order retains its own value. | WorkpackageMaster.TargetCompletionDate | Move pending complete review |
TargetEndDate | DateTime? | Nullable | Target end date/time for the owning work header. Each package/order retains its own value. | WorkpackageMaster.TargetEndDate | Move pending complete review |
TargetStartDate | DateTime? | Nullable | Target start date/time for the owning work header. Each package/order retains its own value. | WorkpackageMaster.TargetStartDate | Move pending complete review |
TaskReferenceRemarks | String | Nullable | Drop TaskReferenceRemarks from the unified WorkorderMaster HTML proposal and move / merge it into WorkStep.TaskReferenceRemarks. Backend/database changes pending complete review. | WorkpackageOrder.TaskReferenceRemarks | Dropped Moved to WorkStep.TaskReferenceRemarks |
TechAssistanceRequested | Boolean | Required | Drop TechAssistanceRequested from the unified WorkorderMaster HTML proposal and move / merge it into WorkStep.TechAssistanceRequested. Backend/database changes pending complete review. | WorkorderMaster.TechAssistanceRequested | Dropped Moved to WorkStep.TechAssistanceRequested |
UnknownAircraft | String | Required | Unknown aircraft text for the owning work header. Change the proposed type from Boolean to required String, retaining the reviewed field name. Define text validation and reconcile existing Boolean values during later adoption; a legacy true/false value does not identify the aircraft. Backend/database conversion pending complete review. | WorkpackageMaster.UnknownAircraft | Change Boolean to String; implementation pending |
UnknownPartNumber | String | Nullable | Carry the existing UnknownPartNumber field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.UnknownPartNumber | Carry forward; detailed semantics pending review |
UpdateId | Guid? | Nullable | Carry the existing UpdateId field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkorderMaster.UpdateId | Carry forward; detailed semantics pending review |
WorkApprovalStatus | WorkApprovalStatus? { Waiting, Approved, Rejected, Bypassed } | Nullable | Drop WorkApprovalStatus from the current unified WorkorderMaster HTML proposal and revisit its approval workflow during later review. Final disposition and backend/database changes remain pending complete project review. | WorkpackageMaster.WorkpackageApprovalStatus, WorkorderMaster.WorkorderApprovalStatus | Dropped Later review |
WorkLevel | String | Nullable | Carry the existing WorkLevel field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.WorkLevel | Carry forward; detailed semantics pending review |
WorkScope | ShopWorkScope { Inspection, Repair, Overhaul, Modification, Testing } | Required | Carry the existing WorkScope field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkpackageOrder.WorkScope | Carry forward; detailed semantics pending review |
WorkStatus | WorkStatus { Draft, Planning, Open, InProgress, Production, QualityReview, Released, Closed, Cancelled } | Required | Merge the former header status into the single WorkStep.WorkStatus lifecycle together with CompletionState and ExecutionStatus. Preserve header scope and conflicting source values during adoption. HTML review decision; backend / database adoption pending complete review. | WorkorderMaster.WorkorderStatus, WorkorderMaster.WorkpackageStatus, WorkpackageMaster.WorkpackageStatus, WorkpackageMaster.ReleasedToService, WorkpackageMaster.ShopStatus, WorkorderMaster.ReleasedToService, WorkorderMaster.ShopStatus | Dropped Moved to WorkStep.WorkStatus |
WorkTemplateId | Guid? | Nullable | Drop WorkTemplateId from the unified WorkorderMaster HTML proposal and move / merge it into WorkStep.WorkTemplateId. Backend/database changes pending complete review. | WorkorderMaster.WorkTemplateId | Dropped Moved to WorkStep.WorkTemplateId |
WorkorderAssetType | WorkpackageAssetType { Aircraft, Component } | Required | Aircraft or Component context for the owning header; package and order values remain separate. | WorkpackageOrder.WorkorderAssetType | Carry forward; detailed semantics pending review |
WorkorderDescription | String | Nullable | Carry the existing WorkorderDescription field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkorderMaster.WorkorderDescription | Carry forward; detailed semantics pending review |
WorkorderNo | String | Required | Carry the existing WorkorderNo field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkorderMaster.WorkorderNo | Carry forward; detailed semantics pending review |
WorkorderRoutineCheckType | WorkorderRoutineCheckType? { Daily, Weekly, PFC, MPC, Transit, StayOver, BiWeekly } | Nullable | WorkorderMaster routine check classification. Legacy owner-specific field; unified-header mapping pending; legacy DB column and JSON key: RoutineCheckType. | WorkorderMaster.WorkorderRoutineCheckType | Dropped |
WorkorderSequence | Int32 | Required | Carry the existing WorkorderSequence field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkorderMaster.WorkorderSequence | Carry forward; detailed semantics pending review |
WorkorderTitle | String | Nullable | Optional title of the owning workorder, renamed from WorkpackageTitle. Preserve the existing nullable text values during later adoption; backend/database rename pending complete review. | WorkpackageMaster.WorkpackageTitle | Renamed from WorkpackageTitle · implementation pending |
WorkorderType | String | Required | Carry the existing WorkorderType field into WorkorderMaster; preserve current meaning and review role-specific validation before implementation. | WorkorderMaster.WorkorderType | Carry forward; detailed semantics pending review |
WorkpackageDescription | String | Nullable | Drop WorkpackageDescription from the unified WorkorderMaster HTML proposal. Backend/database changes pending complete review. | WorkpackageMaster.WorkpackageDescription, WorkorderMaster.WorkpackageDescription | Dropped |
WorkpackageNumber | String | Nullable | Drop WorkpackageNumber from the unified WorkorderMaster HTML proposal. Backend/database changes pending complete review. | WorkpackageMaster.WorkpackageNumber | Dropped |
WorkpackageRoutineCheckType | String | Nullable | Drop WorkpackageRoutineCheckType from the unified WorkorderMaster proposal. Keep this legacy routine-check classification visible in the HTML for review; backend/database removal remains pending complete project review. | WorkpackageMaster.WorkpackageRoutineCheckType | Dropped |
WorkpackageType | WorkpackageCategory { Maintenance, Repair } | Required | Drop WorkpackageType from the unified WorkorderMaster HTML proposal. Backend/database changes pending complete review. | WorkpackageMaster.WorkpackageType | Dropped |