Coflyr · Backend model field catalog

CompetencyTemplate

CompetencyTraining.CompetencyTemplates.

68 mapped fields7 field groupsGenerated 2026-10-06

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

7 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`Code`	`string`	Required	Records code for this competency template.
3	`Name`	`string`	Required	Records name for this competency template.
4	`QualificationClassName`	`string`	Nullable	Records qualification class name for this competency template.
5	`QualificationTypeName`	`string`	Nullable	Records qualification type name for this competency template.
6	`RecordName`	`string`	Nullable	Records record name for this competency template.
7	`RequiresRegulatoryApprovalNumber`	`bool`	Required	Indicates whether regulatory approval number applies to this competency template.

Relationships and references

5 fields

#	Field	EF type	Storage	Business purpose
1	`DefaultTrainingProviderBusinessPartnerId`	`Guid?`	Nullable	Selects the related default training provider business partner record.
2	`ParentCompetencyTemplateId`	`Guid?`	Nullable	Selects the related parent competency template record.
3	`PlanningQualificationId`	`Guid?`	Nullable	Selects the related planning qualification record.
4	`PrerequisiteCompetencyTemplateId`	`Guid?`	Nullable	Selects the related prerequisite competency template record.
5	`TrainingMaterialReference`	`string`	Nullable	Records training material reference for this competency template.

Status and controls

15 fields

#	Field	EF type	Storage	Business purpose
1	`DefaultCanDoubleInspect`	`bool`	Required	Indicates whether default can double inspect applies to this competency template.
2	`DefaultCanInspect`	`bool`	Required	Indicates whether default can inspect applies to this competency template.
3	`DefaultCanPerform`	`bool`	Required	Indicates whether default can perform applies to this competency template.
4	`ExaminationCleared`	`bool`	Required	Indicates whether examination cleared applies to this competency template.
5	`IsMandatory`	`bool`	Required	Indicates whether mandatory applies to this competency template.
6	`IsRecurrent`	`bool`	Required	Indicates whether recurrent applies to this competency template.
7	`IsTemplateGroupHeader`	`bool`	Required	Indicates whether template group header applies to this competency template.
8	`PlanningStatus`	`int?`	Nullable	Tracks the planning status of this competency template.
9	`RequiredForCertifyingStaff`	`bool`	Required	Indicates whether required for certifying staff applies to this competency template.
10	`RequiredForExternalStaff`	`bool`	Required	Indicates whether required for external staff applies to this competency template.
11	`RequiresAircraftTypeScope`	`bool`	Required	Indicates whether aircraft type scope applies to this competency template.
12	`RequiresDoubleInspectionSign`	`bool`	Required	Indicates whether double inspection sign applies to this competency template.
13	`RequiresInspectionSign`	`bool`	Required	Indicates whether inspection sign applies to this competency template.
14	`RequiresPerformedSign`	`bool`	Required	Indicates whether performed sign applies to this competency template.
15	`RestrictToAircraftApplicability`	`bool`	Required	Indicates whether restrict to aircraft applicability applies to this competency template.

Amounts and measurements

5 fields

#	Field	EF type	Storage	Business purpose
1	`DefaultTrainingHours`	`decimal?`	Nullable	Records default training hours for this competency template.
2	`ExaminationDurationMinutes`	`int?`	Nullable	Records examination duration minutes for this competency template.
3	`MinimumHours`	`decimal?`	Nullable	Records minimum hours for this competency template.
4	`PercentagePass`	`decimal?`	Nullable	Records percentage pass for this competency template.
5	`TotalMarks`	`decimal?`	Nullable	Records total marks for this competency template.

Descriptions and details

1 fields

#	Field	EF type	Storage	Business purpose
1	`PassingRuleDescription`	`string`	Nullable	Records passing rule description for this competency template.

Audit and revision

3 fields

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

Other fields

32 fields

#	Field	EF type	Storage	Business purpose
1	`AircraftModelCode`	`string`	Nullable	Records aircraft model code for this competency template.
2	`AircraftSubTypeCode`	`string`	Nullable	Records aircraft sub type code for this competency template.
3	`AircraftTypeCode`	`string`	Nullable	Records aircraft type code for this competency template.
4	`AuthorizationType`	`int`	Required	Records authorization type for this competency template.
5	`CertificateTemplateCode`	`string`	Nullable	Records certificate template code for this competency template.
6	`CourseCode`	`string`	Nullable	Records course code for this competency template.
7	`CourseTitle`	`string`	Nullable	Records course title for this competency template.
8	`CoverageDefinition`	`string`	Nullable	Records coverage definition for this competency template.
9	`ExaminationCode`	`string`	Nullable	Records examination code for this competency template.
10	`ExaminationTitle`	`string`	Nullable	Records examination title for this competency template.
11	`ExternalSystemCode`	`string`	Nullable	Records external system code for this competency template.
12	`GpaPass`	`decimal?`	Nullable	Records gpa pass for this competency template.
13	`GracePeriodDays`	`int?`	Nullable	Records grace period days for this competency template.
14	`MaintenanceLevelGranted`	`int?`	Nullable	Records maintenance level granted for this competency template.
15	`MinimumAttempts`	`int?`	Nullable	Records the minimum attempts for this competency template.
16	`MinimumMarks`	`decimal?`	Nullable	Records minimum marks for this competency template.
17	`QualificationClassCode`	`string`	Nullable	Records qualification class code for this competency template.
18	`QualificationTypeCode`	`string`	Nullable	Records qualification type code for this competency template.
19	`QualificationValue`	`string`	Nullable	Records qualification value for this competency template.
20	`RecordCode`	`string`	Nullable	Records record code for this competency template.
21	`RecurrentFrequencyUnit`	`int?`	Nullable	Records recurrent frequency unit for this competency template.
22	`RecurrentFrequencyValue`	`int?`	Nullable	Records recurrent frequency value for this competency template.
23	`RegulatoryFramework`	`int`	Required	Records regulatory framework for this competency template.
24	`RenewalWindowDays`	`int?`	Nullable	Records renewal window days for this competency template.
25	`RequirementType`	`int`	Required	Records requirement type for this competency template.
26	`ResourceRequirementClassificationCode`	`string`	Nullable	Records resource requirement classification code for this competency template.
27	`ScopeCode`	`string`	Nullable	Records scope code for this competency template.
28	`SyllabusCode`	`string`	Nullable	Records syllabus code for this competency template.
29	`TemplateType`	`int`	Required	Records template type for this competency template.
30	`TrainingDeliveryMethod`	`string`	Nullable	Records training delivery method for this competency template.
31	`ValidityPeriodUnit`	`int?`	Nullable	Records validity period unit for this competency template.
32	`ValidityPeriodValue`	`int?`	Nullable	Records validity period value for this competency template.