View: vJobCandidate

Properties

Property	Value
Name	vJobCandidate
ID	1883153754
Schema	HumanResources
Owner	dbo
Encrypted
Schema Bound
With Check Option
ANSI NULLS
Uses Quoted Identifier
Has Opaque Metadata
Published
Schema Published
Replicated
Has Replication Filter
Has Unchecked Assembly Data
Date Correlation View
Uses Database Collation
Tracked by CDC
MS Shipped
Modify Date	8/8/2010 5:23:45 PM
Create Date	8/8/2010 5:23:45 PM

Extended Properties

View Columns

Column Name	Datatype	Nullable	Is Identity
JobCandidateID	int
BusinessEntityID	int
Name.Prefix	nvarchar(30)
Name.First	nvarchar(30)
Name.Middle	nvarchar(30)
Name.Last	nvarchar(30)
Name.Suffix	nvarchar(30)
Skills	nvarchar(max)
Addr.Type	nvarchar(30)
Addr.Loc.CountryRegion	nvarchar(100)
Addr.Loc.State	nvarchar(100)
Addr.Loc.City	nvarchar(100)
Addr.PostalCode	nvarchar(20)
EMail	nvarchar(max)
WebSite	nvarchar(max)
ModifiedDate	datetime

Indexes

Object Level Permissions

Permissions for: KrystianRole

Permission	Grantor	Grant	With Grant Option	Deny
Alter	dbo
Control
Delete
Execute
Insert
Receive
References
Select	dbo
Take Ownership
Update
View Change Tracking
View Definition

Column Level Permissions

Objects that depend on [vJobCandidate]

• HumanResources.vJobCandidate

Objects on which [vJobCandidate] depends

• HumanResources.vJobCandidate
  • HumanResources.JobCandidate
    • HumanResources.Employee
      • dbo.Flag
      • Person.Person
        • dbo.Name
        • dbo.NameStyle
        • Demographics.exist
        • Person.AdditionalContactInfoSchemaCollection
        • Person.BusinessEntity
        • Person.IndividualSurveySchemaCollection
    • HumanResources.HRResumeSchemaCollection

SQL

See also