[dbo].[chg]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	747
Created	11:07:06 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 chg_x10: persid\chg_ref_num\open_date\active_flag$	persid	nvarchar(30)	60
$Indexes chg_x0: open_date\chg_ref_num$ $Indexes chg_x11: parent\chg_ref_num\open_date\active_flag$ $Indexes chg_x10: persid\chg_ref_num\open_date\active_flag$	chg_ref_num	nvarchar(30)	60
	summary	nvarchar(240)	480
	description	ntext	max
	status	nvarchar(12)	24
$Indexes chg_x4: assignee\active_flag$ $Indexes chg_x6: category\active_flag$ $Indexes chg_x5: group_id\active_flag$ $Indexes chg_x2: log_agent\active_flag$ $Indexes chg_x11: parent\chg_ref_num\open_date\active_flag$ $Indexes chg_x10: persid\chg_ref_num\open_date\active_flag$ $Indexes chg_x7: priority\active_flag$ $Indexes chg_x15: project\active_flag$ $Indexes chg_x1: requestor\active_flag$	active_flag	int	4
	start_date	int	4
$Indexes chg_x0: open_date\chg_ref_num$ $Indexes chg_x11: parent\chg_ref_num\open_date\active_flag$ $Indexes chg_x10: persid\chg_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 chg_x2: log_agent\active_flag$	log_agent	binary(16)	16
$Indexes chg_x4: assignee\active_flag$	assignee	binary(16)	16
	organization	binary(16)	16
$Indexes chg_x5: group_id\active_flag$	group_id	binary(16)	16
	affected_contact	binary(16)	16
$Indexes chg_x1: requestor\active_flag$	requestor	binary(16)	16
$Indexes chg_x6: category\active_flag$	category	nvarchar(12)	24
$Indexes chg_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	ntext	max
	backout_plan	ntext	max
	impact	int	4
$Indexes chg_x11: parent\chg_ref_num\open_date\active_flag$	parent	int	4
	effort	ntext	max
	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
$Indexes chg_x15: project\active_flag$	project	binary(16)	16
	zusmrequestid	int	4
	zusmrequestitemid	int	4
	zend_date	int	4
	zstart_date	int	4
	zTest	int	4
	tenant	binary(16)	16
	chgtype	int	4
	sched_start_date	int	4
	sched_end_date	int	4
	sched_duration	int	4
	actual_start_date	int	4
	actual_end_date	int	4
	business_case	ntext	max
	cab	binary(16)	16
	cab_approval	int	4
	closure_code	int	4
	risk	int	4
	zcl_proj_id	nvarchar(100)	200
	zcl_task_id	nvarchar(100)	200
	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
	XPKchg	id
	chg_x0	open_date, chg_ref_num
	chg_x3	chg_ref_num
	chg_x1	requestor, active_flag
	chg_x10	persid, chg_ref_num, open_date, active_flag
	chg_x11	parent, chg_ref_num, open_date, active_flag
	chg_x12	template_name
	chg_x13	close_date
	chg_x14	resolve_date
	chg_x15	project, active_flag
	chg_x16	tenant
	chg_x17	chgtype
	chg_x18	sched_start_date
	chg_x19	sched_end_date
	chg_x2	log_agent, active_flag
	chg_x4	assignee, active_flag
	chg_x5	group_id, active_flag
	chg_x6	category, active_flag
	chg_x7	priority, active_flag
	chg_x8	status
	chg_x9	active_flag

Type	Action	Owning Principal
Grant	Delete	service_desk_admin_group
Grant	Insert	service_desk_admin_group
Grant	Delete	uapmbatch
Grant	Insert	uapmbatch
Grant	Delete	swcmadmin
Grant	Insert	swcmadmin
Grant	Delete	uapmadmin_group
Grant	Insert	uapmadmin_group
Grant	Delete	uapmbatch_group
Grant	Insert	uapmbatch_group
Grant	Delete	uapmadmin
Grant	Insert	uapmadmin
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].[chg]
(
[id] [int] NOT NULL,
[persid] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[chg_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) NOT 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] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[backout_plan] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[impact] [int] NULL,
[parent] [int] NULL,
[effort] [ntext] 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,
[project] [binary] (16) NULL,
[zusmrequestid] [int] NULL,
[zusmrequestitemid] [int] NULL,
[zend_date] [int] NULL,
[zstart_date] [int] NULL,
[zTest] [int] NULL,
[tenant] [binary] (16) NULL,
[chgtype] [int] NULL,
[sched_start_date] [int] NULL,
[sched_end_date] [int] NULL,
[sched_duration] [int] NULL,
[actual_start_date] [int] NULL,
[actual_end_date] [int] NULL,
[business_case] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cab] [binary] (16) NULL,
[cab_approval] [int] NULL,
[closure_code] [int] NULL,
[risk] [int] NULL,
[zcl_proj_id] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[zcl_task_id] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS 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].[chg] ADD CONSTRAINT [XPKchg] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x9] ON [dbo].[chg] ([active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x4] ON [dbo].[chg] ([assignee], [active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x6] ON [dbo].[chg] ([category], [active_flag]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [chg_x3] ON [dbo].[chg] ([chg_ref_num]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x17] ON [dbo].[chg] ([chgtype]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x13] ON [dbo].[chg] ([close_date]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x5] ON [dbo].[chg] ([group_id], [active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x2] ON [dbo].[chg] ([log_agent], [active_flag]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [chg_x0] ON [dbo].[chg] ([open_date], [chg_ref_num]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x11] ON [dbo].[chg] ([parent], [chg_ref_num], [open_date], [active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x10] ON [dbo].[chg] ([persid], [chg_ref_num], [open_date], [active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x7] ON [dbo].[chg] ([priority], [active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x15] ON [dbo].[chg] ([project], [active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x1] ON [dbo].[chg] ([requestor], [active_flag]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x14] ON [dbo].[chg] ([resolve_date]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x19] ON [dbo].[chg] ([sched_end_date]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x18] ON [dbo].[chg] ([sched_start_date]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x8] ON [dbo].[chg] ([status]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x12] ON [dbo].[chg] ([template_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [chg_x16] ON [dbo].[chg] ([tenant]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[chg] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[chg] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[chg] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[chg] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[chg] TO [service_desk_ro_group]
GRANT SELECT ON  [dbo].[chg] TO [swcmadmin]
GRANT INSERT ON  [dbo].[chg] TO [swcmadmin]
GRANT DELETE ON  [dbo].[chg] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[chg] TO [swcmadmin]
GRANT SELECT ON  [dbo].[chg] TO [uapmadmin]
GRANT INSERT ON  [dbo].[chg] TO [uapmadmin]
GRANT DELETE ON  [dbo].[chg] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[chg] TO [uapmadmin]
GRANT SELECT ON  [dbo].[chg] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[chg] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[chg] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[chg] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[chg] TO [uapmbatch]
GRANT INSERT ON  [dbo].[chg] TO [uapmbatch]
GRANT DELETE ON  [dbo].[chg] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[chg] TO [uapmbatch]
GRANT SELECT ON  [dbo].[chg] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[chg] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[chg] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[chg] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[chg] TO [uapmreporting]
GRANT SELECT ON  [dbo].[chg] TO [uapmreporting_group]
GO