Skip to main content
Mitratech Success Center

TTask

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

ACCEPTAN CE_IID

(NUMBER)

         

Currently not used.

   

activityItem

-->

ACTIVITY_I TEM_ID

(NUMBER)

Activity

(Gene ral 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_H OURS

(NUMBER)

Actual Work

(Gene ral block)

x

   

decimal

Actual length of time spent to complete the task (Hours.Minut es).

x

 

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

COMPLETE D_ON

(DATE)

Completed On

x

   

date

Date and time the task was completed. Time-zone- independent.

x

 

 

 

(Gene ral block)

             

completedPercent

COMPLETE D_PERCENT

(NUMBER)

% Complete

(General block)

x

   

decimal

Percentage of the task that is currently complete.

x

 

contact-->

CONTACT_ ID

(NUMBER)

Contact

(Gene ral 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)

Creat ed 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)

Creat ed On

(Security block)

x

   

date

Date and time the task record was created.

 

x

createdOnBehalfOf

CREATED_ ON_BEHAL F_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

(Gene ral block)

 

x

JTaskAssignee

object

Links to the definition information of the user who is currently assigned to the task.

 

x

cu r r e n t Assignee-->

CURRENT_ ASSIGNEE _ID

(NUMBER)

Assigned To

(Gene ral block)

 

x

 

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

(Gene ral 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.

   
                   

documentF older-->

DOCUMEN T_FOLDER _ID

(NUMBER)

Docu ments 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

(Gene ral block)

x

   

date

The date when the task is due. Time-zone- independent.

x

x

estimatedH ours

ESTIMATE D_HOURS

(NUMBER)

Estimated Duration

(Gene ral block)

x

   

decimal

Amount of time (Hours.Minutes) needed to complete the task.

 

x

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.

   

forwardedB yAssignee - - >

FORW ARDED_BY_AS SIGNEE_ID

(NUMBER)

   

x

 

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

Histor y 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.

   

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)

Modifi ed On (Security block)

x

   

date

Date and time the task was most recently modified.

   

note -->

NOTE_ID (NUMBER)

Notes

(Gene ral 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_II D

(NUMBER)

Posting Status

(Gene ral 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

(Gene ral block)

x

   

int

Task priority.
1 - Highest
2 - High
3 - Normal 4 - Low
5 - Lowest

x

x

project-->

PROJECT_I D (NUMBER)

Project

(Gene ral 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_AMO UNT

(NUMBER)

Rate

(Gene ral 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

(Gene ral block)

x

   

string (250)

Description of the task.

 

x

startDate

Before TeamConn ect 3.3 SP2: sta rtOn

START_ON (DATE)

Start On

(Gene ral block)

x

   

date

Date when the task was started. Time-zone- independent.

x

x

totalAmoun t

TOTAL_AM OUNT

(NUMBER)

Total

(Gene ral 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

transa ction - ->

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

(Gene ral block)

     

int

The current status of the task.

1 - Not Started

2 - Started

3 - Completed

   
  • Was this article helpful?