ST_TASKHISTORY

This table contains the task history - one record for each revision.

Column Field Type Length Primary Description

1

ServerID

int

4

Y

Server ID

2

ID

int

4

Y

ObjectID

3

RevisionNumber

int

4

Y

Number of revisions

4

CreatedTime

datetime

8

N

ObjectID of the root object

5

CreatedUserID

varchar

254

N

Creation time

6

ModifiedTime

datetime

8

N

Creation user

7

ModifiedUserID

varchar

254

N

Time last modified

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

MSProject Last Update

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_TASKHISTORY

ServerID

2

ST_TASKS

ID

ST_TASKHISTORY

ID

1

ST_TASKHISTORY

ServerID

ST_VIEWMEMBER

ServerID

2

ST_TASKHISTORY

ID

ST_VIEWMEMBER

ID

3

ST_TASKHISTORY

RevisionNumber

ST_VIEWMEMBER

RevisionNumber

1

ST_TASKHISTORY

ServerID

ST_WORKRECORDHISTORY

ServerID

2

ST_TASKHISTORY

ID

ST_WORKRECORDHISTORY

StWorkTaskID

3

ST_TASKHISTORY

RevisionNumber

STWORKRECORDHISTORY

RevisionNumber