Attributes Area

The Attributes area displays attributes that the current dataset defines. An attribute value can be inherited from another dataset or computed in a Derive transform based on the values of other attributes.

The Attributes area contains the following columns:

• Key: Indicates that the attribute is the DataSet key that uniquely identifies a record in the PDM table. (Database naming conventions use the suffix SEQ_ID for fields that are unique record identifiers.) Key attributes dictate the type of building block that displays in the Web Application; only one attribute can be the DataSet key.
• Name: Displays the attribute name. The name must start with a letter, followed by up to thirty letters, digits, or underscore characters.

  Note:

  In the current implementation, you should avoid using an SQL- reserved word (for example, where) as an attribute name, which can result in an error. Attribute names must be unique within a given dataset, although you can use the same attribute name in different datasets.

• Source: Identifies the source dataset. This dataset is normally another dataset. When the source is identified as Derivation, the attribute was created from other attributes within the current dataset.
• Type: Shows the range of values to which the attribute can be bound:
  • D (Date)
  • F (Float)
  • I (Integer)
  • S (String)
  • T (Time)