Human Resources
18 columns
52 rows
8 formats

Employee Internal Transfer Histories

This dataset provides a detailed record of employee internal transfers within an organization, capturing department and role changes, transfer types (lateral or upward), approval workflows, and salary adjustments. It is ideal for analyzing workforce mobility, supporting succession planning, and identifying talent development trends across departments.

last updated 12 Jul 2025
by GoMask

The brief that made it

Succession planning and talent pipeline analysis

Sample rows

preview · 8 of 52 rows · all 18 columns

transfer_idstring	transfer_typestring	previous_salaryfloat	reason_for_transferstring	employee_idstring	employee_namestring	current_manager_idstring	current_manager_namestring	from_departmentstring	to_departmentstring	from_role_titlestring	to_role_titlestring	effective_datedate	new_salaryfloat	transfer_initiated_bystring	approval_statusstring	approval_datedate	notesstring
TRF-10001	lateral	67000	Skill development	EMP-1201	Sophia Bennett	MGR-301	Alan Fitzgerald	Finance	Operations	Financial Analyst	Operations Analyst	2024-07-01	67000	HR System	approved	2024-06-10	blank
TRF-10002	upward	54000	Succession planning	EMP-1222	Leonard Smith	MGR-311	Megan Palmer	Sales	Sales	Sales Associate	Sales Manager	2024-08-01	67000	Megan Palmer	approved	2024-07-15	High performer
TRF-10003	lateral	72000	Business need	EMP-1205	Emily Wang	MGR-302	Priya Ramesh	IT	Finance	IT Analyst	Financial Systems Analyst	2024-07-12	72500	Priya Ramesh	approved	2024-06-25	blank
TRF-10004	upward	61000	Promotion opportunity	EMP-1210	Victor Johnson	MGR-305	Lisa Conrad	Operations	Logistics	Operations Specialist	Logistics Supervisor	2024-09-01	72000	Operations Director	pending	blank	blank
TRF-10005	lateral	63500	Skill development	EMP-1208	Fatima Alvi	MGR-309	Carlos Jimenez	Finance	Finance	Accountant	Accountant	2024-07-20	64000	HR System	approved	2024-07-05	Requested by employee
TRF-10006	upward	55000	Succession planning	EMP-1217	Jamal Carter	MGR-313	Sarah Lin	IT	IT	Support Technician	IT Analyst	2024-08-15	61000	Sarah Lin	pending	blank	blank
TRF-10007	lateral	59000	Business need	EMP-1203	Hannah Lee	MGR-301	Alan Fitzgerald	Operations	Operations	Shift Supervisor	Shift Supervisor	2024-07-25	59200	Alan Fitzgerald	approved	2024-07-12	blank
TRF-10008	upward	52000	Business need	EMP-1213	Ravi Patel	MGR-307	Monica O'Brien	Logistics	Logistics	Logistics Associate	Logistics Supervisor	2024-09-10	61000	Monica O'Brien	pending	blank	Training required
TRF-10009	lateral	54000	Skill development	EMP-1220	Sierra Martinez	MGR-306	Gary Stevens	Sales	Marketing	Sales Associate	Marketing Analyst	2024-08-18	55200	HR System	approved	2024-08-01	blank
TRF-10010	lateral	57000	Business need	EMP-1212	William King	MGR-310	Helena Rivera	Marketing	Sales	Marketing Analyst	Sales Associate	2024-07-30	57000	Helena Rivera	approved	2024-07-18	blank
TRF-10011	upward	48000	Succession planning	EMP-1209	Grace Kim	MGR-308	Samuel Turner	Finance	Finance	Accounts Payable Clerk	Accounts Payable Supervisor	2024-09-15	56000	Samuel Turner	pending	blank	blank
TRF-10012	lateral	53000	Skill development	EMP-1204	Jordan Brooks	MGR-307	Monica O'Brien	Logistics	Operations	Logistics Associate	Operations Analyst	2024-07-18	54000	HR System	approved	2024-07-03	blank
TRF-10013	upward	56500	Promotion opportunity	EMP-1218	Natalie Cooper	MGR-304	Angela Wu	Marketing	Marketing	Marketing Analyst	Marketing Specialist	2024-08-21	60500	Angela Wu	approved	2024-08-10	Excellent campaign results
TRF-10014	lateral	72500	Business need	EMP-1215	David Miller	MGR-312	Robert Evans	IT	IT	IT Analyst	IT Analyst	2024-08-05	72800	IT Director	approved	2024-07-30	blank
TRF-10015	lateral	67000	Skill development	EMP-1206	Olivia Davis	MGR-303	Linda Zhang	Operations	Finance	Operations Analyst	Financial Analyst	2024-09-10	67000	Linda Zhang	pending	blank	blank
TRF-10016	lateral	54000	Business need	EMP-1216	Marcus Brown	MGR-314	Zoe Phillips	Sales	Marketing	Sales Associate	Marketing Analyst	2024-07-28	54500	Zoe Phillips	approved	2024-07-15	blank
TRF-10017	lateral	67500	Skill development	EMP-1221	Isabel Rivera	MGR-315	Roger Daniels	Finance	IT	Financial Analyst	IT Analyst	2024-08-16	67500	Roger Daniels	approved	2024-08-01	blank
TRF-10018	lateral	52500	Business need	EMP-1202	Benjamin Foster	MGR-316	Julia Kim	Logistics	Marketing	Logistics Associate	Marketing Analyst	2024-07-03	53000	Julia Kim	rejected	blank	Insufficient experience
TRF-10019	upward	64500	Promotion opportunity	EMP-1214	Tariq Hassan	MGR-317	Helen Tran	Finance	Finance	Accountant	Senior Accountant	2024-09-05	71000	Helen Tran	approved	2024-08-28	CPA achieved
TRF-10020	lateral	54000	Skill development	EMP-1207	Lucas Green	MGR-318	Diane Brooks	Sales	Sales	Sales Associate	Sales Associate	2024-08-10	54000	Diane Brooks	approved	2024-07-29	blank

What the 52 rows show

from the 52-row sample

61,000median previous_salary
3approval statuses
10from departments
10to departments
67,000median new_salary

transfer_type52 rows by value

previous_salary52 rows, in bands of 5,000

Median 61,000, from 47,000 to 92,000.

reason_for_transfer52 rows · top 10 of 18 values

Skill development9
Business need9
promotion6
Succession planning4
Promotion opportunity4
business need4
skill development3
succession planning2
career development2
broader business exposure1

18 columns by typefrom the column list below

string 14
float 2
date 2

Columns

18 columns in three groups

blueprint · 18 columns
column	type	description	example
Text 14 columns
`transfer_id`	string	Unique identifier for each internal transfer record.unique	TRF-10001
`employee_id`	string	Unique identifier for the employee involved in the transfer.	EMP-1201
`employee_name`	string	Full name of the employee.	Sophia Bennett
`current_manager_id`	string	Unique identifier of the employee's manager after the transfer.optional	MGR-301
`current_manager_name`	string	Full name of the employee's manager after the transfer.optional	Alan Fitzgerald
`from_department`	string	Department the employee is transferring from.10 departments	Finance
`to_department`	string	Department the employee is transferring to.10 departments	Operations
`from_role_title`	string	Role title the employee held before the transfer.	Financial Analyst
`to_role_title`	string	Role title the employee assumes after the transfer.	Operations Analyst
`transfer_type`	string	Type of transfer: lateral (same level) or upward (promotion).lateral · upward	lateral
`reason_for_transfer`	string	Reason provided for the transfer (e.g., succession planning, skill development, business need).optional	Skill development
`transfer_initiated_by`	string	Identifier or name of the person or system that initiated the transfer.optional	HR System
`approval_status`	string	Current approval status of the transfer (e.g., pending, approved, rejected).pending · approved · rejected	approved
`notes`	string	Additional notes or comments about the transfer.optional	High performer
Numbers 2 columns
`previous_salary`	float	Employee's salary before the transfer.0 or more · optional	67000
`new_salary`	float	Employee's salary after the transfer.0 or more · optional	67000
Dates and times 2 columns
`effective_date`	date	Date when the transfer becomes effective.	2024-07-01
`approval_date`	date	Date when the transfer was approved (if applicable).optional	2024-06-10

Use it for

A human resources dashboard
Previous_salary by transfer_type and a breakdown of reason_for_transfer. Excel, Power BI or Tableau.
What pattern can you find in 52 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 52 rows.
Transfers52
TRF-1000167000lateral
TRF-1000254000upward
TRF-1000372000lateral
A software demo
Believable transfers with employee_id, employee_name and current_manager_id to fill a screen in front of a buyer.

This dataset52 rows18 columns

Yours1,000 rows18 columns

blueprint · employee-internal-transfer-histories

Behind this dataset

Same schema. As many rows as you need.

These 52 rows came out of a blueprint — 18 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with

Log transfer date and roles
Record department changes
Flag transfers within first year
Summarize by function/level
Exclude external hires

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: employee-internal-transfer-histories

What should your data show?

No signup. No card.

Sample rows

What the 52 rows show

Columns

Use it for

A human resources dashboard

A class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Human Resources

What should your data show?