HumanResources.EmployeePayHistory

Table: 'HumanResources.EmployeePayHistory'

Field Name Data Type Size Original Type Default Nullable Description Check

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 19,4 decimal(19,4) Not null Salary hourly rate. ([Rate]>=(6.50) AND [Rate]<=(200.00))

PayFrequency tinyint Not null 1 = Salary received monthly, 2 = Salary received biweekly ([PayFrequency]=(2) OR [PayFrequency]=(1))

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
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	19,4	decimal(19,4)		Not null	Salary hourly rate.	([Rate]>=(6.50) AND [Rate]<=(200.00))
PayFrequency	tinyint				Not null	1 = Salary received monthly, 2 = Salary received biweekly	([PayFrequency]=(2) OR [PayFrequency]=(1))
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'HumanResources.EmployeePayHistory'

Primary Key Name Field Names

PK_EmployeePayHistory_EmployeeID_RateChangeDate EmployeeID, RateChangeDate

Primary Key Name	Field Names
PK_EmployeePayHistory_EmployeeID_RateChangeDate	EmployeeID, RateChangeDate

Foreign keys for table 'HumanResources.EmployeePayHistory', 1 item

Foreign Primary Key Name

EmployeePayHistory.EmployeeID Employee.EmployeeID FK_EmployeePayHistory_Employee_EmployeeID

Foreign	Primary	Key Name
EmployeePayHistory.EmployeeID	Employee.EmployeeID	FK_EmployeePayHistory_Employee_EmployeeID

Indexes for table 'HumanResources.EmployeePayHistory', 1 item

Index Name Description Clustered Unique Fields

PK_EmployeePayHistory_EmployeeID_RateChangeDate Clustered index created by a primary key constraint. Yes Yes EmployeeID, RateChangeDate

Index Name	Description	Clustered	Unique	Fields
PK_EmployeePayHistory_EmployeeID_RateChangeDate	Clustered index created by a primary key constraint.	Yes	Yes	EmployeeID, RateChangeDate

Triggers for table 'HumanResources.EmployeePayHistory', 1 item

Name Description Type Enabled

uEmployeePayHistory AFTER UPDATE trigger setting the ModifiedDate column in the EmployeePayHistory table to the current date. after Update Yes

Name	Description	Type	Enabled
uEmployeePayHistory	AFTER UPDATE trigger setting the ModifiedDate column in the EmployeePayHistory table to the current date.	after Update	Yes

Dependencies for table 'HumanResources.EmployeePayHistory', 4 items

Object Name Type Field Name

HumanResources.CK_EmployeePayHistory_PayFrequency check cns N/A

HumanResources.CK_EmployeePayHistory_Rate check cns N/A

HumanResources.uEmployeePayHistory trigger N/A

HumanResources.uspUpdateEmployeeHireInfo stored procedure N/A