[dbo].[issue]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	3
Created	11:07:18 AM Wednesday, March 07, 2007
Last Modified	4:36:03 PM Wednesday, March 24, 2010

	Name	Data Type	Max Length (Bytes)
	id	int	4
$Indexes issue_x8: persid\ref_num\open_date\active_flag$	persid	nvarchar(30)	60
$Indexes issue_x0: open_date\ref_num$ $Indexes issue_x11: parent\ref_num\open_date\active_flag$ $Indexes issue_x8: persid\ref_num\open_date\active_flag$	ref_num	nvarchar(30)	60
	summary	nvarchar(240)	480
	description	ntext	max
	status	nvarchar(12)	24
$Indexes issue_x4: assignee\active_flag$ $Indexes issue_x6: category\active_flag$ $Indexes issue_x5: group_id\active_flag$ $Indexes issue_x2: log_agent\active_flag$ $Indexes issue_x11: parent\ref_num\open_date\active_flag$ $Indexes issue_x8: persid\ref_num\open_date\active_flag$ $Indexes issue_x7: priority\active_flag$ $Indexes issue_x1: requestor\active_flag$	active_flag	int	4
	start_date	int	4
$Indexes issue_x0: open_date\ref_num$ $Indexes issue_x11: parent\ref_num\open_date\active_flag$ $Indexes issue_x8: persid\ref_num\open_date\active_flag$	open_date	int	4
	last_mod_dt	int	4
	last_mod_by	binary(16)	16
	close_date	int	4
	resolve_date	int	4
	rootcause	int	4
	est_total_time	int	4
	actual_total_time	int	4
$Indexes issue_x2: log_agent\active_flag$	log_agent	binary(16)	16
$Indexes issue_x4: assignee\active_flag$	assignee	binary(16)	16
	organization	binary(16)	16
$Indexes issue_x5: group_id\active_flag$	group_id	binary(16)	16
	affected_contact	binary(16)	16
$Indexes issue_x1: requestor\active_flag$	requestor	binary(16)	16
$Indexes issue_x6: category\active_flag$	category	nvarchar(12)	24
$Indexes issue_x7: priority\active_flag$	priority	int	4
	need_by	int	4
	est_comp_date	int	4
	actual_comp_date	int	4
	est_cost	int	4
	actual_cost	int	4
	justification	nvarchar(240)	480
	backout_plan	nvarchar(240)	480
	impact	int	4
$Indexes issue_x11: parent\ref_num\open_date\active_flag$	parent	nvarchar(30)	60
	effort	nvarchar(240)	480
	support_lev	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
	string1	nvarchar(40)	80
	string2	nvarchar(40)	80
	string3	nvarchar(40)	80
	string4	nvarchar(40)	80
	string5	nvarchar(40)	80
	string6	nvarchar(40)	80
	service_date	int	4
	service_num	nvarchar(30)	60
	product	int	4
	actions	nvarchar(750)	1500
	type_of_contact	int	4
	reporting_method	int	4
	person_contacting	int	4
	flag1	int	4
	flag2	int	4
	flag3	int	4
	flag4	int	4
	flag5	int	4
	flag6	int	4
	user1	nvarchar(100)	200
	user2	nvarchar(100)	200
	user3	nvarchar(100)	200
	cawf_procid	nvarchar(40)	80
	ticket_avoided	int	4
	tenant	binary(16)	16
	external_system_ticket	ntext	max
	orig_user_admin_org	binary(16)	16
	orig_user_cost_center	int	4
	orig_user_dept	int	4
	orig_user_organization	binary(16)	16
	requested_by	binary(16)	16
	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

	Name	Columns	Unique
	XPKissue	id
	issue_x0	open_date, ref_num
	issue_x3	ref_num
	issue_x1	requestor, active_flag
	issue_x10	active_flag
	issue_x11	parent, ref_num, open_date, active_flag
	issue_x12	template_name
	issue_x13	close_date
	issue_x14	resolve_date
	issue_x15	tenant
	issue_x2	log_agent, active_flag
	issue_x4	assignee, active_flag
	issue_x5	group_id, active_flag
	issue_x6	category, active_flag
	issue_x7	priority, active_flag
	issue_x8	persid, ref_num, open_date, active_flag
	issue_x9	status

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].[issue]
(
[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,
[start_date] [int] NULL,
[open_date] [int] NULL,
[last_mod_dt] [int] NULL,
[last_mod_by] [binary] (16) NULL,
[close_date] [int] NULL,
[resolve_date] [int] NULL,
[rootcause] [int] NULL,
[est_total_time] [int] NULL,
[actual_total_time] [int] NULL,
[log_agent] [binary] (16) NOT NULL,
[assignee] [binary] (16) NULL,
[organization] [binary] (16) NULL,
[group_id] [binary] (16) NULL,
[affected_contact] [binary] (16) NULL,
[requestor] [binary] (16) NOT NULL,
[category] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[priority] [int] NOT NULL,
[need_by] [int] NULL,
[est_comp_date] [int] NULL,
[actual_comp_date] [int] NULL,
[est_cost] [int] NULL,
[actual_cost] [int] NULL,
[justification] [nvarchar] (240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[backout_plan] [nvarchar] (240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[impact] [int] NULL,
[parent] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[effort] [nvarchar] (240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[support_lev] [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,
[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,
[service_date] [int] NULL,
[service_num] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[product] [int] NULL,
[actions] [nvarchar] (750) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[type_of_contact] [int] NULL,
[reporting_method] [int] NULL,
[person_contacting] [int] NULL,
[flag1] [int] NULL,
[flag2] [int] NULL,
[flag3] [int] NULL,
[flag4] [int] NULL,
[flag5] [int] NULL,
[flag6] [int] NULL,
[user1] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[user2] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[user3] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cawf_procid] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ticket_avoided] [int] NULL,
[tenant] [binary] (16) NULL,
[external_system_ticket] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS 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,
[requested_by] [binary] (16) 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
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[issue] ADD CONSTRAINT [XPKissue] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [issue_x10] ON [dbo].[issue] ([active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [issue_x4] ON [dbo].[issue] ([assignee], [active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [issue_x6] ON [dbo].[issue] ([category], [active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [issue_x13] ON [dbo].[issue] ([close_date]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [issue_x5] ON [dbo].[issue] ([group_id], [active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [issue_x2] ON [dbo].[issue] ([log_agent], [active_flag]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [issue_x0] ON [dbo].[issue] ([open_date], [ref_num]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [issue_x11] ON [dbo].[issue] ([parent], [ref_num], [open_date], [active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [issue_x8] ON [dbo].[issue] ([persid], [ref_num], [open_date], [active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [issue_x7] ON [dbo].[issue] ([priority], [active_flag]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [issue_x3] ON [dbo].[issue] ([ref_num]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [issue_x1] ON [dbo].[issue] ([requestor], [active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [issue_x14] ON [dbo].[issue] ([resolve_date]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [issue_x9] ON [dbo].[issue] ([status]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [issue_x12] ON [dbo].[issue] ([template_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [issue_x15] ON [dbo].[issue] ([tenant]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[issue] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[issue] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[issue] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[issue] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[issue] TO [service_desk_ro_group]
GRANT SELECT ON  [dbo].[issue] TO [swcmadmin]
GRANT INSERT ON  [dbo].[issue] TO [swcmadmin]
GRANT DELETE ON  [dbo].[issue] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[issue] TO [swcmadmin]
GRANT SELECT ON  [dbo].[issue] TO [uapmadmin]
GRANT INSERT ON  [dbo].[issue] TO [uapmadmin]
GRANT DELETE ON  [dbo].[issue] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[issue] TO [uapmadmin]
GRANT SELECT ON  [dbo].[issue] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[issue] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[issue] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[issue] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[issue] TO [uapmbatch]
GRANT INSERT ON  [dbo].[issue] TO [uapmbatch]
GRANT DELETE ON  [dbo].[issue] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[issue] TO [uapmbatch]
GRANT SELECT ON  [dbo].[issue] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[issue] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[issue] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[issue] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[issue] TO [uapmreporting]
GRANT SELECT ON  [dbo].[issue] TO [uapmreporting_group]
GO