title: "Competence" category: reference tags: [entity, competence, datamodel] source: Entities.xml date: 2026-04-17 status: published

Competence

Type: Entity Properties: 19 Contexts: 6 Statussen: 5

Zie ook het handgeschreven artikel: competence

DB-schema: lookup_table_schema("Competence") · ../tables/Competence

Contextsbewerken

0: MT (CompetenceContext.None)
1: MT (CompetenceContext.MID)
2: TD (CompetenceContext.TS)
4: Fleet (CompetenceContext.Fleet)
8: Infra (CompetenceContext.Infra)
16: IT (CompetenceContext.IT)

Statussenbewerken

-1: Trash (CompetenceStatus.Trash)
0: None (CompetenceStatus.None)
1: Open (CompetenceStatus.Created)
2: Goedgekeurd (CompetenceStatus.Approved)
4: Vervallen (CompetenceStatus.Expired)

Propertiesbewerken

Property	Type	Kolom	Width	Nullable	Default
Id	UltimoString	CMPID	6	false
Context	Context	CMPCONTEXT		false	1
DataProvider	UltimoString	CMPDATAPROVIDER	50	true
Description	UltimoString	CMPDESCR	200	true
Exported	Boolean	CMPEXPORTED		false	0
ExternalId	UltimoString	CMPEXTERNALID	50	true
ExternalStatus	UltimoString	CMPEXTERNALSTATUS	50	true
ProviderMutationDate	DateTime?	CMPPROVIDERMUTDATE		true
RecordCreateDate	DateTime?	CMPRECCREATEDATE		true	SYSDATETIME
RemarkText	UltimoString	CMPREMARKTEXT		true
Status	Status	CMPRECSTATUS		false	1
StatusApprovedDate	DateTime?	CMPAPPROVEDDATE		true
StatusApprovedEmployee	Employee	CMPAPPROVEDEMPID		true
StatusCreatedDate	DateTime?	CMPCREATEDDATE		true	SYSDATETIME
StatusCreatedEmployee	Employee	CMPCREATEDEMPID		true	USERID
StatusExpiredDate	DateTime?	CMPEXPIREDDATE		true
StatusExpiredEmployee	Employee	CMPEXPIREDEMPID		true
SystemCompany	Company	CMPCOMPID		false
TransferNextTime	Boolean	CMPTRANSFERNEXTTIME		false	0

Brondatabewerken

Entity-definitie — lookup_entity("Competence") Model-perspectief (properties, contexts, statussen). Bron: Entities.xml.
DB-schema — lookup_table_schema("Competence") · ../tables/Competence DB-perspectief (triggers, computed, defaults). Bron: database-schema.json.
Workflows — find_workflows("", entity="Competence") Before/After Save events voor Competence. Bron: workflows.xml.