[dbo].[kpi_exceptions]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	2:23:20 PM Friday, March 21, 2008
Last Modified	2:23:21 PM Friday, March 21, 2008

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

Created

2:23:20 PM Friday, March 21, 2008

Last Modified

2:23:21 PM Friday, March 21, 2008

	Name	Data Type	Max Length (Bytes)
	kpi_exception_id	binary(17)	17
$Indexes kpi_exceptions_idx1: kpi_id\datetime\exception_name_template$	kpi_id	int	4
$Indexes kpi_exceptions_idx1: kpi_id\datetime\exception_name_template$	datetime	datetime	8
$Indexes kpi_exceptions_idx1: kpi_id\datetime\exception_name_template$	exception_name_template	nvarchar(255)	510
	description_template	nvarchar(255)	510
	status_symbol	nvarchar(50)	100
	startdate	nvarchar(32)	64
	enddate	nvarchar(32)	64
	exception_name	nvarchar(255)	510
	description	nvarchar(255)	510

Name

Data Type

Max Length (Bytes)

Allow Nulls

kpi_exception_id

binary(17)

$Indexes kpi_exceptions_idx1: kpi_id\datetime\exception_name_template$

kpi_id

int

$Indexes kpi_exceptions_idx1: kpi_id\datetime\exception_name_template$

datetime

$Indexes kpi_exceptions_idx1: kpi_id\datetime\exception_name_template$

exception_name_template

nvarchar(255)

510

description_template

nvarchar(255)

510

status_symbol

nvarchar(50)

100

startdate

nvarchar(32)

enddate

nvarchar(32)

exception_name

nvarchar(255)

510

description

nvarchar(255)

510

Name	Columns
kpi_exceptions_idx1	kpi_id, datetime, exception_name_template
XPKkpi_exceptions	kpi_exception_id

Name

Columns

kpi_exceptions_idx1

kpi_id, datetime, exception_name_template

XPKkpi_exceptions

kpi_exception_id

Type	Action	Owning Principal
Grant	Delete	aionadmin_group
Grant	Insert	aionadmin_group
Grant	Select	aionadmin_group
Grant	Update	aionadmin_group

Type

Action

Owning Principal

Grant

Delete

aionadmin_group

Grant

Insert

aionadmin_group

Grant

Select

aionadmin_group

Grant

Update

aionadmin_group

SQL Script

CREATE TABLE [dbo].[kpi_exceptions]
(
[kpi_exception_id] [binary] (17) NULL,
[kpi_id] [int] NOT NULL,
[datetime] [datetime] NOT NULL,
[exception_name_template] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[description_template] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status_symbol] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[startdate] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[enddate] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[exception_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XPKkpi_exceptions] ON [dbo].[kpi_exceptions] ([kpi_exception_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [kpi_exceptions_idx1] ON [dbo].[kpi_exceptions] ([kpi_id], [datetime], [exception_name_template]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[kpi_exceptions] TO [aionadmin_group]
GRANT INSERT ON  [dbo].[kpi_exceptions] TO [aionadmin_group]
GRANT DELETE ON  [dbo].[kpi_exceptions] TO [aionadmin_group]
GRANT UPDATE ON  [dbo].[kpi_exceptions] TO [aionadmin_group]
GO