Coflyr · Backend model field catalog
WorkStepMaterialDemand
Maintenance.WorkStep.
25 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 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
1 fields| # | Field | Model / 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 | 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 | IpcReference | String | Nullable | Merge into the shared WorkStep.IpcReference. | Merged To WorkStep.IpcReference · pending |
| 7 | PartId | Guid | Required | Merge into the shared WorkStep.PartId. | Merged To WorkStep.PartId · pending |
| 8 | WorkStepId | Guid | Required | Merge into the shared WorkStep.WorkStepId. | Merged To WorkStep.WorkStepId · pending |
Status and controls
3 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | IsTool | Boolean | Required | Mark IsTool Dropped from the unified WorkStep proposal, with later review of tool identification and material-demand classification. Backend/database adoption deferred until complete project review. | Dropped Removal pending complete review |
| 2 | RequestStatus | WorkStepResourceRequestStatus { Requested, Cancelled, Fulfilled }EF: WorkStepResourceRequestStatus | Required | Merge into the shared WorkStep.RequestStatus. Retired independently editable material-demand status. In the unified WorkStep proposal this is a read-only summary derived from linked MaterialPartRequest fulfilment and verified net quantities. Full required quantity supplied means Fulfilled; partial or outstanding supply means Requested; explicitly cancelled unmet demand means Cancelled. Closed or allocated requests alone do not prove fulfilment. Preserve request history and transaction evidence. Backend/database adoption remains pending complete review. | Merged To WorkStep.RequestStatus · pending |
| 3 | RequiredProbabilityPercent | Decimal | Required | Drop RequiredProbabilityPercent from the unified WorkStep proposal. The current field records a 0–100 material-demand probability and is copied into material requests. Preserve existing probability values and review their ownership and treatment in material-demand planning and fulfillment before retiring WorkStep storage; do not silently reinterpret probability as Quantity. No move to CriticalEvent is approved. Backend/database adoption remains pending complete review. | Dropped Removal pending complete review |
Amounts and measurements
2 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | PriceBookCode | String | Nullable | Drop PriceBookCode from the unified WorkStep proposal and review its need later. This optional free-text pricing-catalogue reference is currently copied into material requests; it does not retrieve prices or calculate costs. Preserve existing values and review ownership by purchasing, quotations or material requests before backend/database adoption. No replacement field is approved in this decision; backend/database changes remain pending complete review. | Dropped · Later review |
| 2 | Quantity | Decimal | Required | Merge into the shared WorkStep.Quantity. | Merged To WorkStep.Quantity · pending |
Descriptions and details
2 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 |
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
7 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 work step material demand. | — |
| 3 | PassFailValue | Boolean? | Nullable | Records pass fail value for this work step material demand. | — |
| 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 | AdditionalInfo | String | Nullable | Merge into the shared WorkStep.AdditionalInfo. | Merged To WorkStep.AdditionalInfo · pending |
| 7 | AircraftLocationCode | String | Nullable | Replace AircraftLocationCode with ConfigurationMasterId, existing ConfigurationId and LocationReferenceId (all nullable UUID lookups). Map legacy text and validate matching master/position/location during later adoption. Backend/database changes deferred. | Dropped Removal pending complete review |