THistory

Last updated
Save as PDF

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			date Time	Date and time when the history was created, as entered by the user.	x
categories --> Before TeamCo nnect 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
createdOn BehalfOf	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
default Category -->	DEFAULT_CATEGORY_ID (NUMBER)	Default category (General block)	x	x	YRecentlyViewedRecord	object	The default category of the history record.	x	x
document Folder-->	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
group AccessList -->	n/a			x	EHistGroupAccess		Links to the group security information entered through the Security block of the record.
modified By-->	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.
primary Key	PRIMARY_KEY (NUMBER)		x			int	The unique ID of the history record.
security TypeIID	SECURITY_ TYPE_IID (NUMBER)	Security Type (Security block)	x			int	Specifies whether the history record is public or private. 0 - Public 2 - Private
short Description	SHORT_ DESCRIPTION (VARCHAR2) (250)		x			string (250)	The first 250 characters in the Description field.		x
text	TEXT (VARCHAR)	Description (General block)	x			long String	The contents of the Description field.		x
unique Code	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.
approvalStatusID	APPROVAL_STATUS_ID (NUMBER)					NUMBER
docuSourceLocationID	DOCU_SOURCE_LOCATION_ID (NUMBER)					NUMBER
forumID	FORUM_ID (NUMBER)					NUMBER

EHistDetail

EHistDetail contains all categories added to history records. Each time a category is added to a history record, an entry is made in this table in the database.

In Object Navigator, EHistDetail is not displayed when you traverse using the detailList--> bridge. Instead, a list of all categories that have been defined for the object definition appears. This list is labeled Category. From each category, you can traverse to a table called Detail Fields, which displays all custom fields belonging to the category you selected.

For more information about how custom field values are stored in the database, see Object Model: Custom Fields.

Object: EHistDetail (E_HIST_DETAIL)

Attribute	Database column name	Field in UI	End of path	Bridge	Links to object table:	Data type	Comments	Commonly used in:
								Rules	Temp/Wiz
category-->	CATEGORY_ ID (NUMBER)	Category	x	x	YRecentlViewedRecord	object	The category of the history with which the details are associated.
detailDate ValueList -->	n/a			x			Links to the information for history custom fields of type Date.
detail Memo ValueList-->	n/a			x			Links to the information for history custom fields of type Memo Text.
detailNumbValueList -->	n/a			x			Links to the information for history custom fields of type Number and Check Box.
detailObje ValueList -->	n/a			x			Links to the information for history custom fields of type List (drop-down or radio button lists).
detailObjf ValueList -->	n/a			x			Links to the information for history custom fields of type Custom Object.
detailText ValueList-- >	n/a			x			Links to the information for history custom fields of type Text.
owner-->	ENTERPRISE_ OBJECT_ ID (NUMBER)			x	THistory	object	The history with which the custom fields are associated.
isManual	IS_ MANUAL (NUMBER)		x			boolean	Specifies whether the category is added manually or automatically to the history. Categories are added automatically when they are the parent of the category that is added manually. 0 - Added Automatically 1 - Added Manually
primary Key	PRIMARY_KEY (NUMBER)		x			int	The unique ID of the history category record.
version	VERSION (NUMBER)		x			int	Indicates how many times the added category was updated.