[dbo].[si_rec

Property	Value
Row Count	1439
Created	11:07:31 AM Wednesday, March 07, 2007
Last Modified	5:05:34 AM Tuesday, December 01, 2009

Property

Value

Row Count

1439

Created

11:07:31 AM Wednesday, March 07, 2007

Last Modified

5:05:34 AM Tuesday, December 01, 2009

	Name	Data Type	Collation	Max Length (Bytes)
$Cluster Primary Key $si_re_u000014e900000000: rec_uuid\persid\data_source$ $Indexes IX_si_rec_prop_1: active\state\category\rec_uuid\open_date\ref_num\time_to_violate$ $Indexes IX_si_rec_prop_3: assigned_org\rec_uuid\violate_status$ $Indexes IX_si_rec_prop_4: customer_loc\rec_uuid\violate_status$ $Indexes IX_si_rec_prop_5: customer_org\rec_uuid\violate_status$ $Indexes IX_si_rec_prop_7: group_name\rec_uuid$ $Indexes IX_si_rec_prop_2: open_date\close_date\rec_uuid$ $Indexes IX_si_rec_prop_8: time_to_violate\rec_uuid\si_sla_name$	rec_uuid	binary(16)		16
$Indexes IX_si_rec_prop_1: active\state\category\rec_uuid\open_date\ref_num\time_to_violate$	active	int		4
$Indexes IX_si_rec_prop_1: active\state\category\rec_uuid\open_date\ref_num\time_to_violate$	state	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	status	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	root_cause	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
$Indexes IX_si_rec_prop_1: active\state\category\rec_uuid\open_date\ref_num\time_to_violate$	category	nvarchar(256)	SQL_Latin1_General_CP1_CS_AS	512
$Indexes IX_si_rec_prop_4: customer_loc\rec_uuid\violate_status$	customer_loc	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
$Indexes IX_si_rec_prop_7: group_name\rec_uuid$	group_name	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	assignee	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
$Indexes IX_si_rec_prop_1: active\state\category\rec_uuid\open_date\ref_num\time_to_violate$	ref_num	nvarchar(16)	SQL_Latin1_General_CP1_CS_AS	32
$Indexes IX_si_rec_prop_1: active\state\category\rec_uuid\open_date\ref_num\time_to_violate$ $Indexes IX_si_rec_prop_8: time_to_violate\rec_uuid\si_sla_name$	time_to_violate	int		4
	summary	nvarchar(256)	SQL_Latin1_General_CP1_CI_AS	512
$Indexes IX_si_rec_prop_8: time_to_violate\rec_uuid\si_sla_name$	si_sla_name	nvarchar(20)	SQL_Latin1_General_CP1_CS_AS	40
$Indexes IX_si_rec_prop_1: active\state\category\rec_uuid\open_date\ref_num\time_to_violate$ $Indexes IX_si_rec_prop_2: open_date\close_date\rec_uuid$	open_date	datetime		8
$Indexes IX_si_rec_prop_2: open_date\close_date\rec_uuid$	close_date	datetime		8
	time_open	int		4
	reopen_flag	int		4
	est_cost	money		8
	act_cost	money		8
	est_duration	int		4
	act_duration	int		4
$Indexes IX_si_rec_prop_3: assigned_org\rec_uuid\violate_status$	assigned_org	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
$Indexes IX_si_rec_prop_5: customer_org\rec_uuid\violate_status$	customer_org	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	assignee_loc	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	assignee_org	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	group_loc	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	group_org	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	percent_done	int		4
	is_child	int		4
$Indexes IX_si_rec_prop_3: assigned_org\rec_uuid\violate_status$ $Indexes IX_si_rec_prop_4: customer_loc\rec_uuid\violate_status$ $Indexes IX_si_rec_prop_5: customer_org\rec_uuid\violate_status$	violate_status	int		4
	ci_hw_family	int		4
	ci_sw_family	int		4
	ci_svc_family	int		4
	ci_cmp_family	int		4
	ci_misc_family	int		4
	approved	int		4
	last_update_date	datetime		8
	last_update_by	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	priority	nvarchar(20)	SQL_Latin1_General_CP1_CI_AS	40
	type	char(10)	SQL_Latin1_General_CP1_CS_AS	10
	open_date_day	int		4
	open_date_month	int		4
	completion_date_day	int		4
	completion_date_month	int		4
	need_by	datetime		8
$Cluster Primary Key $si_re_u000014e900000000: rec_uuid\persid\data_source$	persid	nvarchar(64)	SQL_Latin1_General_CP1_CS_AS	128
$Cluster Primary Key $si_re_u000014e900000000: rec_uuid\persid\data_source$	data_source	varchar(256)	SQL_Latin1_General_CP1_CS_AS	256
	tot_dur_cost	money		8
	time_spent_cost	money		8

Name

Data Type

Collation

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key $si_re_u000014e900000000: rec_uuid\persid\data_source$ $Indexes IX_si_rec_prop_1: active\state\category\rec_uuid\open_date\ref_num\time_to_violate$ $Indexes IX_si_rec_prop_3: assigned_org\rec_uuid\violate_status$ $Indexes IX_si_rec_prop_4: customer_loc\rec_uuid\violate_status$ $Indexes IX_si_rec_prop_5: customer_org\rec_uuid\violate_status$ $Indexes IX_si_rec_prop_7: group_name\rec_uuid$ $Indexes IX_si_rec_prop_2: open_date\close_date\rec_uuid$ $Indexes IX_si_rec_prop_8: time_to_violate\rec_uuid\si_sla_name$

rec_uuid

binary(16)

$Indexes IX_si_rec_prop_1: active\state\category\rec_uuid\open_date\ref_num\time_to_violate$

active

int

$Indexes IX_si_rec_prop_1: active\state\category\rec_uuid\open_date\ref_num\time_to_violate$

state

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

status

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

root_cause

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

$Indexes IX_si_rec_prop_1: active\state\category\rec_uuid\open_date\ref_num\time_to_violate$

category

nvarchar(256)

SQL_Latin1_General_CP1_CS_AS

512

$Indexes IX_si_rec_prop_4: customer_loc\rec_uuid\violate_status$

customer_loc

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

$Indexes IX_si_rec_prop_7: group_name\rec_uuid$

group_name

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

assignee

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

$Indexes IX_si_rec_prop_1: active\state\category\rec_uuid\open_date\ref_num\time_to_violate$

ref_num

nvarchar(16)

SQL_Latin1_General_CP1_CS_AS

$Indexes IX_si_rec_prop_1: active\state\category\rec_uuid\open_date\ref_num\time_to_violate$ $Indexes IX_si_rec_prop_8: time_to_violate\rec_uuid\si_sla_name$

time_to_violate

int

summary

nvarchar(256)

SQL_Latin1_General_CP1_CI_AS

512

$Indexes IX_si_rec_prop_8: time_to_violate\rec_uuid\si_sla_name$

si_sla_name

nvarchar(20)

SQL_Latin1_General_CP1_CS_AS

$Indexes IX_si_rec_prop_1: active\state\category\rec_uuid\open_date\ref_num\time_to_violate$ $Indexes IX_si_rec_prop_2: open_date\close_date\rec_uuid$

open_date

datetime

$Indexes IX_si_rec_prop_2: open_date\close_date\rec_uuid$

close_date

datetime

time_open

int

reopen_flag

int

est_cost

money

act_cost

money

est_duration

int

act_duration

int

$Indexes IX_si_rec_prop_3: assigned_org\rec_uuid\violate_status$

assigned_org

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

$Indexes IX_si_rec_prop_5: customer_org\rec_uuid\violate_status$

customer_org

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

assignee_loc

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

assignee_org

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

group_loc

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

group_org

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

percent_done

int

is_child

int

$Indexes IX_si_rec_prop_3: assigned_org\rec_uuid\violate_status$ $Indexes IX_si_rec_prop_4: customer_loc\rec_uuid\violate_status$ $Indexes IX_si_rec_prop_5: customer_org\rec_uuid\violate_status$

violate_status

int

ci_hw_family

int

ci_sw_family

int

ci_svc_family

int

ci_cmp_family

int

ci_misc_family

int

approved

int

last_update_date

datetime

last_update_by

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

priority

nvarchar(20)

SQL_Latin1_General_CP1_CI_AS

type

char(10)

SQL_Latin1_General_CP1_CS_AS

open_date_day

int

open_date_month

int

completion_date_day

int

completion_date_month

int

need_by

datetime

$Cluster Primary Key $si_re_u000014e900000000: rec_uuid\persid\data_source$

persid

nvarchar(64)

SQL_Latin1_General_CP1_CS_AS

128

$Cluster Primary Key $si_re_u000014e900000000: rec_uuid\persid\data_source$

data_source

varchar(256)

SQL_Latin1_General_CP1_CS_AS

256

tot_dur_cost

money

time_spent_cost

money

	Name	Columns
$Cluster Primary Key $si_re_u000014e900000000: rec_uuid\persid\data_source$	$si_re_u000014e900000000	rec_uuid, persid, data_source
	baseidx_si_rec_prop	persid
	IX_si_rec_prop_1	active, state, category, rec_uuid, open_date, ref_num, time_to_violate
	IX_si_rec_prop_2	open_date, close_date, rec_uuid
	IX_si_rec_prop_3	assigned_org, rec_uuid, violate_status
	IX_si_rec_prop_4	customer_loc, rec_uuid, violate_status
	IX_si_rec_prop_5	customer_org, rec_uuid, violate_status
	IX_si_rec_prop_7	group_name, rec_uuid
	IX_si_rec_prop_8	time_to_violate, rec_uuid, si_sla_name

Name

Columns

Unique

$Cluster Primary Key $si_re_u000014e900000000: rec_uuid\persid\data_source$

$si_re_u000014e900000000

rec_uuid, persid, data_source

baseidx_si_rec_prop

persid

IX_si_rec_prop_1

active, state, category, rec_uuid, open_date, ref_num, time_to_violate

IX_si_rec_prop_2

open_date, close_date, rec_uuid

IX_si_rec_prop_3

assigned_org, rec_uuid, violate_status

IX_si_rec_prop_4

customer_loc, rec_uuid, violate_status

IX_si_rec_prop_5

customer_org, rec_uuid, violate_status

IX_si_rec_prop_7

group_name, rec_uuid

IX_si_rec_prop_8

time_to_violate, rec_uuid, si_sla_name

Type	Action	Owning Principal
Grant	Insert	aiuser
Grant	Delete	aiadmin
Grant	Insert	aiadmin
Grant	Delete	siadmins
Grant	Insert	siadmins
Grant	Delete	aiuser
Grant	Select	aiadmin
Grant	Update	aiadmin
Grant	Select	aipublic
Grant	Select	siadmins
Grant	Update	siadmins
Grant	Select	aiuser
Grant	Update	aiuser

Type

Action

Owning Principal

Grant

Insert

aiuser

Grant

Delete

aiadmin

Grant

Insert

aiadmin

Grant

Delete

siadmins

Grant

Insert

siadmins

Grant

Delete

aiuser

Grant

Select

aiadmin

Grant

Update

aiadmin

Grant

Select

aipublic

Grant

Select

siadmins

Grant

Update

siadmins

Grant

Select

aiuser

Grant

Update

aiuser

SQL Script

CREATE TABLE [dbo].[si_rec_prop]
(
[rec_uuid] [binary] (16) NOT NULL,
[active] [int] NULL,
[state] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[root_cause] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[category] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[customer_loc] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[group_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[assignee] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ref_num] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[time_to_violate] [int] NULL,
[summary] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[si_sla_name] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[open_date] [datetime] NULL,
[close_date] [datetime] NULL,
[time_open] [int] NULL,
[reopen_flag] [int] NULL,
[est_cost] [money] NULL,
[act_cost] [money] NULL,
[est_duration] [int] NULL,
[act_duration] [int] NULL,
[assigned_org] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[customer_org] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[assignee_loc] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[assignee_org] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[group_loc] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[group_org] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[percent_done] [int] NULL,
[is_child] [int] NULL,
[violate_status] [int] NULL,
[ci_hw_family] [int] NULL,
[ci_sw_family] [int] NULL,
[ci_svc_family] [int] NULL,
[ci_cmp_family] [int] NULL,
[ci_misc_family] [int] NULL,
[approved] [int] NULL,
[last_update_date] [datetime] NULL,
[last_update_by] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[priority] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[type] [char] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[open_date_day] [int] NULL,
[open_date_month] [int] NULL,
[completion_date_day] [int] NULL,
[completion_date_month] [int] NULL,
[need_by] [datetime] NULL,
[persid] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[data_source] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[tot_dur_cost] [money] NULL,
[time_spent_cost] [money] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[si_rec_prop] ADD CONSTRAINT [$si_re_u000014e900000000] PRIMARY KEY CLUSTERED ([rec_uuid], [persid], [data_source]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_si_rec_prop_1] ON [dbo].[si_rec_prop] ([active], [state], [category], [rec_uuid], [open_date], [ref_num], [time_to_violate]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_rec_prop_3] ON [dbo].[si_rec_prop] ([assigned_org], [rec_uuid], [violate_status]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_rec_prop_4] ON [dbo].[si_rec_prop] ([customer_loc], [rec_uuid], [violate_status]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_rec_prop_5] ON [dbo].[si_rec_prop] ([customer_org], [rec_uuid], [violate_status]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_rec_prop_7] ON [dbo].[si_rec_prop] ([group_name], [rec_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_rec_prop_2] ON [dbo].[si_rec_prop] ([open_date], [close_date], [rec_uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_si_rec_prop] ON [dbo].[si_rec_prop] ([persid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_rec_prop_8] ON [dbo].[si_rec_prop] ([time_to_violate], [rec_uuid], [si_sla_name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[si_rec_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_rec_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_rec_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_rec_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_rec_prop] TO [aipublic]
GRANT SELECT ON  [dbo].[si_rec_prop] TO [aiuser]
GRANT INSERT ON  [dbo].[si_rec_prop] TO [aiuser]
GRANT DELETE ON  [dbo].[si_rec_prop] TO [aiuser]
GRANT UPDATE ON  [dbo].[si_rec_prop] TO [aiuser]
GRANT SELECT ON  [dbo].[si_rec_prop] TO [siadmins]
GRANT INSERT ON  [dbo].[si_rec_prop] TO [siadmins]
GRANT DELETE ON  [dbo].[si_rec_prop] TO [siadmins]
GRANT UPDATE ON  [dbo].[si_rec_prop] TO [siadmins]
GO