Field type behavior

Field types determine which fields are available for normalization and which transform categories are used.

  • Normalization: Field types determine which fields are available for normalization. When a user creates a new normalization record, the only fields that appear in the choice list are those that match the defined normalization field types for the table selected. For example, in the base system, users see only string fields and not date or integer fields.
  • Transformation: Field types determine which transform categories are used. Each category contains a list of transformation definitions that is presented to the user when a new transform is created. The default associations are appropriate for most transforms, but can be reconfigured to suit an organization's business needs.

Normalization field types must match the system field types (from the dictionary). The default field types available depend upon the platform version.