dbo.GO_EmployeePayRecordEarnings 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
EmployeeID	Stores the unique identifier of a specific employee	char	15
CheckDate	Stores the check date in datetime format	datetime	4
CheckNumber	Stores the check number	char	21
BatchCode	Batch code differentiates payroll batches	char	13
IsTimesheet		bit	1
Code		varchar	50
CodeDescription		varchar	150
ShiftCode		varchar	50
ShiftPremium		numeric	9 (19,5)
StartDate		datetime	4
EndDate		datetime	4
UnitsToPay		numeric	9 (19,5)
UnitsYTD		int	4
PayRate	Employee’s per unit Pay Rate	numeric	9 (19,5)
TipType	1 - for direct tips (money left on table) 2 - for indirect tips (money included on receipts)	int	4
EarnedAmount	Earning Amount	numeric	9 (19,5)
StateCode	The two-digit state abbreviation corresponding to the state where the pay was earned	char	3
SutaCode	The two-digit state abbreviation corresponding to the state where state unemployment is to be paid	char	3
StateJurisdiction	Greenshades Jurisdiction code corresponding to the StateCode. This is typically “US-“ plus the state abbreviation; e.g. US-FL	varchar	6
SutaStateJurisdiction	Greenshades Jurisdiction code corresponding to the SutaCode. This is typically “US-“ plus the state abbreviation; e,g. US-FL	varchar	6
LocalTaxCode	Local Tax Code corresponding to the local tax assessed on the earning; must correspond to local type tax in the EmployeeTaxRecords file	varchar	50
WorkersCompCode	Workers Compensation code	char	7
DaysWorked		int	4
WeeksWorked		int	4
UserDefined1		varchar	1
UserDefined2		varchar	1
MiscDate		datetime	4
SubjectToFIT	1 if subject to FIT; 0 otherwise	bit	1
SubjectToEmployeeFICA	1 if subject to FICA; 0 otherwise	bit	1
SubjectToEmployerFICA	1 if subject to employer FICA; 0 otherwise	bit	1
SubjectToEmployeeMedicare	1 if subject to Employee Medicare; 0 otherwise	bit	1
SubjectToEmployerMedicare	1 if subject to Employer Medicare; 0 otherwise	bit	1
SubjectToFederalUnemployment	1 if subject to Federal Unemployment; 0 otherwise	bit	1
SubjectToStateWithholding	1 if subject to State Withholding; 0 otherwise	bit	1
SubjectToStateSDI	1 if subject to State SDI; 0 otherwise	bit	1
SubjectToStateUnemployment	1 if subject to State Unemployment; 0 otherwise	bit	1
SubjectToLocalWithholding	1 if subject to Local Withholding; 0 otherwise	bit	1
SubjectToLocalLDI	1 if subject to local LDI; 0 otherwise	bit	1
SubjectToLocalUnemployment	1 if subject to local unemployment; 0 otherwise	bit	1
SubjectToLocalOther	1 if subject to Local Other; 0 otherwise	bit	1
SubjectToEmployeeSUI	1 if subject to employee SUI; 0 otherwise	bit	1
SubjectToWorkersComp	1 if subject to Workers Comp; 0 otherwise	bit	1
RowID		int	4
Parent_PayRecordRowID		int	4

Related Objects

dbo Schema
SQL Objects Database