Employees

Employee data feed, delivering essential information to Wagestream for core service functionality.

Below is a table of all the fields/attributes/columns that you can supply to Wagestream on an employee. Wagestream will be able to expand further on what is required or not required during our technical scoping activities

Attribute

Description

Data Type

employee_id

This is typically the unique identifier for the employee across your many HR/WFM/Payroll systems, it's typically an employees payroll number, or similar

string

name

The employees full name

string (256 characters)

email

The employees email address, should default to their personal email address

string (email)

group

The legal entity which, on pay day, pays this employee. If you have employees paid from different businesses within your organisation - you will need to include this

string (256 characters)

division

Setting this attributes allows you to identify which division, or maybe which site, or hotel, or department an employee works in.

It is generally used to segment the workforce within our employer portal

string (256 characters)

assignment_id

If an employee can work multiple positions, e.g Manager by day, but front-of-house at night. You will need to include their equivalent position, occupancy, assignment

And include 1 record per employee per assignment - e.g if an employee holds 3 assignments - you would send us 3 employee records all with different assignment_id's

string (256 characters)

pay_schedule_id

A unique identifier relating to the pay schedule an employee is assigned to.

For example you may have 1 group of employees on a weekly pay-cycle,
but another on a monthly, you can use this field to tell us which pay-cycle/schedule the employee is on

string (256 characters)

start_date

The original hire/start date for the employee (i.e. the day they joined the business). Note - for Rehires, the start date should return the Rehire date.

ISO 8601 Date ex. 2021-10-12

termination_date

Synonymous with leaving date, the date the main contract or assignment for this employee ends. This information is used to off-board and un-enrol an employee in Wagestream

ISO 8601 Date ex. 2021-10-12

salary

Gross salary amount, decimal to two decimal places

decimal (2 decimal places)

contracted_hours

A decimal value (2 decimal places) representing the number of contracted hours for a defined period, which by default is monthly, but can be overridden using the salary_frequency column. This field is only required if you have employees on contracted hours and are using the rate field

decimal (2 decimal places)

rate

A decimal value (2 decimal places) which represents the base/default hourly rate for this employee

decimal (2 places)

bank_account_number

The employees UK Bank primary account number which is used to receive their salary, or EU IBAN number

string (256 characters)

bank_sort_code

The employees UK sortcode (8 digits without the dashes representing a UK bank sortcode

or a EU BIC code

Please note we do not support UK building society roll numbers

string (256 characters)