In order for Jarrison Time to import clocking information from a Gallagher system, JT requires a link to an employee number field which has been set up in Gallagher. After the field is setup in Gallagher, we need to know how to identify it from Jarrison Time. To do this please follow the below steps.
1) In SQL Management studio open a new query.
2) Copy and paste the script below into the new query, and execute it on the Gallagher Central database.
Select Name,ID FROM [CCFTCentral].[dbo].FTItem
WHERE TypeID = (Select ID FROM [CCFTCentral].[dbo].FTItemType WHERE Name Like 'personal data field %')
It will find the Personal Data Field ID (i.e. Employee Number Field or Pers. No.) which will be used as employee number. The result that is returned should be entered in Jarrison Time in the System Configuration Import Clockings tab, as the Personal Data Field ID.
Note that employees who do not have the Personal data field populated in Gallagher will not import in Jarrison Time.