Table Name:	csc_incident
Table Number:	5110
Group:	Exchange Mgr
Description:	Represents a Customer Support Consortium service incident
Flags:
Baseline/Custom:	Baseline

select * from table_csc_incident

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
ack_ind	LONG	tinyint			0	DIRECT	Indicates acknowledgment of the problem submission; i.e., 0=no acknowledgement 1=acknowleged, default=0
comments	CHAR	text				ALLOW_NULL	Text description of the incident
confirm_ind	LONG	tinyint			0	DIRECT	Indicates confirmation of close for the problem submission; i.e., 0=not confirmed 1=confimed, default=0
current_state	LONG	smallint				DIRECT	The current state of the SERVICE INCIDENT object in the virtual machine. From a user-defined popup list
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
entitle_ind	LONG	tinyint			0	DIRECT	Indicates entitlement for service of the problem submission; i.e., 0=no entitlement 1=entitled, default=0. This is the internal entitlement state
entitled	LONG	tinyint				DIRECT	Whether the incident is entitled to service; i.e., 0=no, 1=yes. This is the entitlement as reported/received
lack_ind	LONG	tinyint			0	DIRECT	Indicates whether information from requestor is lacking; i.e., 0=not lacking 1=is lacking, default=0
local_ind	LONG	tinyint			1	DIRECT	Indicates whether a csc_incident originated; i.e., 0=not originated locally, 1=originated locally. Default=1
objid	LONG	int	3			DIRECT	Internal record number
prob_ind	LONG	tinyint			0	DIRECT	Indicates if a problem has been submitted; 0=no, 1=yes, default=0
provider_id	CHAR	varchar		80			Local service incident ID generated by the provider
provider_priority	LONG	tinyint			1	DIRECT	The priority of the problem as defined by the provider; values must be in the range 1-5 with 1 being most sever. Default=1
requestor_id	CHAR	varchar	4	80			Service incident's ID that is generated by the requester. This is the official Service Incident ID when referred to by either party
requestor_severity	LONG	tinyint			1	DIRECT	The severity of the problem as defined by the requester; Values must be in the range 1-5 with 1 being most sever. Default=1
response_date	CLK_TIME	datetime					Date and time by which a response is needed
response_time	CHAR	varchar		30			Promised/desired response time to the customer
rpt_email	CHAR	varchar		80			Original e-mail address
rpt_fax	CHAR	varchar		20			Original reporting site fax number which includes area code, number and extension
rpt_first	CHAR	varchar		30			Original reporting site contact. Contact's first name
rpt_last	CHAR	varchar		30			Original reporting site contact. Contact's last name
rpt_phone	CHAR	varchar		20			Original reporting site phone which includes area code, number and extension
server_id	LONG	int				DIRECT	Exchange protocol server ID number
title	CHAR	varchar		80			Title of the CSC incident
trans_name	CHAR	varchar		80			Name of the last transaction which was acknowledged for the Service Incident
wait_ind	LONG	tinyint			0	DIRECT	Indicates waiting for confirmation of close for the problem submission; i.e., 0=not waiting 1=waiting, default=0
workflow_status	CHAR	varchar		30			What the status of this incident is according to the workflow

Relations:

Relation	Type	Target Object	Inverse Relation	Comment
incident2csc_activity	OTM	csc_activity	activity2csc_incident	Actions performed on the CSC incident
entitle2csc_agreement	MTO	csc_agreement	entitle2csc_incident	CSC agreement used for entitlement
reporter2csc_contact	MTO	csc_contact	reporter2csc_incident	Reporter contact for the incident
requestor2csc_contact	MTO	csc_contact	requestor2csc_incident	Requestor contact for the incident
provider2csc_contact	MTO	csc_contact	provider2csc_incident	Provider contact for the incident
incident2csc_org	MTO	csc_org	csc_org2csc_incident	Requestor organization for the incident
incident2csc_problem	OTOF	csc_problem	problem2csc_incident	Description of the problem
incident2csc_product	MTO	csc_product	prod2csc_incident	Csc_product involved in the incident
incdnt2csc_resolution	OTM	csc_resolution	res2csc_incident	Resolutions for the incident
incident2csc_solution	OTOF	csc_solution	solution2csc_incident	Solution for the CSC indident

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
incident_ind	server_id:requestor_id:local_ind	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
incident_ind	server_id, requestor_id, local_ind	nonclustered, unique located on PRIMARY
ind_entitle2csc_agreement	entitle2csc_agreement	nonclustered located on PRIMARY
ind_incident2csc_org	incident2csc_org	nonclustered located on PRIMARY
ind_provider2csc_contact	provider2csc_contact	nonclustered located on PRIMARY
ind_reporter2csc_contact	reporter2csc_contact	nonclustered located on PRIMARY
ind_requestor2csc_contact	requestor2csc_contact	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

csc_incident

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog