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

From dbscript Online Help
Jump to: navigation, search
Line 129: Line 129:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[Person.Contact_(table)|Person.Contact]]
 +
| ContactID
 +
| ContactID
 +
|-
 +
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
 +
| ManagerID
 +
| EmployeeID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|-
 +
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
 +
| EmployeeID
 +
| ManagerID
 +
|-
 +
| [[HumanResources.EmployeeAddress_(table)|HumanResources.EmployeeAddress]]
 +
| EmployeeID
 +
| EmployeeID
 +
|-
 +
| [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]]
 +
| EmployeeID
 +
| EmployeeID
 +
|-
 +
| [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]]
 +
| EmployeeID
 +
| EmployeeID
 +
|-
 +
| [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]]
 +
| EmployeeID
 +
| EmployeeID
 +
|-
 +
| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
 +
| EmployeeID
 +
| EmployeeID
 +
|-
 +
| [[Sales.SalesPerson_(table)|Sales.SalesPerson]]
 +
| EmployeeID
 +
| SalesPersonID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Triggers
 +
| '''Type
 +
 +
|-
 +
| dEmployee
 +
| INSTEAD OF DELETE
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| HumanResources.Employee
 +
|-
 +
 +
| '''Description
 +
| Employee information such as salary, department, and title.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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.
 
|  
 
|  
 
|}
 
|}

Revision as of 23:26, 26 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
Retrieved from "http://dbshelp.devio.at/index.php?title=HumanResources.Employee_(table)&oldid=1091"