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 |
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 |
|
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 |
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 |
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 |
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 |
object |
Links to the definition information of the user who is currently assigned to the task. |
|
x |
|
currentAssigneeUser--> |
CURRENT_ASSIGNEE_USER_ID (NUMBER) |
|
|
x |
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 |
object |
8 Default task category. --> Links to the definition information of the category. |
|
x |
|
detailList--> |
n/a |
|
x |
x |
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 |
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 |
object |
Links to the definition information of the user who forwarded the task to the current assignee. |
|
|
|
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 |
|
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 |
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 |
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 |
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 |
object |
Links to the transactions associated with the task record. |
|
|
|
userAccessList--> |
n/a |
|
|
x |
|
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 |
|
|