dbo.GS_EEGeocodeTrackerResults Table

Properties

Creation Date	9/25/2015 3:11 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	0
Data Space Used	0.00 KB
Index Space Used	0.00 KB

Columns

Column Name	Datatype	Length
GeocodeTrackerResults_ID	int	4
EmployeeID	varchar	15
DexID	int	4
HomeCity	varchar	35
HomeState	varchar	29
WorkCity	varchar	35
WorkState	varchar	29
WorkLocationWithExplicitJuris	varchar	100
Modified	datetime	4

Indexes

Index	Description	Primary	Unique
PK__GS_EEGeo__0A076853BD4ED75F
UQ__GS_EEGeo__7AD04FF0CED73E17

Relationships

Relationship	Description
FK__GS_EEGeoc__Geoco__4F403811
FK__GS_EEGeoc__Geoco__51288083

Objects that depend on dbo.GS_EEGeocodeTrackerResults

Database Object	Object Type	Dep Level
dbo.GS_EEGeocodeTrackerResultJurisdictions	Table	1
dbo.GS_EEGeocodeTrackerResultSuggestions	Table	1
dbo.GS_EEGeocodeTrackerResultUncertainPossibilities	Table	2
dbo.GS_RefreshEEGeocodeTrackerResults	Stored Procedure	1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[GS_EEGeocodeTrackerResults](
	[GeocodeTrackerResults_ID] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeID] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[DexID] [int] NOT NULL,
	[HomeCity] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[HomeState] [varchar](29) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[WorkCity] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[WorkState] [varchar](29) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[WorkLocationWithExplicitJuris] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Modified] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[GeocodeTrackerResults_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
UNIQUE NONCLUSTERED 
(
	[EmployeeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Related Objects

dbo Schema
SQL Objects Database