Table: dbo.Preloaded_Payroll_Check_Entry_Batch
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.
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Preloaded_Payroll_Check_Entry_Batch$client_pay_schedule_KEY | client_pay_schedule_KEY |
Unique constraints
Name | Columns | Description
UK_Preloaded_Payroll_Check_Entry_Batch$client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Preloaded_Payroll_Check_Entry_Batch$client_pay_schedule_KEY | client_pay_schedule_KEY | Client_Pay_Schedule (client_pay_schedule_KEY) |
FK_Preloaded_Payroll_Check_Entry_Batch$client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY | Client_Pay_Schedule_Detail (client_pay_schedule_detail_KEY) |