Difference between revisions of "HumanResources.Employee (table)"

From dbscript Online Help
Jump to: navigation, search
Line 387: Line 387:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 
| '''Referenced Object
 
| '''Referenced Object
−
| '''Object Type
 
−
| '''Dependency Type
 
  
 
|-
 
|-
 +
| Data Type
 +
| Type
 
| [[dbo.Flag_(type)|dbo.Flag]]
 
| [[dbo.Flag_(type)|dbo.Flag]]
−
| Type
+
 
−
| Data Type
 
 
|-
 
|-
−
| [[.HumanResources_(schema)|.HumanResources]]
 
 
| Schema
 
| Schema
 
| Schema
 
| Schema
 +
| [[HumanResources_(schema)|.HumanResources]]
 +
 
|}
 
|}
  
Line 404: Line 406:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 
| '''Referencing Object
 
| '''Referencing Object
−
| '''Object Type
 
−
| '''Reference Type
 
  
 
|-
 
|-
 +
| Select
 +
| View
 
| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 
| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 +
 +
|-
 +
| Select
 
| View
 
| View
 +
| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
 +
 +
|-
 
| Select
 
| Select
 +
| View
 +
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 +
 
|-
 
|-
−
| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
+
| Select
 
| View
 
| View
 +
| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 +
 +
|-
 
| Select
 
| Select
−
|-
 
−
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 
 
| View
 
| View
−
| Select
+
| [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]]
 +
 
 
|-
 
|-
−
| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 
−
| View
 
 
| Select
 
| Select
 +
| Procedure
 +
| [[dbo.uspGetEmployeeManagers_(procedure)|dbo.uspGetEmployeeManagers]]
 +
 
|-
 
|-
−
| [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]]
 
−
| View
 
 
| Select
 
| Select
 +
| Procedure
 +
| [[dbo.uspGetManagerEmployees_(procedure)|dbo.uspGetManagerEmployees]]
 +
 
|-
 
|-
−
| [[dbo.uspGetEmployeeManagers_(procedure)|dbo.uspGetEmployeeManagers]]
+
| Update
 
| Procedure
 
| Procedure
−
| Select
+
| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]]
 +
 
 
|-
 
|-
−
| [[dbo.uspGetManagerEmployees_(procedure)|dbo.uspGetManagerEmployees]]
+
| Update
 
| Procedure
 
| Procedure
−
| Select
+
| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]]
 +
 
 
|-
 
|-
−
| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]]
 
−
| Procedure
 
 
| Update
 
| Update
−
|-
 
−
| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]]
 
 
| Procedure
 
| Procedure
−
| Update
 
−
|-
 
 
| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]]
 
| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]]
−
| Procedure
+
 
−
| Update
 
 
|-
 
|-
 +
| Select
 +
| SQL table-valued-function
 
| [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
 
| [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
−
| SQL table-valued-function
+
 
−
| Select
 
 
|}
 
|}

Revision as of 06:31, 30 November 2009

wikibot

Table HumanResources.Employee


Column Data Type Nullable Default PK Index
EmployeeID int not null PK_Employee_EmployeeID
NationalIDNumber nvarchar(15) not null AK_Employee_NationalIDNumber
ContactID int not null
LoginID nvarchar(256) not null AK_Employee_LoginID
ManagerID int null IX_Employee_ManagerID
Title nvarchar(50) not null
BirthDate datetime not null
MaritalStatus nchar(1) not null
Gender nchar(1) not null
HireDate datetime not null
SalariedFlag dbo.Flag not null ((1))
VacationHours smallint not null ((0))
SickLeaveHours smallint not null ((0))
CurrentFlag dbo.Flag not null ((1))
rowguid uniqueidentifier not null (newid()) AK_Employee_rowguid
ModifiedDate datetime not null (getdate())


Relation Column Referenced Column
Person.Contact ContactID ContactID
HumanResources.Employee ManagerID EmployeeID


Detail Table Column Referencing Column
HumanResources.Employee EmployeeID ManagerID
HumanResources.EmployeeAddress EmployeeID EmployeeID
HumanResources.EmployeeDepartmentHistory EmployeeID EmployeeID
HumanResources.EmployeePayHistory EmployeeID EmployeeID
HumanResources.JobCandidate EmployeeID EmployeeID
Purchasing.PurchaseOrderHeader EmployeeID EmployeeID
Sales.SalesPerson EmployeeID SalesPersonID


Triggers Type
dEmployee INSTEAD OF DELETE

automatically generated

Table HumanResources.Employee
Description Employee information such as salary, department, and title.


Column Data Type Nullable Default Description / PK / Index
EmployeeID int not null Primary key for Employee records.
PK_Employee_EmployeeID
NationalIDNumber nvarchar(15) not null Unique national identification number such as a social security number.
AK_Employee_NationalIDNumber
ContactID int not null Identifies the employee in the Contact table. Foreign key to Contact.ContactID.
LoginID nvarchar(256) not null Network login.
AK_Employee_LoginID
ManagerID int null Manager to whom the employee is assigned. Foreign Key to Employee.M
IX_Employee_ManagerID
Title nvarchar(50) not null Work title such as Buyer or Sales Representative.
BirthDate datetime not null Date of birth.
MaritalStatus nchar(1) not null M = Married, S = Single
Gender nchar(1) not null M = Male, F = Female
HireDate datetime not null Employee hired on this date.
SalariedFlag Flag not null (1) Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.
VacationHours smallint not null (0) Number of available vacation hours.
SickLeaveHours smallint not null (0) Number of available sick leave hours.
CurrentFlag Flag not null (1) 0 = Inactive, 1 = Active
rowguid uniqueidentifier not null (NEWID()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_Employee_rowguid
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Person.Contact ContactID ContactID
HumanResources.Employee ManagerID EmployeeID


Detail Table Column Referencing Column
HumanResources.Employee EmployeeID ManagerID
HumanResources.EmployeeAddress EmployeeID EmployeeID
HumanResources.EmployeeDepartmentHistory EmployeeID EmployeeID
HumanResources.EmployeePayHistory EmployeeID EmployeeID
HumanResources.JobCandidate EmployeeID EmployeeID
Purchasing.PurchaseOrderHeader EmployeeID EmployeeID
Sales.SalesPerson EmployeeID SalesPersonID


Triggers Type
dEmployee INSTEAD OF DELETE


Dependency Type Object Type Referenced Object
Data Type Type dbo.Flag
Schema Schema .HumanResources


Reference Type Object Type Referencing Object
Select View HumanResources.vEmployee
Select View HumanResources.vEmployeeDepartment
Select View HumanResources.vEmployeeDepartmentHistory
Select View Sales.vSalesPerson
Select View Sales.vSalesPersonSalesByFiscalYears
Select Procedure dbo.uspGetEmployeeManagers
Select Procedure dbo.uspGetManagerEmployees
Update Procedure HumanResources.uspUpdateEmployeeHireInfo
Update Procedure HumanResources.uspUpdateEmployeeLogin
Update Procedure HumanResources.uspUpdateEmployeePersonalInfo
Select SQL table-valued-function dbo.ufnGetContactInformation
Retrieved from "http://dbshelp.devio.at/index.php?title=HumanResources.Employee_(table)&oldid=1583"