Difference between revisions of "HumanResources (schema)"
| Line 25: | Line 25: | ||
| Schema | | Schema | ||
| Table | | Table | ||
| − | | [[HumanResources.Department_ | + | | [[HumanResources.Department_(table)|HumanResources.Department]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| Table | | Table | ||
| − | | [[HumanResources.Employee_ | + | | [[HumanResources.Employee_(table)|HumanResources.Employee]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| Table | | Table | ||
| − | | [[HumanResources.EmployeeAddress_ | + | | [[HumanResources.EmployeeAddress_(table)|HumanResources.EmployeeAddress]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| Table | | Table | ||
| − | | [[HumanResources.EmployeeDepartmentHistory_ | + | | [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| Table | | Table | ||
| − | | [[HumanResources.EmployeePayHistory_ | + | | [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| Table | | Table | ||
| − | | [[HumanResources.JobCandidate_ | + | | [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| Table | | Table | ||
| − | | [[HumanResources.Shift_ | + | | [[HumanResources.Shift_(table)|HumanResources.Shift]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| View | | View | ||
| − | | [[HumanResources.vEmployee_ | + | | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| View | | View | ||
| − | | [[HumanResources.vEmployeeDepartment_ | + | | [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| View | | View | ||
| − | | [[HumanResources.vEmployeeDepartmentHistory_ | + | | [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| View | | View | ||
| − | | [[HumanResources.vJobCandidate_ | + | | [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| View | | View | ||
| − | | [[HumanResources.vJobCandidateEducation_ | + | | [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| View | | View | ||
| − | | [[HumanResources.vJobCandidateEmployment_ | + | | [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| Procedure | | Procedure | ||
| − | | [[HumanResources.uspUpdateEmployeeHireInfo_ | + | | [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| Procedure | | Procedure | ||
| − | | [[HumanResources.uspUpdateEmployeeLogin_ | + | | [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]] |
|- valign="top" | |- valign="top" | ||
| Schema | | Schema | ||
| Procedure | | Procedure | ||
| − | | [[HumanResources.uspUpdateEmployeePersonalInfo_ | + | | [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]] |
|- valign="top" | |- 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 |
