Adding Position and Supervisor Description and Short Description to Employee History Report

Hello,

We are wanting our employee history report to bring in the following fields:

Position Short Description
Position Description
Supervisor Description
Supervisor Short Description

I added them under the field selection dab of employee history configuration, but they don't seem to be working. Has anyone successfully done this? Thank you.

Find more posts tagged with

Accepted answers

All comments

lynn-rivard

If your list is on the Employee business class, you would want to use these fields to return that data:

ActivePrimaryWorkAssignmentRel.Position.Description

label is "Position_Description"

ActivePrimaryWorkAssignmentRel.Position.ShortDescription

label is "Position_Short_Description"

ActivePrimaryWorkAssignmentRel.DirectSupervisor.Description

label is "Supervisor_Description"

ActivePrimaryWorkAssignmentRel.DirectSupervisor.ShortDescription

label is "Supervisor_Short_Description"

Rachel Lake

Thanks Irivard, but I'm looking for the history, so I think it would need to come from one of the audit business classes. The above would just return the current information.

Sylvie Vincenti

We would be very interested on how to do this as well. We are in the process of upgrading to GHR and no one at Infor can seem to tell me how to pull historical data (including the effective dates) into a report. Drills can pull historical data but they can't tell me which business class to use to pull it. They want us to validate migrated data, including historical but say they have no way for us to pull it out to do a comparison. If anyone knows a way to pull this I would really appreciate any help on how to pull it

mmacgown

If you are using Infor HRT in the cloud, you should have Employee Field History available to you in the array of Employee History reports (Administrator > Reports > Employee History-Employee History). You can filter on Business Class and Field Name and use the (current) Value and Old Value fields to determine the changes associated with the Action taken to create the history, including Position and Supervisor attributes. Use the EmployeeFieldHistory business class for these, which will also provide effective date.

Another alternative is to use the TurnoverData business class. You can extract old and new data as well as effective date from there as well, presuming the cube is set up and current.

Feel free to reach out.

Rachel Lake

Hi there,

I don't see the description and short description for the position on the EmployeeFieldHistory BC. I also don't have any data in the TurnoverData BC.

mmacgown

You can add current Position Description and Prior Position Description (and Short Description too) as columns in EmployeeFieldHistory by using Personalizations and/or create a report using the EmployeeFieldHistory list. For the current Position Description value, use "WorkAssignment.Position.Description" field name; for prior Position Description value, use "WorkAssignment.PriorPosition.Description" field name. To acquire the ShortDescription value, replace "Description" in the field logic with ShortDescription.

It sounds like you do not have the EmployeeTurnover cube configured and running in Administrator>Utilities>Cubes where relevant data can be loaded and refreshed.

Reach out if I can assist further.

Copyright © 2025 Infor. All rights reserved.