Coflyr · Backend model field catalog

ProductionPerformanceSnapshot

Production.ProductionPerformanceSnapshots.

22 mapped fields5 field groupsGenerated 2026-10-08

Model class: coflyr.features.production.execution.models.ProductionPerformanceSnapshot
Source: Features/Production/Execution/Models/ProductionExecutionModels.cs
Table: Production.ProductionPerformanceSnapshots
Review: Under development · marked 2026-10-08 · Common production backend/EF mapping added. Physical schema migration, backfill, frontend and activation remain pending complete project review.

Every mapped scalar field appears once. Types and nullability come from current backend EF metadata; physical 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

Under development · DB pending. Immutable snapshot of progress, earned/actual labor, package downtime, findings and mandatory event requirements. Common production framework.

Identity and naming

1 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.

Relationships and references

1 fields

#	Field	EF type	Storage	Business purpose
1	`ExecutionId`	`Guid`	Required	Production run owning this scope, hold, usage, quality, acceptance or performance record.

Amounts and measurements

7 fields

#	Field	EF type	Storage	Business purpose
1	`ActualManHours`	`decimal`	Required	Finalized Staff-kind bookings within this run, counted once. Cancelled/corrected originals, tool bookings and live bookings are excluded.
2	`HoldElapsedHours`	`decimal`	Required	Union of package-wide hold intervals up to AsOf, avoiding double counting concurrent holds. Task holds remain separate records.
3	`LaborEfficiencyPercent`	`decimal?`	Nullable	100 × planned hours earned by Completed steps ÷ actual finalized staff hours. Null for no actual hours or incomplete baselines.
4	`PlannedManHours`	`decimal`	Required	Frozen estimate from the released plan element. Null means no defensible hour baseline is available.
5	`ProductiveManHours`	`decimal`	Required	Finalized productive staff time, using recorded productive hours or the recorded productivity percentage.
6	`ProgressPercent`	`decimal`	Required	100 × (Completed + NotPerformed) ÷ (Total − Excluded). Empty executable scope reports zero.
7	`TotalSteps`	`int`	Required	Count of frozen run tasks.

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	`AsOf`	`DateTime`	Required	UTC cutoff of this immutable snapshot. Live bookings are excluded from finalized labor totals.
2	`CompletedSteps`	`int`	Required	Tasks whose main WorkStep is Completed at the snapshot cutoff.
3	`ExcludedSteps`	`int`	Required	Cancelled/Removed tasks, excluded from the executable progress denominator.
4	`ExecutionVersion`	`int`	Required	Run version at the time the performance snapshot was captured.
5	`NotPerformedSteps`	`int`	Required	Tasks formally disposed as NotPerformed through the existing controlled step process.
6	`OpenFindings`	`int`	Required	Relevant existing ProductionFindings for scoped orders whose status is not Closed.
7	`OpenHolds`	`int`	Required	Count of uncleared package/task holds at capture time.
8	`OpenSteps`	`int`	Required	Tasks not completed, formally not performed, cancelled or removed.
9	`PendingQualityRequirements`	`int`	Required	All mandatory Pending requirements on the production occurrence, including obligations without a ProductionQualityGate link.
10	`RecordedBy`	`string`	Required	Server-recorded actor recording actual usage or a performance snapshot.
11	`StepsWithoutHourBaseline`	`int`	Required	Tasks with no released-plan manpower estimate. Efficiency is null when any baseline is missing.