C11/System/ARI/SQL/schema/GC_TRANSIT_ARI/tables/import.Employee.sql

CREATE TABLE [import].[Employee] (
   [timestamp] [binary](8) NOT NULL,
   [No_] [varchar](20) NOT NULL,
   [First Name] [varchar](50) NOT NULL,
   [Last Name] [varchar](50) NOT NULL,
   [Union Membership No_] [varchar](30) NOT NULL,
   [Employment Date] [datetime] NOT NULL,
   [Termination Date] [datetime] NOT NULL,
   [Name] [varchar](50) NOT NULL,
   [Home Page 2] [varchar](80) NOT NULL,
   [Function Code] [varchar](20) NOT NULL,
   [Default Task Type] [varchar](10) NOT NULL,
   [Task Type Group] [varchar](10) NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [Employee$0] PRIMARY KEY CLUSTERED ([No_], [Client_DB])
)


GO