In ServiceNow, there is the concept of display values and actual values. The actual value represents the raw value in the database, whereas the display value represents the user-understandable value that is usually shown in the UI.

For some fields, there are significant differences in how these values display in the UI vs. in the database. For example:

1. Encrypted text: The database value is encrypted, while the displayed value is unencrypted based on the user's encryption context.

2. Reference fields: The database value is sys_id, but the display value is a display field of a referenced record.

3. Date fields: The database value is in UTC format, while the display value is based on the user's time zone.

4.Choice fields: The database value may be a number, but the display value will be more descriptive.

There are other fields where the actual value and display value vary. Display values are manipulated based on the actual value in the database and user or system settings and preferences.

Thanks & Regards,

Subham Kumar Shaw

ServiceNow Architect/Consultant

ServiceNow Community Rising Star ' 2022/2023/2024