title: "EmpLabour (table)" category: reference tags: [table, emplabour, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.EmpLabour
Schema: dba
Aantal kolommen: 29
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
EmplEmpId |
nvarchar(9) | Nee | — | — |
EmplWeek |
int | Nee | ((0)) | — |
EmplContext |
bigint | Nee | ((0)) | — |
EmplRecStatus |
int | Nee | ((0)) | — |
EmplApprvDate |
datetimeoffset(7) | Ja | — | — |
EmplApprvEmpId |
nvarchar(9) | Ja | — | — |
EmplCloseDate |
datetimeoffset(7) | Ja | — | — |
EmplCloseEmpId |
nvarchar(9) | Ja | — | — |
EmplCompId |
nvarchar(6) | Nee | — | — |
EmplCreateDate |
datetimeoffset(7) | Ja | — | — |
EmplDataProvider |
nvarchar(50) | Ja | — | — |
EmplExported |
smallint | Nee | ((0)) | — |
EmplExternalId |
nvarchar(50) | Ja | — | — |
EmplExternalStatus |
nvarchar(50) | Ja | — | — |
EmplExtra1 |
smallint | Nee | ((0)) | — |
EmplExtra2 |
int | Nee | ((0)) | — |
EmplExtra3 |
nvarchar(5) | Ja | — | — |
EmplHours |
decimal(21,2) | Nee | ((0)) | — |
EmplHoursFr |
decimal(21,2) | Nee | ((0)) | — |
EmplHoursMo |
decimal(21,2) | Nee | ((0)) | — |
EmplHoursSa |
decimal(21,2) | Nee | ((0)) | — |
EmplHoursSu |
decimal(21,2) | Nee | ((0)) | — |
EmplHoursTh |
decimal(21,2) | Nee | ((0)) | — |
EmplHoursTu |
decimal(21,2) | Nee | ((0)) | — |
EmplHoursWe |
decimal(21,2) | Nee | ((0)) | — |
EmplProviderMutDate |
datetimeoffset(7) | Ja | — | — |
EmplRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
EmplTransferNextTime |
smallint | Nee | ((0)) | — |
EmplWeekStartDate |
int | Nee | ((0)) | — |
Trigger-gevulde kolommenbewerken
EmplHours← TRSD_EMPLABOURLINE, TRSM_EMPLABOURLINEEmplHoursFr← TRSD_EMPLABOURLINE, TRSM_EMPLABOURLINEEmplHoursMo← TRSD_EMPLABOURLINE, TRSM_EMPLABOURLINEEmplHoursSa← TRSD_EMPLABOURLINE, TRSM_EMPLABOURLINEEmplHoursSu← TRSD_EMPLABOURLINE, TRSM_EMPLABOURLINEEmplHoursTh← TRSD_EMPLABOURLINE, TRSM_EMPLABOURLINEEmplHoursTu← TRSD_EMPLABOURLINE, TRSM_EMPLABOURLINEEmplHoursWe← TRSD_EMPLABOURLINE, TRSM_EMPLABOURLINE
Brondatabewerken
- DB-schema —
lookup_table_schema("EmpLabour")Alle kolommen met types, triggers, computed. Bron:database-schema.json.