Table: dbo.Web_Services_Employee_Deletion_Queue
Table to track deleted employees pending transmission to Web Services
Columns
Name | Type | Constraints | Description
web_services_employee_deletion_queue_KEY | int (4) | NOT NULL | Primary Key; queue of deleted employee guids pending transmission to Web Services
web_services_transmit_queue_KEY | int (4) | NOT NULL | Foreign key; queue of all data pending transmission to Web Services
client_KEY | int (4) | NOT NULL | Foreign key; related client PK
employee_guid | uniqueidentifier (16) | NOT NULL | Guid of an employee which has been deleted from SBPR

Primary key
Name | Columns | Description
PK_Web_Services_Employee_Deletion_Queue | web_services_employee_deletion_queue_KEY |
Unique constraints
Name | Columns | Description
UK_Web_Services_Employee_Deletion_Queue$employee_guid | employee_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Web_Services_Employee_Deletion_Queue__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Web_Services_Employee_Deletion_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Web_Services_Transmit_Queue (web_services_transmit_queue_KEY) |