title: "JobPlan (table)" category: reference tags: [table, jobplan, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.JobPlan
Schema: dba
Aantal kolommen: 36
Zie ook de entity-pagina: ../entities/JobPlan
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
JpId |
nvarchar(11) | Nee | — | — |
JpDescr |
nvarchar(250) | Ja | — | — |
JpContext |
bigint | Nee | ((1)) | — |
JpRecStatus |
int | Nee | ((0)) | — |
JpApprvDate |
datetimeoffset(7) | Ja | — | — |
JpApprvEmpId |
nvarchar(9) | Ja | — | — |
JpConvertedDurationToHours |
smallint | Nee | ((1)) | — |
JpCopyFromJobId |
nvarchar(12) | Ja | — | — |
JpCopyText |
smallint | Nee | ((0)) | — |
JpCustomerText |
nvarchar(max) | Ja | — | — |
JpDataProvider |
nvarchar(50) | Ja | — | — |
JpDocId |
nvarchar(11) | Ja | — | — |
JpDowntimeRequired |
smallint | Nee | ((0)) | — |
JpDurationCalc |
decimal(21,2) | Nee | ((0)) | — |
JpEmpId |
nvarchar(9) | Ja | — | — |
JpExported |
smallint | Nee | ((0)) | — |
JpExternalId |
nvarchar(50) | Ja | — | — |
JpExternalStatus |
nvarchar(50) | Ja | — | — |
JpExtra1 |
smallint | Nee | ((0)) | — |
JpExtra2 |
int | Nee | ((0)) | — |
JpExtra3 |
int | Nee | ((0)) | — |
JpExtra4 |
nvarchar(5) | Ja | — | — |
JpExtra5 |
nvarchar(5) | Ja | — | — |
JpHours |
decimal(21,2) | Nee | ((0)) | — |
JpIspId |
nvarchar(11) | Ja | — | — |
JpProviderMutDate |
datetimeoffset(7) | Ja | — | — |
JpRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
JpReOpenDate |
datetimeoffset(7) | Ja | — | — |
JpReOpenEmpId |
nvarchar(9) | Ja | — | — |
JpSkcId |
nvarchar(9) | Ja | — | — |
JpSvcId |
nvarchar(9) | Ja | — | — |
JpText |
nvarchar(max) | Ja | — | — |
JpTransferNextTime |
smallint | Nee | ((0)) | — |
JpVdrId |
nvarchar(6) | Ja | — | — |
JpFlukeOneQAProcedure |
nvarchar(100) | Ja | — | — |
JpConvertedFromInspectionPlan |
smallint | Nee | ((0)) | — |
Trigger-gevulde kolommenbewerken
JpHours← TRSD_JPRES, TRSM_JPRES
Brondatabewerken
- DB-schema —
lookup_table_schema("JobPlan")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("JobPlan")· ../entities/JobPlan Properties, contexts, statussen. Bron:Entities.xml.