1 | Record Type | 1 | E for Employee Record Information (import type identification). |
2 | Site | 4 | Optional. Usually left blank. If blank then the site code at the place of import is used. |
3 | Employee Number | 10 | Required. Each employee on the site needs a unique 10 character, alphanumeric identifier. |
4 | Pay Number | 20 | Optional. The identifier used by the payroll system, if it's different from the employee number. |
5 | Card Number | 10 | Optional. The Card Number that is associated with this employee. |
6 | First Name | 20 | Optional. The first name, or initial, of the employee. |
7 | Last Name | 20 | Optional. The employee’s last name. |
8 | Hired Date | 10 | Optional. The date when the employee has hired – dd/mm/yyyy. |
9 | Shift | 6 | Optional. The shift code of the shift that the employee should be processed with. |
10 | Company | 30 | Optional. Places the employee in a particular company, from the time/date entered above. You can use either the company number, or the company name (as set in the TNA Configuration module.) If the company does not exist then it will be created on the fly in the TNA system. |
11 | Branch | 30 | Optional. Places the employee in a particular branch, from the date entered above. You can use either the branch number, or the branch name (as set in the TNA Configuration module.) If the branch does not exist then it will be created on the fly in the TNA system. |
12 | Department | 30 | Optional. Places the employee in a particular department, from the date entered above. You can use either the department number, or the department name (as set in the TNA Configuration module.) If the department does not exist then it will be created on the fly in the TNA system. |
13 | Cost Centre | 30 | Optional. Places the employee in a particular cost centre, from the date entered above. You can use either the cost centre number, or the cost centre name (as set in the TNA Configuration module.) If the cost centre does not exist then it will be created on the fly in the TNA system. |
14 | Category | 30 | Optional. Places the employee in a particular category, from the date entered above. You can use either the category number, or the category name (as set in the TNA Configuration module.) If the category does not exist then it will be created on the fly in the TNA system. |
15 | Scale | 30 | Optional. Places the employee in a particular scale, from the date entered above. You can use either the scale number, or the scale name (as set in the TNA Configuration module.) If the scale does not exist then it will be created on the fly in the TNA system. |
16 | Type | 30 | Optional. Places the employee in a particular type, from the date entered above. You can use either the type number, or the type name (as set in the TNA Configuration module.) If the type does not exist then it will be created on the fly in the TNA system. |
17 | Workgroup | 30 | Optional. Places the employee in a particular workgroup, from the date entered above. You can use either the workgroup number, or the workgroup name (as set in the TNA Configuration module.) If the workgroup does not exist then it will be created on the fly in the TNA system. |
18 | Job | 30 | Optional. Places the employee in a particular job, from the date entered above. You can use either the job number, or the job name (as set in the TNA Configuration module.) If the job does not exist then it will be created on the fly in the TNA system. |
19 | ID Number | 20 | Optional. A national identity number for the employee. For example a passport number, or social security number. |
20 | Work Email | 60 | Optional. The employee's work email address. |
21 | Home Email | 60 | Optional. The employee's work email address. |
22 | Termination Date | 10 | Optional. The employee's termination date - dd/mm/yyyy |
23 | Access Rights | 30 | Optional. Places the employee in a access rights group. You can use either the access rights number, or the description (as set in the TNA Configuration module.) |
24 | Payroll Shift Start Date | 10 | Optional. The date the employee started on the payroll shift - dd/mm/yyyy |
25 | Web Login | 60 | Optional. The employee's login name for the web interface. |
26 | Web Password | 10 | Optional. The web interface password. |
27 | Var1 | 20 | Optional. The first employee variable field (variable fields are in the Other tab in the Employee file). |
28 | Var2 | 20 | Optional. The second employee variable field (variable fields are in the Other tab in the Employee file). |
29 | Var3 | 20 | Optional. The third employee variable field (variable fields are in the Other tab in the Employee file). |
30 | Var4 | 20 | Optional. The fourth employee variable field (variable fields are in the Other tab in the Employee file). |
31 | Var5 | 20 | Optional. The fifth employee variable field (variable fields are in the Other tab in the Employee file). |
32 | Var6 | 20 | Optional. The sixth employee variable field (variable fields are in the Other tab in the Employee file). |
33 | Var7 | 20 | Optional. The seventh employee variable field (variable fields are in the Other tab in the Employee file). |
34 | Var8 | 20 | Optional. The eighth employee variable field (variable fields are in the Other tab in the Employee file). |
35 | Var9 | 20 | Optional. The ninth employee variable field (variable fields are in the Other tab in the Employee file). |
36 | Var10 | 20 | Optional. The tenth employee variable field (variable fields are in the Other tab in the Employee file). |