title: "CourseCompleted (table)" category: reference tags: [table, coursecompleted, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.CourseCompleted
Schema: dba
Aantal kolommen: 31
Zie ook de entity-pagina: ../entities/CourseCompleted
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
CrscId |
nvarchar(7) | Nee | — | — |
CrscContext |
bigint | Nee | ((0)) | — |
CrscRecStatus |
int | Nee | ((0)) | — |
CrscActivatedDate |
datetimeoffset(7) | Ja | — | — |
CrscActivatedEmpId |
nvarchar(9) | Ja | — | — |
CrscCertificateExpires |
date | Ja | — | — |
CrscCertifiedDate |
date | Ja | — | — |
CrscCompletedDate |
datetimeoffset(7) | Ja | — | — |
CrscCompletedEmpId |
nvarchar(9) | Ja | — | — |
CrscCrsId |
nvarchar(6) | Ja | — | — |
CrscDataProvider |
nvarchar(50) | Ja | — | — |
CrscDate |
date | Ja | — | — |
CrscEmpId |
nvarchar(9) | Ja | — | — |
CrscExpiredDate |
datetimeoffset(7) | Ja | — | — |
CrscExpiredEmpId |
nvarchar(9) | Ja | — | — |
CrscExported |
smallint | Nee | ((0)) | — |
CrscExternalId |
nvarchar(50) | Ja | — | — |
CrscExternalStatus |
nvarchar(50) | Ja | — | — |
CrscPlannedDate |
datetimeoffset(7) | Ja | — | — |
CrscPlannedEmpId |
nvarchar(9) | Ja | — | — |
CrscPostponedDate |
datetimeoffset(7) | Ja | — | — |
CrscPostponedEmpId |
nvarchar(9) | Ja | — | — |
CrscProviderMutDate |
datetimeoffset(7) | Ja | — | — |
CrscPrsId |
nvarchar(11) | Ja | — | — |
CrscRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
CrscRefreshCourse |
smallint | Nee | ((0)) | — |
CrscRemark |
nvarchar(max) | Ja | — | — |
CrscStartDate |
date | Ja | — | — |
CrscStoppedDate |
datetimeoffset(7) | Ja | — | — |
CrscStoppedEmpId |
nvarchar(9) | Ja | — | — |
CrscTransferNextTime |
smallint | Nee | ((0)) | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("CourseCompleted")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("CourseCompleted")· ../entities/CourseCompleted Properties, contexts, statussen. Bron:Entities.xml.