Difference between revisions of "HumanResources (schema)"
| 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_(xml_schema_collection)|HumanResources.HRResumeSchemaCollection]] | + | | [[HumanResources.HRResumeSchemaCollection_(_(xml_schema_collection))|HumanResources.HRResumeSchemaCollection]] |
|} | |} | ||
Revision as of 22:59, 23 June 2010
wikibot
| Schema | HumanResources |
| Description | Contains objects related to employees and departments. |
Source
CREATE SCHEMA HumanResources AUTHORIZATION dbo
Dependencies
| 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
| 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 |
