Data Export for Current & Past Employees including Positions

(1) Share

Report

Posted on by theresay@etco.co.nz

Hello,

1. Is there a way to export data on current and past employees including their positions? I can't find a way to include past apprentices and their positions.

2. Is there also a way to export fields from different tables into one excel workbook? For example I want to have one excel table that combines Employee number, name, start date from the 'Employee V2' table and then also have data on each employees position, position type, department number, job from the 'Positions V2' table and then the name of department from the 'departments' table.

Thanks!

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report

RE: Data Export for Current & Past Employees including Positions

In that case, you get historical data using personnel actions?

Was this reply helpful? Yes No
theresay@etco.co.nz 28 on at

Like (0)

Report

RE: Data Export for Current & Past Employees including Positions

Yes when creating positions

Was this reply helpful? Yes No
Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report

RE: Data Export for Current & Past Employees including Positions

Are you using personnel actions for Positions?

Was this reply helpful? Yes No
theresay@etco.co.nz 28 on at

Like (0)

Report

RE: Data Export for Current & Past Employees including Positions

Thank you Parag. Do you know if historcal data is stored for employee positions? eg. I would like to export a list of employees and all the past positions they have had and date duration of when they held this position.

Was this reply helpful? Yes No
Suggested answer

Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report

RE: Data Export for Current & Past Employees including Positions

Hi Theresa,

There is no direct way, but you can export data for all workers, positions, worker positions assignment and make Vlookup in excel.

Another way, use Power query in excel and make a join on above tables and get all data.

Was this reply helpful? Yes No