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 swipe clock partner login, which is an auto generated field["BR"] in SwipeClock application entered while requesting data into ACS from SwipeClock application, for connection purposes.["BR"] 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