dbo.GO_EmployeeDependents View

Properties

Columns

Column Name	Description	Datatype	Length
EmployeeID	Stores the unique identifier of a specific employee	char	15
Parent_EmployeeID		char	15
SequenceNumber	unique sequence of numbers that ties Employee to dependent	int	4
Relationship	Dependent's relationship to Employee Accepted Values Child Guardian Other Parent Self Sibling Spouse	varchar	8
Comments	Comments	char	21
FirstName	Dependent's first name	char	15
MiddleInitial	Dependent's middle initial	char	1
LastName	Dependent's last name	char	21
SocialSecurityNumber	Dependent's Social Security Number	char	15
Gender	Dependent's gender	varchar	6
BirthDate	Dependent's birth date	datetime	4
HomePhone	Dependent's home phone number	char	21
WorkPhone	Dependent's work phone number	char	21
Extension	Dependent's extension number, if applicable	char	5
AddressOne	Dependent's address - line 1	char	61
AddressTwo	Dependent's address - line 2	char	61
City	Dependent's city	char	35
State	Dependent's state or province	char	29
ZipCode	Dependent's five- or nine-digit ZIP code	char	11
FullTimeStudent	1 or 0	bit	1
EmployeeDependentID		int	4
IsSmoker		int	4

Objects that depend on dbo.GO_EmployeeDependents

	Database Object	Object Type	Description	Dep Level
	dbo.GO_EmployeeFringeBenefitEnrolledDependents	View		1