1. Person Record (1 per employee)
Important
If there is a restriction on the number of data items available to import at a single time then please provide any subsequent imports with the same unique Employee Reference for each employee as the first import so that they may be re-joined on the correct person record in the software. The Employee Reference is an essential requirement on all data provided as this creates a link across all data sources.
Field Name
EMP_ID Works/Payroll No. ie a unique Employee Reference
FORENAME Forename(s)
SURNAME Surname
TITLE Title
INITIALS Initials
DATE_BIRTH Date of Birth
NI_NUMBER NI Number
GENDER Gender (M or F)
ADDRESS1 Address
ADDRESS2
ADDRESS3
ADDRESS4
ADDRESS5
POSTCODE
DATE_RETIRE Retirement Date (optional)
DATE_START Start Date – For those employees who started in the year
being processed
DATE_LEFT Leave Date – For those employees who left in the year being processed
SALARY Annual Salary
PAY_CAT_ID Cost Centre
TAX_CODE TAX Code (e.g. 647L)
WM_1_FLAG Week/Month 1 Flag (Y or N)
NI_CAT NI Category
NI_NUMBER NI Number
PAY_METH Payment Method (can be defaulted to BACS)
BANK_ID Bank Name (optional)
BANK_SORT Bank Sort Code
BANK_ACC Bank Account Number
AUTOPAY_ID Roll Number
BANK_NAME Bank Account Name (can de defaulted to
employee name)
BANK_ACC_TYPE Account Type (can be defaulted)
STATUS_ID Employee Status – Current, Leaver, Suspended
(can be defaulted)
HOURS_PER_WEEK Hours Per Week (optional)
JOB_FRACTION Weeks Per Year (optional)
SAL_GRD_ID Salary Grade (optional)
SCALE_POINT Scale Point (optional)
PAYSLIP_METHOD_ID Payslip Method (can be defaulted to PRINTED)
PAYSLIP_ ADDRESS Payslip Address (can be defaulted to YES to print address on
Payslip)
MARITAL_STATUS Marital Status (optional)