[dbo].[call

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	1763
Created	11:07:05 AM Wednesday, March 07, 2007
Last Modified	4:35:59 PM Wednesday, March 24, 2010

	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
	affected_service	binary(16)	16
	external_system_ticket	ntext	max
	incorrectly_assigned	int	4
	major_incident	int	4
	orig_user_admin_org	binary(16)	16
	orig_user_cost_center	int	4
	orig_user_dept	int	4
	orig_user_organization	binary(16)	16
	outage_detail_what	ntext	max
	outage_detail_who	ntext	max
	outage_detail_why	ntext	max
	outage_reason_desc	ntext	max
	outage_type	int	4
	pct_service_restored	int	4
	remote_control_used	int	4
	requested_by	binary(16)	16
	resolution_code	int	4
	resolution_method	int	4
	resolvable_at_lower	int	4
	return_to_service	int	4
	symptom_code	int	4
	target_closed_count	int	4
	target_closed_last	int	4
	target_hold_count	int	4
	target_hold_last	int	4
	target_resolved_count	int	4
	target_resolved_last	int	4
	target_start_last	int	4
	caextwf_instance_id	int	4
	sap_category	nvarchar(32)	64
	sap_client	nvarchar(3)	6
	sap_component	nvarchar(32)	64
	sap_cprog	nvarchar(24)	48
	sap_dbsys	nvarchar(12)	24
	sap_frontend	nvarchar(12)	24
	sap_instance	nvarchar(12)	24
	sap_msg	nvarchar(12)	24
	sap_os	nvarchar(32)	64
	sap_priority	int	4
	sap_sftwcomp	nvarchar(32)	64
	sap_sftwcomppatch	nvarchar(10)	20
	sap_sftwcomprel	nvarchar(32)	64
	sap_solman	nvarchar(1)	2
	sap_state	int	4
	sap_status	nvarchar(32)	64
	sap_subject	nvarchar(32)	64
	sap_syshost	nvarchar(64)	128
	sap_sysid	nvarchar(3)	6
	sap_systyp	nvarchar(12)	24
	sap_userstatus	nvarchar(40)	80
	sap_xnum	nvarchar(32)	64

	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,
[affected_service] [binary] (16) NULL,
[external_system_ticket] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[incorrectly_assigned] [int] NULL,
[major_incident] [int] NULL,
[orig_user_admin_org] [binary] (16) NULL,
[orig_user_cost_center] [int] NULL,
[orig_user_dept] [int] NULL,
[orig_user_organization] [binary] (16) NULL,
[outage_detail_what] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[outage_detail_who] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[outage_detail_why] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[outage_reason_desc] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[outage_type] [int] NULL,
[pct_service_restored] [int] NULL,
[remote_control_used] [int] NULL,
[requested_by] [binary] (16) NULL,
[resolution_code] [int] NULL,
[resolution_method] [int] NULL,
[resolvable_at_lower] [int] NULL,
[return_to_service] [int] NULL,
[symptom_code] [int] NULL,
[target_closed_count] [int] NULL,
[target_closed_last] [int] NULL,
[target_hold_count] [int] NULL,
[target_hold_last] [int] NULL,
[target_resolved_count] [int] NULL,
[target_resolved_last] [int] NULL,
[target_start_last] [int] NULL,
[caextwf_instance_id] [int] NULL,
[sap_category] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_client] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_component] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_cprog] [nvarchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_dbsys] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_frontend] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_instance] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_msg] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_os] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_priority] [int] NULL,
[sap_sftwcomp] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_sftwcomppatch] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_sftwcomprel] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_solman] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_state] [int] NULL,
[sap_status] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_subject] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_syshost] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_sysid] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_systyp] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_userstatus] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sap_xnum] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS 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