Properties

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

Columns

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

Total: 5 column(s)

Indexes

	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	1
	Name	dbo	User Defined type	1
	NameStyle	dbo	User Defined type	1
	Phone	dbo	User Defined type	1
	Contact	Person	Table	2
	Employee	HumanResources	Table	3

Total: 6 object(s)

Objects that depend on [HumanResources].[EmployeePayHistory]

	Object Name	Owner	Object Type	Dep Level
	uspUpdateEmployeeHireInfo	HumanResources	Procedure	1

Total: 1 object(s)

SQL

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
    (
        [EmployeeID],
        [RateChangeDate]
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_EmployeePayHistory_Employee_EmployeeID] FOREIGN KEY
    (
        [EmployeeID]
    ) REFERENCES [Employee] (
        [EmployeeID]
    ),
    CONSTRAINT [CK_EmployeePayHistory_PayFrequency] CHECK ([PayFrequency]=(2) OR [PayFrequency]=(1)),
    CONSTRAINT [CK_EmployeePayHistory_Rate] CHECK ([Rate]>=(6.50) AND [Rate]<=(200.00))
) ON [PRIMARY]
GO

See Also

List of tables