HumanResources.Employee

Columns

• //

  ${escapify(column.description)}
  BusinessEntityID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  NationalIDNumber
  [nvarchar](15) NOT NULL
• //

  ${escapify(column.description)}
  LoginID
  [nvarchar](256) NOT NULL
• //

  ${escapify(column.description)}
  OrganizationNode
  [hierarchyid] NULL
• //

  ${escapify(column.description)}
  OrganizationLevel
  [smallint] NULL
• //

  ${escapify(column.description)}
  JobTitle
  [nvarchar](50) NOT NULL
• //

  ${escapify(column.description)}
  BirthDate
  [date] NOT NULL

  //

  CONSTRAINT: Check constraint [BirthDate] >= '1930-01-01' AND [BirthDate] <= dateadd(year,(-18),GETDATE())

  ([BirthDate]>='1930-01-01' AND [BirthDate]<=dateadd(year,(-18),getdate()))
• //

  ${escapify(column.description)}
  MaritalStatus
  [nchar](1) NOT NULL

  //

  CONSTRAINT: Check constraint [MaritalStatus]='s' OR [MaritalStatus]='m' OR [MaritalStatus]='S' OR [MaritalStatus]='M'

  (upper([MaritalStatus])='S' OR upper([MaritalStatus])='M')
• //

  ${escapify(column.description)}
  Gender
  [nchar](1) NOT NULL

  //

  CONSTRAINT: Check constraint [Gender]='f' OR [Gender]='m' OR [Gender]='F' OR [Gender]='M'

  (upper([Gender])='F' OR upper([Gender])='M')
• //

  ${escapify(column.description)}
  HireDate
  [date] NOT NULL

  //

  CONSTRAINT: Check constraint [HireDate] >= '1996-07-01' AND [HireDate] <= dateadd(day,(1),GETDATE())

  ([HireDate]>='1996-07-01' AND [HireDate]<=dateadd(day,(1),getdate()))
• //

  ${escapify(column.description)}
  SalariedFlag
  [Flag] NOT NULL DEFAULT ((1))

  //

  USER-DEFINED DATA TYPE

  [bit] NOT NULL
• //

  ${escapify(column.description)}
  VacationHours
  [smallint] NOT NULL DEFAULT ((0))

  //

  CONSTRAINT: Check constraint [VacationHours] >= (-40) AND [VacationHours] <= (240)

  ([VacationHours]>=(-40) AND [VacationHours]<=(240))
• //

  ${escapify(column.description)}
  SickLeaveHours
  [smallint] NOT NULL DEFAULT ((0))

  //

  CONSTRAINT: Check constraint [SickLeaveHours] >= (0) AND [SickLeaveHours] <= (120)

  ([SickLeaveHours]>=(0) AND [SickLeaveHours]<=(120))
• //

  ${escapify(column.description)}
  CurrentFlag
  [Flag] NOT NULL DEFAULT ((1))

  //

  USER-DEFINED DATA TYPE

  [bit] NOT NULL
• //

  ${escapify(column.description)}
  rowguid
  [uniqueidentifier] NOT NULL DEFAULT (newid())
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_Employee_BusinessEntityID
  UNIQUE CLUSTERED
  BusinessEntityID
• //

  Unique nonclustered index.
  IX_Employee_OrganizationNode
  NONCLUSTERED
  OrganizationNode
• //

  Unique nonclustered index.
  IX_Employee_OrganizationLevel_OrganizationNode
  NONCLUSTERED
  OrganizationLevel , OrganizationNode
• //

  Unique nonclustered index.
  AK_Employee_LoginID
  UNIQUE NONCLUSTERED
  LoginID
• //

  Unique nonclustered index.
  AK_Employee_NationalIDNumber
  UNIQUE NONCLUSTERED
  NationalIDNumber
• //

  Unique nonclustered index. Used to support replication samples.
  AK_Employee_rowguid
  UNIQUE NONCLUSTERED
  rowguid

Foreign Keys

• //

  Foreign key constraint referencing Person.BusinessEntityID.
  FK_Employee_Person_BusinessEntityID
  Person.Person
  BusinessEntityID ⥱ BusinessEntityID

Sample Data