Databases > AdventureWorks2019 > Tables > HumanResources.EmployeePayHistory

AdventureWorks2019

HumanResources.EmployeePayHistory

//
Employee pay history.

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    BusinessEntityID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    RateChangeDate
    [datetime] NOT NULL
  • //
    ${escapify(column.description)}
    Rate
    [money] NOT NULL
    //
    CONSTRAINT: Check constraint [Rate] >= (6.50) AND [Rate] <= (200.00)
    ([Rate]>=(6.50) AND [Rate]<=(200.00))
  • //
    ${escapify(column.description)}
    PayFrequency
    [tinyint] NOT NULL
    //
    CONSTRAINT: Check constraint [PayFrequency]=(3) OR [PayFrequency]=(2) OR [PayFrequency]=(1)
    ([PayFrequency]=(2) OR [PayFrequency]=(1))
  • //
    ${escapify(column.description)}
    ModifiedDate
    [datetime] NOT NULL DEFAULT (getdate())

Indexes

  • //
    Clustered index created by a primary key constraint.
    PK_EmployeePayHistory_BusinessEntityID_RateChangeDate
    UNIQUE CLUSTERED
    BusinessEntityID , RateChangeDate

Foreign Keys

  • //
    Foreign key constraint referencing Employee.EmployeeID.
    FK_EmployeePayHistory_Employee_BusinessEntityID
    HumanResources.Employee
    BusinessEntityID ⥱ BusinessEntityID

Sample Data

BusinessEntityID
RateChangeDate
Rate
PayFrequency
ModifiedDate
1
125.5
2
2
63.4615
2
3
43.2692
2
4
8.62
2
4
23.72
2
4
29.8462
2
5
32.6923
2
6
32.6923
2
7
50.4808
2
8
40.8654
2
9
40.8654
2
10
42.4808
2
11
28.8462
2
12
25
2
13
25
2
14
36.0577
2
15
32.6923
2
16
24
2
16
28.75
2
16
37.5
2
17
13.4615
2
18
14.4231
2
19
13.4615
2
20
13.4615
2
21
14.4231
2