This table stores preloaded payroll check entry batches. Batched will be calculated overnight and removed when the batch is submitted or a change in the system invalidates the stored data. |
client_pay_schedule_KEY | int (4) | NOT NULL | The primary key, as well as a foreign key to the client pay schedule table, ensuring only one batch is ever preloaded for a schedule. |
client_pay_schedule_detail_KEY | int (4) | | |
xml_dataset | varbinary (-1) | | The preloaded dataset, including the created payroll checks and supporting data, converted to XML and compressed. |
error | nvarchar (512) | | Column used to capture any errors that occurred during the preloading of a batch. |
batch_calc_began | datetime (8, 3) | | Captures the UTC time the preloading process began for a batch, preventing duplicate processing. The preload row should be created before processing begins. |
batch_calc_ended | datetime (8, 3) | | Captures the UTC time the preloading process ended for a batch, letting the batch check entry process know the batch is ready for use as well as monitoring performance. |
xml_dataset_refreshed | varbinary (-1) | | The preloaded dataset refreshed for new values after a batch has been suspended, converted to XML and compressed. |
xml_dataset_deleted | varbinary (-1) | | The dataset containing transactions prepared for deletion as the result of a refresh, converted to XML and compressed. |