Coflyr · Backend model field catalog
TrainingNeedAnalysis
CompetencyTraining.TrainingNeedAnalyses.
23 mapped fields7 field groupsGenerated 2026-10-06
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.
Identity and naming
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Id | Guid | Required | Stable identifier for this record. |
Relationships and references
3 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | LearningActivityId | Guid? | Nullable | Selects the related learning activity record. |
| 2 | RegulatoryReferenceBusinessPartnerId | Guid? | Nullable | Selects the related regulatory reference business partner record. |
| 3 | TnaReference | string | Nullable | Records tna reference for this training need analysis. |
Status and controls
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | NonTrainingCorrectiveActionRequired | bool | Required | Indicates whether non training corrective action required applies to this training need analysis. |
| 2 | TrainingRequired | bool | Required | Indicates whether training required applies to this training need analysis. |
Dates and timing
4 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | EffectivenessReviewDueDate | DateTime? | Nullable | Records the effectiveness review due date for this training need analysis. |
| 2 | IdentifiedDate | DateTime? | Nullable | Records the identified date for this training need analysis. |
| 3 | TargetCompletionDate | DateTime? | Nullable | Records the target completion date for this training need analysis. |
| 4 | TrainingDueDate | DateTime? | Nullable | Records the training due date for this training need analysis. |
Descriptions and details
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | NonTrainingReason | string | Nullable | Records non training reason for this training need analysis. |
Audit and revision
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | UpdateId | Guid? | Nullable | Links to the preceding revision or update record. |
Other fields
11 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AnalysisCode | string | Required | Records analysis code for this training need analysis. |
| 2 | AnalysisTitle | string | Required | Records analysis title for this training need analysis. |
| 3 | EffectivenessCheck | string | Nullable | Records effectiveness check for this training need analysis. |
| 4 | EffectivenessEvidence | string | Nullable | Records effectiveness evidence for this training need analysis. |
| 5 | InterimActions | string | Nullable | Records interim actions for this training need analysis. |
| 6 | OrganisationType | int | Required | Records organisation type for this training need analysis. |
| 7 | Priority | int | Required | Records priority for this training need analysis. |
| 8 | RequirementSource | string | Nullable | Records requirement source for this training need analysis. |
| 9 | RiskAssessment | string | Nullable | Records risk assessment for this training need analysis. |
| 10 | SourceType | int | Required | Records source type for this training need analysis. |
| 11 | TnaType | int | Required | Records tna type for this training need analysis. |