Table: dbo.Workforce_Hub_Check_Stub_Queue
This table contains all check stubs that have been queued to send to WorkforceHub
Columns
Name | Type | Constraints | Description
workforce_hub_check_stub_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.
bank_transaction_KEY | int (4) | NOT NULL | The bank_transaction_KEY foreign key.
file_name | nvarchar (100) | NOT NULL | The file name for the check stub.
pdf_file | varbinary (-1) | NOT NULL | The pdf file data for the check stub.
approved_for_transmittal | bit (1) | NOT NULL | Indicates 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
Name | Columns | Description
PK_Workforce_Hub_Check_Stub_Queue | workforce_hub_check_stub_queue_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Workforce_Hub_Check_Stub_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_Check_Stub_Queue__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |