Table: dbo.Timerack_Employee_Update_Queue
This table stores updated employees that are queued for TimeRack export.
Columns
NameTypeConstraintsDescription
timerack_employee_update_queue_KEYint (4)NOT NULLPrimary key.
web_services_transmit_queue_KEYint (4)NOT NULLWeb Services Transmit Queue Key.
employee_KEYint (4)NOT NULLEmployee Key.
pod_prefixnvarchar (30)NOT NULLPOD file name prefix if used. Empty string indicates that no file name prefix should be sent to the POD webservice.
Primary key
NameColumnsDescription
PK_Timerack_Employee_Update_Queuetimerack_employee_update_queue_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Timerack_Employee_Update_Queue__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Timerack_Employee_Update_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWeb_Services_Transmit_Queue (web_services_transmit_queue_KEY)

Schema diagram