dbo.GO_EmployeePayRecords 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
BatchCode	Batch code differentiates payroll batches	char	13
SequenceNumber	Shows the order checks were processed within a batch	int	4
EmployeeID	Stores the unique identifier of a specific employee	char	15
EmployeeNativeID		char	15
EmployeeSSN	Stores employee SSN	char	15
EmployeeName	Stores employee name	char	41
EmployeeDepartment		varchar	50
CheckNumber	Stores the check number	char	21
CheckDate	Stores the check date in datetime format	datetime	4
GrossWages	Stores the gross wages on the check	numeric	9 (19,5)
DeclaredTips	Stores the declared tips on the check, if applicable	numeric	9 (20,5)
NetWages	Stores the net wages on the check	numeric	9 (19,5)
VacationHoursAccrued	Stores the vacation hours accrued on the check	numeric	9 (19,5)
SickHoursAccrued	Stores the sick hours accrued on the check	decimal	9 (20,8)
RecordType	Stores the pay record type. Options are “DirectDeposit” and “Check”	varchar	13
IsVoided	1 if the check is voided; 0 otherwise	bit	1
EmployeeAddress1	Stores the employee's address	char	61
EmployeeAddress2	Stores the second line of the employee's address	char	61
EmployeeCity	Stores the employee's city	char	35
EmployeeState	Stores the employee's state	varchar	2
EmployeePostal	Stores the employee's ZIP code	char	11
EmployeeCountry	Stores the employee's country	char	61
FederalExemptions	Number of federal exemptions	int	4
FederalAdditionalWithholding	Amount of additional federal withholding	numeric	9 (19,5)
FederalFilingStatus	Federal filing status. (SINGLE - single, MAR- married, HOH - Head of Household)	char	7
VacationTimeAmountAccrued		decimal	9 (19,5)
VacationTimeAvailable		decimal	9 (19,5)
SickTimeAmountAccrued		decimal	9 (19,5)
SickTimeAvailable		decimal	9 (19,5)
EmpUserDefined1		char	21
EmpUserDefined2		char	21
PayRecordRowID		int	4
Parent_EmployeeID		char	15

Objects that depend on dbo.GO_EmployeePayRecords

	Database Object	Object Type	Description	Dep Level
	dbo.GO_EmployeePayRecordTaxes	View	This Table is required for Paystub only integration.	1
	dbo.GO_EmployeePayRecordTimeOffBalances	View	This Table is required for Paystub only integration.	1

Objects that dbo.GO_EmployeePayRecords depends on

	Database Object	Object Type	Description	Dep Level
	dbo.GO_EmployeeAddresses	View	This Table is required for Paystub only integration.	1

Related Objects

dbo Schema
SQL Objects Database