Sys_ID displaying in ast_contract instead of Department Name, but not in sys_user

[jerredm]

In our ast_contract table, the Department field is showing Sys IDs. In the sys_user table, the Department field displays department names correctly. Currently, cmn_department display value is set to Sys ID because sys_user departments are provisioned from Azure mappings and is functioning properly. Changing cmn_department display value to Department instead of Sys ID makes the ast_contracts.department display correctly, but then sys_user.department is empty for every user. I believe the fix would be to set the display value to Department in cmn_department, but I am unsure why Users department fields then become blank.

The Lookup list for departments will pull up the cmn_departments list, but after selecting a department it will fill the field with a Created Date.

[Saurabh Gupta]

Hi,
To be able to see the department name in the reference field view, you have to make name attribute of department table as display true or no field as display true, by default system will take name or number as applicable as display value.