Provisioning Tool Guide

10.5

Back Next

Field Properties

You can configure the field properties to associate a field with a base object column, specify the data type, mark the field as read-only, mark the field as required, and make the field searchable.

You can configure the following field properties:

Name: Name of the field that you want to appear in the tree view panel.
Label: Label for the field that you want to appear within views in Data Director.
Read Only: Defines whether the field is editable. If this option is clear, end users can edit the field in a record view if they have create or update privileges for the base object field in the MDM Hub.
If the user has create or update privileges for the base object column in the MDM Hub, the field is editable in
Data Director
.

If the user does not have create or update for the base object column in the MDM Hub, an error occurs when the user tries to save changes in
Data Director
.

For information about configuring resource privileges, see the
Multidomain MDM Configuration Guide
.
Required: Defines if users must enter data in the field when a business entity is created or updated.
URI: Defines the namespace where data types are declared. The data type that you want to configure depends on the URI that you select.

To configure basic data types, such as string, integer, and boolean, select
commonj.sdo
. To configure Informatica data types, such as image URL, hyperlink, and file attachment, select
urn:co-types.informatica.mdm
.
Type: The data type of the field. The data type that you can configure depends on the URI that you select. You can configure the following data types: string, integer, decimal, date, boolean, image URL, hyperlink, and file attachment.; By default, the data type of a business entity field is as close as possible to the data type of the base object column that the field is associated with. For example, a string column in a base object might contain information for an image, so you configure the image URL data type for the business entity field. If you want a field to display web URL, file URI, FTP link, and email address as hyperlinks, configure the hyperlink data type for the field.
You cannot open file URIs with Google Chrome and Mozilla Firefox because of security reasons.
Display Format: The display format for the date fields. Before you specify the display format for the date fields, specify the URI and set the Type property to
Date
.; You can select the
Date
or
Datetime
format for business entity fields that display a date. The display format that you configure is applied to the date field in all the Data Director views.; If a display format is not set for a date field, the date format of the field is the same as the format of the associated base object column.
Filter: Defines a static filter to regulate the data that users can or cannot enter in a field.
When you enable the Filter property, specify the following fields:

Operator
. Controls whether the specified values are allowed or not allowed in the field.

Option
Description

In
Displays the values to the user. If you add a list of comma-separated values as allowed values,
Data Director
users can choose a value from a lookup list.
If you also configure a field filter on the same field, the displayed values reflect the intersection of the static filter and the field filter. For more information about field filters, see Field Filter Rules and User Roles.

Not In
Does not display the values to the user.

Value
. Add values that match the data type of the field.

Requirement
Description

Add multiple values
Comma-separated list of field values. Based on the operator you select, Data Director determines whether to display these values. For example,
Person,SecurePerson,Employee.

Allow null value

To allow NULL data values for fields within a particular business entity, enter empty double quotes ("") as a value. For example, Person, "".

For example, you can configure the firstName field of the Person business entity to match NULL values. When a Data Director user performs a search, the search results include the records where the First Name field is empty.

Allow date and time values
Specifies whether records with the field that matches the date and time appear in Data Director search results. Add the date and time values in the following format:
yyyy-MM-ddTHH:mm:ssTZD.

For example,
2021-06-18T00:00:00Z

The Provisioning tool does not validate the values. If you add a value of the wrong data type, the value does not appear in
Data Director
.
Searchable: A search request searches only the fields that you configure as searchable fields. The scope of a search request increases with the increased number of searchable fields. Multiple searchable fields might affect the performance of the search requests, so configure only the significant fields as searchable fields. For example, configure fields that contain full names, organization names, or email addresses as searchable fields rather than fields that contain country codes, gender codes, or address types.

When you enable the Searchable property, select one or more of the following additional properties for search:
Search Analyzer
Suggester
Sortable
Filterable
Facet Range
Facet
Displayable

Optionally, specify the language for the field values. The default language is English. For information about the search properties, see the chapter about search in the
Multidomain MDM Configuration Guide
.
Column: The base object column associated with the field. You associate a field with a base object column when you add a field to the node.

Option	Description
In	Displays the values to the user. If you add a list of comma-separated values as allowed values, Data Director users can choose a value from a lookup list. If you also configure a field filter on the same field, the displayed values reflect the intersection of the static filter and the field filter. For more information about field filters, see Field Filter Rules and User Roles.
Not In	Does not display the values to the user.

Requirement	Description
Add multiple values	Comma-separated list of field values. Based on the operator you select, Data Director determines whether to display these values. For example, Person,SecurePerson,Employee.
Allow null value	To allow NULL data values for fields within a particular business entity, enter empty double quotes ("") as a value. For example, Person, "". For example, you can configure the firstName field of the Person business entity to match NULL values. When a Data Director user performs a search, the search results include the records where the First Name field is empty.
Allow date and time values	Specifies whether records with the field that matches the date and time appear in Data Director search results. Add the date and time values in the following format: yyyy-MM-ddTHH:mm:ssTZD. For example, 2021-06-18T00:00:00Z