Table: dbo.Web_Services_Transmit_Queue
Top level table to track data that needs to be uploaded to a web service
Columns
NameTypeConstraintsDescription
web_services_transmit_queue_KEYint (4)NOT NULLPrimary key; queue of data needing transmission to a web service
creation__staff_KEYint (4)NOT NULLForeign key; staff member who queued the data
creation_datedatetime (8, 3)NOT NULLDate and time the data was queued
Primary key
NameColumnsDescription
PK_Web_Services_Transmit_Queueweb_services_transmit_queue_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Web_Services_Transmit_Queue__Staff__creation__staff_KEYcreation__staff_KEYStaff (staff_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Timerack_Client_Update_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYTimerack_Client_Update_Queue
FK_Web_Services_Employee_Deletion_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWeb_Services_Employee_Deletion_Queue
FK_Web_Services_Client_Deletion_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWeb_Services_Client_Deletion_Queue
FK_Web_Employee_Check_Stub_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWeb_Employee_Check_Stub_Queue
FK_Workforce_Hub_Check_Stub_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWorkforce_Hub_Check_Stub_Queue
FK_Employee_Self_Service_W2_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYEmployee_Self_Service_W2_Queue
FK_Timerack_Employee_Update_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYTimerack_Employee_Update_Queue
FK_Employee_Self_Service_1095_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYEmployee_Self_Service_1095_Queue
FK_Workforce_Hub_Form_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWorkforce_Hub_Form_Queue
FK_Pod_Service_W2_Queue__Web_Service_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYPod_Service_W2_Queue
FK_Web_Employee_Employee_Update_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWeb_Employee_Employee_Update_Queue
FK_Employee_Self_Service_1099_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYEmployee_Self_Service_1099_Queue

Schema diagram