Table Name:	csc_org
Table Number:	5114
Group:	Exchange Mgr
Description:	Contains organization information. It may be used independently, or as part of a contact description
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_csc_org

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
alt_phone	CHAR	varchar		20			Alternate phone number for the organization
business	CHAR	varchar		255			Description of organization's primary business
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
email	CHAR	varchar		80			Organization's email address
fax	CHAR	varchar		20			Primary fax number for organization
name	CHAR	varchar		80			Name of the organization
objid	LONG	int	3			DIRECT	Internal record number
phone	CHAR	varchar		20			Primary phone number for the organization
region	CHAR	varchar		80			Description of organization's location
server_id	LONG	int				DIRECT	Exchange protocol server ID number

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
csc_org2csc_address	OTOP	csc_address	csc_address2csc_org	Related CSC address
csc_org2csc_contact	OTM	csc_contact	contact2csc_org	Contacts for the CSC organization
csc_org2csc_incident	OTM	csc_incident	incident2csc_org	Incidents for which the organization is the requestor

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
org_ind	server_id:name	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY
org_ind	server_id, name	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

csc_org

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user