TeamConnect Attribute

Name of the attribute as it appears in Object Navigator.

Field in UI

System field in TeamConnect's end-user UI (as provided by default with the system) that corresponds to the attribute. The location of the field in the UI is indicated in parentheses. Not all attributes are represented by fields in the UI.

This document does not attempt to reflect any customization of System Fields in the UI that has been performed for your system.

End of path

Indicates whether the item can be selected at the end of a path in Object Navigator. See Object Model Terms for details.

Bridge

Indicates whether the item is a bridge. This is also indicated by an arrow (-->) at the end of the attribute name. See Object Model Terms for details.

Links to object table

If the item is a bridge, this column indicates the object in the object model (or, the table in Object Navigator tool) to which the bridge provides a relationship.

Note: If the item is ALSO an attribute, then the primary key of this object is the value that the attribute stores in the database.

Tip: When viewing this document electronically, you can click the name of the table to go directly to that object's attribute descriptions in this document.

Data type

Indicates the data type of the attribute.

•If the data type is string, the character limit is indicated in parentheses ().

•If the data type is longString, the limit is imposed by the database. In Oracle, the maximum size of a longString value is 4 GB. In SQL, the maximum size is 1 GB.

•If the data type is datetime, there is an additional property to consider. Some datetime attributes are time-zone-independent. This means that the value in the database for this attribute is retrieved and displayed as is, regardless of the local time zone of the user who entered that value, or the time zone of the user who is now viewing that value. Other attributes are time-zone-dependent. Their value is stored in the database but is adjusted during retrieval to compensate for the time zone of the user who is viewing the value.

In this documentation, the phrase "time-zone-independent" will appear for attributes that possess this property.

Custom datetime fields that are created by solution developers are configurable. The solution developer can choose whether or not to make the field time-zone-independent.

•Bridges are complex data types, and are marked in this documentation with the data type object, except when the bridge links to a list of records rather than a single record.

Comments

Provides a description of the item. For beginners, this column may also provide suggestions for using the item.

For items that are marked End of path and Bridge, two bulleted descriptions are given in this column. These bullets describe the two ways that you can use this item.

For example:

8 The first item is marked with this bullet and describes the item's function when selected as an end of path. For example, selecting user--> as the end of your path in the table JProjAssignee gives you the user who is being identified as an assignee of the project.

--> The second item is marked with this bullet and describes the contents of the table to which the item links, if you use the item as a bridge. For example, selecting user--> as a bridge in the table JProjAssignee gives you access to the table YUser, which contains that user account's definition information.

These two descriptions are provided in order to help you determine the following:

•Whether or not the item should be included as part of your path.

•Whether the item is the attribute you are trying to reach and should therefore be selected as the end of your path.

•Whether you need to use the item as a bridge, and link to the table to which the bridge provides access.

Commonly used in (Rules, Templates/Wizards)

These columns have been introduced primarily to help you learn to build a path using Object Navigator. Because Object Navigator displays all existing attributes, regardless of their function, there are many selections available that serve no practical purpose when you are creating Rules, Templates, Wizards, and Wizard Rules. You can use these columns to help you distinguish between useful and non-useful selections.

For example, in most cases, the Version attribute is not considered a commonly used attribute for creating Rules, Templates, or Wizards.