Bewerken: TaskRiskAnalysis

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `TraId` | nvarchar(6) | Nee | — | — |
| `TraDescr` | nvarchar(200) | Ja | — | — |
| `TraContext` | bigint | Nee | ((0)) | — |
| `TraRecStatus` | int | Nee | ((0)) | — |
| `TraActiveDate` | datetimeoffset(7) | Ja | — | — |
| `TraActiveEmpId` | nvarchar(9) | Ja | — | — |
| `TraCanceledDate` | datetimeoffset(7) | Ja | — | — |
| `TraCanceledEmpId` | nvarchar(9) | Ja | — | — |
| `TraCompId` | nvarchar(6) | Nee | — | — |
| `TraCreatedDate` | datetimeoffset(7) | Ja | — | — |
| `TraCreatedEmpId` | nvarchar(9) | Ja | — | — |
| `TraExpectedRiscId` | nvarchar(5) | Ja | — | — |
| `TraExpectedRiskScore` | decimal(21,2) | Nee | ((0)) | — |
| `TraExpirationDate` | date | Ja | — | — |
| `TraExpiredDate` | datetimeoffset(7) | Ja | — | — |
| `TraExpiredEmpId` | nvarchar(9) | Ja | — | — |
| `TraExported` | smallint | Nee | ((0)) | — |
| `TraInitialRiscId` | nvarchar(5) | Ja | — | — |
| `TraInitialRiskScore` | decimal(21,2) | Nee | ((0)) | — |
| `TraPrsId` | nvarchar(11) | Ja | — | — |
| `TraRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `TraRequestedDate` | datetimeoffset(7) | Ja | — | — |
| `TraRequestedEmpId` | nvarchar(9) | Ja | — | — |
| `TraSitId` | nvarchar(8) | Ja | — | — |
| `TraText` | nvarchar(max) | Ja | — | — |
| `TraValidityDurationInDays` | smallint | Nee | ((0)) | — |