ST_CHANGEPACKAGEHISTORY

This table lists the change package history - one record for every revision.

Column	Field	Type	Length	Primary	Description
1	ServerID	int	4	Y	Server ID
2	ID	int	4	Y	Object ID
3	RevisionNumber	int	4	Y	Revision Number
4	CreatedTime	datetime	8	N	Created Time
5	CreatedUserID	varchar	254	N	Created User
6	ModifiedTime	datetime	8	N	Modified Time
7	ModifiedUserID	varchar	254	N	Modified User
8	RevisionFlags	int	4	N	Revision Flags
9	StComment	text	16	N	Comment
10	Name	varchar	762	N	Name
11	Description	text	16	N	Description
12	SessionType	varchar	254	N	Type of Session
13	Responsibility	varchar	254	N	Responsible User
14	SourceViewID	int	4	N	View of Source
15	TargetViewID	int	4	N	View of Target
16	State	varchar	254	N	State of Change Package
17	CommitTime	datetime	8	N	Commit Time for Change Package
18	CommitUserID	varchar	254	N	Commit user
19	TransactionID	int	4	N	Transaction ID
20	CommittedInBuild	varchar	254	N	Committed Build
21	PreCommitViewLabel	varchar	254	N	Pre commit view label
22	PreCommitRevisionLabel	varchar	254	N	Pre commit revision label
23	PostCommitViewLabel	varchar	254	N	Post commit view label
24	PostCommitRevisionLabel	varchar	254	N	Post commit revision label
25	AttachmentCount	int	4	N	Attachment Count
26	AttachmentNames	text	16	N	Attachment Names

Table Joins

Column	Primary Table	Primary Field	Foreign Table	Foreign Field
1	ST_CHANGEPACKAGES	ServerID	ST_CHANGEPACKAGEHISTORY	ServerID
2	ST_CHANGEPACKAGES	ID	ST_CHANGEPACKAGEHISTORY	ID
1	ST_CHANGEPACKAGEHIST	ServerID	ST_VIEWMEMBER	ServerID
2	ST_CHANGEPACKAGEHISTORY	ID	ST_VIEWMEMBER	ID
3	ST_CHANGEPACKAGEHIST	RevisionNumber	ST_VIEWMEMBER	RevisionNumber