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

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