List of attribute-specific column headings

If the worksheet displays attributes in rows, PI Builder writes the attribute name in the Name column, the attribute's parent element in the Parent column, and the type (attribute) in the Object Type column. You can include additional columns about attributes:

• AttributeIsHidden

  A flag that indicates whether PI AF returns the attribute in search results. For attributes created from a template, the template defines the value of the flag, which cannot be changed for individual instances of the attribute. Possible values:

  • TRUE

    PI AF does not retrieve this attribute in searches for attributes. However, PI AF does show the attribute when browsing the element hierarchy.

  • FALSE

    PI AF retrieves this attribute in searches for attributes.

• AttributeIsConfigurationItem

  A flag that indicates whether the attribute is a configuration item. For attributes created from a template, the template defines the value of the flag, which cannot be changed for individual instances of those attributes. Possible values:

  • TRUE

    Upon a change to the attribute value or any other attribute property, PI AF checks out the attribute's parent element from the PI AF database and marks the element as changed.

  • FALSE

    PI AF does not mark the parent element as changed if the attribute value changes, but will mark the parent element as changed if any other attribute properties change.

    For attributes not created from a template, the default value is TRUE.

• AttributeIsExcluded

  A flag that indicates whether PI AF returns the attribute in search results and when browsing the element hierarchy. Only applicable to attributes with templates. The initial value comes from the attribute template, but each instance of an attribute can have its own value. Possible values:

  • TRUE

    PI AF does not retrieve this attribute in searches for attributes and does not show the attribute when browsing the element hierarchy. PI Builder returns the string Excluded as the value.

  • FALSE

    PI AF retrieves this attribute in searches for attributes and shows the attribute when browsing the element hierarchy.

• AttributeDefaultUOM

  The default unit of measure.

• AttributeType

  The attribute value type.

• AttributeTypeQualifier

  The name of the enumeration set that the attribute uses, if the attribute value type is an enumeration set.

• AttributeValue

  The value of the attribute at retrieval time. For excluded attributes, PI Builder returns Excluded. For attributes that have a data reference, this cell is empty if the Show Values in Rows check box is clear, or contains the value at a specified time if the Show Values in Rows check box is selected. See Show values from data references.

• AttributeDataReference

  The type of data reference, if the attribute has a data reference. Possible values include: Formula, PI Point, PI Point Array, or Table Lookup. If the attribute does not have a data reference, this cell is empty.

• AttributeConfigString

  The attribute configuration string (see Learn about attribute configuration strings), if the attribute has a data reference. If the attribute does not have a data reference, then this cell is empty.

  Note: If the worksheet shows attributes in columns, these attribute-specific columns do not apply. See Data references in attribute columns.