[dbo].[usp_contact]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	349
Created	11:07:45 AM Wednesday, March 07, 2007
Last Modified	4:36:12 PM Wednesday, March 24, 2010

Name	Data Type	Max Length (Bytes)
contact_uuid	binary(16)	16
c_acctyp_id	int	4
c_email_service	nvarchar(30)	60
c_cm_id1	int	4
c_cm_id2	int	4
c_cm_id3	int	4
c_cm_id4	int	4
c_ws_id1	nvarchar(30)	60
c_ws_id2	nvarchar(30)	60
c_ws_id3	nvarchar(30)	60
c_ws_id4	nvarchar(30)	60
c_nx_string1	nvarchar(40)	80
c_nx_string2	nvarchar(40)	80
c_nx_string3	nvarchar(40)	80
c_nx_string4	nvarchar(40)	80
c_nx_string5	nvarchar(40)	80
c_nx_string6	nvarchar(40)	80
c_nx_ref_1	binary(16)	16
c_nx_ref_2	binary(16)	16
c_nx_ref_3	binary(16)	16
c_parent	binary(16)	16
c_vendor	binary(16)	16
c_domain	int	4
c_service_type	nvarchar(30)	60
c_timezone	nvarchar(30)	60
c_val_req	int	4
c_schedule	nvarchar(30)	60
c_available	int	4
global_queue_id	int	4
ldap_dn	nvarchar(512)	1024
integration_cnt	int	4
confirm_save	int	4
sap_personid	nvarchar(12)	24

	Name	Columns	Unique
	XPKusp_contact	contact_uuid
	usp_contact_x0	sap_personid

Type	Action	Owning Principal
Grant	Delete	service_desk_admin_group
Grant	Insert	service_desk_admin_group
Grant	Select	service_desk_admin_group
Grant	Update	service_desk_admin_group
Grant	Select	service_desk_ro_group

SQL Script

CREATE TABLE [dbo].[usp_contact]
(
[contact_uuid] [binary] (16) NOT NULL,
[c_acctyp_id] [int] NULL,
[c_email_service] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_cm_id1] [int] NULL,
[c_cm_id2] [int] NULL,
[c_cm_id3] [int] NULL,
[c_cm_id4] [int] NULL,
[c_ws_id1] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_ws_id2] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_ws_id3] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_ws_id4] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_nx_string1] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_nx_string2] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_nx_string3] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_nx_string4] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_nx_string5] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_nx_string6] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_nx_ref_1] [binary] (16) NULL,
[c_nx_ref_2] [binary] (16) NULL,
[c_nx_ref_3] [binary] (16) NULL,
[c_parent] [binary] (16) NULL,
[c_vendor] [binary] (16) NULL,
[c_domain] [int] NULL,
[c_service_type] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_timezone] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_val_req] [int] NULL,
[c_schedule] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_available] [int] NULL,
[global_queue_id] [int] NULL,
[ldap_dn] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[integration_cnt] [int] NULL,
[confirm_save] [int] NULL,
[sap_personid] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usp_contact] ADD CONSTRAINT [XPKusp_contact] PRIMARY KEY CLUSTERED ([contact_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usp_contact_x0] ON [dbo].[usp_contact] ([sap_personid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usp_contact] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[usp_contact] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[usp_contact] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[usp_contact] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[usp_contact] TO [service_desk_ro_group]
GO