title: "SurveyAssessment" category: reference tags: [entity, survey-assessment, datamodel] source: Entities.xml date: 2026-04-17 status: published
SurveyAssessment
Type: Entity Properties: 27 Contexts: 2 Statussen: 8
DB-schema:
lookup_table_schema("SurveyAssessment")· ../tables/SurveyAssessment
Contextsbewerken
- 1: Leveranciersbeoordeling (
SurveyAssessmentContext.VendorRating) - 2: Contractevaluatie (
SurveyAssessmentContext.ContractAssessment)
Statussenbewerken
- -1: Trash (
SurveyAssessmentStatus.Trash) - 0: None (
SurveyAssessmentStatus.None) - 1: In voorbereiding (
SurveyAssessmentStatus.InPreparation) - 2: In uitvoering (
SurveyAssessmentStatus.Active) - 4: Verwerkt (
SurveyAssessmentStatus.Processed) - 8: Vervallen (
SurveyAssessmentStatus.Expired) - 16: Opvolgen (
SurveyAssessmentStatus.FollowUp) - 32: Gereed (
SurveyAssessmentStatus.Finished)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id | UltimoString | SUAID | 10 | false | |
| Context | Context | SUACONTEXT | false | 1 | |
| Description | UltimoString | SUADESCR | 200 | true | |
| Employee | Employee | SUAEMPID | true | ||
| Exported | Boolean | SUAEXPORTED | false | 0 | |
| IncidentalAssessment | Boolean | SUAINCIDENTALASSESSMENT | false | 0 | |
| NumberToSubmit | Int16 | SUANUMBERTOSUBMIT | false | 0 | |
| ProgressStatus | ProgressStatus | SUAPRSID | true | ||
| RecordCreateDate | DateTime | SUARECCREATEDATE | false | SYSDATETIME | |
| RemarkText | UltimoString | SUAREMARKTEXT | true | ||
| Score | Int16 | SUASCORE | false | 0 | |
| ServiceContract | ServiceContract | SUASVCID | true | ||
| Status | Status | SUARECSTATUS | false | 1 | |
| StatusActiveDate | DateTime? | SUAACTIVEDATE | true | ||
| StatusActiveEmployee | Employee | SUAACTIVEEMPID | true | ||
| StatusExpiredDate | DateTime? | SUAEXPIREDDATE | true | ||
| StatusExpiredEmployee | Employee | SUAEXPIREDEMPID | true | ||
| StatusFinishedDate | DateTime? | SUAFINISHEDDATE | true | ||
| StatusFinishedEmployee | Employee | SUAFINISHEDEMPID | true | ||
| StatusFollowUpDate | DateTime? | SUAFOLLOWUPDATE | true | ||
| StatusFollowUpEmployee | Employee | SUAFOLLOWUPEMPID | true | ||
| StatusInPreparationDate | DateTime? | SUAINPREPARATIONDATE | true | SYSDATETIME | |
| StatusInPreparationEmployee | Employee | SUAINPREPARATIONEMPID | true | USERID | |
| StatusProcessedDate | DateTime? | SUAPROCESSEDDATE | true | ||
| StatusProcessedEmployee | Employee | SUAPROCESSEDEMPID | true | ||
| SurveyTemplate | SurveyTemplate | SUASVYTID | true | ||
| Vendor | Vendor | SUAVDRID | true |
Brondatabewerken
- Entity-definitie —
lookup_entity("SurveyAssessment")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("SurveyAssessment")· ../tables/SurveyAssessment DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="SurveyAssessment")Before/After Save events voor SurveyAssessment. Bron:workflows.xml.