ST_TASKS

This table contains the list of tasks.

Column	Field	Type	Length	Primary	Description
1	ServerID	int	4	Y	Server ID
2	ID	int	4	Y	ObjectID
3	CreatedTime	datetime	8	N	ObjectID of the root object
4	CreatedUserID	varchar	254	N	Creation time
5	ModifiedTime	datetime	8	N	Creation user
6	ModifiedUserID	varchar	254	N	Time last modified
7	RevisionNumber	int	4	N	Number of revisions
8	RevisionFlags	int	4	N	Revision Flags
9	StComment	text	16	N	Comment
10	StTaskParentID	int	4	N	Object ID of Parent Task
11	StTaskNumber	int	4	N	Task Number
12	StTaskName	varchar	254	N	Task Name
13	StTaskNotes	text	16	N	Notes
14	StTaskPercentComplete	int	4	N	Percent Complete
15	StTaskMilestone	varchar	254	N	Milestone
16	StTaskPriority	varchar	254	N	Priority
17	StTaskStatus	varchar	254	N	Status
18	StTaskResponsibility	varchar	254	N	Responsibility
19	StTaskEstimatedHours	float	8	N	Estimated Hours
20	StTaskEstimatedStart	datetime	8	N	Estimated Start
21	StTaskEstimatedFinish	datetime	8	N	Estimated Finish
22	StTaskActualHours	float	8	N	Actual Hours
23	StTaskActualStart	datetime	8	N	Actual Start
24	StTaskActualFinish	datetime	8	N	Actual Finish
25	StTaskDuration	float	8	N	Duration
26	StTaskNeedsAttention	varchar	254	N	Needs Attention
27	StTaskAttentionNotes	text	16	N	Attention Notes
28	AttachmentCount	int	4	N	Attachment Count
29	AttachmentNames	text	16	N	Names of all attachments
30	StTaskType	varchar	254	N	Type
31	StTaskConstraintType	varchar	254	N	Constraint Type
32	StTaskConstraintDate	datetime	8	N	Constraint Date
33	StTaskGUID	varchar	111	N
34	StTaskUniqueID	int	4	N
35	StTaskWBSCode	varchar	64	N	WBSCode
36	StTaskMSProjectFileName	varchar	762	N
37	StTaskMSProjectLastUpdate	datetime	8	N
38	StWorkDependencyLastUpdatdeatetime	datetime	8	N	Work Dependency Last Update
39	StTaskResourceCount	int	4	N	Resource count
40	StTaskResourceNames	text	16	N	List of Resource Users
41	StTaskProcessUsage	varchar	254	N
42	StTaskEstimatedStartVariance	int	4	N	Estimated Start Variance
43	StTaskEstimatedFinishVariance	int	4	N	Estimated Finish Variance
44	StTaskEstimatedHoursVariance	float	8	N	Estimated Hours Variance
45	StTaskOrigin	varchar	254	N	Origin
46	WorkRecordCount	int	4	N	Number of Work Records
47	DotNotation	varchar	254	N	Dot Notation
48	StTaskDescription	text	16	N	Description
49	StTaskOrder	float	8	N	Task Order
50	StTaskLifecycleType	varchar	254	N	Task lifecycle Type
51	StTaskBlocked	int	8	N	Is Task Blocked

Table Joins

Column	Primary Table	Primary Field	Foreign Table	Foreign Field
1	ST_TASKS	ServerID	ST_LINKS	ServerID
2	ST_TASKS	ID	ST_LINKS	ParentObjectID
1	ST_TASKS	ServerID	ST_LINKS	ServerID
2	ST_TASKS	ID	ST_LINKS	ChildObjectID
1	ST_TASKS	ServerID	ST_OBJECTACLS	ServerID
2	ST_TASKS	ID	ST_OBJECTACLS	ObjectID
1	ST_TASKS	ServerID	ST_TASKHISTORY	ServerID
2	ST_TASKS	ID	ST_TASKHISTORY	ID
1	ST_TASKS	ServerID	ST_WORKRECORDS	ServerID
2	STTASKS	ID	STWORKRECORDS	StWorkTaskID