HumanResources.vJobCandidate View
In This Topic
Description
Job candidate names and resumes.
Properties
| Creation Date | 27/10/2017 14:33 |
| Is Schema Bound |  |
| Encrypted | |
| Ansi Nulls |  |
Columns
| | Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula |
|---|
| | JobCandidateID | | Integer | 4 | | | |
| | BusinessEntityID | | Integer | 4 |  | | |
| | Name.Prefix | | VarWChar | 30 | | | |
| | Name.First | | VarWChar | 30 | | | |
| | Name.Middle | | VarWChar | 30 | | | |
| | Name.Last | | VarWChar | 30 | | | |
| | Name.Suffix | | VarWChar | 30 | | | |
| | Skills | | LongVarWChar | 16 | | | |
| | Addr.Type | | VarWChar | 30 | | | |
| | Addr.Loc.CountryRegion | | VarWChar | 100 | | | |
| | Addr.Loc.State | | VarWChar | 100 | | | |
| | Addr.Loc.City | | VarWChar | 100 | | | |
| | Addr.PostalCode | | VarWChar | 20 | | | |
| | EMail | | LongVarWChar | 16 | | | |
| | WebSite | | LongVarWChar | 16 | | | |
| | ModifiedDate | | DBTimeStamp | 4 | | | |
Objects that HumanResources.vJobCandidate depends on
| | Database Object | Object Type | Description | Dep Level |
|---|
 | Person.BusinessEntity | Table | Source of the ID that connects vendors, customers, and employees with address and contact information. | 2 |
| HumanResources.Employee | Table | Employee information such as salary, department, and title. | 3 |
 | dbo.Flag | User Defined Data Type | | 4 |
| HumanResources.JobCandidate | Table | Résumés submitted to Human Resources by job applicants. | 2 |
| dbo.Name | User Defined Data Type | | 2 |
| dbo.NameStyle | User Defined Data Type | | 5 |
| Person.Person | Table | Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts. | 4 |
View Definition
CREATE VIEW [HumanResources].[vJobCandidate]
AS
SELECT
jc.[JobCandidateID]
,jc.[BusinessEntityID]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/Name/Name.Prefix)[1]', 'nvarchar(30)') AS [Name.Prefix]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/Name/Name.First)[1]', 'nvarchar(30)') AS [Name.First]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/Name/Name.Middle)[1]', 'nvarchar(30)') AS [Name.Middle]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/Name/Name.Last)[1]', 'nvarchar(30)') AS [Name.Last]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/Name/Name.Suffix)[1]', 'nvarchar(30)') AS [Name.Suffix]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/Skills)[1]', 'nvarchar(max)') AS [Skills]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(Address/Addr.Type)[1]', 'nvarchar(30)') AS [Addr.Type]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(Address/Addr.Location/Location/Loc.CountryRegion)[1]', 'nvarchar(100)') AS [Addr.Loc.CountryRegion]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(Address/Addr.Location/Location/Loc.State)[1]', 'nvarchar(100)') AS [Addr.Loc.State]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(Address/Addr.Location/Location/Loc.City)[1]', 'nvarchar(100)') AS [Addr.Loc.City]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(Address/Addr.PostalCode)[1]', 'nvarchar(20)') AS [Addr.PostalCode]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/EMail)[1]', 'nvarchar(max)') AS [EMail]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/WebSite)[1]', 'nvarchar(max)') AS [WebSite]
,jc.[ModifiedDate]
FROM [HumanResources].[JobCandidate] jc
CROSS APPLY jc.[Resume].nodes(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
/Resume') AS Resume(ref);
|
See Also