Employee History

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

tip

Roles required:

• Read – hrm_manager, hrm_supervisor, hrm_finance_controller; hrm_agent except the Salary field; employees with access to the agent interface can read their own records; managers of all levels can read their subordinates' records.
• Create, update – hrm_manager, hrm_finance_controller; managers of all levels can edit their subordinates' records.

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 employee history record.

Employee History form fields

Field	Mandatory	Description
Employee	Y	The field is completed automatically with the first and last 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 last 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 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_employment_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_employment_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 (hrm_employee_history) record.
Previous record	N	The field is completed automatically with the previous Employee History (hrm_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.