TInvolved contains the general information of all involved party records. This these records include the contact who is the involved party, project the involved record belongs to, default role, and users who created and modified each record.
Object: TInvolved (T_INVOLVED)
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Links to object table: |
Data type |
Comments |
Commonly used in: |
|
Rules |
Temp/Wiz |
||||||||
activeOn |
ACTIVE_ON (DATE) |
|
x |
|
|
date |
The date on which the involved party became active. |
|
|
application--> |
APPLICATION_ID (NUMBER) |
|
x |
x |
int |
8 The Custom Object definition to which this involved belongs. --> Links to the table that contains information that is specific to project object definitions (such as phase definitions, object autonumbering, and object naming pattern) and indirectly relates the involved to the involved object definition. |
|
|
|
contact--> |
CONTACT_ID (NUMBER) |
Contact (General block) |
x |
x |
object |
8 The contact who is selected as the involved party for this involved record. --> Links to specific information about the contact record. |
x |
x |
|
createdBy--> |
CREATED_BY_ID (NUMBER) |
Created By (Security block) |
x |
x |
object |
8 User who created the involved record. --> Links to specific information about the user account. |
x |
x |
|
createdOn |
CREATED_ON (DATE) |
Created On (Security block) |
x |
|
|
date |
Date the involved 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_CATEGOR Y_ID (NUMBER) |
Indicated by a blue diamond (Categories block) |
x |
x |
object |
8 The default role for the involved. --> Links to specific information about the role. Note: Involved roles are the equivalent of categories for other main objects. This is why their definition information is contained in WObjdCategory. |
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. |
x |
x |
documentFolder--> |
DOCUMENT_FOLDER _ID (NUMBER) |
|
|
x |
object |
Links to specific information about the document folder. |
|
|
|
groupAccessList--> |
n/a |
|
|
x |
|
Links to the group security information entered through the Security block of the record. |
|
|
|
historyList--> |
n/a |
History tab |
x |
x |
|
8 The list of histories that are related to the involved record. --> Links to specific history information for all of the involved's history records. |
x |
|
|
inactiveOn |
INACTIVE_ON (DATE) |
|
x |
|
|
date |
The date on which the involved party became inactive. |
|
|
isActive |
IS_ACTIVE (DATE) |
|
x |
|
|
int |
1 = Involved party is active. 0 = Involved party is inactive. |
|
|
relations--> Before TeamConnect 3.3 SP2: leftRelationList--> |
n/a |
Relations tab |
x |
x |
|
8 The list of relations in which the related involved record is on the left side of the relation, and the current involved record is on the right side of the relation. --> Links to specific relation information. In Object Navigator, this attribute links to an intermediary table Relation Type that allows you to filter the relations by relation type, if desired. Note: The distinction between right and left involved in TeamConnect 3.4 is determined by a 3.4-specific attribute named relationDirection. |
|
|
|
modifiedBy--> |
MODIFIED_BY_ID (NUMBER) |
|
x |
x |
object |
8 The user who last modified the record. --> Links to specific information about the user account. |
|
|
|
modifiedOn |
MODIFIED_ON (DATE) |
|
x |
|
|
date |
The date on which the record was last modified. |
|
|
relations--> Before TeamConnect 3.3 SP2: rightRelationList--> |
n/a |
Relations tab |
x |
x |
|
8 The list of relations in which the related involved record is on the right side of the relation, and the current involved record is on the left side of the relation. --> Links to specific relation information. In Object Navigator, this attribute links to an intermediary table Relation Type that allows you to filter the relations by relation type, if desired. Note: The distinction between right and left involved in TeamConnect 3.4 is determined by a 3.4-specific attribute named relationDirection. |
|
|
|
note--> |
NOTE_ID (NUMBER) |
Notes (General block) |
|
x |
object |
8 The notes entered for the record. --> Links to the table that contains the text entered into the Notes field of the record. |
|
|
|
primaryKey |
PRIMARY_KEY (NUMBER) |
|
x |
|
|
int |
The unique ID of the involved record. |
|
|
project--> |
PROJECT_ID (NUMBER) |
|
x |
x |
object |
8 The project to which this involved record belongs. --> Links to specific information for the project record. |
x |
x |
|
securityTypeIID |
SECURITY_TYPE_II D (NUMBER) |
Public/Private (Security block) |
x |
|
|
Enum |
Specifies whether the involved record is public or private. 0 - Public (PUBLIC) 2 - Private (PRIVATE) |
|
|
userAccessList--> |
n/a |
|
|
x |
|
Links to the user security information entered through the Security block of the record. |
|
|
|
version |
VERSION (NUMBER) |
|
x |
|
|
int |
Indicates how many times the involved record has been updated. |
|
|