Coflyr · Backend model field catalog
WorkStepResourceRequest
Maintenance.WorkStep.
28 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
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
7 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 | AuthorizationId | Guid? | Nullable | Merge into the shared WorkStep.AuthorizationId. | Merged To WorkStep.AuthorizationId · pending |
| 7 | 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 | RequestStatus | WorkStepResourceRequestStatus { Requested, Cancelled, Fulfilled }EF: WorkStepResourceRequestStatus | Required | Merge into the shared WorkStep.RequestStatus. Retained as WorkStep.RequestStatus on ResourceRequest rows only. Requested, Cancelled and Fulfilled describe the resource service request; Fulfilled requires confirmed provision of the requested service, rather than allocation alone. Material-demand summaries are separately derived from MaterialPartRequest fulfilment and cannot be independently edited. Backend/database adoption remains pending complete review. | Merged To WorkStep.RequestStatus · pending |
Dates and timing
3 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | RequestedEnd | DateTime? | Nullable | Merge into the shared WorkStep.RequestedEnd. Requested end of the resource-demand planning window. Distinct from ActionEndDate on an action or resource-assignment row. Saved assignments must remain within their owning request window. | Merged To WorkStep.RequestedEnd · pending |
| 2 | RequestedStart | DateTime? | Nullable | Merge into the shared WorkStep.RequestedStart. Requested start of the resource-demand planning window. Distinct from the actual action interval and the saved resource allocation interval, each on its own row. | Merged To WorkStep.RequestedStart · pending |
| 3 | TimeOffsetHours | Decimal? | Nullable | Merge into the shared WorkStep.TimeOffsetHours. | Merged To WorkStep.TimeOffsetHours · pending |
Amounts and measurements
3 fields| # | Field | Model / EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | DurationHours | Decimal? | Nullable | Merge into the shared WorkStep.DurationHours. | Merged To WorkStep.DurationHours · pending |
| 2 | Quantity | Decimal | Required | Merge into the shared WorkStep.Quantity. | Merged To WorkStep.Quantity · pending |
| 3 | TotalHours | Decimal? | Nullable | Merge into the shared WorkStep.TotalHours. | Merged To WorkStep.TotalHours · 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
9 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 resource request. | — |
| 3 | PassFailValue | Boolean? | Nullable | Records pass fail value for this work step resource request. | — |
| 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 | ClassificationCode | String | Nullable | Merge into the shared WorkStep.ClassificationCode. Optional resource-request classification. Under review for later implementation; category definitions, lookup design and resource/authorization integration remain to be decided. | Merged To WorkStep.ClassificationCode · pending |
| 7 | ResourceCode | String | Nullable | Merge into the shared WorkStep.ResourceCode. | Merged To WorkStep.ResourceCode · pending |
| 8 | ResourceType | WorkStepResourceType { Aircraft, ToolEquipment, Facility, Staff }EF: WorkStepResourceType | Required | Merge into the shared WorkStep.ResourceType. | Merged To WorkStep.ResourceType · pending |
| 9 | ScopeCode | String | Nullable | Merge into the shared WorkStep.ScopeCode. | Merged To WorkStep.ScopeCode · pending |