dbo.GO_CompanyPayCodes View

GreenshadesOnline Integration Help

dbo.GO_CompanyPayCodes View

Collapse All

SQL Objects Database > dbo Schema : dbo.GO_CompanyPayCodes View

Description

This Table is required for Paystub only integration.

Properties

Creation Date	7/17/2015 10:23 AM
Is Schema Bound
Encrypted
Ansi Nulls

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	PayCodeID	Unique identifier for this pay code	varchar	50
	Description	Description for pay code	varchar	100
	Type	Type of pay code Accepted Values: Hourly Salary Piecework Commission Business Expense Overtime Double Time Vacation Sick Holiday Pension Other Earned Income Credit Charged Tips Reported Tips Minimum Wage Balance	varchar	20
	BasePayCodeID		varchar	50
	IsTaxable	Indicates if this earnings code is subject to taxes	bit	1
	IsSubjectToFederalTax	Indicates if this earnings code is subject to federal tax	bit	1
	IsSubjectToSocialSecurityTax	Indicates if this earnings code is subject to social security tax	bit	1
	IsSubjectToMedicareTax	Indicates if this earnings code is subject to medicare tax	bit	1
	IsSubjectToStateTax	Indicates if this earnings code is subject to state tax	bit	1
	IsSubjectToLocalTax	Indicates if this earnings code is subject to local tax	bit	1
	IsSubjectToFUTA	Indicates if this earnings code is subject to federal unemployment tax	bit	1
	IsSubjectToSUTA	Indicates if this earnings code is subject to state unemployement tax	bit	1
	FlatFederalTaxRate	Federal tax rate for this earnings code	decimal	9 (25,13)
	FlatStateTaxRate	State tax rate for this earnings code	decimal	9 (25,13)
	Active	Indicates whether the code is active	bit	1

See Also

Related Objects

dbo Schema
SQL Objects Database

© 2015 All Rights Reserved.

Send comments on this topic.