Employee Information - Import Fields Available

Modified on Fri, 28 Apr, 2023 at 1:39 PM

Employee Information

Importing employee information is usually 'additive' - when you import a spreadsheet/CSV file the system will add any new people it finds, and update any that exist. It is important to remember that if you have 'blank' columns, the system will map the column and overwrite existing data with 'blank' data. Although this is useful for removing content, we would advise not having banks columns unless it is intentional.

If you are importing based on payroll number of NI number, those fields are mandatory and can't be ignored.

Full Description
Database Field
Data Type
Field Length
Inclusion
Pre-Format
Address line 1ADR_1

Character

50

Optional

 

Address line 2ADR_2

Character

50

Optional

 

Address line 3ADR_3

Character

50

Optional

 

Address line 4ADR_4

Character

50

Optional

 

Cost CentreCOSTCENTRE

Character

10

Optional

 

DepartmentDEPARTMENT

Character

15

Optional

 

Is employee a Company directorDIRECTOR

Character

3

Optional

Yes/No

Date of BirthDOB

Date

8

Optional

dd/mm/yyyy

Date of CommencementDOC

Date

8

Optional

dd/mm/yyyy

Date of LeavingDOL

Date

8

Optional

dd/mm/yyyy

E-mail addressEMAIL

Character

50

Optional

 

Exempt from Class 1AEXEMPT

Logic

1

Optional

True/False

Exempt from Payrolling of BenefitsNOPAYROLLLogic1Optional

True/False

Fax NumberFAX

Character

15

Optional

 

ForenameFORENAME

Character

20

Optional

 

InitialsINITIALS

Character

5

Optional

 

LocationLOCATION

Character

30

Optional

 

Mobile Phone NumberMOBILE

Character

15

Optional

 

National Insurance NumberNI_NUMBER

Character

10

Key field

 

PAYE to datePAYETODATE

Numeric

10

Optional

 

Payroll Number (Employee's unique Identifier) PAYROLL

Character

20

Key field

 

Pay GroupPAYGROUPCharacter30Optional
PostcodePOST_CODE

Character

15

Optional

 

RegionREGION

Character

30

Optional

 

Salary

SALARY

Numeric

10

Optional

 

Sex (biological) of employeeSEX

Character

1

Optional

Male/Female

SurnameSURNAME

Character

20

Optional

 

Telephone NumberTELEPHONE

Character

15

Optional

 

TitleTITLE

Character

5

Optional


User Defined/Free Purpose USER_1

Character

15

Optional

 

User Defined/Free Purpose USER_2

Character

15

Optional

 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article