HumanResources Schema
Tables
| Schema | Name | Row Count | Data Size | Index Size | Created | Modified |
|---|---|---|---|---|---|---|
| HumanResources | Department | 16 | 8 KB | 24 KB | 14.10.2005 1:58:32 | 24.5.2007 16:11:42 |
| HumanResources | Employee | 290 | 56 KB | 120 KB | 14.10.2005 1:58:32 | 14.10.2005 1:59:52 |
| HumanResources | EmployeeAddress | 290 | 16 KB | 32 KB | 14.10.2005 1:58:32 | 14.10.2005 1:59:52 |
| HumanResources | EmployeeDepartmentHistory | 296 | 16 KB | 48 KB | 14.10.2005 1:58:32 | 14.10.2005 1:59:52 |
| HumanResources | EmployeePayHistory | 316 | 16 KB | 16 KB | 14.10.2005 1:58:32 | 24.9.2008 16:41:46 |
| HumanResources | JobCandidate | 13 | 128 KB | 32 KB | 14.10.2005 1:58:33 | 14.10.2005 1:59:52 |
| HumanResources | Shift | 3 | 8 KB | 40 KB | 14.10.2005 1:58:36 | 14.10.2005 1:59:56 |
Views
| Schema | Name | Created |
|---|---|---|
| HumanResources | vEmployee | 14.10.2005 1:59:58 |
| HumanResources | vEmployeeDepartment | 14.10.2005 1:59:58 |
| HumanResources | vEmployeeDepartmentHistory | 14.10.2005 1:59:58 |
| HumanResources | vJobCandidate | 14.10.2005 1:59:59 |
| HumanResources | vJobCandidateEducation | 14.10.2005 1:59:59 |
| HumanResources | vJobCandidateEmployment | 14.10.2005 1:59:59 |
Procedures
| Schema | Name | Created | Modified | Assembly Name |
|---|---|---|---|---|
| HumanResources | uspUpdateEmployeeHireInfo | 14.10.2005 2:00:02 | 14.10.2005 2:00:02 | |
| HumanResources | uspUpdateEmployeeLogin | 14.10.2005 2:00:02 | 14.10.2005 2:00:02 | |
| HumanResources | uspUpdateEmployeePersonalInfo | 14.10.2005 2:00:02 | 14.10.2005 2:00:02 |