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
NameTypeConstraintsDescription
client_pay_schedule_KEYint (4)NOT NULLKey to the pay schedule being locked, and the primary key.
user_session_guiduniqueidentifier (16)NOT NULLGuid which ties a particular user session to a table row.
Primary key
NameColumnsDescription
PK_Client_Pay_Schedule_Batch_Session$client_pay_schedule_KEYclient_pay_schedule_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Pay_Schedule_Batch_Session__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYClient_Pay_Schedule (client_pay_schedule_KEY)
FK_Client_Pay_Schedule_Batch_Session__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)

Schema diagram