From dbscript Online Help
wikibot
| Table
|
HumanResources.EmployeePayHistory
|
| Description
|
Employee pay history.
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
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
|
|
Salary hourly rate.
|
| PayFrequency
|
tinyint
|
not null
|
|
1 = Salary received monthly, 2 = Salary received biweekly
|
| ModifiedDate
|
datetime
|
not null
|
(getdate())
|
Date and time the record was last updated.
|
Primary Key
| Primary Key
|
Columns
|
| PK_EmployeePayHistory_EmployeeID_RateChangeDate
|
EmployeeID, RateChangeDate
|
Check Constraints
| Check Constraint
|
Expression
|
Description
|
| CK_EmployeePayHistory_PayFrequency
|
([PayFrequency]=(2) OR [PayFrequency]=(1))
|
Check constraint [PayFrequency]=(3) OR [PayFrequency]=(2) OR [PayFrequency]=(1)
|
| CK_EmployeePayHistory_Rate
|
([Rate]>=(6.50) AND [Rate]<=(200.00))
|
Check constraint [Rate] >= (6.50) AND [Rate] <= (200.00)
|
Foreign Keys
References
| Dependency Type
|
Object Type
|
Referenced Object
|
| Schema
|
Schema
|
HumanResources
|
Dependencies
