Table: dbo.Web_Employee_Employee_Update_Queue
Table to track employee data pending transmission to a web service
Columns
Name | Type | Constraints | Description
web_services_transmit_queue_KEY | int (4) | NOT NULL | Foreign key; queue of all pending updates to WebEmployee portal
employee_KEY | int (4) | NOT NULL | Foreign key; employee pending transmission
resend_welcome_email | bit (1) | NOT NULL | Flag to indicate that the welcome email should be resent to the employee email address
disablePortal | bit (1) | NOT NULL | Flag which indicates if the employees WebEmployee portal should be disabled.
web_employee_employee_update_queue_KEY | int (4) | NOT NULL | Primary Key; queue of employee data updates to WebEmployee portal

Primary key
Name | Columns | Description
PK_Web_Employee_Employee_Update_Queue | web_employee_employee_update_queue_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Web_Employee_Employee_Update_Queue__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Web_Employee_Employee_Update_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Web_Services_Transmit_Queue (web_services_transmit_queue_KEY) |