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
NameTypeConstraintsDescription
client_pay_schedule_KEYint (4)NOT NULLThe 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_KEYint (4)
xml_datasetvarbinary (-1)The preloaded dataset, including the created payroll checks and supporting data, converted to XML and compressed.
errornvarchar (512)Column used to capture any errors that occurred during the preloading of a batch.
batch_calc_begandatetime (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_endeddatetime (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_refreshedvarbinary (-1)The preloaded dataset refreshed for new values after a batch has been suspended, converted to XML and compressed.
xml_dataset_deletedvarbinary (-1)The dataset containing transactions prepared for deletion as the result of a refresh, converted to XML and compressed.
Primary key
NameColumnsDescription
PK_Preloaded_Payroll_Check_Entry_Batch$client_pay_schedule_KEYclient_pay_schedule_KEY
Unique constraints
NameColumnsDescription
UK_Preloaded_Payroll_Check_Entry_Batch$client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Preloaded_Payroll_Check_Entry_Batch$client_pay_schedule_KEYclient_pay_schedule_KEYClient_Pay_Schedule (client_pay_schedule_KEY)
FK_Preloaded_Payroll_Check_Entry_Batch$client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEYClient_Pay_Schedule_Detail (client_pay_schedule_detail_KEY)

Schema diagram