TProject

Last updated
Save as PDF

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
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.
approvalStatusId	APPROVAL_STATUS_ID (NUMBER)					number
docuSourceLocationId	DOCU_SOURCE_LOCATION_ID (NUMBER)					number
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.
forumId	FORUM_ID (NUMBER)					number
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.
milestoneFolderId	MILESTONE_FOLDER_ID (NUMBER)					number
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.