title: "ShiftLog" category: reference tags: [entity, shift-log, datamodel] source: Entities.xml date: 2026-04-17 status: published

ShiftLog

Type: Entity Properties: 21 Contexts: 2 Statussen: 4

DB-schema: lookup_table_schema("ShiftLog") · ../tables/ShiftLog

Property	Type	Kolom	Width	Nullable	Default
Id	UltimoString	SHLID	6	false
CompletedWork	UltimoString	SHLCOMPLETEDWORKTEXT		true
Context	Context	SHLCONTEXT		false
Crew	Crew	SHLCRWID		true
DataProvider	UltimoString	SHLDATAPROVIDER	50	true
Description	UltimoString	SHLDESCR	200	true
Employee	Employee	SHLEMPID		true
Exported	Boolean	SHLEXPORTED		false	0
ExternalId	UltimoString	SHLEXTERNALID	50	true
ExternalStatus	UltimoString	SHLEXTERNALSTATUS	50	true
Lines	List[ShiftLogLine]	SHLLSHLID		true
ProviderMutationDate	DateTime?	SHLPROVIDERMUTDATE		true
RecordChangeDate	DateTime?	SHLRECCHANGEDATE		true
RecordCreateDate	DateTime?	SHLRECCREATEDATE		true	SYSDATETIME
ShiftLogbook	ShiftLogbook	SHLSHLBID		true
Site	Site	SHLSITID		true
StartDate	Date?	SHLSTARTDATE		true	SYSDATE
Status	Status	SHLRECSTATUS		false
SystemCompany	Company	SHLCOMPID		false
TransferNextTime	Boolean	SHLTRANSFERNEXTTIME		false	0
WorkPeriod	WorkPeriod	SHLWPID		true

Entity-definitie — lookup_entity("ShiftLog") Model-perspectief (properties, contexts, statussen). Bron: Entities.xml.
DB-schema — lookup_table_schema("ShiftLog") · ../tables/ShiftLog DB-perspectief (triggers, computed, defaults). Bron: database-schema.json.
Workflows — find_workflows("", entity="ShiftLog") Before/After Save events voor ShiftLog. Bron: workflows.xml.