Coflyr · Backend model field catalog
WorkorderExecutionEntry
Maintenance.WorkStep.
65 mapped fields8 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 WorkStep review decision: consolidate all mapped WorkStep models/field sets into the single WorkStep model and table, including phase and reference details. Mark the other model/table definitions Dropped. Preserve RecordKind, ownership, separate historical/child rows and role-specific validation. HTML only; backend/database implementation remains pending complete review.
← All model classes · AMOS Workpackage example
Dropped · Merge every field into WorkStep. This page retains the source inventory for review; backend/model retirement and physical migration are pending complete review.
Identity and naming
2 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | Id | Guid | Required | Merge into the shared WorkStep.Id. | Merged To WorkStep.Id · pending |
| 2 | TransferApprovalNumber | String | Nullable | Merge into the shared WorkStep.TransferApprovalNumber. | Merged To WorkStep.TransferApprovalNumber · pending |
Relationships and references
15 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | ComponentTaskFormulaId | Guid? | Nullable | Drop ComponentTaskFormulaId from the unified WorkStep proposal. Review common formula definitions, taskcard-based calculation and formula-result traceability in future, together with the deferred CalculatedValue design. Backend/database removal deferred until complete project review. | Dropped Removal pending complete review |
| 2 | ComponentTaskMeasurementId | Guid?Requested: Guid? | Nullable | Merge into the shared WorkStep.MeasurementIdentifierId. Replace the component-specific link through the common WorkStep measurement framework and existing MeasurementIdentifierId. Map legacy measurement definitions and preserve result types, limits, units, reporting/calibration settings; custom-answer links need explicit mapping. Backend/database adoption deferred. | Merged To WorkStep.MeasurementIdentifierId · pending |
| 3 | ConfigurationId | Guid? | Nullable | Merge into the shared WorkStep.ConfigurationId. | Merged To WorkStep.ConfigurationId · pending |
| 4 | FromPartId | Guid? | Nullable | Drop FromPartId. Use PartId on a separate source WorkStep row linked to the same owning action through OwnerRecordId and WorkStepId. ComponentActionRole distinguishes source/destination or removed/installed rows. Preserve both sides and their history as separate rows during deferred backend/database adoption. | Dropped Removal pending complete review |
| 5 | ToPartId | Guid? | Nullable | Drop ToPartId. Use PartId on a separate destination WorkStep row linked to the same owning action through OwnerRecordId and WorkStepId. ComponentActionRole distinguishes source/destination or removed/installed rows. Preserve both sides and their history as separate rows during deferred backend/database adoption. | Dropped Removal pending complete review |
| 6 | ComponentId | Guid?Requested: Guid? | Nullable | Merge into the shared WorkStep.RotableId. Replace ComponentId with RotableId in the unified proposal; preserve legacy data and role-specific validation during later adoption. | Merged To WorkStep.RotableId · pending |
| 7 | CrsReference | String | Nullable | Drop CrsReference from the unified WorkStep HTML proposal; backend/database removal deferred until complete project review. | Dropped Removal pending complete review |
| 8 | FromConfigurationId | Guid? | Nullable | Drop FromConfigurationId. Use ConfigurationId on a separate source WorkStep row linked to the same owning action through OwnerRecordId and WorkStepId. ComponentActionRole distinguishes source/destination or removed/installed rows. Preserve both sides and their history as separate rows during deferred backend/database adoption. | Dropped Removal pending complete review |
| 9 | ToConfigurationId | Guid? | Nullable | Drop ToConfigurationId. Use ConfigurationId on a separate destination WorkStep row linked to the same owning action through OwnerRecordId and WorkStepId. ComponentActionRole distinguishes source/destination or removed/installed rows. Preserve both sides and their history as separate rows during deferred backend/database adoption. | Dropped Removal pending complete review |
| 10 | TransferReference | String | Nullable | Merge into the shared WorkStep.TransferReference. | Merged To WorkStep.TransferReference · pending |
| 11 | TransferToMaintenanceTaskId | Guid? | Nullable | Merge into the shared WorkStep.TransferToMaintenanceTaskId. | Merged To WorkStep.TransferToMaintenanceTaskId · pending |
| 12 | TransferToTaskCardId | Guid? | Nullable | Merge into the shared WorkStep.TransferToTaskCardId. | Merged To WorkStep.TransferToTaskCardId · pending |
| 13 | TransferToWorkorderId | Guid? | Nullable | Merge into the shared WorkStep.TransferToWorkorderId. | Merged To WorkStep.TransferToWorkorderId · pending |
| 14 | UpliftPartId | Guid? | Nullable | Merge into the shared WorkStep.PartId. Replace UpliftPartId with the existing PartId field on the same uplift execution row. Preserve original uplift values, reconcile conflicts explicitly and adapt API/UI validation during later adoption. The original field remains documented here for review; backend/database changes remain pending complete review. | Merged To WorkStep.PartId · pending |
| 15 | WorkStepId | Guid | Required | Merge into the shared WorkStep.WorkStepId. | Merged To WorkStep.WorkStepId · pending |
Status and controls
1 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | TransferCheckOnlyActive | Boolean | Required | Merge into the shared WorkStep.TransferCheckOnlyActive. | Merged To WorkStep.TransferCheckOnlyActive · pending |
Dates and timing
7 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | ActionDate | DateTime? | Nullable | Merge into the shared WorkStep.ActionEndDate. Rename ActionDate to ActionEndDate and merge with the existing ActionEndDate field. Backend/database adoption is pending complete review. | Merged To WorkStep.ActionEndDate · pending |
| 2 | ActionEndDate | DateTime? | Nullable | Merge into the shared WorkStep.ActionEndDate. Date and time when the action represented by this WorkStep row ended or was completed. For action, inspection and sign-off entry roles, use the completion timestamp of that specific entry. Consolidates the former ActionDate into the existing ActionEndDate; reconcile differing legacy values and closure/signing behavior before backend/database adoption. | Merged To WorkStep.ActionEndDate · pending |
| 3 | ActionStartDate | DateTime? | Nullable | Merge into the shared WorkStep.ActionStartDate. Date and time when the action work began. Use with ActionEndDate for the work interval; it does not represent a later inspection, sign-off or closure timestamp. Used by: WorkStep, WorkorderExecutionEntry. | Merged To WorkStep.ActionStartDate · pending |
| 4 | TransferDueAt | DateTime? | Nullable | Merge into the shared WorkStep.TransferDueAt. | Merged To WorkStep.TransferDueAt · pending |
| 5 | TransferDueBlockHours | Decimal? | Nullable | Merge into the shared WorkStep.TransferDueBlockHours. | Merged To WorkStep.TransferDueBlockHours · pending |
| 6 | TransferDueCycles | Decimal? | Nullable | Merge into the shared WorkStep.TransferDueCycles. | Merged To WorkStep.TransferDueCycles · pending |
| 7 | TransferDueHours | Decimal? | Nullable | Merge into the shared WorkStep.TransferDueHours. | Merged To WorkStep.TransferDueHours · pending |
Amounts and measurements
7 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | TransferBaselineBlockHours | Decimal? | Nullable | Merge into the shared WorkStep.TransferBaselineBlockHours. | Merged To WorkStep.TransferBaselineBlockHours · pending |
| 2 | TransferBaselineCycles | Decimal? | Nullable | Merge into the shared WorkStep.TransferBaselineCycles. | Merged To WorkStep.TransferBaselineCycles · pending |
| 3 | TransferBaselineHours | Decimal? | Nullable | Merge into the shared WorkStep.TransferBaselineHours. | Merged To WorkStep.TransferBaselineHours · pending |
| 4 | TransferBlockHours | Decimal? | Nullable | Merge into the shared WorkStep.TransferBlockHours. | Merged To WorkStep.TransferBlockHours · pending |
| 5 | TransferCycles | Decimal? | Nullable | Merge into the shared WorkStep.TransferCycles. | Merged To WorkStep.TransferCycles · pending |
| 6 | TransferHours | Decimal? | Nullable | Merge into the shared WorkStep.TransferHours. | Merged To WorkStep.TransferHours · pending |
| 7 | UpliftQuantity | Decimal? | Nullable | Merge into the shared WorkStep.Quantity. Replace UpliftQuantity with the existing Quantity field on the same uplift execution row. Preserve original uplift values, reconcile conflicts explicitly and adapt API/UI validation during later adoption. The original field remains documented here for review; backend/database changes remain pending complete review. | Merged To WorkStep.Quantity · pending |
Descriptions and details
4 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | TextValue | String | Nullable | Merge into the shared WorkStep.TextValue. | Merged To WorkStep.TextValue · pending |
| 2 | ActionRemarks | String | Nullable | Merge into the shared WorkStep.ActionRemarks. | Merged To WorkStep.ActionRemarks · pending |
| 3 | ActionText | String | Nullable | Merge into the shared WorkStep.ActionText. | Merged To WorkStep.ActionText · pending |
| 4 | MeasurementText | String | Nullable | Merge into the shared WorkStep.TextValue. Merge MeasurementText into the retained TextValue property for individual textual/custom measurement results. Preserve original answers, repeated result rows, historical definition/allowed-answer context and explicit N/A handling. Reconcile conflicting values on the same legacy row and adapt measurement save/closure validation during adoption. Backend/database unchanged. | Merged To WorkStep.TextValue · pending |
Audit and revision
2 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | SystemAuditId | Guid? | Nullable | Merge into the shared WorkStep.SystemAuditId. | Merged To WorkStep.SystemAuditId · pending |
| 2 | UpdateId | Guid? | Nullable | Merge into the shared WorkStep.UpdateId. | Merged To WorkStep.UpdateId · pending |
Other fields
27 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | CalculatedValue | Decimal? | Nullable | Drop CalculatedValue from the unified WorkStep proposal. Formula calculation, result storage and limit evaluation remain under review before backend/database adoption. | Dropped Removal pending complete review |
| 2 | NumericValue | Decimal? | Nullable | Records numeric value for this workorder execution entry. | — |
| 3 | PassFailValue | Boolean? | Nullable | Records pass fail value for this workorder execution entry. | — |
| 4 | RecordKind | WorkStepRecordKind { Execution, Repository, RepositoryRevision, ExecutionEntry, ResourceRequest, MeasurementDefinition, SoftwareChangePlan, ComponentSelection, ExecutionOccurrence, ResourceAssignment, MaterialDemand }EF: WorkStepRecordKind | Required | Merge into the shared WorkStep.RecordKind. | Merged To WorkStep.RecordKind · pending |
| 5 | WithinLimits | Boolean? | Nullable | Drop the standalone WithinLimits property from the unified WorkStep proposal. Assess each recorded measurement against the applicable MeasurementIdentifier limit type, lower/upper limits and unit through MeasurementIdentifierId. The outcome belongs to that individual reading; do not store one shared WithinLimits flag on the reusable identifier. Preserve existing true/false/null assessments, the measured value and the original definition/version used, and reconcile historical cases without silently recalculating them against changed master limits. Define how missing results, absent limits and custom/discrete answers are assessed; preserve an unknown/not-evaluated state when an assessment cannot be made. Measurement-result storage and validation remain pending complete review; backend/database unchanged. | Dropped Removal pending complete review |
| 6 | ActionSigner | String | Nullable | Merge into the shared WorkStep.ActionSigner. | Merged To WorkStep.ActionSigner · pending |
| 7 | ActionTitle | String | Nullable | Merge into the shared WorkStep.ActionTitle. | Merged To WorkStep.ActionTitle · pending |
| 8 | ActionTypeDB: EntryType | WorkStepEntryType { Action, InspectionAction, Measurement, Transfer, Uplift, ComponentChange, Time, SoftwareUpdate, ComponentShopAction, DoubleInspectionAction, MechanicSign, Crs, ReinspectionAction, Sign, Inspect }EF: WorkStepEntryType | Required | Merge into the shared WorkStep.EntryType. | Merged To WorkStep.EntryType · pending |
| 9 | CloseWorkStep | Boolean | Required | Keep CloseWorkStep only as a transient request-command option, not a stored WorkStep property. The option and the direct complete-work endpoint invoke the same lifecycle validation and atomic transition into WorkStatus.Completed. Persist the signed action and transition audit; retries must not duplicate evidence. Quality approval, release and final administrative closure remain separately validated transitions in the same WorkStatus lifecycle. HTML review decision; backend / database adoption pending complete review. | Dropped Removal pending complete review |
| 10 | ComponentMovement | WorkorderComponentMovement? { Install, Remove }EF: WorkorderComponentMovement? Requested: ComponentActionType? | Nullable | Merge into the shared WorkStep.ComponentActionType. Replace ComponentMovement with ComponentActionType in the unified proposal; preserve legacy data and role-specific validation during later adoption. | Merged To WorkStep.ComponentActionType · pending |
| 11 | LowerLimit | Decimal? | Nullable | Drop the standalone WorkStep LowerLimit field. Reference MeasurementIdentifier.LowerLimit through WorkStep.MeasurementIdentifierId for the reusable measurement definition. Map legacy numeric limits into the linked definition, reconcile differing values and preserve the limit applicable to historical results during later implementation. A numeric limit is not a lookup UUID. Backend/database adoption deferred. | Dropped Removal pending complete review |
| 12 | MeasurementIdentifier | String | Nullable | Merge into the shared WorkStep.MeasurementIdentifier. | Merged To WorkStep.MeasurementIdentifier · pending |
| 13 | MeasurementNotApplicable | Boolean | Required | Merge into the shared WorkStep.MeasurementNotApplicable. | Merged To WorkStep.MeasurementNotApplicable · pending |
| 14 | MeasurementType | WorkorderMeasurementType? { Numerical, Custom }EF: WorkorderMeasurementType? | Nullable | Records measurement type for this workorder execution entry. | — |
| 15 | MeasurementUnit | String | Nullable | Records measurement unit for this workorder execution entry. | — |
| 16 | MeasurementValue | Decimal? | Nullable | Records measurement value for this workorder execution entry. | — |
| 17 | MelCategory | String | Nullable | Records mel category for this workorder execution entry. | — |
| 18 | Sequence | Int32 | Required | Merge into the shared WorkStep.Sequence. | Merged To WorkStep.Sequence · pending |
| 19 | TransferBaseline | DateTime? | Nullable | Merge into the shared WorkStep.TransferBaseline. | Merged To WorkStep.TransferBaseline · pending |
| 20 | TransferDays | Decimal? | Nullable | Merge into the shared WorkStep.TransferDays. | Merged To WorkStep.TransferDays · pending |
| 21 | TransferDeferralKind | WorkorderTransferDeferralKind? { Ordinary, Defer }EF: WorkorderTransferDeferralKind? | Nullable | Merge into the shared WorkStep.TransferDeferralKind. | Merged To WorkStep.TransferDeferralKind · pending |
| 22 | TransferInputType | WorkorderTransferInputType? { ToGo, Due }EF: WorkorderTransferInputType? | Nullable | Merge into the shared WorkStep.TransferInputType. | Merged To WorkStep.TransferInputType · pending |
| 23 | TransferStation | String | Nullable | Merge into the shared WorkStep.TransferStation. | Merged To WorkStep.TransferStation · pending |
| 24 | TransferType | WorkorderTransferType? { NewLimits, NoNewLimits, ExtendExistingLimits, AdjustExistingLimits }EF: WorkorderTransferType? | Nullable | Merge into the shared WorkStep.TransferType. | Merged To WorkStep.TransferType · pending |
| 25 | Troubleshooting | Boolean | Required | Manage the troubleshooting requirement through CriticalEvent.ControlOptions.RequiresTroubleshooting selected by CriticalEventId. Record actual troubleshooting and its outcome in the linked execution/component-removal action using ActionText and existing component identity fields. Preserve the legacy removal troubleshooting marker as historical action evidence. Selecting a requirement does not prove work was performed, and performed work must not create a requirement automatically. There is no second editable troubleshooting Boolean on WorkStep. HTML review decision; backend / database adoption pending complete review. | Dropped Removal pending complete review |
| 26 | UpliftUnit | String | Nullable | Merge into the shared WorkStep.UpliftUnit. | Merged To WorkStep.UpliftUnit · pending |
| 27 | UpperLimit | Decimal? | Nullable | Drop the duplicate UpperLimit field from the unified WorkStep proposal. Obtain the measurement upper acceptance limit from MeasurementIdentifier.UpperLimit through MeasurementIdentifierId, together with the applicable limit type and unit. Reconcile differing legacy step and identifier limits explicitly and preserve the definition/version applicable to historical readings so later master changes do not reinterpret prior acceptance decisions. Adapt measurement planning and result/closure validation during later adoption. Backend/database adoption remains pending complete review. | Dropped Removal pending complete review |