HumanResources.EmployeePayHistorytable

From dbscript Online Help
Jump to: navigation, search

wikibot

Table HumanResources.EmployeePayHistory
Description Employee pay history.

Columns

Column Data Type Nullable Default Description
EmployeeID int not null Employee identification number. Foreign key to Employee.EmployeeID.
RateChangeDate datetime not null Date the change in pay is effective
Rate money not null Salary hourly rate.
PayFrequency tinyint not null 1 = Salary received monthly, 2 = Salary received biweekly
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key

Primary Key Columns
PK_EmployeePayHistory_EmployeeID_RateChangeDate EmployeeID, RateChangeDate

Check Constraints

Check Constraint Expression Description
CK_EmployeePayHistory_PayFrequency ([PayFrequency]=(2) OR [PayFrequency]=(1)) Check constraint [PayFrequency]=(3) OR [PayFrequency]=(2) OR [PayFrequency]=(1)
CK_EmployeePayHistory_Rate ([Rate]>=(6.50) AND [Rate]<=(200.00)) Check constraint [Rate] >= (6.50) AND [Rate] <= (200.00)

Foreign Keys

Relation Column Referenced Column
HumanResources.Employee EmployeeID EmployeeID

References

Dependency Type Object Type Referenced Object
Schema Schema HumanResources

Dependencies

Reference Type Object Type Referencing Object
Insert Procedure HumanResources.uspUpdateEmployeeHireInfo