In Column Designer, under EC field mapping, We cannot see department.name. We only see department. Hence data also shows only Code of the respective department in the worksheet.
Column designer --> EC Field mapping
Reproducing the Issue
1> Goto Column Designer
2> Select a field
3> Goto EC Field mapping
4> When you click on the dropdown
5> You will not see Department.Name.
You will only see Department.
As per the current functionality, the attributes like name etc. of migrated Foundation Objects(like Department, Division, Business Unit etc.) cannot be accessed.
There is currently an enhancement request which the engineering team is working upon.
As of now you will need to add the mapping in the Template XML itself as below,
<comp-field-definition id="customDepartment" isCustomField="true" isVisible="true" type="string" useFor="salary" readOnly="true" hidePercentage="false" hideAmount="false" percentageReadOnly="false" reloadable="true" displayOrder="26" reportable="true">
<comp-ect-input-field-map componentType="jobInfo" fieldName="department.name"/>
If you need to add the ".name" ending on the XML for a field please open an incident with Support.
KBA , LOD-SF-CMP , Compensation Management , Problem