Coflyr · Backend model field catalog
WorkStepMeasurementDefinition
Maintenance.WorkStep.
28 mapped fields6 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.
- Distinguish MeasurementId (a unique label within this work step for formula references) from MeasurementIdentifierId (optional reusable discrete-answer set). These are already distinct backend fields; this entry clarifies their meaning only.
- AMOS example: a measurement ID named XYZ can be used in formula XYZ + 12. Source: amoshelp/backend/Engineering/Work Step Repository.pdf.txt, lines 1581–1588.
- Added UnitGroup, IncludeOnReport, and IncludeOnCalibrationReport to the work-step measurement definition and its planning request.
← 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
1 fields| # | Field | EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | Id | Guid | Required | Merge into the shared WorkStep.Id. | Merged To WorkStep.Id · pending |
Relationships and references
8 fields| # | Field | 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 | MeasurementId | String | Required | Merge into the shared WorkStep.MeasurementIdentifier. Merge MeasurementId into the single MeasurementIdentifier text code for measurement definitions and corresponding execution results. Preserve per-workstep uniqueness of planned codes, formula references and repeated readings; keep MeasurementIdentifierId as the separate reusable definition lookup. Backend/database adoption remains pending complete review. | Merged To WorkStep.MeasurementIdentifier · pending |
| 7 | MeasurementIdentifierId | Guid? | Nullable | Merge into the shared WorkStep.MeasurementIdentifierId. Optional link to a reusable custom answer set (Coflyr MeasurementIdentifier), not the AMOS Measurement ID. Example: select GO_NO_GO so the technician can choose Go or No Go for this measurement. | Merged To WorkStep.MeasurementIdentifierId · pending |
| 8 | WorkStepId | Guid | Required | Merge into the shared WorkStep.WorkStepId. Identifies the work step that owns this measurement definition; the AMOS Measurement ID is unique among measurements on this step. | Merged To WorkStep.WorkStepId · pending |
Status and controls
1 fields| # | Field | EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | RequiresCalibration | Boolean | Required | Drop the duplicate RequiresCalibration field from the unified WorkStep proposal. The reusable MeasurementIdentifier already defines RequiresCalibration; review using that definition through MeasurementIdentifierId. Reconcile any differing legacy step-specific values and preserve the definition/version applicable to historical measurements before retiring WorkStep storage. Calibration-evidence validation and backend/database adoption remain pending complete review. No move to CriticalEvent is approved. | Dropped Removal pending complete review |
Descriptions and details
2 fields| # | Field | 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 |
Audit and revision
2 fields| # | Field | 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
14 fields| # | Field | 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 work step measurement definition. | — |
| 3 | PassFailValue | Boolean? | Nullable | Records pass fail value for this work step measurement definition. | — |
| 4 | RecordKind | 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 | ActionTitle | String | Required | Merge into the shared WorkStep.ActionTitle. | Merged To WorkStep.ActionTitle · pending |
| 7 | IncludeOnCalibrationReport | Boolean | Required | Mark IncludeOnCalibrationReport Dropped from the WorkStep proposal, with further review of measurement report inclusion and reporting configuration before implementation. Backend/database adoption deferred. | Dropped Removal pending complete review |
| 8 | IncludeOnReport | Boolean | Required | Mark IncludeOnReport Dropped from the WorkStep proposal, with further review of measurement report inclusion and reporting configuration before implementation. Backend/database adoption deferred. | Dropped Removal pending complete review |
| 9 | 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 |
| 10 | MeasurementType | WorkorderMeasurementType | Required | Determines whether this measurement records a number or a discrete custom result; the choice set link supplies allowed answers for a custom result. | — |
| 11 | Sequence | Int32 | Required | Merge into the shared WorkStep.Sequence. | Merged To WorkStep.Sequence · pending |
| 12 | Unit | String | Nullable | Drop the duplicate Unit field from the unified WorkStep proposal. Obtain this measurement definition value from MeasurementIdentifier.Unit through MeasurementIdentifierId. Reconcile differing legacy step and identifier values explicitly and preserve the unit/group and definition version applicable to each historical reading so later changes to a reusable definition do not reinterpret recorded values. Adapt measurement planning, input and validation during later adoption. Backend/database adoption remains pending complete review. | Dropped Removal pending complete review |
| 13 | UnitGroup | String | Nullable | Drop the duplicate UnitGroup field from the unified WorkStep proposal. Obtain this measurement definition value from MeasurementIdentifier.UnitGroup through MeasurementIdentifierId. Reconcile differing legacy step and identifier values explicitly and preserve the unit/group and definition version applicable to each historical reading so later changes to a reusable definition do not reinterpret recorded values. Adapt measurement planning, input and validation during later adoption. Backend/database adoption remains pending complete review. | Dropped Removal pending complete review |
| 14 | 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 |