Table Name:	csc_revision
Table Number:	5133
Group:	Exchange Mgr
Description:	Records changes to the solution content
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_csc_revision

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
activity_name	LONG	smallint				DIRECT	What revision is being made; i.e., 0=create, 1=update, 2=delete
activity_type	LONG	smallint			0	DIRECT	What kind of revision is being made; i.e., 0=technical, 1=editorial, 2=administrative. Default=0
csc_date	CLK_TIME	datetime					Date for the revision
description	CHAR	varchar		20			Description of what was done
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
editorial_status	LONG	smallint			0	DIRECT	The editorial status of the revision; i.e., 0=in_progress, 1=draft, 2=reviewed, 3=published. Default=0
objid	LONG	int	3			DIRECT	Internal record number
server_id	LONG	int				DIRECT	Exchange protocol server ID number
technical_status	LONG	smallint			0	DIRECT	The technical status of the revision; i.e., 0=open, 1=not_reviewed, 2=reviewed, 3=approved. Default=0

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
rev2csc_admin	MTO	csc_admin	admin2csc_revision	Revisions link to their solutions via the solution's administrative object
author2csc_contact	MTO	csc_contact	author2csc_revision	Person making the revision

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_rev2csc_admin	rev2csc_admin, server_id	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

csc_revision

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user