Standard attribute fields
You enter standard information for most attribute types when you create or edit them.
This table describes the standard fields for most attribute types. After you select the Attribute Type, more fields display. For more information about the attribute types, see Attribute types list.
| Field | Description |
|---|---|
| Attribute Category | The category of attribute.
|
| Attribute Type | The type of attribute. The attribute type controls the type
of data the attribute holds, how it is entered into the database,
and the options for the user interface controls that display. Available
types vary depending on the attribute category you selected. See Attribute types list. Note: You cannot change the attribute
type after you save the new attribute. If you select the wrong type,
you must delete the attribute and create a new one. |
| Attribute Internal Name | The unique name of the attribute, used internally. Do not use spaces or special characters. Ensure that the attribute internal names do not start with a number. |
| Attribute Display Name | The display name for the attribute, which is used in the form and in the user interface of object instances. Spaces and UTF-8 characters are allowed. |
| Attribute Database Column Name | Name of the database column where values for the attribute are stored. By default, this name is the same as the Attribute Internal Name. Ensure that the attribute database column names do not start with a number. Do not exceed the character limit for your database, and avoid including words that are reserved for your database. See Database considerations for attribute database columns. |
| Edit database column name | Select to edit the supplied Attribute Database Column Name value. Not available for system-supplied attributes. |
| Description | A description of the attribute. |
| Help Text | A short message that displays as a descriptive tooltip next to the user interface control. |
This table describes the additional information that you define for most grid attributes:
| Field | Description |
|---|---|
| Sortable | Select this option to enable users to sort table data based on the values in this column. |
| Sort Type | The direction in which to sort values in this column. Select Ascending to sort in ascending order or Descending to sort in descending order. |
| Can group by | When this check box is enabled, this attribute groups the data in read-only rows that are based on the value of this attribute. This attribute applies only after you add it to a read-only grid. |
| Alignment | Alignment of the attribute in the table. You can select Left, Center, or Right. The default is Left. |
| Summary function | Available only when the Attribute Type is Decimal, Integer, Money, or Calculated. Performs a simple calculation on the column and displays it in a summary row at the bottom of the grid. Options are Sum, Average, Min, or Max. If no columns in the grid have a summary function, the summary row is not present. |
This table describes the standard display information that you enter for all attributes.
| Field | Description |
|---|---|
| Form Element Type | The type of user interface control to display for this attribute on the form. Examples of user interface controls include text field, check box, and drop-down list. The types that are available depend on the selected Attribute Category and Attribute Type. |
| Special behavior | The options are None, Required, or Read-only.
The default is None. These behaviors do not apply to the Image or Calculated attribute types, or to system-supplied attributes. |
| Special behavior (Offer attributes only) | Offer attributes have different special behaviors, which synchronize their behavior with offers in Unica Campaign. The options are Parameterized, Static, and Hidden.
|