Skip to main content
Mitratech Success Center

TProject

TProject contains the general information for a project record. This information includes the project's name, creation date, closing date, parent project, main assignee, and other information.

This table also links to the list of a project's assignees, which are sub-objects of a project, categories added to the project, and related objects of the project (such as child projects and involved records).

Object: TProject (T_PROJECT)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

accountList-->

n/a

Accounts tab

x

x

TAccount

 

The list of accounts that have this project selected in their posting criteria.

Links to account information for the related accounts.

In Object Navigator, links to an intermediary table named Category that allows you to filter the accounts based on a category, if desired.

application-->

APPLICATION_ID (NUMBER)

 

x

x

WObjd
ProjectInfo

object

The Custom Object definition to which this project belongs.

appointmentList-->

n/a

Appointments tab

x

x

TAppointment

 

8 The list of appointments that are related to the project.

8 Links to specific appointment information.

8 In Object Navigator, links to a table named Category that allows you to filter the appointments based on a category, if desired.

appointmentList-->

n/a

Appointments tab

x

x

TAppointment

 

8 The list of appointments that are related to the project.

8 Links to specific appointment information.

8 In Object Navigator, links to a table named Category that allows you to filter the appointments based on a category, if desired.

assignees-->

Before TeamConnect 3.3

SP2: assigneeList-->

n/a

Assignees tab

x

x

JProjAssignee

 

8 The list of assignees added to the project.

--> Links to the join table that contains specific information for assignees added to the project.

In Object Navigator, links to a table named Assignee Role that allows you to filter the assignees based on a role, if desired.

embedded Projects
-->

Before TeamConnect 3.3

SP2: childList-->

n/a

Tabs for child or embedded object records

x

x

TProject

 

8 The list of all child projects of the current project, including child and embedded objects. Does not include grandchild objects.

--> In Object Navigator, links to the Child Object table, which allows you to select the child or embedded custom object whose records you want to identify in your path. After you select a child object, links to the TProject table.

The Child Object table is not an object in the object model and appears only in Object Navigator to allow you to identify which child object's records you need.

closedOn

CLOSED_ ON (DATE)

Closed On (General block)

x

   

date

Date the project status was changed to Closed.

contact-->

CONTACT_
ID (NUMBER)

Field for selecting a contact, with customized label, in General block

x

x

TContact

object

8 The contact selected for a contact-centric project.

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

createdBy-->

CREATED_
BY_ID (NUMBER)

Created By (Security block)

x

x

YUser

object

8 User who created the record.

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

createdOn

CREATED_ON (DATE)

Created On (Security block)

x

   

date

Date the project 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.

currentPhase
Type-->

CURRENT_PHASE_
TYPE_ID (NUMBER)

Current
Phase
(General block)

x

x

WObjdPhaseType

object

8 The current phase of the project.

--> Links to the definition of the phase.

defaultCategory-->

DEFAULT_
CATEGORY_ID (NUMBER)

Indicated by a blue diamond (Categories block)

x

x

YRecently
Viewed
Record

object

8 The default category for the project.

--> Links to the category's definition information.

categories-->

Before TeamConnect 3.3

SP2: detailList-->

n/a

 

x

x

EProjDetail

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.

expenseList-->

n/a

Expenses tab

x

x

TExpense

 

8 The list of expenses that are related to the project.

--> Links to specific expense information.

In Object Navigator, links to a table named Category that allows you to filter the expenses based on a category, if desired.

groupAccessList-->

n/a

   

x

EProjGroup
Access

 

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

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

THistory

 

8 The list of histories that are related to the project.

--> Links to specific history information for all of the project's history records.

involvedFolder-->

INVOLVED_FOLDER_ID (NUMBER)

   

x

TDocument

object

Links to the folder that stores documents that belong to involved parties for the project.

involvedList-->

n/a

Involved tab

x

x

TInvolved

 

8 The list of involveds that are related to the project.

--> Links to specific involved party information for involved parties of the project.

In Object Navigator,
links to a table named Involved Role that allows you to filter the involved parties based on a role, if desired.

isClosed

IS_CLOSED (NUMBER)

 

x

   

boolean

The setting for whether a project is in the open or closed status.

1 - is Closed
0 - is Open

isElectronic

IS_
ELECTRONIC

 

x

   

boolean

If TRUE, indicates that the record originated from an external application such as Collaborati.

relations-->

Before TeamConnect 3.3

SP2:
leftRelation List-->

n/a

Relations tab

x

x

ProjRelation

 

8 The list of relations in which the related project record is on the left side of the relation, and the current project 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 project in Team Conne ct 3.4 is deter mined by a 3.4- specific attribute named
relationDirection.

mainAssignee-->

MAIN_
ASSIGNEE_
ID (NUMBER)

   

x

JProj
Assignee

object

Links to the information about the main assignee only, such as the main assignee's user account or the assigned on date.

modifiedBy-->

MODIFIED_BY (DATE)

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 the record was last modified.

name

NAME (VARCHAR2) (250)

Name (General block)

x

   

string (250)

The name of the record.

nameUpper

NAME_
UPPER (VARCHAR2) (250)

 

x

   

string (250)

The name of the record in uppercase characters.

idNumber

Before TeamConnect 3.3

SP2:
numberString

NUMBER_
STRING (VARCHAR2) (50)

Number (General block)

x

   

string (50)

The record number.

numberStringUpper

NUMBER_
STRING _ UPPER (VARCHAR2) (50)

 

x

   

string (50)

The record number in uppercase characters.

openedOn

OPENED_ON (DATE)

Opened On (General block)

x

   

date

Date the project was opened.

parent-->

PARENT_ID (NUMBER)

 

x

x

TProject, if a parent exists

object

8 The parent project of the current project.

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

phaseList-->

Before TeamConnect 3.3

SP2: phaseChanges
-->

n/a

   

x

JProjPhase

 

Links to the table that contains information for all phases for the project that have taken place.

primaryKey

PRIMARY_
KEY (NUMBER)

 

x

   

int

The unique ID of the project record.

relations-->

Before TeamConnect 3.3

SP2: rightRelationList-->

n/a

Relations tab

x

x

ProjRelation

 

8 The list of relations in which the related project record is on the right side of the relation, and the current project 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 project in Team Connect 3.4 is determined by a 3.4- specific attribute named relationDirection.

securityTypeIID

SECURITY_
TYPE_IID 
(NUMBER)

Public/
Private
(Security block)

x

   

Enum

Specifies whether the project is public or private as follows:

0 - Public (PUBLIC)
2 - Private (PRIVATE)

taskList-->

n/a

Tasks tab

x

x

TTask

 

8 The list of tasks that are related to the project.

--> Links to specific task information for tasks that are related to the project.

In Object Navigator, links to a table named Category that allows you to filter the tasks based on a category, if desired.

treeKey

TREE_KEY (VARCHAR2) (700)

 

x

   

string (700)

The chain of primary keys that identifies the parent tree of the project. Used for searching and reporting purposes only.

userAccessList-->

n/a

   

x

EProjUser
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 project record has been updated.

  • Was this article helpful?