Coflyr · Backend model field catalog

StaffCompetencyCompletion

HumanResources.StaffCompetencyCompletions.

20 mapped fields7 field groupsGenerated 2026-10-06
Model class
coflyr.models.manpower.StaffCompetencyCompletion
Source
Features/Manpower/StaffCompetencyCompletion/Models/StaffCompetencyCompletion.cs
Table
HumanResources.StaffCompetencyCompletions
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
#FieldEF typeStorageBusiness purpose
1IdGuidRequiredStable identifier for this record.
2CompletionReferenceNumberstringNullableRecords completion reference number for this staff competency completion.

Relationships and references

2 fields
#FieldEF typeStorageBusiness purpose
1CompetencyTemplateIdGuidRequiredSelects the related competency template record.
2StaffMemberIdGuidRequiredSelects the related staff member record.

Status and controls

1 fields
#FieldEF typeStorageBusiness purpose
1CompletionStatusintRequiredTracks the completion status of this staff competency completion.

Dates and timing

4 fields
#FieldEF typeStorageBusiness purpose
1ExpiryDateDateTime?NullableRecords the expiry date for this staff competency completion.
2GraceDueDateDateTime?NullableRecords the grace due date for this staff competency completion.
3NextDueDateDateTime?NullableRecords the next due date for this staff competency completion.
4RenewalWindowStartDateDateTime?NullableRecords the renewal window start date for this staff competency completion.

Amounts and measurements

2 fields
#FieldEF typeStorageBusiness purpose
1ActualHoursdecimal?NullableRecords actual hours for this staff competency completion.
2ActualPercentagedecimal?NullableRecords actual percentage for this staff competency completion.

Audit and revision

2 fields
#FieldEF typeStorageBusiness purpose
1SystemAuditIdGuid?NullableLinks to system audit history when this model stores the reference.
2UpdateIdGuid?NullableLinks to the preceding revision or update record.

Other fields

7 fields
#FieldEF typeStorageBusiness purpose
1ActualAttemptsint?NullableRecords the actual attempts for this staff competency completion.
2ActualGpadecimal?NullableRecords actual gpa for this staff competency completion.
3ActualMarksdecimal?NullableRecords actual marks for this staff competency completion.
4CompletedAtDateTime?NullableRecords the completed at for this staff competency completion.
5CompletionProviderstringNullableRecords completion provider for this staff competency completion.
6CompletionTypeint?NullableRecords completion type for this staff competency completion.
7ValidFromDateTime?NullableRecords valid from for this staff competency completion.