Owner: HumanResources 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB: 16 
Index Size KB: 16 
Rows: 316 
Description: Employee pay history. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    EmployeeID  int          Employee identification number. Foreign key to Employee.EmployeeID. 
    RateChangeDate  datetime          Date the change in pay is effective 
    Rate  money          Salary hourly rate. 
    PayFrequency  tinyint          1 = Salary received monthly, 2 = Salary received biweekly 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 5 column(s)


Index Primary Unique Description
  PK_EmployeePayHistory_EmployeeID_RateChangeDate      Primary key (clustered) constraint 
Total: 1 index(es)

Check Constraints

Name Expression
  CK_EmployeePayHistory_PayFrequency  ([PayFrequency]=(2) OR [PayFrequency]=(1)) 
  CK_EmployeePayHistory_Rate  ([Rate]>=(6.50) AND [Rate]<=(200.00)) 
Total: 2 constraint(s)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  HumanResources.Employee  FK_EmployeePayHistory_Employee_EmployeeID  PK_Employee_EmployeeID 
Total: 1 table(s)

Objects that [HumanResources].[EmployeePayHistory] depends on

Object Name Owner Object Type Dep Level
  Flag  dbo  User Defined type 
  Name  dbo  User Defined type 
  NameStyle  dbo  User Defined type 
  Phone  dbo  User Defined type 
  Contact  Person  Table 
  Employee  HumanResources  Table 
Total: 6 object(s)

Objects that depend on [HumanResources].[EmployeePayHistory]

Object Name Owner Object Type Dep Level
  uspUpdateEmployeeHireInfo  HumanResources  Procedure 
Total: 1 object(s)


CREATE TABLE [EmployeePayHistory] (
    [EmployeeID] [int] NOT NULL ,
    [RateChangeDate] [datetime] NOT NULL ,
    [Rate] [money] NOT NULL ,
    [PayFrequency] [tinyint] NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_EmployeePayHistory_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_EmployeePayHistory_EmployeeID_RateChangeDate] PRIMARY KEY  CLUSTERED
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_EmployeePayHistory_Employee_EmployeeID] FOREIGN KEY
    ) REFERENCES [Employee] (
    CONSTRAINT [CK_EmployeePayHistory_PayFrequency] CHECK ([PayFrequency]=(2) OR [PayFrequency]=(1)),
    CONSTRAINT [CK_EmployeePayHistory_Rate] CHECK ([Rate]>=(6.50) AND [Rate]<=(200.00))

See Also

List of tables