Bewerken: ObjectCompetence

Sectie: Kolommen

Reden:

## Kolommen

| 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 | — | — |