# Table: EmployeePayHistory

## Properties

Property | Value
--- | ---
Name | EmployeePayHistory
ID | 1237579447
Owner | dbo
Schema | HumanResources
Filegroup | PRIMARY
Data Size (KB) | 16 KB
Index Size (KB) | 16 KB
Rows | 316
Unused (KB) | 0 KB
ANSI Null On |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space |
Filestream Data Space ID |
Has Unchecked Assembly Data |
Text In Row Limit (bytes) | Option not set
Large Value Types Out Of Row |
FullText Change Tracking On |
Tracked By Cdc |
Published |
Schema Published |
Replicated |
Replication Filter |
Merge Published |
Sync Tran Subscribed |
MS Shipped |
Modify Date | 8/8/2010 5:23:39 PM
Create Date | 8/8/2010 5:21:51 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Employee pay history.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | BusinessEntityID | int |  |  |
2 | RateChangeDate | datetime |  |  |
3 | Rate | money |  |  |
4 | PayFrequency | tinyint |  |  |
5 | ModifiedDate | datetime |  |  |

## Identity Columns

No identity columns defined.

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK_EmployeePayHistory_BusinessEntityID_RateChangeDate |  | MS_Description | Primary key (clustered) constraint

## Primary Key Columns

Name
BusinessEntityID
RateChangeDate

## Foreign Keys

Name | Referenced Object | Update Action | Delete Action
--- | --- | --- | ---
FK_EmployeePayHistory_Employee_BusinessEntityID | HumanResources.Employee | No action | No action

## Column Level Check Constraints

Name | Column ID | Column | Definition | Is Disabled | Is Not For Replication | Is Not Trusted | Uses Database Collation | Is System Named
--- | --- | --- | --- | --- | --- | --- | --- | ---
CK_EmployeePayHistory_PayFrequency | 4 | PayFrequency | ([PayFrequency]=(2) OR [PayFrequency]=(1)) |  |  |  |  |
CK_EmployeePayHistory_Rate | 3 | Rate | ([Rate]>=(6.50) AND [Rate]<=(200.00)) |  |  |  |  |

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_EmployeePayHistory_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_EmployeePayHistory_BusinessEntityID_RateChangeDate | CLUSTERED |  |  |  |  |

## FullText Indexes

No fulltext indexes defined.

## Referencing Tables

No referencing tables defined.

## Object Level Permissions

#### Permissions for: weekly_receipts

Permission | Grantor | Grant | With Grant Option | Deny
--- | --- | --- | --- | ---
Alter |  |  |  |
Control | dbo |  |  |
Delete |  |  |  |
Insert |  |  |  |
References |  |  |  |
Select |  |  |  |
Take Ownership |  |  |  |
Update |  |  |  |
View Change Tracking |  |  |  |
View Definition |  |  |  |

## Column Level Permissions

No explicit column permissions granted to this object

## Statistics

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK_EmployeePayHistory_BusinessEntityID_RateChangeDate | Aug 8 2010 5:22PM | 316 | 316 | 153 | 0.9716312 | 12 |  |  | 316

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.003448276 | 4 | BusinessEntityID
0.003164557 | 12 | BusinessEntityID, RateChangeDate

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 1 | 0 | 1
3 | 1 | 1 | 1 | 1
4 | 0 | 3 | 0 | 1
6 | 1 | 1 | 1 | 1
8 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1
12 | 1 | 1 | 1 | 1
14 | 1 | 1 | 1 | 1
15 | 0 | 1 | 0 | 1
16 | 0 | 3 | 0 | 1
18 | 1 | 1 | 1 | 1
20 | 1 | 1 | 1 | 1
22 | 1 | 1 | 1 | 1
24 | 1 | 1 | 1 | 1
26 | 1 | 1 | 1 | 1
28 | 1 | 1 | 1 | 1
30 | 1 | 1 | 1 | 1
32 | 1 | 1 | 1 | 1
34 | 1 | 1 | 1 | 1
36 | 1 | 1 | 1 | 1
38 | 1 | 1 | 1 | 1
40 | 1 | 1 | 1 | 1
42 | 1 | 1 | 1 | 1
44 | 1 | 1 | 1 | 1
46 | 1 | 1 | 1 | 1
48 | 1 | 1 | 1 | 1
50 | 1 | 1 | 1 | 1
52 | 1 | 1 | 1 | 1
54 | 1 | 1 | 1 | 1
56 | 1 | 1 | 1 | 1
58 | 1 | 1 | 1 | 1
60 | 1 | 1 | 1 | 1
62 | 1 | 1 | 1 | 1
64 | 1 | 1 | 1 | 1
66 | 1 | 1 | 1 | 1
68 | 1 | 1 | 1 | 1
70 | 1 | 1 | 1 | 1
72 | 1 | 1 | 1 | 1
74 | 1 | 1 | 1 | 1
76 | 1 | 1 | 1 | 1
78 | 1 | 1 | 1 | 1
80 | 1 | 1 | 1 | 1
82 | 1 | 1 | 1 | 1
84 | 1 | 1 | 1 | 1
86 | 1 | 1 | 1 | 1
88 | 1 | 1 | 1 | 1
90 | 1 | 1 | 1 | 1
92 | 1 | 1 | 1 | 1
94 | 1 | 1 | 1 | 1
96 | 1 | 1 | 1 | 1
98 | 1 | 1 | 1 | 1
100 | 1 | 1 | 1 | 1
102 | 1 | 1 | 1 | 1
104 | 1 | 1 | 1 | 1
106 | 1 | 1 | 1 | 1
108 | 1 | 1 | 1 | 1
110 | 1 | 1 | 1 | 1
112 | 1 | 1 | 1 | 1
114 | 1 | 1 | 1 | 1
116 | 1 | 1 | 1 | 1
118 | 1 | 1 | 1 | 1
120 | 1 | 1 | 1 | 1
122 | 1 | 1 | 1 | 1
124 | 1 | 1 | 1 | 1
126 | 1 | 1 | 1 | 1
128 | 1 | 1 | 1 | 1
130 | 1 | 1 | 1 | 1
132 | 1 | 1 | 1 | 1
134 | 1 | 1 | 1 | 1
136 | 1 | 1 | 1 | 1
138 | 1 | 1 | 1 | 1
140 | 1 | 1 | 1 | 1
142 | 1 | 1 | 1 | 1
144 | 1 | 1 | 1 | 1
146 | 1 | 1 | 1 | 1
148 | 1 | 1 | 1 | 1
150 | 1 | 1 | 1 | 1
152 | 1 | 1 | 1 | 1
154 | 1 | 1 | 1 | 1
156 | 1 | 1 | 1 | 1
158 | 1 | 1 | 1 | 1
160 | 1 | 1 | 1 | 1
162 | 1 | 1 | 1 | 1
164 | 1 | 1 | 1 | 1
166 | 1 | 1 | 1 | 1
167 | 0 | 3 | 0 | 1
169 | 1 | 1 | 1 | 1
170 | 0 | 3 | 0 | 1
171 | 0 | 1 | 0 | 1
172 | 0 | 3 | 0 | 1
173 | 0 | 1 | 0 | 1
175 | 3 | 3 | 1 | 3
177 | 3 | 3 | 1 | 3
178 | 0 | 3 | 0 | 1
180 | 1 | 1 | 1 | 1
182 | 1 | 1 | 1 | 1
184 | 1 | 1 | 1 | 1
186 | 1 | 1 | 1 | 1
188 | 1 | 1 | 1 | 1
190 | 1 | 1 | 1 | 1
192 | 1 | 1 | 1 | 1
194 | 1 | 1 | 1 | 1
196 | 1 | 1 | 1 | 1
198 | 1 | 1 | 1 | 1
200 | 1 | 1 | 1 | 1
202 | 1 | 1 | 1 | 1
204 | 1 | 1 | 1 | 1
206 | 1 | 1 | 1 | 1
208 | 1 | 1 | 1 | 1
210 | 1 | 1 | 1 | 1
212 | 1 | 1 | 1 | 1
214 | 1 | 1 | 1 | 1
216 | 1 | 1 | 1 | 1
218 | 1 | 1 | 1 | 1
220 | 1 | 1 | 1 | 1
222 | 1 | 1 | 1 | 1
223 | 0 | 1 | 0 | 1
224 | 0 | 3 | 0 | 1
226 | 1 | 1 | 1 | 1
228 | 1 | 1 | 1 | 1
230 | 1 | 1 | 1 | 1
232 | 1 | 1 | 1 | 1
233 | 0 | 1 | 0 | 1
234 | 0 | 3 | 0 | 1
236 | 1 | 1 | 1 | 1
238 | 1 | 1 | 1 | 1
240 | 1 | 1 | 1 | 1
242 | 1 | 1 | 1 | 1
244 | 1 | 1 | 1 | 1
246 | 1 | 1 | 1 | 1
248 | 1 | 1 | 1 | 1
249 | 0 | 1 | 0 | 1
250 | 0 | 3 | 0 | 1
252 | 1 | 1 | 1 | 1
254 | 1 | 1 | 1 | 1
256 | 1 | 1 | 1 | 1
258 | 1 | 1 | 1 | 1
260 | 1 | 1 | 1 | 1
262 | 1 | 1 | 1 | 1
264 | 1 | 1 | 1 | 1
266 | 1 | 1 | 1 | 1
268 | 1 | 1 | 1 | 1
270 | 1 | 1 | 1 | 1
272 | 1 | 1 | 1 | 1
274 | 1 | 1 | 1 | 1
276 | 1 | 1 | 1 | 1
278 | 1 | 1 | 1 | 1
280 | 1 | 1 | 1 | 1
282 | 1 | 1 | 1 | 1
284 | 1 | 1 | 1 | 1
286 | 1 | 1 | 1 | 1
288 | 1 | 1 | 1 | 1
290 | 1 | 1 | 1 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
_WA_Sys_00000003_49C3F6B7 | Feb 8 2011 6:56PM | 316 | 316 | 62 | 1 | 8 |  |  | 316

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.01515152 | 8 | Rate

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
6.5000 | 0 | 7 | 0 | 1
7.0000 | 1 | 1 | 1 | 1
7.2500 | 0 | 7 | 0 | 1
8.6200 | 0 | 2 | 0 | 1
9.0000 | 0 | 3 | 0 | 1
9.2500 | 0 | 4 | 0 | 1
9.5000 | 0 | 27 | 0 | 1
9.7500 | 0 | 1 | 0 | 1
9.8600 | 0 | 1 | 0 | 1
10.0000 | 0 | 15 | 0 | 1
10.2500 | 0 | 2 | 0 | 1
10.5769 | 0 | 4 | 0 | 1
11.0000 | 0 | 26 | 0 | 1
12.4500 | 0 | 26 | 0 | 1
12.7500 | 0 | 2 | 0 | 1
13.4500 | 0 | 17 | 0 | 1
13.4615 | 0 | 4 | 0 | 1
13.5000 | 0 | 1 | 0 | 1
13.9423 | 0 | 2 | 0 | 1
14.0000 | 0 | 22 | 0 | 1
14.4231 | 0 | 5 | 0 | 1
15.0000 | 0 | 26 | 0 | 1
16.0000 | 0 | 4 | 0 | 1
16.5865 | 0 | 1 | 0 | 1
16.8269 | 0 | 2 | 0 | 1
17.7885 | 0 | 1 | 0 | 1
18.2692 | 0 | 11 | 0 | 1
19.0000 | 0 | 5 | 0 | 1
19.2308 | 0 | 1 | 0 | 1
21.6346 | 1 | 1 | 1 | 1
22.5000 | 0 | 1 | 0 | 1
23.0769 | 0 | 14 | 0 | 1
23.5577 | 0 | 1 | 0 | 1
23.7200 | 0 | 1 | 0 | 1
24.0000 | 0 | 1 | 0 | 1
24.0385 | 0 | 1 | 0 | 1
24.5192 | 0 | 1 | 0 | 1
25.0000 | 0 | 23 | 0 | 1
26.4423 | 0 | 2 | 0 | 1
27.1394 | 0 | 1 | 0 | 1
27.4038 | 0 | 4 | 0 | 1
28.7500 | 0 | 1 | 0 | 1
28.8462 | 0 | 2 | 0 | 1
29.8462 | 0 | 1 | 0 | 1
30.0000 | 0 | 1 | 0 | 1
32.4519 | 0 | 2 | 0 | 1
32.6923 | 0 | 3 | 0 | 1
34.7356 | 0 | 1 | 0 | 1
37.5000 | 1 | 1 | 1 | 1
38.4615 | 0 | 2 | 0 | 1
39.6635 | 1 | 1 | 1 | 1
40.8654 | 0 | 2 | 0 | 1
42.4808 | 0 | 1 | 0 | 1
43.2692 | 0 | 2 | 0 | 1
48.1010 | 0 | 3 | 0 | 1
48.5577 | 0 | 1 | 0 | 1
50.4808 | 0 | 2 | 0 | 1
60.0962 | 0 | 1 | 0 | 1
63.4615 | 0 | 1 | 0 | 1
72.1154 | 0 | 1 | 0 | 1
84.1346 | 0 | 1 | 0 | 1
125.5000 | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
_WA_Sys_00000004_49C3F6B7 | Feb 8 2011 7:01PM | 316 | 316 | 2 | 0 | 1 |  |  | 316

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.5 | 1 | PayFrequency

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 180 | 0 | 1
2 | 0 | 136 | 0 | 1

## Objects that depend on [EmployeePayHistory]

- HumanResources.EmployeePayHistory
  - HumanResources.uspUpdateEmployeeHireInfo

## Objects on which [EmployeePayHistory] depends

- HumanResources.EmployeePayHistory
  - HumanResources.Employee
    - Person.Person
      - Person.AdditionalContactInfoSchemaCollection
      - Person.BusinessEntity
      - Demographics.exist
      - Person.IndividualSurveySchemaCollection
      - dbo.Name
      - dbo.NameStyle
    - dbo.Flag

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [HumanResources].[EmployeePayHistory]( [BusinessEntityID] [int] NOT NULL, [RateChangeDate] [datetime] NOT NULL, [Rate] [money] NOT NULL, [PayFrequency] [tinyint] NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Employee identification number. Foreign key to Employee.BusinessEntityID.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'EmployeePayHistory', @level2type=N'COLUMN',@level2name=N'BusinessEntityID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date the change in pay is effective' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'EmployeePayHistory', @level2type=N'COLUMN',@level2name=N'RateChangeDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Salary hourly rate.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'EmployeePayHistory', @level2type=N'COLUMN',@level2name=N'Rate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1 = Salary received monthly, 2 = Salary received biweekly' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'EmployeePayHistory', @level2type=N'COLUMN',@level2name=N'PayFrequency' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'EmployeePayHistory', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Employee pay history.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'EmployeePayHistory'

#### See also

List of Tables