HumanResources.EmployeePayHistory

Table: 'HumanResources.EmployeePayHistory'

5 fields. 58 bytes.

Employee pay history.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
EmployeeIDint   Not nullEmployee identification number. Foreign key to Employee.EmployeeID. 
RateChangeDatedatetime   Not nullDate the change in pay is effective 
Ratemoney19,4decimal(19,4) Not nullSalary hourly rate.([Rate]>=(6.50) AND [Rate]<=(200.00))
PayFrequencytinyint   Not null1 = Salary received monthly, 2 = Salary received biweekly([PayFrequency]=(2) OR [PayFrequency]=(1))
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'HumanResources.EmployeePayHistory'

Primary Key NameField Names
PK_EmployeePayHistory_EmployeeID_RateChangeDateEmployeeID, RateChangeDate

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

ForeignPrimaryKey Name
EmployeePayHistory.EmployeeIDEmployee.EmployeeIDFK_EmployeePayHistory_Employee_EmployeeID

Indexes for table 'HumanResources.EmployeePayHistory', 1 item

Index NameDescriptionClusteredUniqueFields
PK_EmployeePayHistory_EmployeeID_RateChangeDateClustered index created by a primary key constraint.YesYesEmployeeID, RateChangeDate

Triggers for table 'HumanResources.EmployeePayHistory', 1 item

NameDescriptionTypeEnabled
uEmployeePayHistoryAFTER 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 NameTypeField Name
HumanResources.CK_EmployeePayHistory_PayFrequencycheck cnsN/A
HumanResources.CK_EmployeePayHistory_Ratecheck cnsN/A
HumanResources.uEmployeePayHistorytriggerN/A
HumanResources.uspUpdateEmployeeHireInfostored procedureN/A