Coflyr · Backend model field catalog

ProductionPlanElement

public.ProductionPlanElements.

42 mapped fields8 field groupsGenerated 2026-10-08

Model class: coflyr.features.production.planning.models.ProductionPlanElement
Source: Features/Production/Planning/Models/ProductionPlanProgramModels.cs
Table: public.ProductionPlanElements
Review: Under development · marked 2026-10-08 · Shared aircraft/component planning backend class updated. Database migration and legacy component table retirement remain pending until complete project review. Field listing reflects current backend EF model, not the unchanged database snapshot.

Every mapped scalar field appears once. Types and nullability come from the updated backend EF model. Database migration is pending. Navigation properties and unmapped DTO fields are outside this page. Purpose text is inferred from names and should be checked against the feature workflow.

← All model classes · AMOS Workpackage example

Backend updated; database pending. Fields on this page reflect the common aircraft/component planning classes. They are not a claim that the existing database schema has been migrated.

Identity and naming

4 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`ElementName`	`string`	Required	Records element name for this production plan element.
3	`RowNumber`	`int`	Required	Records row number for this production plan element.
4	`SequenceNumber`	`int`	Required	Records sequence number for this production plan element.

Relationships and references

7 fields

#	Field	EF type	Storage	Business purpose
1	`AtaId`	`Guid?`	Nullable	Selects the related ata record.
2	`ParentElementId`	`Guid?`	Nullable	Selects the related parent element record.
3	`ProductionPlanId`	`Guid?`	Nullable	Selects the related production plan record.
4	`ProductionPlanTemplateId`	`Guid?`	Nullable	Selects the related production plan template record.
5	`TaskCardId`	`Guid?`	Nullable	Selects the related task card record.
6	`WorkStepId`	`Guid?`	Nullable	Selects the related work step record.
7	`WorkorderId`	`Guid?`	Nullable	Selects the related workorder record.

Status and controls

6 fields

#	Field	EF type	Storage	Business purpose
1	`Accomplished`	`bool`	Required	Indicates whether accomplished applies to this production plan element.
2	`Closed`	`bool`	Required	Indicates whether closed applies to this production plan element.
3	`Critical`	`bool`	Required	Indicates whether critical applies to this production plan element.
4	`DefaultFindingGroup`	`bool`	Required	Indicates whether default finding group applies to this production plan element.
5	`InternalMilestone`	`bool`	Required	Indicates whether internal milestone applies to this production plan element.
6	`Suspended`	`bool`	Required	Indicates whether suspended applies to this production plan element.

Dates and timing

7 fields

#	Field	EF type	Storage	Business purpose
1	`ActualEnd`	`DateTime?`	Nullable	Records actual end for this production plan element.
2	`ActualStart`	`DateTime?`	Nullable	Records actual start for this production plan element.
3	`OriginalEnd`	`DateTime?`	Nullable	Records original end for this production plan element.
4	`OriginalStart`	`DateTime?`	Nullable	Records original start for this production plan element.
5	`ScheduledEnd`	`DateTime?`	Nullable	Records scheduled end for this production plan element.
6	`ScheduledStart`	`DateTime?`	Nullable	Records scheduled start for this production plan element.
7	`StartOffsetMinutes`	`int`	Required	Records start offset minutes for this production plan element.

Amounts and measurements

4 fields

#	Field	EF type	Storage	Business purpose
1	`AchievedPercent`	`decimal`	Required	Stores the achieved percent used by this production plan element.
2	`BookedManHours`	`decimal`	Required	Records booked man hours for this production plan element.
3	`DurationMinutes`	`int`	Required	Records duration minutes for this production plan element.
4	`EstimatedManHours`	`decimal`	Required	Records estimated man hours for this production plan element.

Descriptions and details

1 fields

#	Field	EF type	Storage	Business purpose
1	`SuspensionReason`	`string`	Nullable	Records suspension reason for this production plan element.

Audit and revision

2 fields

#	Field	EF type	Storage	Business purpose
1	`SystemAuditId`	`Guid?`	Nullable	Links to system audit history when this model stores the reference.
2	`UpdateId`	`Guid?`	Nullable	Links to the preceding revision or update record.

Other fields

11 fields

#	Field	EF type	Storage	Business purpose
1	`AreaCode`	`string`	Nullable	Records area code for this production plan element.
2	`Color`	`string`	Nullable	Records color for this production plan element.
3	`Criteria`	`string`	Nullable	Records criteria for this production plan element.
4	`ElementType`	`ProductionPlanElementType`	Required	Records element type for this production plan element.
5	`MilestoneAccomplishedAt`	`DateTime?`	Nullable	Records the milestone accomplished at for this production plan element.
6	`PanelCode`	`string`	Nullable	Records panel code for this production plan element.
7	`PhaseCode`	`string`	Nullable	Records phase code for this production plan element.
8	`QualificationCode`	`string`	Nullable	Records qualification code for this production plan element.
9	`ShopRequestCode`	`string`	Nullable	Records shop request code for this production plan element.
10	`SpecialCode`	`string`	Nullable	Records special code for this production plan element.
11	`SuspendedAt`	`DateTime?`	Nullable	Records the suspended at for this production plan element.