ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
HumanResources.EmployeePayHistory_(table)
Print
RSS
Modified: 2011/08/27 10:14 by
wikibot
-
Uncategorized
»
dbo.ErrorLog_(table)
»
HumanResources.EmployeePayHistory_(table)
[X]
»
dbo.ErrorLog_(table)
»
HumanResources.EmployeePayHistory_(table)
Edit
wikibot
Table
HumanResources.EmployeePayHistory
Description
Employee pay history.
Edit
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.
Edit
Primary Key
Primary Key
Columns
PK_EmployeePayHistory_EmployeeID_RateChangeDate
EmployeeID, RateChangeDate
Edit
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)
Edit
Foreign Keys
Relation
Column
Referenced Column
HumanResources.Employee
EmployeeID
EmployeeID
Edit
References
Dependency Type
Object Type
Referenced Object
Schema
Schema
HumanResources
Edit
Dependencies
Reference Type
Object Type
Referencing Object
Insert
Procedure
HumanResources.uspUpdateEmployeeHireInfo
Edit
automatically generated
Table
HumanResources.EmployeePayHistory
Description
Employee pay history.
Column
Data Type
Nullable
Default
Description / PK / Index
EmployeeID
int
not null
Employee identification number. Foreign key to Employee.EmployeeID.
PK_EmployeePayHistory_EmployeeID_RateChangeDate
RateChangeDate
datetime
not null
Date the change in pay is effective
PK_EmployeePayHistory_EmployeeID_RateChangeDate
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.
Relation
Column
Referenced Column
HumanResources.Employee
EmployeeID
EmployeeID
Dependency Type
Object Type
Referenced Object
Schema
Schema
HumanResources
Reference Type
Object Type
Referencing Object
Insert
Procedure
HumanResources.uspUpdateEmployeeHireInfo
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.