title: "Survey" category: reference tags: [entity, survey, datamodel] source: Entities.xml date: 2026-04-17 status: published
Survey
Type: Entity Properties: 17 Contexts: 2 Statussen: 7
DB-schema:
lookup_table_schema("Survey")· ../tables/Survey
Contextsbewerken
- 1: Vragenlijst (
SurveyContext.VendorRating) - 2: Vragenlijst (
SurveyContext.ContractAssessment)
Statussenbewerken
- -1: Trash (
SurveyStatus.Trash) - 0: None (
SurveyStatus.None) - 1: In voorbereiding (
SurveyStatus.InPreparation) - 2: Ter beoordeling (
SurveyStatus.ForReview) - 4: Vragenlijst ingediend (
SurveyStatus.Submitted) - 8: Verwerkt (
SurveyStatus.Processed) - 16: Vervallen (
SurveyStatus.Expired)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id | UltimoString | SVYID | 10 | false | |
| Context | Context | SVYCONTEXT | false | 1 | |
| Employee | Employee | SVYEMPID | true | ||
| Exported | Boolean | SVYEXPORTED | false | 0 | |
| RecordCreateDate | DateTime | SVYRECCREATEDATE | false | SYSDATETIME | |
| Status | Status | SVYRECSTATUS | false | 1 | |
| StatusExpiredDate | DateTime? | SVYEXPIREDDATE | true | ||
| StatusExpiredEmployee | Employee | SVYEXPIREDEMPID | true | ||
| StatusForReviewDate | DateTime? | SVYFORREVIEWDATE | true | ||
| StatusForReviewEmployee | Employee | SVYFORREVIEWEMPID | true | ||
| StatusInPreparationDate | DateTime? | SVYINPREPARATIONDATE | true | SYSDATETIME | |
| StatusInPreparationEmployee | Employee | SVYINPREPARATIONEMPID | true | USERID | |
| StatusProcessedDate | DateTime? | SVYPROCESSEDDATE | true | ||
| StatusProcessedEmployee | Employee | SVYPROCESSEDEMPID | true | ||
| StatusSubmittedDate | DateTime? | SVYSUBMITTEDDATE | true | ||
| StatusSubmittedEmployee | Employee | SVYSUBMITTEDEMPID | true | ||
| SurveyAssessment | SurveyAssessment | SVYSUAID | true |
Brondatabewerken
- Entity-definitie —
lookup_entity("Survey")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("Survey")· ../tables/Survey DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="Survey")Before/After Save events voor Survey. Bron:workflows.xml.