Table: dbo.Client_Payroll_Information_Swipe_Clock_Partner_Login_Credentials
This table contains login/configuration["BR"] information related to Swipe Clock. This table has a 0..1 to 1 relationship with Client.
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLPrimary and foreign key. Foreign-keyed to Client_Payroll_Information rather than directly to Client.
accountant_idbigint (8)NOT NULLAn UnquotedJSON Number is to be provided as specified by the Swipeclock documentation
encrypted_accountant_secretnvarchar (-1)NOT NULLThe accountant secret of swipeclock partner login, which is an auto generated field in Swipeclock application entered while requesting data into ACS from Swipeclock application, for connection purposes. This value is encrypted.
Primary key
NameColumnsDescription
PK_Client_Payroll_Information_Swipe_Clock_Partner_Login_Credentials$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Payroll_Information_Swipe_Clock_Partner_Login_Credentials__Client_Payroll_Information__client_KEYclient_KEYClient_Payroll_Information (client_KEY)Client key on which swipe clock is enabled and it is Foreign-keyed to["BR"] Client_Payroll_Information rather than directly to Client.

Schema diagram