Table: dbo.Web_Employee_Check_Stub_Queue
Table to track check stubs data pending transmission to a web service
Columns
NameTypeConstraintsDescription
web_employee_check_stub_queue_KEYint (4)NOT NULLPrimary key; queue of check stub data files
web_services_transmit_queue_KEYint (4)NOT NULLForeign key; associated web services transmit queue
file_namenvarchar (100)NOT NULLName of the PDF file containing the employee check stub
bank_transaction_KEYint (4)NOT NULLForeign key; Bank transaction associated with the employee check stub
stub_filevarbinary (-1)Embedded check stub PDF file. Null for voided/deleted checks and stubs generated before 2010.3.7 update.
approved_for_transmittalbit (1)NOT NULLIndicates records approved for transmission to ESS. 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_Web_Employee_Check_Stub_Queueweb_employee_check_stub_queue_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Web_Employee_Check_Stub_Queue__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Web_Employee_Check_Stub_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWeb_Services_Transmit_Queue (web_services_transmit_queue_KEY)

Schema diagram