Bewerken: JobProgressStatusHistory

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `JobprshJobId` | nvarchar(12) | Nee | — | — |
| `JobprshDetailId` | int | Nee | ((0)) | — |
| `JobprshContext` | bigint | Nee | ((0)) | — |
| `JobprshRecStatus` | int | Nee | ((0)) | — |
| `JobPrshAocIdForCompetence` | nvarchar(11) | Ja | — | — |
| `JobPrshCheckedCmpForRelease` | smallint | Nee | ((0)) | — |
| `JobPrshCheckedCompetence` | smallint | Nee | ((0)) | — |
| `JobprshCompId` | nvarchar(6) | Nee | — | — |
| `JobprshCusSId` | nvarchar(10) | Ja | — | — |
| `JobprshDate` | datetimeoffset(7) | Nee | — | — |
| `JobPrshEmpHasCompetence` | smallint | Nee | ((0)) | — |
| `JobprshEmpId` | nvarchar(9) | Ja | — | — |
| `JobPrshEmpIdForCompetence` | nvarchar(9) | Ja | — | — |
| `JobPrshEqmtIdForCompetence` | nvarchar(9) | Ja | — | — |
| `JobprshExported` | smallint | Nee | ((0)) | — |
| `JobPrshFoundCmpId` | nvarchar(6) | Ja | — | — |
| `JobprshHours` | decimal(21,2) | Nee | ((0)) | — |
| `JobprshHoursEmpId` | nvarchar(9) | Ja | — | — |
| `JobprshImplicitStatusChange` | smallint | Nee | ((0)) | — |
| `JobprshNewPrsId` | nvarchar(11) | Ja | — | — |
| `JobprshOldPrsId` | nvarchar(11) | Ja | — | — |
| `JobprshRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `JobprshRemarkText` | nvarchar(max) | Ja | — | — |
| `JobPrshWotIdForCompetence` | nvarchar(6) | Ja | — | — |
| `JobprshDataProvider` | nvarchar(50) | Ja | — | — |
| `JobprshProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `JobprshTransferNextTime` | smallint | Nee | ((0)) | — |
| `JobprshExternalId` | nvarchar(50) | Ja | — | — |
| `JobprshExternalStatus` | nvarchar(50) | Ja | — | — |
| `JobPrshMobileActionPerformedDate` | datetimeoffset(7) | Ja | (TRY_CAST(session_context(N'MobileActionPerformedDate') AS [datetimeoffset])) | — |
| `JobprshCompetences` | nvarchar(max) | Ja | — | — |