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 |