THistory contains the general information for a history record. This information includes the user who created the history, creation date, short description, history text, default category and so on. This table links to the list of custom fields created for the history categories and related information contained in other tables.
Object: THistory (T_HISTORY)
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 |
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 |
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 |
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 |
object |
The default category of the history record. |
x |
x |
|
documentFolder--> |
DOCUMENT_FOLDER_ID (NUMBER) |
|
|
x |
object |
Links to specific information about the document folder. |
|
|
|
enteredBy--> |
ENTERED_BY_ID (NUMBER) |
Entered by (General block) |
x |
x |
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 |
|
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 |
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 |
|
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. |
|
|