dbo.GO_EmployeeAddresses View

Description

This Table is required for Paystub only integration.

Properties

Columns

Column Name	Description	Datatype	Length
EmployeeID	Stores the unique identifier of a specific employee	char	15
EmployeeAddressID	Unique ID for the employee address; if more than one address for an employee, this ID distinguishes between multiple addresses This column relates to PrimaryAddressCode Column in GO_Employees	varchar	50
AddressOne	Physical location - address line 1	char	61
AddressTwo	Physical location - address line 2	char	61
AddressThree	Physical location - address line 3	char	61
City	Physical location - city	char	35
State	Physical location - two-letter state abbreviation	varchar	2
ZipCode	Physical location - five- or nine-digit ZIP code	char	11
County	Physical location - county	char	61
Country	Country name from IRS options	char	61
PhoneOne	Primary Phone Number	char	21
PhoneTwo	Secondary Phone Number	char	21
PhoneThree	Tertiary Phone Number	char	21
Fax	Fax Number	char	21
ForeignAddress	Indicate whether it is a foreign address or not	tinyint	1
ForeignState	State when address is non-U.S. (e.g. a Canadian province)	char	23
ForeignPostalCode	Postal code when address is non-U.S. (e.g. a Canadian postal code)	char	15
CountryCode	Country name from IRS options	char	7
Email	Employees Email Address	varchar	201
EmployeeAddressRowID		int	4
Parent_EmployeeID		char	15

Objects that depend on dbo.GO_EmployeeAddresses

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