Custom Type

Administration | Synchronisations | Synchronisation | Details | Custom Type field

The SAN (Sales Assistance Number validation) custom type provides an interface between the software system 'REG' and PayGlobal.

The format of the SAN custom type synchronisation file is as follows:

Details

Field No	Field Type	Comments	Data Source	Character Position
1	A/N - 7	Employee Code	Employee.EmployeeCode	1 - 7
2	AN - 10	Swipe Card Number	Employee.Clockcard	8 - 17
3	A - 26	First Name	Employee.FirstNames	18 - 43
4	A - 26	Last Name	Employee.LastName	44 - 69
5	N - 4	SAC Code	Employee.Dim3Code	70 - 73
6	AN - 10	Commence Date (Format: DD/MM/YYYY)	Employee.StartDate	74 - 83
7	A - 3	PayPoint	Employee.DepartmentCode	84 - 86

Trailer

Field No

Field Type

Comments

Data Source

Character Position

A/N - 4

Number of employee records.

Left padded with zeroes.

N/A

1 - 4

The fields in the files are comma separated and enclosed in double quotes.

The names of the files take the following format:
pg_ssss_ddmmyyyy

Where ssss = the physical store number which comes from employee.xeephysscode and ddmmyyyy is the date on which the export was run.