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
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | Primary and foreign key.["BR"] Foreign-keyed to Client_Payroll_Information rather than directly to Client.
site_id | nvarchar (256) | NOT NULL | The Site Id of Swipeclock is used as a component of login information in `TimeWorksPlus` and `TimeWorksPlus and WorkforceHub (Legacy)`
file_format_name | nvarchar (256) | NOT NULL | specifies["BR"] one of the known-to-swipeclock file format names, which indicates the output format desired from their service.
import_time_files_only | bit (1) | NOT NULL | If 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_id | nvarchar (256) | NOT NULL | the Site Id we get from first time enabling `WorkforceHub Advance` or `WorkforceHub Plus`. Later used as a component of login information.

Primary key
Name | Columns | Description
PK_Client_Payroll_Information_Swipe_Clock_Details$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Payroll_Information_Swipe_Clock_Details__Client_Payroll_Information__client_KEY | client_KEY | Client_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.