Table to track check stubs data pending transmission to a web service |
web_employee_check_stub_queue_KEY | int (4) | NOT NULL | Primary key; queue of check stub data files |
web_services_transmit_queue_KEY | int (4) | NOT NULL | Foreign key; associated web services transmit queue |
file_name | nvarchar (100) | NOT NULL | Name of the PDF file containing the employee check stub |
bank_transaction_KEY | int (4) | NOT NULL | Foreign key; Bank transaction associated with the employee check stub |
stub_file | varbinary (-1) | | Embedded check stub PDF file. Null for voided/deleted checks and stubs generated before 2010.3.7 update. |
approved_for_transmittal | bit (1) | NOT NULL | Indicates 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. |