Export (0) Print
Expand All
Expand Minimize

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:
© 2014 Microsoft