Coflyr · Backend model field catalog
WorkpackageMaster
Maintenance.WorkpackageMaster.
70 mapped fields7 field groupsGenerated 2026-10-10
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.
Reviewed changes
- Latest naming decision: rename the unified reviewed Workorder model to WorkorderMaster. Deprecate the legacy WorkpackageMaster and former WorkorderMaster definitions; keep one parent/child WorkorderMaster with all prior field decisions. This is an HTML review update; backend/database implementation remains pending complete review.
- Pending implementation after complete review: replace ComponentPartNumber with the existing PartId lookup, now stored in WorkorderMaster. This HTML omits the separate text field; the backend still retains it.
- Pending complete review: consolidate WorkorderIssueMethod and WorkpackageIssueMethod into WorkorderMaster.IssueMethod using the shared WorkorderIssueMethod enum. Backend and database updates are deferred.
- Pending complete review: move HandedOverToProduction to WorkorderMaster.HandedOverToProduction (Boolean). Backend and database updates are deferred.
- Pending complete review: move Department to WorkorderMaster.Department (String). Backend and database updates are deferred.
- Pending complete review: move Classification to WorkorderMaster.Classification and convert to nullable WorkorderClassification enum using the existing aircraft-package categories; preserve legacy classification labels during conversion. Backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.DepartmentId to WorkorderMaster.DepartmentId (Guid?). Preserve lookup relationships where applicable; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.ParentWorkorderId to WorkorderMaster.ParentWorkorderId (Guid?). Preserve lookup relationships where applicable; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.ApprovalNo to WorkorderMaster.ApprovalNo (String). Preserve lookup relationships where applicable; backend/database updates are deferred.
- Pending complete review: merge the duplicate WorkorderMaster.ApprovalNo and WorkpackageMaster.ApprovalNo definitions into one nullable String field WorkorderMaster.ApprovalNo. Each owning header retains its own value. Backend/database updates are deferred.
- Pending complete review: rename WorkpackageMaster.ComponentSerialNumber to SerialNumber and merge it with WorkorderMaster.SerialNumber in the common WorkorderMaster.SerialNumber nullable String field. Backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.ExternalWorkorderNo to WorkorderMaster.ExternalWorkorderNo (nullable String). Backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.InboundFlightNumber to WorkorderMaster.InboundFlightNumber (nullable String). Backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.OutboundFlightNumber to WorkorderMaster.OutboundFlightNumber (nullable String). Backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.AirframeRotableId to WorkorderMaster.AirframeRotableId (Guid?). Preserve lookup relationships where applicable; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.AssignedTechnicianStaffId to WorkorderMaster.AssignedTechnicianStaffId (Guid?). Preserve lookup relationships where applicable; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.FinancialProjectReference to WorkorderMaster.FinancialProjectReference (String). Preserve lookup relationships where applicable; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.MaintenanceProgramId to WorkorderMaster.MaintenanceProgramId (Guid?). Preserve lookup relationships where applicable; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.MaintenanceProviderBusinessPartnerId to WorkorderMaster.MaintenanceProviderBusinessPartnerId (Guid?). Preserve lookup relationships where applicable; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.OperatorBusinessPartnerId to WorkorderMaster.OperatorBusinessPartnerId (Guid?). Preserve lookup relationships where applicable; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.RequiredConditionId to WorkorderMaster.RequiredConditionId (Guid?). Preserve lookup relationships where applicable; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.ReservedFacilityId to WorkorderMaster.ReservedFacilityId (Guid?). Preserve lookup relationships where applicable; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.ShopFacilityId to WorkorderMaster.ShopFacilityId (Guid?). Preserve lookup relationships where applicable; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.EstimatedEndDate to WorkorderMaster.EstimatedEndDate (DateTime?). Preserve current nullability; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.EstimatedStartDate to WorkorderMaster.EstimatedStartDate (DateTime?). Preserve current nullability; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.FlightDateTime to WorkorderMaster.FlightDateTime (DateTime?). Preserve current nullability; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.PlannedDate to WorkorderMaster.PlannedDate (DateTime). Preserve current nullability; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.PlanningEndDate to WorkorderMaster.PlanningEndDate (DateTime?). Preserve current nullability; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.StandardDepartureTime to WorkorderMaster.StandardDepartureTime (DateTime?). Preserve current nullability; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.TargetCompletionDate to WorkorderMaster.TargetCompletionDate (DateTime?). Preserve current nullability; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.TargetEndDate to WorkorderMaster.TargetEndDate (DateTime?). Preserve current nullability; backend/database updates are deferred.
- Pending complete review: move WorkpackageMaster.TargetStartDate to WorkorderMaster.TargetStartDate (DateTime?). Preserve current nullability; backend/database updates are deferred.
- Pending complete review: merge WorkpackagePlannedEndDate and WorkorderPlannedEndDate into WorkorderMaster.PlannedEndDate (DateTime?). Package dates remain optional; enforce required-date validation for workorders. This supersedes the earlier move under WorkorderPlannedEndDate. Backend/database updates are deferred.
- Rename WorkpackageMaster.ExternalWorkorderNoType to WorkorderMaster.ExternalWorkType; preserve its nullable ExternalWorkorderNumberType enum and Customer/MaintenanceProvider/Vendor/Other values. Backend/database rename pending complete review.
- Pending complete review: drop the proposed HumanStaffId issuer lookup and its consolidated legacy issuer fields. This supersedes the earlier issuer-name/staff merge; backend/database changes are deferred.
- Pending complete review: replace InitialDueAircraftType, InitialDueCheckOnlyActive and InitialDueCheckType with WorkorderMaster.ComplyWithMaintenanceTaskId (nullable UUID lookup to MaintenanceTask), selected through a searchable TaskCode / TaskTitle dropdown. Backend/database adoption and due/compliance processing are deferred.
- Pending complete review: move IsLiveBookingActive to WorkStep and mark it Dropped from unified WorkorderMaster. Staff booking remains the source of individual live-time state; backend/database adoption deferred.
- Pending complete review: move LiveBookingStartedAt and LiveBookingStoppedAt to WorkStep as nullable timestamps and mark both Dropped from unified WorkorderMaster. Retain individual staff-booking timestamps and existing booking cleanup review decisions; backend/database adoption deferred.
- Pending complete review: move ReleaseSign and ReleasedToService to WorkStep and mark both Dropped from unified WorkorderMaster. Merge duplicate package/order ReleasedToService definitions; release/sign-off workflow integration and backend/database adoption deferred.
- Pending complete review: move RoutingStatus, ShopStatus and ShopcardCollectionStatus to WorkStep, preserving enum types, values and required storage; mark their header definitions Dropped. Drop ShopWorkOrderNumber and ShopcardCollectionComplete from WorkorderMaster. Backend/database adoption deferred.
- Pending complete review: move SpecialEquipmentRequest and SpecialEquipmentRequest2 to WorkStep as separate nullable text fields, preserving each 500-character maximum; mark both Dropped from unified WorkorderMaster. Backend/database adoption deferred.
- Pending complete review: merge TaskReferenceRemarks into WorkStep and move TechAssistanceRequested, WorkStatus and WorkTemplateId there; mark these header fields Dropped. Drop WorkpackageDescription, WorkpackageNumber and WorkpackageType; mark WorkApprovalStatus Dropped / Later review. Change UnknownAircraft from Boolean to required String and rename WorkpackageTitle to WorkorderTitle. Backend/database adoption deferred.
- Pending complete review: merge RemovedInServiceableCondition into the existing WorkStep.IsRemovedServiceable Boolean and mark the header source Dropped. Other remaining WorkorderMaster fields stay on the header; backend/database adoption deferred.
← All model classes · AMOS Workpackage example
Deprecated · Legacy definition; backend/database retirement pending. Fields merge into WorkorderMaster (renamed WorkpackageOrder). Parent workorders replace this package header. The table below is the current backend reference inventory.
Identity and naming
12 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | Id | GuidEF: Guid | Required | Stable identifier for this record. | — |
| 2 | ApprovalNo | StringEF: String | Nullable | Merge into the shared WorkorderMaster.ApprovalNo. 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. Backend/database updates pending complete review. | Merged To WorkorderMaster.ApprovalNo · pending |
| 3 | ComponentSerialNumber | StringEF: String | Nullable | Merge into the shared WorkorderMaster.SerialNumber. 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. Backend/database updates pending complete review. | Merged To WorkorderMaster.SerialNumber · pending |
| 4 | CustomerWorkpackageNumber | StringEF: String | Nullable | Move to the shared WorkorderMaster.ExternalWorkNumber. External/customer-provided work number for the owning work header. Renamed from CustomerWorkpackageNumber; preserve existing nullable text values during later adoption. Backend/database changes pending complete review. | Moved To WorkorderMaster.ExternalWorkNumber · pending |
| 5 | ExternalWorkorderNo | StringEF: String | Nullable | Drop ExternalWorkorderNo from the unified WorkorderMaster HTML proposal. Backend/database removal pending complete project review. | Dropped Removal pending complete review |
| 6 | ExternalWorkpackageNumber | StringEF: String | Nullable | Drop ExternalWorkpackageNumber from the unified WorkorderMaster HTML proposal. Backend/database removal pending complete project review. | Dropped Removal pending complete review |
| 7 | InboundFlightNumber | StringEF: String | Nullable | Move to the shared WorkorderMaster.InboundFlightNumber. Inbound flight number associated with the owning work header. Move to WorkorderMaster.InboundFlightNumber; backend/database updates pending complete review. | Moved To WorkorderMaster.InboundFlightNumber · pending |
| 8 | IssuerFamilyName | StringEF: String Requested: Guid? · StaffMember lookup | Nullable | The consolidated issuer lookup HumanStaffId is marked Dropped. This legacy issuer field is excluded from the unified WorkorderMaster proposal; backend/database removal pending complete review. | Dropped Removal pending complete review |
| 9 | IssuerFirstName | StringEF: String Requested: Guid? · StaffMember lookup | Nullable | The consolidated issuer lookup HumanStaffId is marked Dropped. This legacy issuer field is excluded from the unified WorkorderMaster proposal; backend/database removal pending complete review. | Dropped Removal pending complete review |
| 10 | OutboundFlightNumber | StringEF: String | Nullable | Move to the shared WorkorderMaster.OutboundFlightNumber. Outbound flight number associated with the owning work header. Move to WorkorderMaster.OutboundFlightNumber; backend/database updates pending complete review. | Moved To WorkorderMaster.OutboundFlightNumber · pending |
| 11 | ShopWorkOrderNumber | StringEF: String | Nullable | Drop ShopWorkOrderNumber from the unified WorkorderMaster HTML proposal. Backend/database changes pending complete review. | Dropped Removal pending complete review |
| 12 | WorkpackageNumber | StringEF: String | Nullable | Drop WorkpackageNumber from the unified WorkorderMaster HTML proposal. Backend/database changes pending complete review. | Dropped Removal pending complete review |
Relationships and references
11 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | AirframeRotableId | Guid?EF: Guid? Requested: Guid? | Nullable | Merge into the shared WorkorderMaster.RotableId. 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. | Merged To WorkorderMaster.RotableId · pending |
| 2 | AssignedTechnicianStaffId | Guid?EF: Guid? | Nullable | Move to the shared WorkorderMaster.AssignedTechnicianStaffId. Assigned technician staff lookup for the owning work header; move its lookup relationship with this ID. Each owning package/order retains its own value. Move to WorkorderMaster.AssignedTechnicianStaffId; backend/database updates pending complete review. | Moved To WorkorderMaster.AssignedTechnicianStaffId · pending |
| 3 | DepartmentId | Guid?EF: Guid? | Nullable | Drop DepartmentId from the unified WorkorderMaster HTML proposal; backend/database removal deferred until complete project review. | Dropped Removal pending complete review |
| 4 | FinancialProjectReference | StringEF: String | Nullable | Move to the shared WorkorderMaster.FinancialProjectReference. Financial project reference for the owning work header. Each owning package/order retains its own value. Move to WorkorderMaster.FinancialProjectReference; backend/database updates pending complete review. | Moved To WorkorderMaster.FinancialProjectReference · pending |
| 5 | MaintenanceProgramId | Guid?EF: Guid? | Nullable | Move to the shared WorkorderMaster.MaintenanceProgramId. Maintenance program lookup for the owning work header; move its lookup relationship with this ID. Each owning package/order retains its own value. Move to WorkorderMaster.MaintenanceProgramId; backend/database updates pending complete review. | Moved To WorkorderMaster.MaintenanceProgramId · pending |
| 6 | MaintenanceProviderBusinessPartnerId | Guid?EF: Guid? | Nullable | Move to the shared WorkorderMaster.MaintenanceProviderBusinessPartnerId. Maintenance provider BusinessPartner lookup for the owning work header; move its lookup relationship with this ID. Each owning package/order retains its own value. Move to WorkorderMaster.MaintenanceProviderBusinessPartnerId; backend/database updates pending complete review. | Moved To WorkorderMaster.MaintenanceProviderBusinessPartnerId · pending |
| 7 | OperatorBusinessPartnerId | Guid?EF: Guid? | Nullable | Move to the shared WorkorderMaster.OperatorBusinessPartnerId. 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. Move to WorkorderMaster.OperatorBusinessPartnerId; backend/database updates pending complete review. | Moved To WorkorderMaster.OperatorBusinessPartnerId · pending |
| 8 | ParentWorkorderId | Guid?EF: Guid? | Nullable | Move to the shared WorkorderMaster.ParentWorkorderId. Parent WorkorderMaster lookup for the owning header; preserve the relationship target and reconcile inverse ChildWorkorders ownership during implementation. Move to WorkorderMaster.ParentWorkorderId; backend/database updates pending complete review. | Moved To WorkorderMaster.ParentWorkorderId · pending |
| 9 | RequiredConditionId | Guid?EF: Guid? | Nullable | Move to the shared WorkorderMaster.RequiredConditionId. Required condition lookup for the owning work header; move its lookup relationship with this ID. Each owning package/order retains its own value. Move to WorkorderMaster.RequiredConditionId; backend/database updates pending complete review. | Moved To WorkorderMaster.RequiredConditionId · pending |
| 10 | ReservedFacilityId | Guid?EF: Guid? | Nullable | Move to the shared WorkorderMaster.ReservedFacilityId. Reserved facility lookup for the owning work header; move its lookup relationship with this ID. Each owning package/order retains its own value. Move to WorkorderMaster.ReservedFacilityId; backend/database updates pending complete review. | Moved To WorkorderMaster.ReservedFacilityId · pending |
| 11 | ShopFacilityId | Guid?EF: Guid? | Nullable | Move to the shared WorkorderMaster.ShopFacilityId. Shop facility lookup for the owning work header; move its lookup relationship with this ID. Each owning package/order retains its own value. Move to WorkorderMaster.ShopFacilityId; backend/database updates pending complete review. | Moved To WorkorderMaster.ShopFacilityId · pending |
Status and controls
9 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | ApprovalRequestedBy | StringEF: String Requested: Guid? | Nullable | Move to the shared WorkorderMaster.ApprovalRequestedStaffId. 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. | Moved To WorkorderMaster.ApprovalRequestedStaffId · pending |
| 2 | ApprovalRequestedDate | DateTime?EF: DateTime? | Nullable | Records the approval requested date for this workpackage master. | — |
| 3 | InitialDueCheckOnlyActive | BooleanEF: Boolean | Required | Drop InitialDueCheckOnlyActive from the unified WorkorderMaster proposal; replaced by the ComplyWithMaintenanceTaskId lookup. Backend/database adoption pending complete review. | Dropped Removal pending complete review |
| 4 | IsLiveBookingActive | BooleanEF: Boolean | Required | Mark IsLiveBookingActive Dropped from the unified WorkStep proposal, with later review of live labor-booking state and its relationship to linked StaffTimeBooking records. Backend/database adoption deferred until complete project review. | Dropped Removal pending complete review |
| 5 | PaperworkStatus | WorkpackagePaperworkStatus { NotTracked, Pending, Received }EF: WorkpackagePaperworkStatus | Required | Tracks the paperwork status of this workpackage master. | — |
| 6 | RoutingStatus | ComponentRoutingStatus { AtCurrentShop, AwaitingRoute, InTransit, Arrived }EF: ComponentRoutingStatus | Required | Drop RoutingStatus from the unified WorkorderMaster HTML proposal and move it to WorkStep.RoutingStatus. Backend/database changes pending complete review. | Dropped Removal pending complete review |
| 7 | ShopStatus | ShopWorkOrderStatus { Draft, InProgress, Testing, QualityReview, ApprovedForRelease, Closed, Cancelled }EF: ShopWorkOrderStatus | Required | Merge this lifecycle field into WorkStatus. Preserve its original state and transition evidence, including physical completion versus quality/release progression; do not discard a completed-work fact when the current lifecycle state advances. HTML review decision; backend / database adoption pending complete review. | Dropped Removal pending complete review |
| 8 | WorkpackageApprovalStatusDB: ApprovalStatus | StringEF: String Requested: WorkApprovalStatus? | 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. | Dropped Removal pending complete review |
| 9 | WorkpackageStatus | ComponentWorkpackageStatus { Draft, Planning, Production, QualityReview, Released, Closed, Cancelled }EF: ComponentWorkpackageStatus Requested: WorkStatus | Required | Drop WorkStatus from the unified WorkorderMaster HTML proposal and move / merge it into WorkStep.WorkStatus. Backend/database changes pending complete review. | Dropped Removal pending complete review |
Dates and timing
13 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | EstimatedEndDate | DateTime?EF: DateTime? | Nullable | Move to the shared WorkorderMaster.EstimatedEndDate. Estimated completion date/time for the owning work header. Move to WorkorderMaster.EstimatedEndDate; backend/database updates pending complete review. | Moved To WorkorderMaster.EstimatedEndDate · pending |
| 2 | EstimatedStartDate | DateTime?EF: DateTime? | Nullable | Move to the shared WorkorderMaster.EstimatedStartDate. Estimated start date/time for the owning work header. Move to WorkorderMaster.EstimatedStartDate; backend/database updates pending complete review. | Moved To WorkorderMaster.EstimatedStartDate · pending |
| 3 | FlightDateTime | DateTime?EF: DateTime? | Nullable | Move to the shared WorkorderMaster.FlightDateTime. Associated flight date/time for the owning work header; retain existing flight-link/snapshot review decisions for implementation. Move to WorkorderMaster.FlightDateTime; backend/database updates pending complete review. | Moved To WorkorderMaster.FlightDateTime · pending |
| 4 | InitialDueAircraftType | StringEF: String | Nullable | Drop InitialDueAircraftType from the unified WorkorderMaster proposal; replaced by the ComplyWithMaintenanceTaskId lookup. Backend/database adoption pending complete review. | Dropped Removal pending complete review |
| 5 | InitialDueCheckType | StringEF: String | Nullable | Drop InitialDueCheckType from the unified WorkorderMaster proposal; replaced by the ComplyWithMaintenanceTaskId lookup. Backend/database adoption pending complete review. | Dropped Removal pending complete review |
| 6 | LiveBookingStartedAt | DateTime?EF: DateTime? | Nullable | Drop LiveBookingStartedAt from the header proposal and move it to WorkStep.BookingStart. Backend/database changes pending complete review. | Dropped Removal pending complete review |
| 7 | PlannedDate | DateTimeEF: DateTime | Required | Move to the shared WorkorderMaster.PlannedDate. Required planned date for the owning work header. Move to WorkorderMaster.PlannedDate; backend/database updates pending complete review. | Moved To WorkorderMaster.PlannedDate · pending |
| 8 | PlanningEndDate | DateTime?EF: DateTime? | Nullable | Move to the shared WorkorderMaster.PlanningEndDate. Planning end date/time for the owning work header. Move to WorkorderMaster.PlanningEndDate; backend/database updates pending complete review. | Moved To WorkorderMaster.PlanningEndDate · pending |
| 9 | StandardDepartureTime | DateTime?EF: DateTime? | Nullable | Move to the shared WorkorderMaster.StandardDepartureTime. Standard departure date/time for the owning work header. Move to WorkorderMaster.StandardDepartureTime; backend/database updates pending complete review. | Moved To WorkorderMaster.StandardDepartureTime · pending |
| 10 | TargetCompletionDate | DateTime?EF: DateTime? | Nullable | Move to the shared WorkorderMaster.TargetCompletionDate. Target completion date/time for the owning work header. Move to WorkorderMaster.TargetCompletionDate; backend/database updates pending complete review. | Moved To WorkorderMaster.TargetCompletionDate · pending |
| 11 | TargetEndDate | DateTime?EF: DateTime? | Nullable | Move to the shared WorkorderMaster.TargetEndDate. Target end date/time for the owning work header. Move to WorkorderMaster.TargetEndDate; backend/database updates pending complete review. | Moved To WorkorderMaster.TargetEndDate · pending |
| 12 | TargetStartDate | DateTime?EF: DateTime? | Nullable | Move to the shared WorkorderMaster.TargetStartDate. Target start date/time for the owning work header. Move to WorkorderMaster.TargetStartDate; backend/database updates pending complete review. | Moved To WorkorderMaster.TargetStartDate · pending |
| 13 | WorkpackagePlannedEndDateDB: PlannedEndDate | DateTime?EF: DateTime? Requested: DateTime? · required for workorders | Nullable | Merge into the shared WorkorderMaster.PlannedEndDate. 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. Backend/database updates pending complete review. | Merged To WorkorderMaster.PlannedEndDate · pending |
Descriptions and details
1 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | WorkpackageDescription | StringEF: String | Nullable | Drop WorkpackageDescription from the unified WorkorderMaster HTML proposal. Backend/database changes pending complete review. | Dropped Removal pending complete review |
Audit and revision
1 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | SystemAuditId | Guid?EF: Guid? | Nullable | Links to system audit history when this model stores the reference. | — |
Other fields
23 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | AircraftPosition | StringEF: String Requested: Guid? | Nullable | Merge into the shared WorkorderMaster.ConfigurationId. 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. | Merged To WorkorderMaster.ConfigurationId · pending |
| 2 | AtaChapterStd | StringEF: String | Nullable | Dropped from the unified WorkorderMaster HTML proposal; backend/database removal pending complete review. | Dropped Removal pending complete review |
| 3 | AutoGenerated | BooleanEF: 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. | Create button to insert autogenerated workorder number; implementation pending |
| 4 | Classification | StringEF: String Requested: WorkpackageOrderClassification? | Nullable | Move to the shared WorkorderMaster.Classification. 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. Move and enum conversion pending complete review. | Moved To WorkorderMaster.Classification · pending |
| 5 | Department | StringEF: String | Nullable | Drop Department from the unified WorkorderMaster HTML proposal; backend/database removal deferred until complete project review. | Dropped Removal pending complete review |
| 6 | ExternalWorkorderNoType | ExternalWorkorderNumberType? { Customer, MaintenanceProvider, Vendor, Other }EF: ExternalWorkorderNumberType? | Nullable | Rename to the shared WorkorderMaster.ExternalWorkType. Nullable classification of the external work reference: Customer, MaintenanceProvider, Vendor or Other. Renamed from ExternalWorkorderNoType. Backend/database rename pending complete review. | Renamed To WorkorderMaster.ExternalWorkType · pending |
| 7 | ExternalWorkpackageNumberType | ExternalWorkpackageNumberType? { Customer, MaintenanceProvider, Vendor, Other, Shop }EF: ExternalWorkpackageNumberType? | Nullable | Drop ExternalWorkpackageNumberType from the unified WorkorderMaster HTML proposal. Backend/database removal pending complete project review. | Dropped Removal pending complete review |
| 8 | HandedOverToProduction | BooleanEF: Boolean | Required | Move to the shared WorkorderMaster.HandedOverToProduction. Move to WorkorderMaster.HandedOverToProduction. Whether the owning header has been handed over to production. Each package/order keeps its own value. Backend/database updates pending complete review. | Moved To WorkorderMaster.HandedOverToProduction · pending |
| 9 | LiveBookingStoppedAt | DateTime?EF: DateTime? | Nullable | Drop LiveBookingStoppedAt from the header proposal and move it to WorkStep.BookingEnd. Backend/database changes pending complete review. | Dropped Removal pending complete review |
| 10 | MaintenanceProvider | StringEF: String | Nullable | Records maintenance provider for this workpackage master. | — |
| 11 | ReleasedToService | BooleanEF: Boolean | Required | Remove the independently editable release Boolean. Determine release from valid, active, authorized release/sign records for the correct aircraft/component, work and quantity scope. Partial release does not release the whole scope; revoked/superseded records do not count. WorkStatus.Released is a validated projection of this evidence, not a second editable release assertion. Completion or a signature of another kind cannot imply release. HTML review decision; backend / database adoption pending complete review. | Dropped Removal pending complete review |
| 12 | RemovedInServiceableCondition | BooleanEF: 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. | Dropped Removal pending complete review |
| 13 | ShopcardCollectionComplete | BooleanEF: 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. | Dropped · Replaced by WorkStep.ShopcardCollectionStatus |
| 14 | ShopcardCollectionNeeded | BooleanEF: 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. | Dropped · Replaced by WorkStep.ShopcardCollectionStatus |
| 15 | SpecialEquipmentRequest | StringEF: String | Nullable | Drop SpecialEquipmentRequest from the unified WorkorderMaster HTML proposal and move it to WorkStep.SpecialEquipmentRequest. Backend/database changes pending complete review. | Dropped Removal pending complete review |
| 16 | SpecialEquipmentRequest2 | StringEF: String | Nullable | Drop SpecialEquipmentRequest2 from the unified WorkorderMaster HTML proposal and move it to WorkStep.SpecialEquipmentRequest2. Backend/database changes pending complete review. | Dropped Removal pending complete review |
| 17 | StationFrom | StringEF: String | Nullable | Records station from for this workpackage master. | — |
| 18 | StationTo | StringEF: String | Nullable | Records station to for this workpackage master. | — |
| 19 | UnknownAircraft | BooleanEF: Boolean Requested: 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. | Change to String · implementation pending |
| 20 | WorkpackageIssueMethodDB: IssueMethod | StringEF: String | Nullable | Move to the shared WorkorderMaster.IssueMethod. Move to the shared IssueMethod enum on WorkpackageOrder; backend and database changes pending complete review. | Moved To WorkorderMaster.IssueMethod · pending |
| 21 | WorkpackageRoutineCheckTypeDB: RoutineCheckType | StringEF: 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. | Dropped Removal pending complete review |
| 22 | WorkpackageTitle | StringEF: String | Nullable | Rename to the shared WorkorderMaster.WorkorderTitle. Optional title of the owning workorder, renamed from WorkpackageTitle. Preserve the existing nullable text values during later adoption; backend/database rename pending complete review. | Renamed To WorkorderMaster.WorkorderTitle · pending |
| 23 | WorkpackageType | WorkpackageCategory { Maintenance, Repair }EF: WorkpackageCategory | Required | Drop WorkpackageType from the unified WorkorderMaster HTML proposal. Backend/database changes pending complete review. | Dropped Removal pending complete review |