Coflyr · Backend model field catalog

Effectivity

Common.Effectivities.

44 mapped fields6 field groupsGenerated 2026-10-06

Model class: coflyr.models.common.Effectivity
Source: Features/MaintenanceProgram/Effectivity/Models/Effectivity.cs
Table: Common.Effectivities
Review: Not marked

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.

← All model classes · AMOS Workpackage example

Identity and naming

3 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`SequenceNo`	`int?`	Nullable	Records sequence no for this effectivity.
3	`SerialNumber`	`string`	Nullable	Records serial number for this effectivity.

Relationships and references

16 fields

#	Field	EF type	Storage	Business purpose
1	`ConfigurationId`	`Guid?`	Nullable	Selects the related configuration record.
2	`ConfigurationMasterId`	`Guid?`	Nullable	Selects the related configuration master record.
3	`DeferredDefectMasterId`	`Guid?`	Nullable	Selects the related deferred defect master record.
4	`DeferredMaintenanceMasterId`	`Guid?`	Nullable	Selects the related deferred maintenance master record.
5	`LearningActivityId`	`Guid?`	Nullable	Selects the related learning activity record.
6	`MaintenanceProgramMasterId`	`Guid?`	Nullable	Selects the related maintenance program master record.
7	`MaintenanceTaskId`	`Guid?`	Nullable	Selects the related maintenance task record.
8	`OperationSpecificationId`	`Guid?`	Nullable	Selects the related operation specification record.
9	`ParentNodeId`	`Guid?`	Nullable	Selects the related parent node record.
10	`PartBomId`	`Guid?`	Nullable	Selects the related part bom record.
11	`PartId`	`Guid?`	Nullable	Selects the related part record.
12	`PublicationMasterId`	`Guid?`	Nullable	Selects the related publication master record.
13	`RequirementId`	`Guid?`	Nullable	Selects the related requirement record.
14	`RotableId`	`Guid?`	Nullable	Selects the related rotable record.
15	`TaskCardId`	`Guid?`	Nullable	Selects the related task card record.
16	`TrainingNeedAnalysisId`	`Guid?`	Nullable	Selects the related training need analysis record.

Status and controls

5 fields

#	Field	EF type	Storage	Business purpose
1	`AllSerialNumbers`	`bool`	Required	Indicates whether all serial numbers applies to this effectivity.
2	`ExcludeRestrictions`	`bool`	Required	Indicates whether exclude restrictions applies to this effectivity.
3	`IncludeRestrictions`	`bool`	Required	Indicates whether include restrictions applies to this effectivity.
4	`IsConditional`	`bool`	Required	Indicates whether conditional applies to this effectivity.
5	`OnlySpecificSerialNumbers`	`bool`	Required	Indicates whether only specific serial numbers applies to this effectivity.

Descriptions and details

1 fields

#	Field	EF type	Storage	Business purpose
1	`RangeRemarks`	`string`	Nullable	Records range remarks for this effectivity.

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

17 fields

#	Field	EF type	Storage	Business purpose
1	`Department`	`string`	Nullable	Records department for this effectivity.
2	`EffectiveFrom`	`DateTime?`	Nullable	Records effective from for this effectivity.
3	`EffectiveTo`	`DateTime?`	Nullable	Records effective to for this effectivity.
4	`EffectivityCode`	`string`	Nullable	Records effectivity code for this effectivity.
5	`EffectivityTitle`	`string`	Nullable	Records effectivity title for this effectivity.
6	`NodeType`	`int`	Required	Records node type for this effectivity.
7	`OperationApplicability`	`int`	Required	Records operation applicability for this effectivity.
8	`RangeShift`	`int`	Required	Records range shift for this effectivity.
9	`RelationshipType`	`int`	Required	Records relationship type for this effectivity.
10	`ReportingBackMessage`	`string`	Nullable	Records reporting back message for this effectivity.
11	`Scope`	`int`	Required	Records scope for this effectivity.
12	`SerialFrom`	`string`	Nullable	Records serial from for this effectivity.
13	`SerialNumberType`	`int`	Required	Records serial number type for this effectivity.
14	`SerialPrefix`	`string`	Nullable	Records serial prefix for this effectivity.
15	`SerialSelectionType`	`int`	Required	Records serial selection type for this effectivity.
16	`SerialTo`	`string`	Nullable	Records serial to for this effectivity.
17	`TargetType`	`int`	Required	Records target type for this effectivity.