Table: dbo.Client_Payroll_Information_Swipe_Clock_Details
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.["BR"] Foreign-keyed to Client_Payroll_Information rather than directly to Client.
site_idnvarchar (256)NOT NULLthe Site Id of SwipeClock is used as a component of login information in TimeWorks Plus and TimeWorks Plus and WorkforceHub (Legacy)
file_format_namenvarchar (256)NOT NULLspecifies["BR"] one of the known-to-swipeclock file format names, which indicates the output format desired from their service.
import_time_files_onlybit (1)NOT NULLIf 1, only xml time clock file are imported. If 0, import brings in xml time clock files as well as employee information.
workforce_hub_site_idnvarchar (256)NOT NULLthe Site Id we get from first time enabling WorkforceHub Advance or WorkforceHub Plus. Later used as a component of login information.
Primary key
NameColumnsDescription
PK_Client_Payroll_Information_Swipe_Clock_Details$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Payroll_Information_Swipe_Clock_Details__Client_Payroll_Information__client_KEYclient_KEYClient_Payroll_Information (client_KEY)Client["BR"] key on which swipe clock is enabled and it is Foreign-keyed to Client_Payroll_Information rather than directly to Client.

Schema diagram