Table: dbo.Web_Employee_Employee_Update_Queue
Table to track employee data pending transmission to a web service
Columns
NameTypeConstraintsDescription
web_services_transmit_queue_KEYint (4)NOT NULLForeign key; queue of all pending updates to WebEmployee portal
employee_KEYint (4)NOT NULLForeign key; employee pending transmission
resend_welcome_emailbit (1)NOT NULLFlag to indicate that the welcome email should be resent to the employee email address
disablePortalbit (1)NOT NULLFlag which indicates if the employees WebEmployee portal should be disabled.
web_employee_employee_update_queue_KEYint (4)NOT NULLPrimary Key; queue of employee data updates to WebEmployee portal
Primary key
NameColumnsDescription
PK_Web_Employee_Employee_Update_Queueweb_employee_employee_update_queue_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Web_Employee_Employee_Update_Queue__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Web_Employee_Employee_Update_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWeb_Services_Transmit_Queue (web_services_transmit_queue_KEY)

Schema diagram