Coflyr · Backend model field catalog

CompetencyDefinitionFrequency

CompetencyTraining.CompetencyDefinitionFrequencies.

37 mapped fields6 field groupsGenerated 2026-10-06

Model class: coflyr.models.manpower.CompetencyDefinitionFrequency
Source: Features/Manpower/CompetencyDefinitionFrequency/Models/CompetencyDefinitionFrequency.cs
Table: CompetencyTraining.CompetencyDefinitionFrequencies
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

2 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 competency definition frequency.

Relationships and references

2 fields

#	Field	EF type	Storage	Business purpose
1	`CompetencyDefinitionId`	`Guid`	Required	Selects the related competency definition record.
2	`ParentCompetencyDefinitionFrequencyId`	`Guid?`	Nullable	Selects the related parent competency definition frequency record.

Status and controls

6 fields

#	Field	EF type	Storage	Business purpose
1	`ApplyTolerance`	`bool?`	Nullable	Indicates whether apply tolerance applies to this competency definition frequency.
2	`FrequencyStatus`	`int`	Required	Tracks the frequency status of this competency definition frequency.
3	`IsFrequencyGroupHeader`	`bool`	Required	Indicates whether frequency group header applies to this competency definition frequency.
4	`IsRepetitive`	`bool?`	Nullable	Indicates whether repetitive applies to this competency definition frequency.
5	`IsUnlimited`	`bool?`	Nullable	Indicates whether unlimited applies to this competency definition frequency.
6	`TerminateInterval`	`bool?`	Nullable	Indicates whether terminate interval applies to this competency definition frequency.

Dates and timing

5 fields

#	Field	EF type	Storage	Business purpose
1	`DueDate`	`DateOnly?`	Nullable	Records the due date for this competency definition frequency.
2	`ExpectedDate`	`DateOnly?`	Nullable	Records the expected date for this competency definition frequency.
3	`LastCompletedDate`	`DateTime?`	Nullable	Records the last completed date for this competency definition frequency.
4	`NextDueDate`	`DateTime?`	Nullable	Records the next due date for this competency definition frequency.
5	`NextDueStrategy`	`string`	Nullable	Records the next due strategy for this competency definition frequency.

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

20 fields

#	Field	EF type	Storage	Business purpose
1	`CalculationInfo`	`string`	Nullable	Records calculation info for this competency definition frequency.
2	`FrequencyCode`	`string`	Nullable	Records frequency code for this competency definition frequency.
3	`FrequencyNodeType`	`int?`	Nullable	Records frequency node type for this competency definition frequency.
4	`FrequencyRemark`	`string`	Nullable	Records frequency remark for this competency definition frequency.
5	`FrequencyTitle`	`string`	Nullable	Records frequency title for this competency definition frequency.
6	`GracePeriodDays`	`int?`	Nullable	Records grace period days for this competency definition frequency.
7	`IntervalUnit`	`int?`	Nullable	Records interval unit for this competency definition frequency.
8	`IntervalValue`	`decimal?`	Nullable	Records interval value for this competency definition frequency.
9	`LowerRange`	`decimal?`	Nullable	Records lower range for this competency definition frequency.
10	`RenewalWindowDays`	`int?`	Nullable	Records renewal window days for this competency definition frequency.
11	`RequirementValue`	`string`	Nullable	Records requirement value for this competency definition frequency.
12	`RequirementValueType`	`string`	Nullable	Records requirement value type for this competency definition frequency.
13	`RulesAndProblemsJson`	`string`	Nullable	Records rules and problems json for this competency definition frequency.
14	`ThresholdValue`	`decimal?`	Nullable	Records threshold value for this competency definition frequency.
15	`ToGoDays`	`int?`	Nullable	Records to go days for this competency definition frequency.
16	`ToleranceNegative`	`decimal?`	Nullable	Records tolerance negative for this competency definition frequency.
17	`TolerancePositive`	`decimal?`	Nullable	Records tolerance positive for this competency definition frequency.
18	`UpperRange`	`decimal?`	Nullable	Records upper range for this competency definition frequency.
19	`ValidityUnit`	`int?`	Nullable	Records validity unit for this competency definition frequency.
20	`ValidityValue`	`decimal?`	Nullable	Records validity value for this competency definition frequency.