Table: dbo.Web_Services_Employee_Deletion_Queue
Table to track deleted employees pending transmission to Web Services
Columns
NameTypeConstraintsDescription
web_services_employee_deletion_queue_KEYint (4)NOT NULLPrimary Key; queue of deleted employee guids pending transmission to Web Services
web_services_transmit_queue_KEYint (4)NOT NULLForeign key; queue of all data pending transmission to Web Services
client_KEYint (4)NOT NULLForeign key; related client PK
employee_guiduniqueidentifier (16)NOT NULLGuid of an employee which has been deleted from SBPR
Primary key
NameColumnsDescription
PK_Web_Services_Employee_Deletion_Queueweb_services_employee_deletion_queue_KEY
Unique constraints
NameColumnsDescription
UK_Web_Services_Employee_Deletion_Queue$employee_guidemployee_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Web_Services_Employee_Deletion_Queue__Client__client_KEYclient_KEYClient (client_KEY)
FK_Web_Services_Employee_Deletion_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWeb_Services_Transmit_Queue (web_services_transmit_queue_KEY)

Schema diagram