Show/Hide Toolbars

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)

 

 

 

 

 

Currently not used.

 

 

activityItem-->

ACTIVITY_ITEM_ID

(NUMBER)

Activity

(General block)

x

x

LTaskActivityItem

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.Minutes).

x

 

assigneeHistory-->

Before TeamConnect 3.3 SP2: assigneeList-->

n/a

 

 

x

JTaskAssignee

 

Links to the join table that contains information for all assignees added to the task.

x

x

completedDate

Before TeamConnect 3.3 SP2: completedOn

COMPLETED_ON

(DATE)

Completed On

(General block)

x

 

 

date

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

x

 

completedPercent

COMPLETED_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 "currentAssignee" to access user info.

x

x

defaultCategory-->

DEFAULT_CATEGORY_ID

(NUMBER)

Default Category

(General block)

x

x

YRecentlyViewedRecord

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.

 

 

documentFolder-->

DOCUMENT_FOLDER_ID

(NUMBER)

Documents block

 

x

TDocument

object

Links to specific information about the document folder.

 

 

dueDate

Before TeamConnect 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

estimatedHours

ESTIMATED_HOURS

(NUMBER)

Estimated Duration

(General block)

x

 

 

decimal

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

 

x

forwardedByAssignee-->

FORWARDED_BY_ASSIGNEE_ID

(NUMBER)

 

 

x

JTaskAssignee

object

Links to the definition information of the user who forwarded the task to the current assignee.

 

 

groupAccessList-->

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.

 

 

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 TeamConnect 3.3 SP2: postingStatusIID

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 TeamConnect 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

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

(VARCHAR2) (250)

Subject

(General block)

x

 

 

string (250)

Description of the task.

 

x

startDate

Before TeamConnect 3.3 SP2: startOn

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)

Transactions block

 

x

RTransaction

object

Links to the transactions associated with the task record.

 

 

userAccessList-->

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 TeamConnect 3.3 SP2: workStatusIID

WORK_STATUS_IID

(NUMBER)

Status

(General block)

 

 

 

int

The current status of the task.

1 - Not Started

2 - Started

3 - Completed