Employee History

Main information about the work-related changes registered in the system is stored in the Employee History (hrm_employee_history) table. Use the employee history records to track changes in the career: for instance, under whose supervision an employee worked, what was their job title and how long did they work on it, and what was the size of compensation.

tip

Roles required:

• Read – the employee whose history is stored, the employee manager and their managers, hrm_agent.

• Create, update – the employee manager and their managers, hrm_agent.

• Read – hrm_manager, hrm_supervisor, hrm_finance_controller; hrm_agent except the Salary field; employees can read their own records, and managers of all levels irrespective of their roles can read their employees' records.

• Create, update – hrm_manager, hrm_supervisor, hrm_finance_controller.

Create and update employee history

---

A record is added to the Employee History table at the first saving of the changes in the fields referring to the records of the Employee (employee) and Employment Contracts (hrm_employment_contract) tables. Further updates during the same day are added to the current record of employee history.

Employee History form fields

Field	Mandatory	Description
Employee	Y	The field is completed automatically with the first and second name of the user from the Employee (employee) table.
Start	Y	The field is completed automatically with the date of the first record saving.
End	N	The field is completed automatically with the day before the start date of the next period.
Duration	N	The field is completed automatically.
Manager	N	The field is completed automatically with the first and second name of the current manager of the user from the Employee (employee) table.
Unit	N	The field is completed automatically with the name of the current unit of the user from the Employee (employee) table.
Job title	N	The field is completed automatically with the name of the current job title of the user from the Employee (employee) table.
Salary	N	The field is completed automatically with the current salary of the user from the Employee Contracts (hrm_employee_contract) table.
Employment type	N	The field is completed automatically with the value that matches the current user employment type from the Employee Contracts (hrm_employee_contract) table. Possible options: Full-time employment Part-time employment Project work Rotational work Internship Note that changing the list of options in the Employee Contracts table does not automatically change the option list in the Employee History record.
Previous record	N	The field is completed automatically with the previous employee history record.
Previous record.Manager	N	Previous manager of the employee. The field is displayed if the value of the Manager field of the previous Employee History (hrm_employee_history) record is different from the Manager in the current record. The field is completed automatically.
Previous record.Unit	N	Previous unit of the employee. The field is displayed if the value of the Unit field of the previous Employee History (hrm_employee_history) record is different from the Unit in the current record. The field is completed automatically.
Previous record.Job title	N	Previous job title of the employee. The field is displayed if the value of the Job title field of the previous Employee History (hrm_employee_history) record is different from the Job title in the current record. The field is completed automatically.
Previous record.Salary	N	Previous salary of the employee. The field is displayed if the value of the Salary field of the previous Employee History (hrm_employee_history) record is different from the Salary in the current record. The field is completed automatically.
Previous record.Employment type	N	Previous employment type of the employee. The field is displayed if the value of the Employment type field of the previous Employee History (hrm_employee_history) record is different from the Employment type in the current record. The field is completed automatically.