HumanResources EmployeePayHistory (table)

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