[dbo].[call

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	830
Created	11:07:05 AM Wednesday, March 07, 2007
Last Modified	11:10:58 AM Monday, May 11, 2009

	Name	Data Type	Max Length (Bytes)
	id	int	4
$Indexes call_req_x12: persid\ref_num\open_date\active_flag\type$	persid	nvarchar(30)	60
$Indexes call_req_x0: open_date\ref_num$ $Indexes call_req_x13: parent\ref_num\open_date\active_flag\type$ $Indexes call_req_x12: persid\ref_num\open_date\active_flag\type$	ref_num	nvarchar(30)	60
	summary	nvarchar(240)	480
	description	ntext	max
$Indexes call_req_x10: status\type$	status	nvarchar(12)	24
$Indexes call_req_x11: active_flag\type$ $Indexes call_req_x6: affected_rc\active_flag\type$ $Indexes call_req_x4: assignee\active_flag\type$ $Indexes call_req_x7: category\active_flag\type$ $Indexes call_req_x1: customer\active_flag\type$ $Indexes call_req_x5: group_id\active_flag\type$ $Indexes call_req_x2: log_agent\active_flag\type$ $Indexes call_req_x13: parent\ref_num\open_date\active_flag\type$ $Indexes call_req_x12: persid\ref_num\open_date\active_flag\type$ $Indexes call_req_x8: priority\active_flag\type$	active_flag	int	4
$Indexes call_req_x0: open_date\ref_num$ $Indexes call_req_x13: parent\ref_num\open_date\active_flag\type$ $Indexes call_req_x12: persid\ref_num\open_date\active_flag\type$	open_date	int	4
	time_spent_sum	int	4
	last_mod_dt	int	4
	last_mod_by	binary(16)	16
	close_date	int	4
	resolve_date	int	4
	rootcause	int	4
$Indexes call_req_x2: log_agent\active_flag\type$	log_agent	binary(16)	16
$Indexes call_req_x4: assignee\active_flag\type$	assignee	binary(16)	16
$Indexes call_req_x5: group_id\active_flag\type$	group_id	binary(16)	16
$Indexes call_req_x1: customer\active_flag\type$	customer	binary(16)	16
	charge_back_id	nvarchar(12)	24
$Indexes call_req_x6: affected_rc\active_flag\type$	affected_rc	binary(16)	16
	support_lev	nvarchar(30)	60
$Indexes call_req_x7: category\active_flag\type$	category	nvarchar(30)	60
	solution	nvarchar(30)	60
	impact	int	4
$Indexes call_req_x8: priority\active_flag\type$	priority	int	4
	urgency	int	4
	severity	int	4
	extern_ref	nvarchar(30)	60
	last_act_id	nvarchar(12)	24
	cr_tticket	int	4
$Indexes call_req_x13: parent\ref_num\open_date\active_flag\type$	parent	nvarchar(30)	60
	template_name	nvarchar(30)	60
	sla_violation	int	4
	predicted_sla_viol	int	4
	macro_predict_viol	int	4
	created_via	int	4
	call_back_date	int	4
	call_back_flag	int	4
	event_token	nvarchar(80)	160
	sched_token	nvarchar(128)	256
$Indexes call_req_x11: active_flag\type$ $Indexes call_req_x6: affected_rc\active_flag\type$ $Indexes call_req_x4: assignee\active_flag\type$ $Indexes call_req_x7: category\active_flag\type$ $Indexes call_req_x1: customer\active_flag\type$ $Indexes call_req_x5: group_id\active_flag\type$ $Indexes call_req_x2: log_agent\active_flag\type$ $Indexes call_req_x13: parent\ref_num\open_date\active_flag\type$ $Indexes call_req_x12: persid\ref_num\open_date\active_flag\type$ $Indexes call_req_x8: priority\active_flag\type$ $Indexes call_req_x10: status\type$	type	nvarchar(10)	20
	string1	nvarchar(40)	80
	string2	nvarchar(40)	80
	string3	nvarchar(40)	80
	string4	nvarchar(40)	80
	string5	nvarchar(40)	80
	string6	nvarchar(40)	80
	problem	nvarchar(30)	60
	incident_priority	int	4
	change	int	4
	ticket_avoided	int	4
	tenant	binary(16)	16
	cawf_procid	nvarchar(40)	80
	caused_by_chg	int	4
	outage_start_time	int	4
	outage_end_time	int	4

	Name	Columns	Unique
	XPKcall_req	id
	call_req_x0	open_date, ref_num
	call_req_x3	ref_num
	call_req_x1	customer, active_flag, type
	call_req_x10	status, type
	call_req_x11	active_flag, type
	call_req_x12	persid, ref_num, open_date, active_flag, type
	call_req_x13	parent, ref_num, open_date, active_flag, type
	call_req_x14	template_name
	call_req_x15	close_date
	call_req_x16	resolve_date
	call_req_x17	change
	call_req_x18	problem
	call_req_x19	tenant
	call_req_x2	log_agent, active_flag, type
	call_req_x20	caused_by_chg
	call_req_x4	assignee, active_flag, type
	call_req_x5	group_id, active_flag, type
	call_req_x6	affected_rc, active_flag, type
	call_req_x7	category, active_flag, type
	call_req_x8	priority, active_flag, type
	call_req_x9	extern_ref

Type	Action	Owning Principal
Grant	Delete	service_desk_admin_group
Grant	Insert	service_desk_admin_group
Grant	Delete	uapmadmin_group
Grant	Insert	uapmadmin_group
Grant	Delete	swcmadmin
Grant	Insert	swcmadmin
Grant	Delete	uapmbatch_group
Grant	Insert	uapmbatch_group
Grant	Delete	uapmadmin
Grant	Insert	uapmadmin
Grant	Delete	uapmbatch
Grant	Insert	uapmbatch
Grant	Select	service_desk_admin_group
Grant	Update	service_desk_admin_group
Grant	Select	service_desk_ro_group
Grant	Select	uapmadmin_group
Grant	Update	uapmadmin_group
Grant	Select	uapmbatch_group
Grant	Update	uapmbatch_group
Grant	Select	uapmreporting_group
Grant	Select	uapmadmin
Grant	Update	uapmadmin
Grant	Select	uapmbatch
Grant	Update	uapmbatch
Grant	Select	uapmreporting
Grant	Select	swcmadmin
Grant	Update	swcmadmin

SQL Script

CREATE TABLE [dbo].[call_req]
(
[id] [int] NOT NULL,
[persid] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ref_num] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[summary] [nvarchar] (240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[description] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[status] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[active_flag] [int] NOT NULL,
[open_date] [int] NULL,
[time_spent_sum] [int] NULL,
[last_mod_dt] [int] NULL,
[last_mod_by] [binary] (16) NULL,
[close_date] [int] NULL,
[resolve_date] [int] NULL,
[rootcause] [int] NULL,
[log_agent] [binary] (16) NOT NULL,
[assignee] [binary] (16) NULL,
[group_id] [binary] (16) NULL,
[customer] [binary] (16) NOT NULL,
[charge_back_id] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[affected_rc] [binary] (16) NULL,
[support_lev] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[category] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[solution] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[impact] [int] NULL,
[priority] [int] NOT NULL,
[urgency] [int] NULL,
[severity] [int] NULL,
[extern_ref] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_act_id] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cr_tticket] [int] NULL,
[parent] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[template_name] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sla_violation] [int] NULL,
[predicted_sla_viol] [int] NULL,
[macro_predict_viol] [int] NULL,
[created_via] [int] NULL,
[call_back_date] [int] NULL,
[call_back_flag] [int] NULL,
[event_token] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sched_token] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[type] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[string1] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[string2] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[string3] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[string4] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[string5] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[string6] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[problem] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[incident_priority] [int] NULL,
[change] [int] NULL,
[ticket_avoided] [int] NULL,
[tenant] [binary] (16) NULL,
[cawf_procid] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[caused_by_chg] [int] NULL,
[outage_start_time] [int] NULL,
[outage_end_time] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[call_req] ADD CONSTRAINT [XPKcall_req] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x11] ON [dbo].[call_req] ([active_flag], [type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x6] ON [dbo].[call_req] ([affected_rc], [active_flag], [type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x4] ON [dbo].[call_req] ([assignee], [active_flag], [type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x7] ON [dbo].[call_req] ([category], [active_flag], [type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x20] ON [dbo].[call_req] ([caused_by_chg]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x17] ON [dbo].[call_req] ([change]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x15] ON [dbo].[call_req] ([close_date]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x1] ON [dbo].[call_req] ([customer], [active_flag], [type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x9] ON [dbo].[call_req] ([extern_ref]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x5] ON [dbo].[call_req] ([group_id], [active_flag], [type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x2] ON [dbo].[call_req] ([log_agent], [active_flag], [type]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [call_req_x0] ON [dbo].[call_req] ([open_date], [ref_num]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x13] ON [dbo].[call_req] ([parent], [ref_num], [open_date], [active_flag], [type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x12] ON [dbo].[call_req] ([persid], [ref_num], [open_date], [active_flag], [type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x8] ON [dbo].[call_req] ([priority], [active_flag], [type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x18] ON [dbo].[call_req] ([problem]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [call_req_x3] ON [dbo].[call_req] ([ref_num]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x16] ON [dbo].[call_req] ([resolve_date]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x10] ON [dbo].[call_req] ([status], [type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x14] ON [dbo].[call_req] ([template_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [call_req_x19] ON [dbo].[call_req] ([tenant]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[call_req] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[call_req] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[call_req] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[call_req] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[call_req] TO [service_desk_ro_group]
GRANT SELECT ON  [dbo].[call_req] TO [swcmadmin]
GRANT INSERT ON  [dbo].[call_req] TO [swcmadmin]
GRANT DELETE ON  [dbo].[call_req] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[call_req] TO [swcmadmin]
GRANT SELECT ON  [dbo].[call_req] TO [uapmadmin]
GRANT INSERT ON  [dbo].[call_req] TO [uapmadmin]
GRANT DELETE ON  [dbo].[call_req] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[call_req] TO [uapmadmin]
GRANT SELECT ON  [dbo].[call_req] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[call_req] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[call_req] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[call_req] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[call_req] TO [uapmbatch]
GRANT INSERT ON  [dbo].[call_req] TO [uapmbatch]
GRANT DELETE ON  [dbo].[call_req] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[call_req] TO [uapmbatch]
GRANT SELECT ON  [dbo].[call_req] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[call_req] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[call_req] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[call_req] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[call_req] TO [uapmreporting]
GRANT SELECT ON  [dbo].[call_req] TO [uapmreporting_group]
GO