TTask

Last updated
Save as PDF

TTask contains the general information for a task record including the task's due date, estimated hours, rate amount, start-on date, and completed date. This table links to the list of custom fields created for the task categories and other related information contained in other tables.

Object: TTask (T_TASK)

Attribute	Database column name	Field in UI	End of path	Bridge	Links to object table	Data type	Comments	Commonly used in:
								Rules	Temp / Wiz
acceptanceIID	ACCEPTANCE_IID (NUMBER)					int	Currently not used.
activityItem -->	ACTIVITY_ITEM_ID (NUMBER)	Activity (General block)	x	x	LTaskActivi tyItem	object	8 Activity item specified for the task. --> Links to the definition information for the task activity item.	x	x
actualHours	ACTUAL_HOURS (NUMBER)	Actual Work (General block)	x			decimal	Actual length of time spent to complete the task (Hours.Minut es).	x
approvalStatusId	APPROVAL_STATUS_ID (NUMBER)					number
assigneeHis tory--> Before TeamConn ect 3.3 SP2: assigneeLis t-->	n/a			x	JTaskAssig nee		Links to the join table that contains information for all assignees added to the task.	x	x
completedD ate Before TeamConnect 3.3 SP2:completed On	COMPLETED_ON (DATE)	Completed On	x			date	Date and time the task was completed. Time-zone- independent.	x
completedPercent	COMPLETE D_PERCENT (NUMBER)	% Complete (General block)	x			decimal	Percentage of the task that is currently complete.	x
contact-->	CONTACT_ID (NUMBER)	Contact (General block)	x	x	TContact	object	8 Contact who is associated to the task, e.g. for whom the task is performed. --> Links to the specific information about the contact object.		x
createdBy-- >	CREATED_ BY_ID (NUMBER)	Created By (Security block)	x	x	YUser	object	8 User who created the task 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 task record was created.		x
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.	X
currentAssignee-->	CURRENT_ ASSIGNEE _ID (NUMBER)	Assigned To (General block)		x	JTaskAssignee	object	Links to the definition information of the user who is currently assigned to the task.		x
currentAssigneeUser-->	CURRENT_ ASSIGNEE _USER_ID (NUMBER)			x	YUser	object	The user who is currently assigned to the task. It is more efficient to use this field in searches and queries than to use the field "currentAssig nee" to access user info.	x	x
defaultCategory-->	DEFAULT_ CATEGORY_ID (NUMBER)	DefaultCategory (General block)	x	x	YRecentlyViewedRec ord	object	8 Default task category. --> Links to the definition information of the category.		x
detailList-->	n/a		x	x	ETaskDetail 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.
detailList-->	n/a		x	x
docuSourceLocationId	DOCU_SOURCE_LOCATION_ID (NUMBER)					number
documentF older-->	DOCUMEN T_FOLDER _ID (NUMBER)	Documents block		x	TDocument	object	Links to specific information about the document folder.
dueDate Before TeamConn ect 3.3 SP2: dueOn	DUE_ON (DATE)	Due On (General block)	x			date	The date when the task is due. Time-zone- independent.	x	x
emailAlertNumDaysAdvance	EMAIL_ALERT_NUM_DAYS_ADVANCE (NUMBER)					number
estimatedH ours	ESTIMATED_HOURS (NUMBER)	Estimated Duration (General block)	x			decimal	Amount of time (Hours.Minutes) needed to complete the task.		x
forumId	FORUM_ID (NUMBER)					number
forwardedByAssignee - - >	FORWARD ED_BY_AS SIGNEE_ID (NUMBER)			x	JTaskAssignee	object	Links to the definition information of the user who forwarded the task to the current assignee.
groupAcces sList-->	n/a			x	ETaskGroupAccess		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 all histories that are related to the task record. --> Links to specific history information for all of the task's history records.
isEmailNotificationActive	IS_EMAIL_NOTIFICATION_ACTIVE (NUMBER)					number
isTaskExpirationSent	IS_TASK_EXPIRATION_SENT (NUMBER)					number
milestoneId	MILESTONE_ID (NUMBER)					number
modifiedBy- ->	MODIFIED_ BY_ID (NUMBER)	Modified By (Security block)	x	x	YUser	object	8 User who most recently modified the task. --> Links to specific information about the user account.
modifiedOn	MODIFIED_ ON (DATE)	Modified On (Security block)	x			date	Date and time the task was most recently modified.
note -->	NOTE_ID (NUMBER)	Notes (General block)		x	JNote	object	Links to the table that contains the text entered into the Notes field of the record.
postingStatus Before TeamConn ect 3.3 SP2: postin gStatusIID	STATUS_IID (NUMBER)	Posting Status (General block)	x			Enum	This enumeration is based on TAccount. Specifies whether the task was posted or not: 1 - Not Posted 2 - Posted 3 - Failed 4 - Posted For Approval	x
primaryKey	PRIMARY_ KEY (NUMBER)		x			int	The unique ID of the task record.
priority Before TeamConn ect 3.3 SP2: priorityIID	PRIORITY_ IID (NUMBER)	Priority (General block)	x			int	Task priority. 1 - Highest 2 - High 3 - Normal 4 - Low 5 - Lowest	x	x
priorityTypeIID	PRIORITY_TYPE_IID (NUMBER)					number
project-->	PROJECT_ID (NUMBER)	Project (General block)	x	x	TProject	object	8 Project record for which this task record is created. --> Links to specific information about the project record.	x	x
rateAmount	RATE_AMOUNT (NUMBER)	Rate (General block)	x			decimal	Rate the user charges (per hour) to perform the task.	x	x
securityTypeIID	SECURITY_TYPE_IID (NUMBER)	Security Type (Security block)	x			int	Specifies whether the task is public or private. 0 - Public 2 - Private
shortDescription	SHORT_DESCRIPTION (VARCHAR 2) (250)	Subject (General block)	x			string (250)	Description of the task.		x
startDate Before TeamConn ect 3.3 SP2: sta rtOn	START_ON (DATE)	Start On (General block)	x			date	Date when the task was started. Time-zone- independent.	x	x
totalAmount	TOTAL_AMOUNT (NUMBER)	Total (General block)	x			decimal	Total amount of money spent to completing the task as the product of the rate (rateAmount ) and amount of time spent (actualHours ).	x	x
transaction - ->	TRANSACTION_ID (NUMBER)	Transaction s block		x	RTransaction	object	Links to the transactions associated with the task record.
userAccess List-->	n/a			x	ETaskUserAccess		Links to the user security information entered through the Security block of the record.
version	VERSION (NUMBER)		x			int	Numeric instance that tells you how many times each row was modified.
workStatus Before TeamConn ect 3.3 SP2: workS tatusI ID	WORK_STATUS_IID (NUMBER)	Status (General block)				int	The current status of the task. 1 - Not Started 2 - Started 3 - Completed