[dbo].[si_wf

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

Property

Value

Row Count

553

Created

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

Last Modified

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

	Name	Data Type	Collation	Max Length (Bytes)
$Cluster Primary Key $si_wf_u000014ed00000000: wf_uuid\persid\data_source$ $Indexes IX_si_wf_prop_2: rec_category\rec_uuid\wf_uuid$ $Indexes IX_si_wf_prop_5: rec_category\task_type\violate_status\wf_uuid$ $Indexes IX_si_wf_prop_6: rec_category\task_type\wf_uuid$ $Indexes IX_si_wf_prop_3: rec_end_user_loc\rec_end_user_org\wf_uuid$ $Indexes baseidx_si_wf_prop: wf_uuid\data_source$	wf_uuid	binary(16)		16
$Indexes IX_si_wf_prop_5: rec_category\task_type\violate_status\wf_uuid$ $Indexes IX_si_wf_prop_6: rec_category\task_type\wf_uuid$	task_type	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
$Indexes IX_si_wf_prop_2: rec_category\rec_uuid\wf_uuid$	rec_uuid	binary(16)		16
$Indexes IX_si_wf_prop_2: rec_category\rec_uuid\wf_uuid$ $Indexes IX_si_wf_prop_5: rec_category\task_type\violate_status\wf_uuid$ $Indexes IX_si_wf_prop_6: rec_category\task_type\wf_uuid$	rec_category	nvarchar(256)	SQL_Latin1_General_CP1_CS_AS	512
	on_hold	int		4
	start_date	datetime		8
	completion_date	datetime		8
	time_open	int		4
	est_cost	money		8
	est_duration	int		4
	actual_cost	money		8
	actual_duration	int		4
$Indexes IX_si_wf_prop_3: rec_end_user_loc\rec_end_user_org\wf_uuid$	rec_end_user_loc	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
$Indexes IX_si_wf_prop_3: rec_end_user_loc\rec_end_user_org\wf_uuid$	rec_end_user_org	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	rec_assignee_loc	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	rec_assignee_org	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	assignee_org	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	assignee_loc	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	assignee_manager	nvarchar(100)	SQL_Latin1_General_CP1_CI_AS	200
	group_loc	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	group_org	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	done_by_loc	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	done_by_group	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
$Indexes IX_si_wf_prop_5: rec_category\task_type\violate_status\wf_uuid$	violate_status	int		4
	last_update_date	datetime		8
	last_update_by	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	assigned_flag	int		4
	rec_priority	nvarchar(20)	SQL_Latin1_General_CP1_CS_AS	40
	rec_ref_num	nvarchar(16)	SQL_Latin1_General_CP1_CS_AS	32
	rec_type	char(10)	SQL_Latin1_General_CP1_CS_AS	10
	time_to_violate	int		4
$Cluster Primary Key $si_wf_u000014ed00000000: wf_uuid\persid\data_source$ $Indexes baseidx_si_wf_prop: wf_uuid\data_source$	data_source	varchar(256)	SQL_Latin1_General_CP1_CS_AS	256
$Cluster Primary Key $si_wf_u000014ed00000000: wf_uuid\persid\data_source$	persid	nvarchar(64)	SQL_Latin1_General_CP1_CS_AS	128

Name

Data Type

Collation

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key $si_wf_u000014ed00000000: wf_uuid\persid\data_source$ $Indexes IX_si_wf_prop_2: rec_category\rec_uuid\wf_uuid$ $Indexes IX_si_wf_prop_5: rec_category\task_type\violate_status\wf_uuid$ $Indexes IX_si_wf_prop_6: rec_category\task_type\wf_uuid$ $Indexes IX_si_wf_prop_3: rec_end_user_loc\rec_end_user_org\wf_uuid$ $Indexes baseidx_si_wf_prop: wf_uuid\data_source$

wf_uuid

binary(16)

$Indexes IX_si_wf_prop_5: rec_category\task_type\violate_status\wf_uuid$ $Indexes IX_si_wf_prop_6: rec_category\task_type\wf_uuid$

task_type

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

$Indexes IX_si_wf_prop_2: rec_category\rec_uuid\wf_uuid$

rec_uuid

binary(16)

$Indexes IX_si_wf_prop_2: rec_category\rec_uuid\wf_uuid$ $Indexes IX_si_wf_prop_5: rec_category\task_type\violate_status\wf_uuid$ $Indexes IX_si_wf_prop_6: rec_category\task_type\wf_uuid$

rec_category

nvarchar(256)

SQL_Latin1_General_CP1_CS_AS

512

on_hold

int

start_date

datetime

completion_date

datetime

time_open

int

est_cost

money

est_duration

int

actual_cost

money

actual_duration

int

$Indexes IX_si_wf_prop_3: rec_end_user_loc\rec_end_user_org\wf_uuid$

rec_end_user_loc

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

$Indexes IX_si_wf_prop_3: rec_end_user_loc\rec_end_user_org\wf_uuid$

rec_end_user_org

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

rec_assignee_loc

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

rec_assignee_org

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

assignee_org

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

assignee_loc

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

assignee_manager

nvarchar(100)

SQL_Latin1_General_CP1_CI_AS

200

group_loc

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

group_org

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

done_by_loc

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

done_by_group

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

$Indexes IX_si_wf_prop_5: rec_category\task_type\violate_status\wf_uuid$

violate_status

int

last_update_date

datetime

last_update_by

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

assigned_flag

int

rec_priority

nvarchar(20)

SQL_Latin1_General_CP1_CS_AS

rec_ref_num

nvarchar(16)

SQL_Latin1_General_CP1_CS_AS

rec_type

char(10)

SQL_Latin1_General_CP1_CS_AS

time_to_violate

int

$Cluster Primary Key $si_wf_u000014ed00000000: wf_uuid\persid\data_source$ $Indexes baseidx_si_wf_prop: wf_uuid\data_source$

data_source

varchar(256)

SQL_Latin1_General_CP1_CS_AS

256

$Cluster Primary Key $si_wf_u000014ed00000000: wf_uuid\persid\data_source$

persid

nvarchar(64)

SQL_Latin1_General_CP1_CS_AS

128

Name

Columns

Unique

Fill Factor

$Cluster Primary Key $si_wf_u000014ed00000000: wf_uuid\persid\data_source$

$si_wf_u000014ed00000000

wf_uuid, persid, data_source

baseidx_si_wf_prop

wf_uuid, data_source

IX_si_wf_prop_1

rec_uuid

IX_si_wf_prop_2

rec_category, rec_uuid, wf_uuid

IX_si_wf_prop_3

rec_end_user_loc, rec_end_user_org, wf_uuid

IX_si_wf_prop_5

rec_category, task_type, violate_status, wf_uuid

IX_si_wf_prop_6

rec_category, task_type, wf_uuid

Type	Action	Owning Principal
Grant	Delete	aiadmin
Grant	Insert	aiadmin
Grant	Delete	siadmins
Grant	Insert	siadmins
Grant	Delete	aiuser
Grant	Insert	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

Delete

aiadmin

Grant

Insert

aiadmin

Grant

Delete

siadmins

Grant

Insert

siadmins

Grant

Delete

aiuser

Grant

Insert

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_wf_prop]
(
[wf_uuid] [binary] (16) NOT NULL,
[task_type] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rec_uuid] [binary] (16) NULL,
[rec_category] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[on_hold] [int] NULL,
[start_date] [datetime] NULL,
[completion_date] [datetime] NULL,
[time_open] [int] NULL,
[est_cost] [money] NULL,
[est_duration] [int] NULL,
[actual_cost] [money] NULL,
[actual_duration] [int] NULL,
[rec_end_user_loc] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rec_end_user_org] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rec_assignee_loc] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rec_assignee_org] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[assignee_org] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[assignee_loc] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[assignee_manager] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_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,
[done_by_loc] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[done_by_group] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[violate_status] [int] NULL,
[last_update_date] [datetime] NULL,
[last_update_by] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[assigned_flag] [int] NULL,
[rec_priority] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rec_ref_num] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rec_type] [char] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[time_to_violate] [int] NULL,
[data_source] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[persid] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[si_wf_prop] ADD CONSTRAINT [$si_wf_u000014ed00000000] PRIMARY KEY CLUSTERED ([wf_uuid], [persid], [data_source]) WITH (FILLFACTOR=90) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_wf_prop_2] ON [dbo].[si_wf_prop] ([rec_category], [rec_uuid], [wf_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_wf_prop_5] ON [dbo].[si_wf_prop] ([rec_category], [task_type], [violate_status], [wf_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_wf_prop_6] ON [dbo].[si_wf_prop] ([rec_category], [task_type], [wf_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_wf_prop_3] ON [dbo].[si_wf_prop] ([rec_end_user_loc], [rec_end_user_org], [wf_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_wf_prop_1] ON [dbo].[si_wf_prop] ([rec_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_si_wf_prop] ON [dbo].[si_wf_prop] ([wf_uuid], [data_source]) WITH (FILLFACTOR=90) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[si_wf_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_wf_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_wf_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_wf_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_wf_prop] TO [aipublic]
GRANT SELECT ON  [dbo].[si_wf_prop] TO [aiuser]
GRANT INSERT ON  [dbo].[si_wf_prop] TO [aiuser]
GRANT DELETE ON  [dbo].[si_wf_prop] TO [aiuser]
GRANT UPDATE ON  [dbo].[si_wf_prop] TO [aiuser]
GRANT SELECT ON  [dbo].[si_wf_prop] TO [siadmins]
GRANT INSERT ON  [dbo].[si_wf_prop] TO [siadmins]
GRANT DELETE ON  [dbo].[si_wf_prop] TO [siadmins]
GRANT UPDATE ON  [dbo].[si_wf_prop] TO [siadmins]
GO