Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
EmployeePayHistory Table (AdventureWorks)
Collapse the table of content
Expand the table of content

EmployeePayHistory Table (AdventureWorks)

Contains current and historical salary information for employees.

The EmployeePayHistory table is contained in the HumanResources schema.

Column Data type Nullability 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

Hourly rate of pay.

PayFrequency

tinyint

Not null

1 = Salary received monthly

2 = Salary received biweekly

ModifiedDate

datetime

Not null

Date and time the row was last updated.

Community Additions

ADD
Show:
© 2015 Microsoft