HumanResources.EmployeePayHistory (table)

wikibot

Table

HumanResources.EmployeePayHistory

Column	Data Type	Nullable	Default	PK	Index
EmployeeID	int	not null		PK_EmployeePayHistory_EmployeeID_RateChangeDate
RateChangeDate	datetime	not null		PK_EmployeePayHistory_EmployeeID_RateChangeDate
Rate	money	not null
PayFrequency	tinyint	not null
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
HumanResources.Employee	EmployeeID	EmployeeID

automatically generated

Table	HumanResources.EmployeePayHistory
Description	Employee pay history.

Column	Data Type	Nullable	Default	Description / PK / Index
EmployeeID	int	not null		Employee identification number. Foreign key to Employee.EmployeeID. PK_EmployeePayHistory_EmployeeID_RateChangeDate
RateChangeDate	datetime	not null		Date the change in pay is effective PK_EmployeePayHistory_EmployeeID_RateChangeDate
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.

Relation	Column	Referenced Column
HumanResources.Employee	EmployeeID	EmployeeID

Dependency Type	Object Type	Referenced Object
Schema	Schema	HumanResources

Reference Type	Object Type	Referencing Object
Insert	Procedure	HumanResources.uspUpdateEmployeeHireInfo