Table: dbo.Pod_Service_W2_Queue
A row in this table corresponds to a UT W2 pod file queued for transmission
Columns
Name | Type | Constraints | Description
pod_service_w2_queue_KEY | int (4) | NOT NULL | Primary Key.
web_services_transmit_queue_KEY | int (4) | NOT NULL | Indicates which Web_Services_Transmit_Queue this row is associated with.
employee_KEY | int (4) | NOT NULL | Indicates which employee this row is associated with.
form_year | smallint (2) | NOT NULL | The year of the form being queued.
w2_file | varbinary (-1) | NOT NULL | The binary of the xml file for the W2.
firm_id | int (4) | NOT NULL | The firm id to use when transmitting the pod file.

Primary key
Name | Columns | Description
PK_Pod_Service_W2_Queue | pod_service_w2_queue_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Pod_Service_W2_Queue__Web_Service_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Web_Services_Transmit_Queue (web_services_transmit_queue_KEY) |
FK_Pod_Service_W2_Queue__Employee__empoyee_KEY | employee_KEY | Employee (employee_KEY) |