Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

archivedOn

ARCHIVED_ON

(NUMBER)

Date

Time

(General block)

x

dateTime

Date and time when the history was created, as entered by the user.

x

categories-->

Before TeamConnect 3.3 SP2: detailList-->

n/a

x

x

EHistDetail

In Object Navigator, links to Category list which appears in the UI only.

8 The list of categories added to the current object.

--> In the object model, the added categories link to the values that have been added for custom fields, according to field type.

--> In Object Navigator, this attribute is enhanced. It links to a list of all categories defined for the object definition, rather than those added to the current object. From there, you can select a category and traverse to the list of custom fields that belong to it.

createdBy-->

CREATED_BY_ID

(NUMBER)

Created By

(Security block)

x

x

YUser

object

8 User who created the history record.

--> Links to specific information about the user account.

x

x

createdOn

CREATED_ON

(DATE)

Created On

(Security block)

x

date

Date and time the history record was created.

x

x

createdOnBehalfOf

CREATED_ON_BEHALF_OF_ID

x

TContact

object

When not null, it indicates that the record was created through an e-billing system or other external application. The contact referenced will often be a vendor in TeamConnect.

X

defaultCategory-->

DEFAULT_CATEGORY_ID

(NUMBER)

Default category

(General block)

x

x

YRecentlyViewedRecord

object

The default category of the history record.

x

x

documentFolder-->

DOCUMENT_FOLDER_ID

(NUMBER)

x

TDocument

object

Links to specific information about the document folder.

enteredBy-->

ENTERED_BY_ID

(NUMBER)

Entered by

(General block)

x

x

YUser

object

8 User who created the history record.

Note: This is the same user as in the createdBy

--> Links to specific information about the user account.

x

x

groupAccessList-->

n/a

x

EHistGroupAccess

Links to the group security information entered through the Security block of the record.

modifiedBy-->

MODIFIED_BY_ID

(NUMBER)

Modified By

(Security block)

x

x

YUser

object

8 User who last modified the record.

--> Links to specific information about the user account.

modifiedOn

MODIFIED_ON

(DATE)

Modified On

(Security block)

x

date

Date and time the record was last modified.

objectID

OBJECT_ID

(NUMBER)

displayed as the Parent Object (General block)

x

int

The object record to which the history record belongs.

primaryKey

PRIMARY_KEY

(NUMBER)

x

int

The unique ID of the history record.

securityTypeIID

SECURITY_TYPE_IID

(NUMBER)

Security Type

(Security block)

x

int

Specifies whether the history record is public or private.

0 - Public

2 - Private

shortDescription

SHORT_DESCRIPTION

(VARCHAR2) (250)

x

string (250)

The first 250 characters in the Description field.

x

text

TEXT

(VARCHAR)

Description

(General block)

x

longString

The contents of the Description field.

x

uniqueCode

PARENT_UNIQUE_CODE

(VARCHAR2) (4)

x

string (4)

The four-character alphanumeric code that uniquely identifies the object to which the history record belongs.

userAccessList-->

n/a

x

EHistUserAccess

Links to the user security information entered through the Security block of the record.

version

VERSION

(NUMBER)

x

int

Indicates the number of times the history record has been updated.