Difference between revisions of "HumanResources (schema)"
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| − | |- | + | |- valign="top" |
| '''Schema | | '''Schema | ||
| HumanResources | | HumanResources | ||
| Line 8: | Line 8: | ||
| '''Description | | '''Description | ||
| Contains objects related to employees and departments. | | Contains objects related to employees and departments. | ||
| − | |||
|} | |} | ||
| − | |||
=== Source === | === Source === | ||
| Line 24: | Line 22: | ||
| '''Referencing Object | | '''Referencing Object | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| Table | | Table | ||
| [[HumanResources.Department_(table)|HumanResources.Department]] | | [[HumanResources.Department_(table)|HumanResources.Department]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| Table | | Table | ||
| [[HumanResources.Employee_(table)|HumanResources.Employee]] | | [[HumanResources.Employee_(table)|HumanResources.Employee]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| Table | | Table | ||
| [[HumanResources.EmployeeAddress_(table)|HumanResources.EmployeeAddress]] | | [[HumanResources.EmployeeAddress_(table)|HumanResources.EmployeeAddress]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| Table | | Table | ||
| [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]] | | [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| Table | | Table | ||
| [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]] | | [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| Table | | Table | ||
| [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]] | | [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| Table | | Table | ||
| [[HumanResources.Shift_(table)|HumanResources.Shift]] | | [[HumanResources.Shift_(table)|HumanResources.Shift]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| View | | View | ||
| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]] | | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| View | | View | ||
| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]] | | [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| View | | View | ||
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]] | | [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| View | | View | ||
| [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]] | | [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| View | | View | ||
| [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]] | | [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| View | | View | ||
| [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]] | | [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| Procedure | | Procedure | ||
| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]] | | [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| Procedure | | Procedure | ||
| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]] | | [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| Procedure | | Procedure | ||
| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]] | | [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| XML Schema Collection | | XML Schema Collection | ||
| − | | [[HumanResources.HRResumeSchemaCollection_( | + | | [[HumanResources.HRResumeSchemaCollection_(xml schema collection)|HumanResources.HRResumeSchemaCollection]] |
|} | |} | ||
Latest revision as of 23:15, 23 June 2010
wikibot[edit]
| Schema | HumanResources |
| Description | Contains objects related to employees and departments. |
Source[edit]
CREATE SCHEMA HumanResources AUTHORIZATION dbo
Dependencies[edit]
| Reference Type | Object Type | Referencing Object |
| Schema | Table | HumanResources.Department |
| Schema | Table | HumanResources.Employee |
| Schema | Table | HumanResources.EmployeeAddress |
| Schema | Table | HumanResources.EmployeeDepartmentHistory |
| Schema | Table | HumanResources.EmployeePayHistory |
| Schema | Table | HumanResources.JobCandidate |
| Schema | Table | HumanResources.Shift |
| Schema | View | HumanResources.vEmployee |
| Schema | View | HumanResources.vEmployeeDepartment |
| Schema | View | HumanResources.vEmployeeDepartmentHistory |
| Schema | View | HumanResources.vJobCandidate |
| Schema | View | HumanResources.vJobCandidateEducation |
| Schema | View | HumanResources.vJobCandidateEmployment |
| Schema | Procedure | HumanResources.uspUpdateEmployeeHireInfo |
| Schema | Procedure | HumanResources.uspUpdateEmployeeLogin |
| Schema | Procedure | HumanResources.uspUpdateEmployeePersonalInfo |
| Schema | XML Schema Collection | HumanResources.HRResumeSchemaCollection |
automatically generated[edit]
| schema | HumanResources |
| Description | Contains objects related to employees and departments. |
CREATE SCHEMA HumanResources AUTHORIZATION dbo
| Reference Type | Object Type | Referencing Object |
| Schema | Table | HumanResources.Department |
| Schema | Table | HumanResources.Employee |
| Schema | Table | HumanResources.EmployeeAddress |
| Schema | Table | HumanResources.EmployeeDepartmentHistory |
| Schema | Table | HumanResources.EmployeePayHistory |
| Schema | Table | HumanResources.JobCandidate |
| Schema | Table | HumanResources.Shift |
| Schema | View | HumanResources.vEmployee |
| Schema | View | HumanResources.vEmployeeDepartment |
| Schema | View | HumanResources.vEmployeeDepartmentHistory |
| Schema | View | HumanResources.vJobCandidate |
| Schema | View | HumanResources.vJobCandidateEducation |
| Schema | View | HumanResources.vJobCandidateEmployment |
| Schema | Procedure | HumanResources.uspUpdateEmployeeHireInfo |
| Schema | Procedure | HumanResources.uspUpdateEmployeeLogin |
| Schema | Procedure | HumanResources.uspUpdateEmployeePersonalInfo |
| Schema | XML Schema Collection | HumanResources.HRResumeSchemaCollection |
