ST_CRHISTORY

This table provides the change request history - one record for every 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 since branching
4	CreatedTime	datetime	8	N	Creation time
5	CreatedUserID	varchar	254	N	Creation user
6	ModifiedTime	datetime	8	N	Time last modified
7	ModifiedUserID	varchar	254	N	User who last modified
8	RevisionFlags	int	4	N	Revision Flags
9	StComment	text	16	N	Comment
10	RootObjectID	int	4	N	ObjectID of the root object
11	ParentObjectID	int	4	N	Object ID of item from which this item is branched from
12	ParentRevision	int	4	N
13	PathRevision	int	4	N	Revision of branching (0 means no branching)
14	ViewID	int	4	N	View ID
15	DotNotation	varchar	254	N	Dot notation
16	ChangeNumber	int	4	N	Change Request Number
17	Synopsis	text	16	N	Synopsis
18	Type	varchar	254	N	Type
19	Status	varchar	254	N	Status
20	Severity	varchar	254	N	Severity
21	Platform	varchar	254	N	Platform
22	Category	varchar	192	N	Category
23	Component	varchar	192	N	Component
24	ExternalReference	varchar	192	N	External Reference
25	AddressedIn	varchar	254	N	Addressed In
26	AddressedBy	varchar	254	N	Addressed By
27	LastBuildTested	varchar	254	N	Last Build Tested
28	Responsibility	varchar	254	N	Responsibility
29	Priority	varchar	254	N	Priority
30	Description	text	16	N	Description
31	TestCommand	varchar	762	N
32	WorkAround	text	16	N	Work Around
33	Fix	text	16	N	Fix
34	ClosedOn	datetime	8	N	Time closed
35	AttachmentCount	int	4	N	Attachment Count
36	AttachmentNames	text	16	N	Names of all attachments
37	ResolvedOn	datetime	8	N	Time resolved
38	VerifiedOn	datetime	8	N	Time verified
39	AddressedInView	int	4	N
40	EnteredOn	datetime	8	N	Time when CR entered
41	EnteredBy	varchar	254	N	User who entered CR
42	Usr_StarFlowStatus	varchar	254	N

Table Joins

Column	Primary Table	Primary Field	Foreign Table	Foreign Field
1	ST_CRS	ServerID	ST_CRHISTORY	ServerID
2	ST_CRS	ID	ST_CRHISTORY	ID
1	ST_CRHISTORY	ServerID	ST_VIEWMEMBER	ServerID
2	ST_CRHISTORY	ID	ST_VIEWMEMBER	ID
3	STCRHISTORY	RevisionNumber	STVIEWMEMBER	RevisionNumber