ST_CHANGEPACKAGES

This table provides the list of change packages.

Column	Field	Type	Length	Primary	Description
1	ServerID	int	4	Y	Server ID
2	ID	int	4	Y	Object ID
3	CreatedTime	datetime	8	N	Created Time
4	CreatedUserID	varchar	254	N	Created User
5	ModifiedTime	datetime	8	N	Modified Time
6	ModifiedUserID	varchar	254	N	Modified User
7	RevisionNumber	int	4	N	Revision Number
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_CHANGEPACKAGECHANGES	ServerID
2	ST_CHANGEPACKAGES	ID	ST_CHANGEPACKAGECHANGES
1	ST_CHANGEPACKAGES	ServerID	ST_CHANGEPACKAGEHISTORY	ServerID
2	ST_CHANGEPACKAGES	ID	ST_CHANGEPACKAGEHISTORY	ID
1	ST_CHANGEPACKAGES	ServerID	ST_OBJECTACLS	ServerID
2	STCHANGEPACKAGES	ID	STOBJECTACLS	ObjectID