HumanResources EmployeePayHistory (table)

wikibot

TableHumanResources.EmployeePayHistory
DescriptionEmployee pay history.

Columns

ColumnData TypeNullableDefaultDescription
EmployeeIDintnot null Employee identification number. Foreign key to Employee.EmployeeID.
RateChangeDatedatetimenot null Date the change in pay is effective
Ratemoneynot null Salary hourly rate.
PayFrequencytinyintnot null 1 = Salary received monthly, 2 = Salary received biweekly
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_EmployeePayHistory_EmployeeID_RateChangeDateEmployeeID, RateChangeDate

Check Constraints

Check ConstraintExpressionDescription
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

RelationColumnReferenced Column
HumanResources.EmployeeEmployeeIDEmployeeID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaHumanResources

Dependencies

Reference TypeObject TypeReferencing Object
InsertProcedureHumanResources.uspUpdateEmployeeHireInfo