Table: dbo.Workforce_Hub_Check_Stub_Queue
This table contains all check stubs that have been queued to send to WorkforceHub
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 WorkforceHub. 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