By default, ServiceNow display values for reference fields and choice lists will not be shared out in your dynamic shares and bulk shares. However, you can enable the sharing of display values for these fields in Replicator properties for a ServiceNow to a Database integration.
NOTE:
- Display values will NOT be shared in schemas to ServiceNow instances.
- Display values do not ensure referential integrity when used to join with other tables. To ensure accurate joining between tables, always rely on the actual sys_id value in the reference field instead.
- With DataSync Agent, the columns for the display value will be sent to the database as a separate column, e.g. a state column have the numerical value and a dv_state column will have the actual value.
Prerequisites
First, you will need to install DataSync for ServiceNow and run the Perspectium Finish Install scripts.
Procedure
To share display values for reference fields and choice lists with your dynamic shares and/or bulk shares, follow these steps:
Log into your sharing ServiceNow instance and navigate to Perspectium > Replicator > Properties.
Check the box labeled Enable replicator to add display value fields (prefixed with 'dv_') for reference and choice fields. Then, scroll to the bottom of the form and click Save to save your changes.