HumanResources.JobCandidate (table) - Revision history

Bot at 22:15, 23 June 2010

2010-06-23T22:15:58Z

Bot at 22:00, 23 June 2010

2010-06-23T22:00:09Z

Bot at 22:07, 2 February 2010

2010-02-02T22:07:15Z

Bot at 21:54, 28 December 2009

2009-12-28T21:54:40Z

Bot at 05:59, 30 November 2009

2009-11-30T05:59:25Z

Bot at 05:34, 30 November 2009

2009-11-30T05:34:47Z

Bot at 05:33, 30 November 2009

2009-11-30T05:33:38Z

Bot at 05:32, 30 November 2009

2009-11-30T05:32:05Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:27Z

Bot at 23:12, 26 November 2009

2009-11-26T23:12:54Z

@@ Line 91: / Line 91: @@
 | Schema
 | Schema
-| [[HumanResources_(_(schema))|HumanResources]]
+| [[HumanResources_(schema)|HumanResources]]
 |- valign="top"
 | Data Type
 | XML Schema Collection
-| [[HumanResources.HRResumeSchemaCollection_(_(xml_schema_collection))|HumanResources.HRResumeSchemaCollection]]
+| [[HumanResources.HRResumeSchemaCollection_(xml schema collection)|HumanResources.HRResumeSchemaCollection]]
 |}
@@ Line 110: / Line 110: @@
 | Select
 | View
-| [[HumanResources.vJobCandidate_(_(view))|HumanResources.vJobCandidate]]
+| [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]]
 |- valign="top"
 | Select
 | View
-| [[HumanResources.vJobCandidateEducation_(_(view))|HumanResources.vJobCandidateEducation]]
+| [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]]
 |- valign="top"
 | Select
 | View
-| [[HumanResources.vJobCandidateEmployment_(_(view))|HumanResources.vJobCandidateEmployment]]
+| [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]]
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | HumanResources.JobCandidate
@@ Line 8: / Line 8: @@
 | '''Description
 | Résumés submitted to Human Resources by job applicants.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | JobCandidateID
@@ Line 52: / Line 50: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_JobCandidate_JobCandidateID
 | JobCandidateID
@@ Line 63: / Line 61: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | IX_JobCandidate_EmployeeID
+|
@@ Line 76: / Line 74: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[HumanResources.Employee_(table)|HumanResources.Employee]]
 | EmployeeID
@@ Line 90: / Line 88: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema
-| [[HumanResources_(schema)|HumanResources]]
+| [[HumanResources_(_(schema))|HumanResources]]
-|-
+|- valign="top"
 | Data Type
 | XML Schema Collection
-| [[HumanResources.HRResumeSchemaCollection_(xml_schema_collection)|HumanResources.HRResumeSchemaCollection]]
+| [[HumanResources.HRResumeSchemaCollection_(_(xml_schema_collection))|HumanResources.HRResumeSchemaCollection]]
 |}
@@ Line 109: / Line 107: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | View
-| [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]]
+| [[HumanResources.vJobCandidate_(_(view))|HumanResources.vJobCandidate]]
-|-
+|- valign="top"
 | Select
 | View
-| [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]]
+| [[HumanResources.vJobCandidateEducation_(_(view))|HumanResources.vJobCandidateEducation]]
-|-
+|- valign="top"
 | Select
 | View
-| [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]]
+| [[HumanResources.vJobCandidateEmployment_(_(view))|HumanResources.vJobCandidateEmployment]]
 |}

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key for JobCandidate records.<br />PK_JobCandidate_JobCandidateID
+| Primary key for JobCandidate records.
 |- valign="top"
 | EmployeeID
@@ Line 31: / Line 32: @@
 | null
+|
-| Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.<br />IX_JobCandidate_EmployeeID
+| Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.
 |- valign="top"
 | Resume
@@ Line 37: / Line 38: @@
 | null
+|
-| Résumé in XML format.<br />
+| Résumé in XML format.
 |- valign="top"
 | ModifiedDate
@@ Line 43: / Line 44: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 60: / Line 83: @@
 |}
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 66: / Line 89: @@
 | '''Object Type
 | '''Referenced Object
 |-
@@ Line 74: / Line 102: @@
 |}
+=== Dependencies ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 97: / Line 125: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | HumanResources.JobCandidate
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | JobCandidateID
 | int
 | not null
+|
-| PK_JobCandidate_JobCandidateID
+| Primary key for JobCandidate records.<br />PK_JobCandidate_JobCandidateID
+|- valign="top"
 | EmployeeID
 | int
 | null
+|
+| Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.<br />IX_JobCandidate_EmployeeID
-| IX_JobCandidate_EmployeeID
+|- valign="top"
 | Resume
 | xml
 | null
+|
+| Résumé in XML format.<br />
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 61: / Line 59: @@
 | EmployeeID
 |}
 == automatically generated ==

@@ Line 68: / Line 68: @@
 | HumanResources.JobCandidate
 |- valign="top"
 | '''Description
 | Résumés submitted to Human Resources by job applicants.
 |-
 |}