View: 'HumanResources.vEmployee', Employee names and addresses.

Field NameType and Size
EmployeeIDint NOT NULL
Titlenvarchar(8) NULL
FirstNameName NOT NULL
MiddleNameName NULL
LastNameName NOT NULL
Suffixnvarchar(10) NULL
JobTitlenvarchar(50) NOT NULL
PhonePhone NULL
EmailAddressnvarchar(50) NULL
EmailPromotionint NOT NULL
AddressLine1nvarchar(60) NOT NULL
AddressLine2nvarchar(60) NULL
Citynvarchar(30) NOT NULL
StateProvinceNameName NOT NULL
PostalCodenvarchar(15) NOT NULL
CountryRegionNameName NOT NULL
AdditionalContactInfoxml NULL