ST_WORKRECORDHISTORY

This table lists the work record history - work records for every task revision.

Column	Field	Type	Length	Primary	Description
1	ServerID	int	4	Y	Server ID
2	ID	int	4	Y	Workrecord ID
3	StWorkTaskID	int	4	N	ObjectID of Task
4	RevisionNumber	int	4	Y	Revision number of task
5	StWorkDate	datetime	8	N	Date
6	StWorkHours	float	8	N	Hours
7	StWorkRemainingHours	float	8	N	Remaining Hours
8	StWorkUserID	varchar	254	N	User Name
9	StWorkComment	Text	16	N	Comment

Table Joins

Column	Primary Table	Primary Field	Foreign Table	Foreign Field
1	ST_TASKHISTORY	ServerID	ST_WORKRECORDHISTORY	ServerID
2	ST_TASKHISTORY	ID	ST_WORKRECORDHISTORY	StWorkTaskID
3	ST_TASKHISTORY	RevisionNumber	STWORKRECORDHISTORY	RevisionNumber