dbo.GS_EEGeocodeTrackerResultUncertainPossibilities 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
GS_EEGeocodeTrackerResultUncertainPossibilities_ID	int	4
EmployeeID	varchar	15
GSTaxCodeID	varchar	25
GSTaxCodeDescriptionReadable	varchar	100
JurisdictionType	varchar	50
TheirTaxCodeID	varchar	25
TheirTaxCodeDescriptionReadable	varchar	100
Modified	datetime	4
GeocodeTrackerSuggestion_ID	int	4

Relationships

Relationship	Description
FK__GS_EEGeoc__Geoco__5310C8F5

Objects that depend on dbo.GS_EEGeocodeTrackerResultUncertainPossibilities

	Database Object	Object Type	Description	Dep Level
	dbo.GS_RefreshEEGeocodeTrackerResults	Stored Procedure		1

Objects that dbo.GS_EEGeocodeTrackerResultUncertainPossibilities depends on

	Database Object	Object Type	Description	Dep Level
	dbo.GS_EEGeocodeTrackerResults	Table		2
	dbo.GS_EEGeocodeTrackerResultSuggestions	Table		1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[GS_EEGeocodeTrackerResultUncertainPossibilities](
	[GS_EEGeocodeTrackerResultUncertainPossibilities_ID] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeID] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[GSTaxCodeID] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[GSTaxCodeDescriptionReadable] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[JurisdictionType] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[TheirTaxCodeID] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[TheirTaxCodeDescriptionReadable] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Modified] [datetime] NULL,
	[GeocodeTrackerSuggestion_ID] [int] NULL
) ON [PRIMARY]

ALTER TABLE [dbo].[GS_EEGeocodeTrackerResultUncertainPossibilities]  WITH CHECK ADD FOREIGN KEY([GeocodeTrackerSuggestion_ID])
REFERENCES [dbo].[GS_EEGeocodeTrackerResultSuggestions] ([GeocodeTrackerResultSuggestions_ID])

Related Objects

dbo Schema
SQL Objects Database