Description
Contains detailed information on agile tasks, To Do List items or calendar appointments.
Dependencies
- CustomFieldValues table
- ExtendedAttributes table
- ScheduledEvents table
- Tasks table
- Validations table
Columns
ActFinish : datetime, allows null: yes
The date when the agile task was actually completed.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
ActHrs : decimal (max 18 decimal digits), allows null: yes
The actual number of hours spent on the task.
ActStart : datetime, allows null: yes
The date when the work on the agile task actually started.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
ActualCost : money, allows null: yes
The actual cost of the agile task (not used for appointments and to do list items).
ActualHrs : decimal (max 18 decimal digits), allows null: yes
The actual time spent on the agile task, in hours (not used for appointments and to do list items).
AssignedToName : varchar (max 78 chars), allows null: yes
The name of the user to whom the associated item is assigned, in the Last name, First name format.
AssigneeUserId : int, allows null: yes
The ID of the user to whom the item is assigned. 0 if the item is not assigned.
Custom1..Custom10 : varchar (max 8000 chars), allows null: yes
The values of custom fields 1 - 10.
These columns correspond to fields that can be available for Rich Text Feature.
Custom11..Custom90 : varchar (max 100 chars), allows null: yes
The values of custom fields 11 through 90.
DateBegin : datetime, allows null: yes
The date when the task starts.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateCreated : datetime, allows null: no, default: Current date and time
The date and time when the item was created.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateDue : datetime, allows null: yes
The date when the task must be completed. Not used for calendar appointments.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateEnd : datetime, allows null: yes
The date when the task finishes.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateLastEscalated : datetime, allows null: yes
The date when the associated item was last affected by an escalation rule.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateOtherReminder : datetime, allows null: yes
The column is not used.
DateUpdated : datetime, allows null: no, default: Current date and time
The date when the item was last updated.
The stored date and time are based on the server’s time zone. For more information, see the Date and Time Fields topic.
Description : varchar (max 8000 chars), allows null: yes
The description of the agile task, to do list item, or appointment.
This column corresponds to a field that can be available for Rich Text Feature.
EntityCode : varchar (max 100 chars), allows null: no
The module where the scheduled item is located.
You can find correspondences between entity code values and related modules in Table of Entity Code Values.
EstCost : money, allows null: yes
The estimated cost of the agile task (not used for appointments and to do list items).
EstFinish : datetime, allows null: yes
The date and time the work on the agile tasks is estimated to finish.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
EstHrs : decimal (max 18 decimal digits), allows null: yes
The estimated time the agile task will take, in hours (not used for appointments and to do list items).
EstHrsRemaining : decimal (max 18 decimal digits), allows null: yes
The estimated number of hours remaining to work on the agile task.
QAComplete calculates this value automatically when the user specifies how many hours have been spent on that task. To learn more, see Calculation of Percent Complete and Estimated Hours Remaining.
EstStart : datetime, allows null: yes
The date and time the work on the agile tasks is estimated to start.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
EventType : varchar (max 300 chars), allows null: no
The type of the item (ProjectTask, To Do List or Appointment). The value of the column is equal to the value of the TaskTypeCode column.
FirstMeetingTaskId : int, allows null: yes, default: 0
The numeric identifier of the first instance of a recurring meeting.
FirstRecurTaskId : int, allows null: yes, default: 0
The numeric identifier of the first instance of a recurring appointment.
FKId : int, allows null: no
The unique identifier of the associated item, such as BugId, FunctionalSpecId, and so on.
FolderId : int, allows null: yes
The unique identifier of the folder where the item is located.
FolderName : varchar (max 511 chars), allows null: yes
The name of the folder where the associated item is located.
Grouping : varchar (max 50 chars), allows null: yes
The mechanism of task grouping.
ImportId : int, allows null: yes
The ID of the imported batch in which the item was imported.
IsMeeting : char (max 1 char), allows null: yes, default: N
Shows if the appointment is a meeting.
IsOnActivityRpt : char (max 1 char), allows null: yes, default: N
The column is reserved for system use only.
IsRecurring : char (max 1 char), allows null: yes, default: N
Shows if the appointment is recurring.
Keywords : varchar (max 200 chars), allows null: yes
A list of keywords used to search for the task.
LastEscalationRule : varchar (max 100 chars), allows null: yes
The name of the escalation rule that last affected the associated item.
LastEscalationRuleId : int, allows null: yes
The ID of the escalation rule that last affected the associated item.
MLSId : int, allows null: yes
The column is reserved for system use only.
NbrEscalations : int, allows null: no
The number of escalation rules that affected the item (0 if there are no escalation rules).
NbrEvents : int, allows null: yes
The number of events attached to the associated item.
NbrFiles : int, allows null: yes
The number of files attached to the associated item.
NbrNotes : int, allows null: yes
The number of notes attached to the associated item.
NbrTasks : int, allows null: yes
The number of tasks attached to the associated item.
NotesDescription : varchar (max), allows null: yes
An alias for the LatestNotes column of the ExtendedAttributes table.
A description of the latest note attached to the associated item.
OriginalId : int, allows null: yes
The column is reserved for system use only.
OtherReminderEmails : varchar (max 1000 chars), allows null: yes
The column is not used.
OutlookId : varchar (max 100 chars), allows null: yes
The column is reserved for system use only.
OwnerName : varchar (max 78 chars), allows null: yes
The name of the user who owns the associated item, in the Last name, First name format.
OwnerUserId : int, allows null: yes
The ID of the user who created the item.
PctComplete : tinyint, allows null: yes
The percentage of task completion (used for agile tasks and to do list items).
QAComplete calculates this value automatically when the user specifies how many hours have been spent on the task. To learn more, see Calculation of Percent Complete and Estimated Hours Remaining.
PriorityCode : varchar (max 100 chars), allows null: yes
An item’s priority code is based on a choice list. The values of this choice list are stored in the Validations Table table. They correspond to the items whose values equal TaskPriority in the ValidationType column.
ProjId : int, allows null: no
The unique numeric identifier of the project that contains the item.
RequestedBy : varchar (max 30 chars), allows null: yes
The ID of the user who requested the agile task, or NULL if no user requested the item (not used for appointments and to do list items).
ScheduledEventId : int, allows null: no, default: auto-generated
The identifier of the scheduled event.
ShowTimeAs : varchar (max 30 chars), allows null: yes
Specifies how the appointment is shown in the calendar.
SortOrder : int, allows null: yes
If the task is a scheduled event, it is the task order.
StatusCode : varchar (max 100 chars), allows null: yes
An item’s status is based on a choice list. The values of this choice list are stored in the Validations Table table. They correspond to the items whose values equal TaskStatus in the ValidationType column.
SubGrouping : varchar (max 50 chars), allows null: yes
The mechanism of task grouping.
TaskDuration : varchar (max 10 chars), allows null: yes
Units of the appointment duration (hours or minutes).
TaskId : int, allows null: no
The unique numeric identifier of the item.
TaskTypeCode : varchar (max 100 chars), allows null: no, default: ProjectTasks
The type of the item (ProjectTask, To Do List or Appointment).
TaskUnits : int, allows null: yes
The number of units (hours or minutes) of the appointment.
Title : varchar (max 255 chars), allows null: no
The title of the agile task, to do list item, or appointment.
UpdateUserId : int, allows null: no, default: 0
The ID of the user who last updated the item.
UserName : varchar (max 78 chars), allows null: yes
The name of the user who last updated the associated item, in the Last name, First name format.