Table: dbo.Employee_Self_Service_W2_Queue
Table to track employee w2 forms pending transmission to ESS
Columns
Name | Type | Constraints | Description
employee_self_service_w2_queue_KEY | int (4) | NOT NULL | Primary Key; queue of employee w2 forms pending transmission to ESS
web_services_transmit_queue_KEY | int (4) | NOT NULL | Foreign key; queue of all data pending transmission to Web Services
employee_KEY | int (4) | NOT NULL | Foreign key; related employee PK
form_year | int (4) | NOT NULL | Year associated with the W2 form
w2_file | varbinary (-1) | NOT NULL | Embedded employee w2 PDF file. Null only for w2s generated before 2010.3.7 update.

Primary key
Name | Columns | Description
PK_Employee_Self_Service_W2_Queue | employee_self_service_w2_queue_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Self_Service_W2_Queue__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Employee_Self_Service_W2_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Web_Services_Transmit_Queue (web_services_transmit_queue_KEY) |