Welcome Guest, you are in: • Login

devio dbscript ScrewTurn Wiki

Navigation¶

Main Page

Create Account

Search the wiki
»

PoweredBy

Discuss (0) View Page Code History

HumanResources EmployeePayHistory (table)

Print

RSS

Modified on 2011/08/27 11:17 by wikibot Categorized as Uncategorized

» 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

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.