HumanResources.vJobCandidate
Field Name | Type and Size |
JobCandidateID | int identity NOT NULL |
EmployeeID | int NULL |
Name.Prefix | nvarchar(30) NULL |
Name.First | nvarchar(30) NULL |
Name.Middle | nvarchar(30) NULL |
Name.Last | nvarchar(30) NULL |
Name.Suffix | nvarchar(30) NULL |
Skills | nvarchar(max) NULL |
Addr.Type | nvarchar(30) NULL |
Addr.Loc.CountryRegion | nvarchar(100) NULL |
Addr.Loc.State | nvarchar(100) NULL |
Addr.Loc.City | nvarchar(100) NULL |
Addr.PostalCode | nvarchar(20) NULL |
EMail | nvarchar(max) NULL |
WebSite | nvarchar(max) NULL |
ModifiedDate | datetime NOT NULL |