Data Conversion

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)