dbo.GS_TrackerTaxRatesResults 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
TrackerTaxRatesResultsID	int	4
GSLocalTaxCodeID	char	7
GPLocalTaxCodeID	char	7
ReadableLocalTaxName	varchar	100
Description	varchar	800
State	varchar	5
Differences	varchar	800
FirstCalculationStep	varchar	100
SecondCalculationStep	varchar	100
ThirdCalculationStep	varchar	100
FourthCalculationStep	varchar	100
FifthCalculationStep	varchar	100
ExemptionAmount	int	4
MinimumTaxableWages	decimal	9 (18,5)
YTDTaxableWageLimit	decimal	9 (18,5)
LocalTaxRate	int	4
LocalTaxAmount	decimal	9 (18,5)
MaximumPerYear	decimal	9 (18,5)
StandardDeductionMethod	int	4
StandardDeductionPercent	int	4
StandardDeductionAmount	decimal	9 (18,5)
StandardDeductionMaximum	decimal	9 (18,5)
StandardDeductionMinimum	decimal	9 (18,5)
TaxType	varchar	35
PerfectMatch	bit	1

Indexes

Index	Description	Primary	Unique
PK__GS_Track__20B3CEE0DD12966B

Relationships

Relationship	Description
FK__GS_Tracke__Track__634730BE

Objects that depend on dbo.GS_TrackerTaxRatesResults

	Database Object	Object Type	Description	Dep Level
	dbo.GS_TrackerTaxRateResultsTaxTable	Table		1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[GS_TrackerTaxRatesResults](
	[TrackerTaxRatesResultsID] [int] IDENTITY(1,1) NOT NULL,
	[GSLocalTaxCodeID] [char](7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[GPLocalTaxCodeID] [char](7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[ReadableLocalTaxName] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Description] [varchar](800) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[State] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Differences] [varchar](800) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[FirstCalculationStep] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[SecondCalculationStep] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[ThirdCalculationStep] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[FourthCalculationStep] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[FifthCalculationStep] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[ExemptionAmount] [int] NOT NULL,
	[MinimumTaxableWages] [decimal](18, 5) NOT NULL,
	[YTDTaxableWageLimit] [decimal](18, 5) NOT NULL,
	[LocalTaxRate] [int] NOT NULL,
	[LocalTaxAmount] [decimal](18, 5) NOT NULL,
	[MaximumPerYear] [decimal](18, 5) NOT NULL,
	[StandardDeductionMethod] [int] NOT NULL,
	[StandardDeductionPercent] [int] NOT NULL,
	[StandardDeductionAmount] [decimal](18, 5) NOT NULL,
	[StandardDeductionMaximum] [decimal](18, 5) NOT NULL,
	[StandardDeductionMinimum] [decimal](18, 5) NOT NULL,
	[TaxType] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[PerfectMatch] [bit] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[TrackerTaxRatesResultsID] 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