Table: dbo.Web_Services_Transmit_Queue
Top level table to track data that needs to be uploaded to a web service
Columns
Name | Type | Constraints | Description
web_services_transmit_queue_KEY | int (4) | NOT NULL | Primary key; queue of data needing transmission to a web service
creation__staff_KEY | int (4) | NOT NULL | Foreign key; staff member who queued the data
creation_date | datetime (8, 3) | NOT NULL | Date and time the data was queued

Primary key
Name | Columns | Description
PK_Web_Services_Transmit_Queue | web_services_transmit_queue_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Web_Services_Transmit_Queue__Staff__creation__staff_KEY | creation__staff_KEY | Staff (staff_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Timerack_Client_Update_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Timerack_Client_Update_Queue |
FK_Web_Services_Employee_Deletion_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Web_Services_Employee_Deletion_Queue |
FK_Web_Services_Client_Deletion_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Web_Services_Client_Deletion_Queue |
FK_Web_Employee_Check_Stub_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Web_Employee_Check_Stub_Queue |
FK_Workforce_Hub_Check_Stub_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Workforce_Hub_Check_Stub_Queue |
FK_Employee_Self_Service_W2_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Employee_Self_Service_W2_Queue |
FK_Timerack_Employee_Update_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Timerack_Employee_Update_Queue |
FK_Employee_Self_Service_1095_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Employee_Self_Service_1095_Queue |
FK_Workforce_Hub_Form_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Workforce_Hub_Form_Queue |
FK_Workforce_Hub_Punch_Category_Queue_web_services_transmit_queue_web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Workforce_Hub_Punch_Category_Queue |
FK_Pod_Service_W2_Queue__Web_Service_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Pod_Service_W2_Queue |
FK_Employee_Self_Service_1099_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Employee_Self_Service_1099_Queue |
FK_Web_Employee_Employee_Update_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Web_Employee_Employee_Update_Queue |