| 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 | ||