Table: dbo.Employee_Self_Service_W2_Queue
Table to track employee w2 forms pending transmission to ESS
Columns
NameTypeConstraintsDescription
employee_self_service_w2_queue_KEYint (4)NOT NULLPrimary Key; queue of employee w2 forms pending transmission to ESS
web_services_transmit_queue_KEYint (4)NOT NULLForeign key; queue of all data pending transmission to Web Services
employee_KEYint (4)NOT NULLForeign key; related employee PK
form_yearint (4)NOT NULLYear associated with the W2 form
w2_filevarbinary (-1)NOT NULLEmbedded employee w2 PDF file. Null only for w2s generated before 2010.3.7 update.
Primary key
NameColumnsDescription
PK_Employee_Self_Service_W2_Queueemployee_self_service_w2_queue_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Self_Service_W2_Queue__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Employee_Self_Service_W2_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWeb_Services_Transmit_Queue (web_services_transmit_queue_KEY)

Schema diagram