dbo.GO_EmployeeI9s View

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
FormExpirationDate		datetime	4
FirstName	Employee’s first name	varchar	15
MiddleInitial	Employee’s middle initial	varchar	1
LastName	Employee’s last name	varchar	21
MaidenName	Employee’s maiden name, if applicable	char	21
Address	Employee's physical address	char	61
Apt	Employee's apartment number, if applicable	varchar	1
DateOfBirth	Employee's date of birth	datetime	4
City	Employee's city of residence	char	35
State	Employee's state of residence	varchar	2
ZipCode	Employee's ZIP code	char	11
SocialSecurityNumber	Employee's Social Security Number	varchar	15
CitizenshipStatus	Employee's citizenship status	varchar	10
AlienNumber		char	21
AlienExpirationDate		datetime	4
Signature	Employee's signature for the I-9	varchar	37
SignatureDate	The date the I-9 was signed	datetime	4
PreparerSignature	The signature of the person who prepared the Employee's I-9	char	61
PreparerName	The name of the preparere	char	61
PreparerAddress		char	255
PreparerDate		datetime	4
CreateDateUTC		datetime	4
ReviewListADocument		char	31
ReviewListAIssuingAuthority		char	31
ReviewListADocumentNumber		char	31
ReviewListAExpirationDate		datetime	4
ReviewListADocumentNumber2		char	31
ReviewListAExpirationDate2		datetime	4
ReviewListBDocument		char	31
ReviewListBIssuingAuthority		char	31
ReviewListBDocumentNumber		char	31
ReviewListBExpirationDate		datetime	4
ReviewListCDocument		char	31
ReviewListCIssuingAuthority		char	31
ReviewListCDocumentNumber		char	31
ReviewListCExpirationDate		datetime	4
ReviewSignatureDate		datetime	4
Active	Indicates if this I-9 is active	bit	1
Parent_EmployeeID		char	15

Objects that dbo.GO_EmployeeI9s 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