Configure an Attribute - Precisely_EnterWorks - EnterWorks - 11.0

To configure an attribute once the attribute's profile is open in the Profile Editor, edit its configuration fields. Do not include HTML tags in fields.

• Name: (Required) Do not include HTML or special characters, such as & < > ". This is a multi-language value.
• Description: (Optional) This is a multi-language value. Do not include HTML or special characters, such as & < > ".
• Restricted Name: (Required) The relational database snapshot column name. Typically, this is comprised of only alphanumeric and underscore characters. The auto-conversion function will change any blank characters to underscores. Do not include HTML or special characters, such as & < > ".
• Language: For attributes of data type CURRENCY, DECIMAL, INTEGER, and BIGINT, the language you choose determines how their values are stored and how EnterWorks editors display their values and interpret entered values. If you select a language, the format of the attribute is determined by the language chosen. The Control Type field will not apply.
  Warning: Once you have data stored in a CURRENCY or DECIMAL type attribute, if you change the attribute's language, the data will not be updated to reflect the new data type. EnterWorks will change the way it interprets the data, but the data itself will not be changed, therefore, the data will be invalid. Do not change the language of CURRENCY and DECIMAL type attributes once you have entered data values.
• Data Type:  (Required) By defining the Data Type, you are defining what values can be stored in the attribute and what functionality can be performed on it. CURRENCY and DECIMAL attributes are affected by the Language selected, as described above.
• Data Type-specific options: Depending on which data type you choose, the following options will appear:
  • Data Precision: Appears for Data Types: BIGINT, CURRENCY, DECIMAL, INTEGER. Indicates the number of digits the value can have. While you can set the precision for BIGINT and INTEGER values, it is not used during validation and has no effect. Make sure that the precision you select is sufficiently large to prevent rounding errors.
  • Data Scale: Appears for Data Type: CURRENCY and DECIMAL. Indicates how many digits are to the right of the decimal point. Make sure that the scale you select is sufficiently large to prevent rounding errors.
  • Data Size: Appears for Data Type: VARCHAR. Indicates the maximum number of characters in the data field.
• Default Value: (Optional) Specifies a default value for the profile's attribute property. This will not affect any existing repositories' attribute property.
• Group: (Required) When a repository is open in the Detail Editor, the attributes are organized into tabs. Within the tabs, the attributes are organized into groups. The Groups dropdown menu displays the existing tabs and groups, in the format "xx – yy" format or "xx | yy" format. The first name is the name of the tab and the second name is the group.
  1. Open the Manage Attribute Group editor. You can select an existing tab and group, or edit or create a new group and optionally a new tab.
     • To edit an existing group, select the group and click the Manage button to the right of the Group dropdown menu.
     • To create a new group, select the empty value and click the Manage button to the right of the Group dropdown menu. Do not include HTML or special characters in the group name, such as & < > ".
  2. The Manage Attribute Group editor will open. Edit the configuration options:
     • Name: The name of the Group. Do not include HTML or special characters in the name, such as & < >, ".
     • Description: There are two ways you can use the description field:
       • Enter a text description of the Group. Do not include HTML.
       • Enter text that defines how many columns will be used to display the Group's attributes in the New UI's Detail Editor.
     • Attribute Tab: Which Attribute Tab the Group will be shown in. If you click the Manage button you will be able to edit the Tab's name and description.
     • Collapsed:  Whether the Group will be initially displayed collapsed or expanded.
     • Group Type:

       • <not specified>: If this field is left empty, it is assumed that the Group will be used to display attributes.
       • Link Relationship: The Group will be used to display link relationships.
       • Variant: The Group will be used to generate variant records.
• Associated Group: (Optional) An association group is a set of attributes that coordinate with each other. Each attribute consists of a list of values, and the first value in the list of one attribute relates to the first value in the list of the other attributes in the association group. Any attribute that is going to be in an Association Group must be a repeating, or multi-value attribute. Association groups cannot contain multi-language attributes.

  If this attribute will be part of an association group, select the association group or click Manage to create an association group. Association Groups are not specific to a Profile so they must have a unique Name across all other Association Groups in the system.

• Code Set: (Optional) If the attribute is a code set, select the code set.
• Control Type: (Optional) Control types specify how data can be entered into an attribute. The way an attribute is displayed depends on the Control Type. The Is Repeatable also affects how the attribute is displayed. For example, the use of a checkbox or radio button is dependent upon the Is Repeatable option.

  For attributes of data type CURRENCY, DECIMAL, INTEGER, and BIGINT, the language you choose determines how their values are stored and how EnterWorks editors display their values and interpret entered values. If you select a language, the format of the attribute is determined by the language chosen. The Control Type field will not apply.

  For a description of each control type, see Attribute Control Types.

• Special Function Indicator: (Optional) Allows the user to specify that the attribute serves a special function, such as a Taxonomy Node Link or that it is a status indicator. The available selections for this characteristic are based on the type of Profile being defined. All special function indicators whose name begins with Extended have been deprecated.
• Category Attribute Association: (Optional) This is only used for Taxonomy Attributes and Dynamic Attributes. In the case of Taxonomy Attributes, it identifies the Category Attribute Association Object to be used. If an attribute is a Dynamic Attribute, this identifies the Association Object to be used.
• Is Variant: A configuration dependent variable. For more information, contact your EnterWorks account representative.
• Copywriter: A configuration dependent variable. For more information, contact your EnterWorks account representative.
• Is Multi-Language: Indicates if this attribute is multi-language, meaning it has the ability to store variant language values.
  Warning: If you change an attribute to be multi-language or to not be multi-language, the snapshot table must be rebuilt after you finish editing the profile.
• Is Global/Category/Dynamic: (Required) Indicates if this attribute is a Global Attribute, Category Attribute or Dynamic Attribute. Note that the attribute will only be displayed in the Category Attribute tree if it is a Category Attribute.
• Is Required: (Optional) This attribute will be required.
• Is Primary Key: (Optional) Indicates this attribute contains the record's unique identifier.
• Seq Gen Ind: (Optional) Indicates that the attribute is the repository's sequence attribute and its value will be automatically generated by EnterWorks unless it is supplied by the user or it is imported when the record is imported. There can be only one Auto-sequenced Attribute per repository.
• Is Repeatable: Indicates if a record can have multiple values for this attribute. When checked, a field appears to the right to specify the delimiter between values. The default delimiter is a comma. If an attribute has a numerical data type and a language has been selected for the attribute, it cannot be a repeatable attribute.
• Is Business Key: Deprecated.

Note that other attribute definition fields may be present, depending on system configuration.

After you are finished configuring attributes, you must save the profile, then clear the cache.