Table: dbo.Pod_Service_W2_Queue
A row in this table corresponds to a UT W2 pod file queued for transmission
Columns
NameTypeConstraintsDescription
pod_service_w2_queue_KEYint (4)NOT NULLPrimary Key.
web_services_transmit_queue_KEYint (4)NOT NULLIndicates which Web_Services_Transmit_Queue this row is associated with.
employee_KEYint (4)NOT NULLIndicates which employee this row is associated with.
form_yearsmallint (2)NOT NULLThe year of the form being queued.
w2_filevarbinary (-1)NOT NULLThe binary of the xml file for the W2.
firm_idint (4)NOT NULLThe firm id to use when transmitting the pod file.
Primary key
NameColumnsDescription
PK_Pod_Service_W2_Queuepod_service_w2_queue_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Pod_Service_W2_Queue__Web_Service_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWeb_Services_Transmit_Queue (web_services_transmit_queue_KEY)
FK_Pod_Service_W2_Queue__Employee__empoyee_KEYemployee_KEYEmployee (employee_KEY)

Schema diagram