HumanResources.EmployeePayHistory - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	HumanResources
Name	EmployeePayHistory
Module	Human Resources

Employee pay history.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		BusinessEntityID	int			HumanResources.Employee	Employee identification number. Foreign key to Employee.BusinessEntityID.
Employee identification number. Foreign key to Employee.BusinessEntityID. References: HumanResources.Employee
	2		RateChangeDate	datetime				Date the change in pay is effective
Date the change in pay is effective
	3		Rate	money				Salary hourly rate.
Salary hourly rate.
	4		PayFrequency	tinyint				1 = Salary received monthly, 2 = Salary received biweekly
1 = Salary received monthly, 2 = Salary received biweekly
	5		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
HumanResources.EmployeePayHistory		HumanResources.Employee	HumanResources.EmployeePayHistory.BusinessEntityID = HumanResources.Employee.BusinessEntityID	FK_EmployeePayHistory_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.
HumanResources.EmployeePayHistory.BusinessEntityID = HumanResources.Employee.BusinessEntityID Name: FK_EmployeePayHistory_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.

Unique keys

	Key name	Columns	Description
	PK_EmployeePayHistory_BusinessEntityID_RateChangeDate	BusinessEntityID, RateChangeDate	Primary key (clustered) constraint
Primary key (clustered) constraint

Uses

Name
HumanResources.EmployeePayHistory
HumanResources.Employee

Used by

Name
HumanResources.EmployeePayHistory
HumanResources.uspUpdateEmployeeHireInfo

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56