Table: dbo.Client_Pay_Schedule_Batch_Session
This table holds identifiers for client pay schedules currently being processed in batch check entry to prevent multiple processing instances.
Columns
Name | Type | Constraints | Description
client_pay_schedule_KEY | int (4) | NOT NULL | Key to the pay schedule being locked, and the primary key.
user_session_guid | uniqueidentifier (16) | NOT NULL | Guid which ties a particular user session to a table row.

Primary key
Name | Columns | Description
PK_Client_Pay_Schedule_Batch_Session$client_pay_schedule_KEY | client_pay_schedule_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Pay_Schedule_Batch_Session__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Client_Pay_Schedule (client_pay_schedule_KEY) |
FK_Client_Pay_Schedule_Batch_Session__User_Session__user_session_guid | user_session_guid | User_Session (user_session_guid) |