Table: dbo.Workforce_Hub_Form_Queue
This table contains all forms that have been queued to send to WorkforceHub
Columns
Name | Type | Constraints | Description
workforce_hub_form_queue_KEY | int (4) | NOT NULL | Primary key.
web_services_transmit_queue_KEY | int (4) | NOT NULL | The web_services_transmit_queue_KEY foreign key.
workforce_hub_form_type_KEY | tinyint (1) | NOT NULL | The workforce_hub_form_type_KEY foreign key.
employee_KEY | int (4) | NOT NULL | The employee_KEY foreign key.
form_year | int (4) | NOT NULL | The processing year for the form.
file_name | nvarchar (100) | NOT NULL | The file name for the form.
pdf_file | varbinary (-1) | NOT NULL | The pdf file data for the form.

Primary key
Name | Columns | Description
PK_Workforce_Hub_Form_Queue | workforce_hub_form_queue_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Workforce_Hub_Form_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Web_Services_Transmit_Queue (web_services_transmit_queue_KEY) |
FK_Workforce_Hub_Form_Queue__Workforce_Hub_Form_Type__workforce_hub_form_type_KEY | workforce_hub_form_type_KEY | Workforce_Hub_Form_Type (workforce_hub_form_type_KEY) |
FK_Workforce_Hub_Form_Queue__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |