You should use CSV files to provide the additional data elements you need to use HR Record to perform the payroll functions. You can prepare the CSV files by using Microsoft Excel. You can then import the data into the system by using the workbench in Authorisation Centre. The column headings should preferably be in the order shown. Field names (data item names used in the database) are shown in brackets. It is recommended you use three separate CSV files, as described below.
Note: In the static details, if you have fully implemented the Personnel module and imported your required data, the data for Title toNI Number should already be in the system.
CSV File 1: Static Details
You can use an empty static details template by downloading the zip file (refer to the bottom of this page).
Use one row for each individual:
Employee Reference (EMP_ID) [10 Characters]
Title (TITLE_ID) [5 Characters]
Surname (SURNAME) [40 Characters]
Forename (FORENAME) [40 Characters]
Initials (INITIALS) [5 Characters]
Known As (optional, defaults to Forename Surname) (KNOWNAS) [40 Characters]
Address Line 1 (HOME_ADD_1) [40 Characters]
Address Line 2 (HOME_ADD_2) [40 Characters]
Address Line 3 (HOME_ADD_3) [40 Characters]
Address Line 4 (HOME_ADD_4) [40 Characters]
Address Line 5 (HOME_ADD_5) [40 Characters]
Post Code (HOME_POST_CODE) [10 Characters]
Date of Birth (DATE_BIRTH) [DD/MM/YYYY]
Gender (SEX_ID) [1 Character eg M or F]
Retirement Date (optional) (DATE_RETIRE) [DD/MM/YYYY]
Employment Start Date (DATE_START) [DD/MM/YYYY]
Leaving Date (DATE_LEFT) [DD/MM/YYYY]
Annual Salary (SALARY) [Numeric]
NI Number (NI_NUMBER) [10 Characters]
Cost Centre (PAY_CAT_ID) [5 Characters]
GEN Code (optional, may be assigned to cost centre) (GEN_CODE) [25 Characters]
NI Category (NI_CAT) [1 Character]
Tax Code Prefix (TAX_PREFIX) [2 Characters]
Tax Code (TAX_CODE) [5 Characters]
Tax Code Suffix (TAX_SUFFIX) [2 Characters]
Week/Month 1 Status (WK1_FLAG) [1 Character eg Y=Yes or N=No]
Bank Sort Code (BANK_SORT) [8 Characters]
Bank Account Number (BANK_ACC) [10 Characters]
Building Society Roll Number (AUTOPAY_ID) [25 Characters]
Account Name (optional) (BANK_ACC_NAME) [40 Characters]
Account Type (optional) (BANK_ACC_TYPE) [1 Character]
Bank Name (optional) (BANK_NAME) [40 Characters]
Student Loans Indicator (optional) (RECLAIM_SL) [1 Character eg Y=Yes or N=No]
Payment Method (PAY_METH) [1 Character eg B=BACS or C=Cheque]
Status (STATUS_ID) [1 Character eg C=Current or S=Suspended or L=Leaver]
Taxable Gross Pay (for this year, this employment) (TAXABLE) [Numeric]
Tax Paid (for this year, this employment) (TAX_THIS) [Numeric]
If not in the “this employment” balances above:
Taxable Gross Pay (for this year, previous employment) (GROSS_PREV) [Numeric]
Tax Paid (for this year, previous employment) (TAX_PREV) [Numeric]
CSV File 2: Pension Scheme Identifier
Use n rows for each individual (typically only 1):
Employee Reference (EMP_ID) [10 Characters]
Employee Pension Scheme Reference (SCHEME_ID) [5 Characters]
If the scheme has not yet been defined in the application software then assign the proposed code.
If there are only a few schemes defined and all rates of contribution are common to all employees attached to the scheme, the following details are not required. The following should be provided only if there are variations per employee in the percentage rates and/or values. This is commonly the case with voluntary schemes.
Employer Contribution % (ER_P_AMT) [Numeric]
Employer Contribution Value (ER_A_AMT) [Numeric]
Employee Contribution % (EE_P_AMT) [Numeric]
Employee Contribution Value (EE_A_AMT) [Numeric]
Voluntary Contribution % (VOL_P_AMT) [Numeric]
Voluntary Contribution Value (VOL_A_AMT) [Numeric]
CSV File 3: Recurring (Fixed) Payments & Deductions
Use n rows for each individual (typically only 1):
Employee Reference (EMP_ID) [10 Characters]
Payroll Code (PAYROLL_ID) [5 Characters eg BP=Basic Pay, FA=First Aid]
Value (optional, depending on type of Payroll Code) (DEF_VALUE) [Numeric]
Note:
A value should only be provided when it is unique to the employee and cannot be derived from the system. Typically, the definition of the payroll code can contain the rate or absolute value, or a calculation can be performed to establish the value – for example, “Salary / 12”. In these circumstances, a value is not expected.