title: "EmpLabourPeriod (table)" category: reference tags: [table, emplabourperiod, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.EmpLabourPeriod
Schema: dba
Aantal kolommen: 33
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
EmplpId |
nvarchar(10) | Nee | — | — |
EmplpContext |
bigint | Nee | ((0)) | — |
EmplpRecStatus |
int | Nee | ((0)) | — |
EmplpCompId |
nvarchar(6) | Nee | — | — |
EmplpCorrectedDate |
datetimeoffset(7) | Ja | — | — |
EmplpCorrectedEmpId |
nvarchar(9) | Ja | — | — |
EmplpCreatedDate |
datetimeoffset(7) | Ja | — | — |
EmplpCreatedEmpId |
nvarchar(9) | Ja | — | — |
EmplpDataProvider |
nvarchar(50) | Ja | — | — |
EmplpEmpId |
nvarchar(9) | Ja | — | — |
EmplpExported |
smallint | Nee | ((0)) | — |
EmplpExternalId |
nvarchar(50) | Ja | — | — |
EmplpExternalStatus |
nvarchar(50) | Ja | — | — |
EmplpGrossHours |
decimal(21,2) | Nee | ((0)) | — |
EmplpHourId |
nvarchar(5) | Ja | — | — |
EmplpHours |
decimal(21,2) | Nee | ((0)) | — |
EmplpHtcId |
nvarchar(5) | Ja | — | — |
EmplpJobId |
nvarchar(12) | Ja | — | — |
EmplpPartOfEmplpId |
nvarchar(10) | Ja | — | — |
EmplpProcessedDate |
datetimeoffset(7) | Ja | — | — |
EmplpProcessedEmpId |
nvarchar(9) | Ja | — | — |
EmplpProviderMutDate |
datetimeoffset(7) | Ja | — | — |
EmplpRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
EmplpSplitDate |
datetimeoffset(7) | Ja | — | — |
EmplpSplitEmpId |
nvarchar(9) | Ja | — | — |
EmplpStartDate |
datetimeoffset(7) | Ja | — | — |
EmplpStartedDate |
datetimeoffset(7) | Ja | — | — |
EmplpStartedEmpId |
nvarchar(9) | Ja | — | — |
EmplpStopDate |
datetimeoffset(7) | Ja | — | — |
EmplpStoppedDate |
datetimeoffset(7) | Ja | — | — |
EmplpStoppedEmpId |
nvarchar(9) | Ja | — | — |
EmplpTransferNextTime |
smallint | Nee | ((0)) | — |
EmplpWeek |
int | Nee | ((0)) | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("EmpLabourPeriod")Alle kolommen met types, triggers, computed. Bron:database-schema.json.