Table: dbo.Workforce_Hub_Form_Queue
This table contains all forms that have been queued to send to Workforce Hub
Columns
NameTypeConstraintsDescription
workforce_hub_form_queue_KEYint (4)NOT NULLPrimary key.
web_services_transmit_queue_KEYint (4)NOT NULLThe web_services_transmit_queue_KEY foreign key.
workforce_hub_form_type_KEYtinyint (1)NOT NULLThe workforce_hub_form_type_KEY foreign key.
employee_KEYint (4)NOT NULLThe employee_KEY foreign key.
form_yearint (4)NOT NULLThe processing year for the form.
file_namenvarchar (100)NOT NULLThe file name for the form.
pdf_filevarbinary (-1)NOT NULLThe pdf file data for the form.
Primary key
NameColumnsDescription
PK_Workforce_Hub_Form_Queueworkforce_hub_form_queue_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Workforce_Hub_Form_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWeb_Services_Transmit_Queue (web_services_transmit_queue_KEY)
FK_Workforce_Hub_Form_Queue__Workforce_Hub_Form_Type__workforce_hub_form_type_KEYworkforce_hub_form_type_KEYWorkforce_Hub_Form_Type (workforce_hub_form_type_KEY)
FK_Workforce_Hub_Form_Queue__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)

Schema diagram