Table: dbo.Workforce_Hub_Check_Stub_Queue
This table contains all check stubs that have been queued to send to Workforce Hub
Columns
NameTypeConstraintsDescription
workforce_hub_check_stub_queue_KEYint (4)NOT NULLPrimary key.
web_services_transmit_queue_KEYint (4)NOT NULLThe web_services_transmit_queue_KEY foreign key.
bank_transaction_KEYint (4)NOT NULLThe bank_transaction_KEY foreign key.
file_namenvarchar (100)NOT NULLThe file name for the check stub.
pdf_filevarbinary (-1)NOT NULLThe pdf file data for the check stub.
approved_for_transmittalbit (1)NOT NULLIndicates records approved for transmission to Workforce Hub. For records added via the standard print process this flag is false until the user confirms the related check prints properly; the record will then either be marked as approved or deleted.
Primary key
NameColumnsDescription
PK_Workforce_Hub_Check_Stub_Queueworkforce_hub_check_stub_queue_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Workforce_Hub_Check_Stub_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_Check_Stub_Queue__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)

Schema diagram