Skip to main content
Mitratech Success Center

TInvolved

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

activeOn

ACTIVE_ ON (DATE)

 

x

   

date

The date on which the involved party became active.

application-->

APPLICATION_ID(NUMBER)

 

x

x

WObjd
Project
Info

int

8 The Custom Object definition to which this involved belongs.

--> Links to the table that contains information that

contact-->

CONTACT_ID (NUMBER)

Contact 
(General block)

x

x

TContact

object

8 The contact who is selected as the involved party for this involved record.

--> Links to specific information about the contact record.

createdBy-->

CREATED_BY_ID(NUMBER)

Created By (Security block)

x

x

YUser

object

8 User who created the involved record.

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

createdOn

CREATED_ON (DATE)

Created On (Security block)

x

   

date

Date the involved record was created.

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.

defaultCategory-->

DEFAULT_
CATEGORY_ID (NUMBER)

Indicated by a blue diamond
(Categories block)

x

x

YRecently
ViewedRecord

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 .

categories-->

Before TeamConnect 3.3

SP2: detailList-->

n/a

 

x

x

EInvlDetail

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.

documentFolder-->

DOCUMENT_
FOLDER_ID (NUMBER)

   

x

TDocument

object

Links to specific information about the document folder.

groupAccessList-->

n/a

   

x

EInvlGroup
Access

 

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

historyList-->

n/a

History tab

x

x

THistory

 

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.

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

InvlRelation
AttrMap

 

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 distinct ion
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

YUser

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

InvlRelation
AttrMap

 

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

JNote

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

TProject

object

8 The project to which this involved record belongs.

--> Links to specific information for the project record.

securityTypeIID

SECURITY_TYPE_
IID (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

ElnvlUser
Access

 

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.

JInvlRelation

JInvlRelation contains the information of all relations between involved parties, such as the type of relationship and the involved contacts on the left and right sides of the relation.

Object: InvlRelationAttrMap (J_INVL_RELATION)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

leftInvolved-->

LEFT_INVOLVED_ID

(NUMBER)

Involved Contact
(left side, Relations block)

 

x

TInvolved

object

The involved that is on the left side of the relationship.

rightInvolved-->

RIGHT_INVOLVED_
ID (NUMBER)

Involved Contact (right side, Relations block)

 

x

TInvolved

object

The involved that is on the right side of the relationship.

relationType-->

BeforeTeamConnect 3.3

SP2: type-->

TYPE_ID (NUMBER)

Relationship (Relations block)

x

x

LContRelation
Type

object

8 The type of the relationship.

--> Links to definition information for the relation type.

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the involved relation item was updated.

EInvlDetail

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

In Object Navigator, a list of all categories that have been defined for the current 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: EInvlDetail (E_INVL_DETAIL)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

category-->

CATEGORY_ID (NUMBER)

Category

x

x

YRecently
ViewedRecord

object

8 The category definition to which this category, which has been added to a record, belongs.

--> Links to specific information about the category.

owner-->

ENTERPRISE_
OBJECT_ID (NUMBER)

   

x

TInvolved

object

Links to the involved record to which the category has been added.

isManual

IS_MANUAL (NUMBER)

 

x

   

boolean

Specifies whether the category is added manually or automatically to the involved. Categories are added automatically when they are the parent of the category that is added manually.

0 - Added Automatically
1 - Added Manually

primaryKey

PRIMARY_KEY (NUMBER)

 

x

   

int

The unique ID of the involved category record.

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the added category was updated.

EInvlUserAccess

EInvlUserAccess contains the user access information that is set in the Security block of each involved record. For example, it includes whether each user that is listed in the Security block is allowed or denied the Read, Update, Delete, and Perm(ission) rights.

Object: EInvlUserAccess (E_INVL_USER_ACCESS)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

isRead

IS_READ (NUMBER)

Read check box

x

   

int

Specifies whether the Read operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

isUpdate

IS_UPDATE (NUMBER)

Update check box

x

   

int

Specifies whether the Update operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected). 

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

isDelete

IS_DELETE (NUMBER)

Delete check box

x

   

int

Specifies whether the Delete operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

isPerm

IS_PERM (NUMBER)

Perm check box

x

   

int

Specifies whether the Set Permission operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

allowDenyIID

ALLOW_DENY_
IID (CHAR) (1)

Option

x

   

Enum

Indicates whether the user is allowed or denied access to the record.

a - Allow (ALLOW)
d - Deny (DENY)

isManual

IS_MANUAL (NUMBER)

 

x

   

boolean

Indicates whether the user rights were assigned manually through the Security block of the record or automatically by the system.

0 - Assigned manually
1 - Assigned automatically

owner-->

ENTERPRISE_
OBJECT_ID (NUMBER)

 

x

x

TInvolved

object

8 The involved record to which this user access setting belongs.

--> Links to specific information about the involved record.

primaryKey

PRIMARY_KEY (NUMBER)

 

x

   

int

Unique ID for the user access rights.

user-->

USER_ID (NUMBER)

List

x

x

YUser

object

8 The user the access rights pertain to.

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

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the user access rights have been updated.

EInvlGroupAccess

EInvlGroupAccess contains the group access information that is set in the Security block of each involved record. For example, it includes whether each group that is listed in the Security block is allowed or denied the Read, Update, Delete, and Perm(ission) rights.

Object: EInvlGroupAccess (E_INVL_GROUP_ACCESS)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

isRead

IS_READ (NUMBER)

Read check box

x

   

int

Specifies whether the Read operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

isUpdate

IS_UPDATE (NUMBER)

Update check box

x

   

int

Specifies whether the Update operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

isDelete

IS_DELETE (NUMBER)

Delete check box

x

   

int

Specifies whether the Delete operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

isPerm

IS_PERM (NUMBER)

Perm check box

x

   

int

Specifies whether the Set Permission operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

allowDenyIID

ALLOW_DENY_
IID (CHAR) (1)

Option

x

   

Enum

Indicates whether the group is allowed or denied access to the record.

a - Allow (ALLOW)
d - Deny (DENY)

group-->

GROUP_ID (NUMBER)

List

x

x

YGroup

object

8 The group that the access rights pertain to.

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

isManual

IS_MANUAL (NUMBER)

 

x

   

boolean

Indicates whether the group access rights were assigned manually through the Security block of the record or automatically by the system.

0 - Assigned manually
1 - Assigned automatically

owner-->

ENTERPRISE_
OBJECT_ID (NUMBER)

 

x

x

TInvolved

object

8 The involved record to which this group access setting belongs.

--> Links to specific information about the involved record.

primaryKey

PRIMARY_KEY (NUMBER)

 

x

   

int

Unique ID for the group access rights.

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the group access rights have been updated.

  • Was this article helpful?