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.