title: "ObjectCompetence (table)" category: reference tags: [table, objectcompetence, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.ObjectCompetence
Schema: dba
Aantal kolommen: 29
Zie ook de entity-pagina: ../entities/ObjectCompetence
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
ObjCmpId |
nvarchar(11) | Nee | — | — |
ObjCmpContext |
bigint | Nee | ((0)) | — |
ObjCmpRecStatus |
int | Nee | ((0)) | — |
ObjCmpAddedForAocId |
nvarchar(11) | Ja | — | — |
ObjCmpAocId |
nvarchar(11) | Ja | — | — |
ObjCmpApprovedDate |
datetimeoffset(7) | Ja | — | — |
ObjCmpApprovedEmpId |
nvarchar(9) | Ja | — | — |
ObjCmpCmpId |
nvarchar(6) | Ja | — | — |
ObjCmpCompId |
nvarchar(6) | Nee | — | — |
ObjCmpCreatedDate |
datetimeoffset(7) | Ja | — | — |
ObjCmpCreatedEmpId |
nvarchar(9) | Ja | — | — |
ObjCmpCrsId |
nvarchar(6) | Ja | — | — |
ObjCmpDataProvider |
nvarchar(50) | Ja | — | — |
ObjcmpEmpId |
nvarchar(9) | Ja | — | — |
ObjCmpEndDate |
date | Ja | — | — |
ObjCmpEqmtId |
nvarchar(9) | Ja | — | — |
ObjCmpExpiredDate |
datetimeoffset(7) | Ja | — | — |
ObjCmpExpiredEmpId |
nvarchar(9) | Ja | — | — |
ObjCmpExpires |
smallint | Nee | ((1)) | — |
ObjCmpExported |
smallint | Nee | ((0)) | — |
ObjCmpExternalId |
nvarchar(50) | Ja | — | — |
ObjCmpExternalStatus |
nvarchar(50) | Ja | — | — |
ObjCmpIncludeSubAocs |
smallint | Nee | ((0)) | — |
ObjCmpProviderMutDate |
datetimeoffset(7) | Ja | — | — |
ObjCmpRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
ObjCmpRemarkText |
nvarchar(max) | Ja | — | — |
ObjCmpStartDate |
date | Ja | — | — |
ObjCmpTransferNextTime |
smallint | Nee | ((0)) | — |
ObjcmpWotId |
nvarchar(6) | Ja | — | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("ObjectCompetence")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("ObjectCompetence")· ../entities/ObjectCompetence Properties, contexts, statussen. Bron:Entities.xml.