HumanResources (schema)

Modified on 2011/08/27 11:16 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Schema'''
| HumanResources
|- valign="top"
| '''Description'''
| Contains objects related to employees and departments.
|}

=== Source ===
{{{{<nowiki>
CREATE SCHEMA HumanResources AUTHORIZATION dbo
</nowiki>}}}}

=== Dependencies ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Reference Type'''
| '''Object Type'''
| '''Referencing Object'''

|- valign="top"
| Schema
| Table
| [[HumanResources Department (table)|HumanResources.Department]]

|- valign="top"
| Schema
| Table
| [[HumanResources Employee (table)|HumanResources.Employee]]

|- valign="top"
| Schema
| Table
| [[HumanResources EmployeeAddress (table)|HumanResources.EmployeeAddress]]

|- valign="top"
| Schema
| Table
| [[HumanResources EmployeeDepartmentHistory (table)|HumanResources.EmployeeDepartmentHistory]]

|- valign="top"
| Schema
| Table
| [[HumanResources EmployeePayHistory (table)|HumanResources.EmployeePayHistory]]

|- valign="top"
| Schema
| Table
| [[HumanResources JobCandidate (table)|HumanResources.JobCandidate]]

|- valign="top"
| Schema
| Table
| [[HumanResources Shift (table)|HumanResources.Shift]]

|- valign="top"
| Schema
| View
| [[HumanResources vEmployee (view)|HumanResources.vEmployee]]

|- valign="top"
| Schema
| View
| [[HumanResources vEmployeeDepartment (view)|HumanResources.vEmployeeDepartment]]

|- valign="top"
| Schema
| View
| [[HumanResources vEmployeeDepartmentHistory (view)|HumanResources.vEmployeeDepartmentHistory]]

|- valign="top"
| Schema
| View
| [[HumanResources vJobCandidate (view)|HumanResources.vJobCandidate]]

|- valign="top"
| Schema
| View
| [[HumanResources vJobCandidateEducation (view)|HumanResources.vJobCandidateEducation]]

|- valign="top"
| Schema
| View
| [[HumanResources vJobCandidateEmployment (view)|HumanResources.vJobCandidateEmployment]]

|- valign="top"
| Schema
| Procedure
| [[HumanResources uspUpdateEmployeeHireInfo (procedure)|HumanResources.uspUpdateEmployeeHireInfo]]

|- valign="top"
| Schema
| Procedure
| [[HumanResources uspUpdateEmployeeLogin (procedure)|HumanResources.uspUpdateEmployeeLogin]]

|- valign="top"
| Schema
| Procedure
| [[HumanResources uspUpdateEmployeePersonalInfo (procedure)|HumanResources.uspUpdateEmployeePersonalInfo]]

|- valign="top"
| Schema
| XML Schema Collection
| [[HumanResources HRResumeSchemaCollection (xml schema collection)|HumanResources.HRResumeSchemaCollection]]

|}
devio dbscript ScrewTurn Wiki

Navigation¶

HumanResources (schema)
