Table Name:	csc_admin
Table Number:	5123
Group:	Exchange Mgr
Description:	Each solution document has one ADMINISTRATIVE object. The ADMINISTRATIVE form includes objects that provide administrative information about an individual solution document
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_csc_admin

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
compliance_level	LONG	tinyint				DIRECT	Level of compliance to the Solution Exchange Standard of this Solution document
copyright	CHAR	varchar		255			Indicates all necessary copyright information
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
disclaimer	CHAR	varchar		255			Describes any disclaimer the owner has about the information
distribution	LONG	smallint			0	DIRECT	Intended distribution-audience for the Solution document; i.e., 0=proprietary, 1=internal, 2=partner, 3=public. Default=0
document_status	LONG	smallint			0	DIRECT	Completion level of this Solution document; i.e., 0=draft, 1=reviewed, 2=published. Default=0
language	CHAR	varchar		30			Language of the content in the document (the English name of the language)
objid	LONG	int	3			DIRECT	Internal record number
rights	CHAR	varchar		255			Describes any information about rights to the knowledge
server_id	LONG	int				DIRECT	Exchange protocol server ID number

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
owner2csc_contact	MTM	csc_contact	owner2csc_admin	Owners of the docutment		mtm_csc_contact4_ csc_admin0
admin2csc_expression	OTOF	csc_expression	text2csc_admin	Related CSC expression
admin2csc_feature	OTOF	csc_feature	feature2csc_admin	Related CSC feature
problem2csc_problem	OTOP	csc_problem	problem2csc_admin	Related CSC problem
admin2csc_resolution	OTOF	csc_resolution	res2csc_admin	Related CSC resolution
admin2csc_revision	OTM	csc_revision	rev2csc_admin	Related CSC revisions
solution2csc_solution	OTOP	csc_solution	solution2csc_admin	Related CSC solution
admin2csc_statement	MTO	csc_statement	text2csc_admin	Related CSC statement

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_problem2csc_problem	problem2csc_problem	nonclustered located on PRIMARY
ind_solution2csc_solution	solution2csc_solution	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

csc_admin

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user