CREATE TABLE [import].[Employee_T] ( [timestamp] [binary](8) NOT NULL, [No_] [varchar](20) NOT NULL, [ID No_] [varchar](20) NOT NULL, [Search Item] [varchar](30) NOT NULL, [Name] [varchar](50) NOT NULL, [Last Name] [varchar](30) NOT NULL, [First Name] [varchar](30) NOT NULL, [Street] [varchar](30) NOT NULL, [Post Code] [varchar](20) NOT NULL, [City] [varchar](30) NOT NULL, [Business Phone No_] [varchar](30) NOT NULL, [Private Business Phone No_] [varchar](30) NOT NULL, [Fax] [varchar](30) NOT NULL, [E-Mail] [varchar](80) NOT NULL, [Homepage] [varchar](80) NOT NULL, [Sex] [int] NOT NULL, [No_ Series] [varchar](10) NOT NULL, [Employee No_ - Payroll] [varchar](20) NOT NULL, [Target Company - Payroll] [varchar](30) NOT NULL, [Destination Journal - Payroll] [varchar](10) NOT NULL, [RI_Def_ Task Type TP] [varchar](20) NOT NULL, [Destination Company - Sync_] [varchar](30) NOT NULL, [Employee No_ - Resource] [varchar](20) NOT NULL, [Rented Employees Duty Planning] [tinyint] NOT NULL, [Vaca_Car_Fwd_Prev_Y_ Inactive] [tinyint] NOT NULL, [Soft-Terminal Coming Inactive] [tinyint] NOT NULL, [Soft-Terminal Leaving Inactive] [tinyint] NOT NULL, [Soft-Terminal Errand Inactive] [tinyint] NOT NULL, [Soft-Terminal Break Inactive] [tinyint] NOT NULL, [Soft-Terminal Dept_ Inactive] [tinyint] NOT NULL, [Date of Birth] [datetime] NOT NULL, [Employment Date] [datetime] NOT NULL, [Leaving Date] [datetime] NOT NULL, [Begin of Plan Continuation] [datetime] NOT NULL, [Begin Special Day Continuation] [datetime] NOT NULL, [Fixed-term Contract until] [datetime] NOT NULL, [Medical Checkup] [datetime] NOT NULL, [Begin Time of Probation] [datetime] NOT NULL, [End Time of Probation] [datetime] NOT NULL, [Begin Work Permit] [datetime] NOT NULL, [End Work Permit] [datetime] NOT NULL, [Begin Integration] [datetime] NOT NULL, [End Integration] [datetime] NOT NULL, [Begin altern_ Vac_ Year] [datetime] NOT NULL, [End altern_ Vac_ Year] [datetime] NOT NULL, [Working Days _ Week] [int] NOT NULL, [Contract No_ - Payroll] [varchar](10) NOT NULL, [Employee No_ - Resource EUID] [int] NOT NULL, [MS-Project Import Inactive] [tinyint] NOT NULL, [Department No_] [varchar](10) NOT NULL, [Division No_] [varchar](10) NOT NULL, [Activity No_] [varchar](10) NOT NULL, [Company No_] [varchar](10) NOT NULL, [Pay Group No_] [varchar](10) NOT NULL, [State No_] [int] NOT NULL, [Group No_ 1] [varchar](10) NOT NULL, [Group No_ 2] [varchar](10) NOT NULL, [Group No_ 3] [varchar](10) NOT NULL, [Time Object No_] [varchar](20) NOT NULL, [Key Reference No_] [varchar](10) NOT NULL, [Sorting Planning Programs] [int] NOT NULL, [Day Object on Pub_ Holidays] [varchar](10) NOT NULL, [Employee User ID] [varchar](20) NOT NULL, [Bar Code Coming Clocking] [varchar](20) NOT NULL, [Bar Code Leaving Clocking] [varchar](20) NOT NULL, [Destination Journal - FDC] [int] NOT NULL, [Company Reference] [int] NOT NULL, [FDC Permissions] [int] NOT NULL, [Dynamic Agreed Vacation] [int] NOT NULL, [Std_ Vac_ Entitlem_ Days] [decimal](38,20) NOT NULL, [Handic_ Vac_ Entitlem_ Days] [decimal](38,20) NOT NULL, [Spec_ Vac_2 Entitlem_ Days] [decimal](38,20) NOT NULL, [Spec_ Vac_3 Entitlem_ Days] [decimal](38,20) NOT NULL, [Std_Vac_Days Car_Fwd_Prev_Y_] [decimal](38,20) NOT NULL, [Handic_ Vac_1 Days Car_ Fwd_] [decimal](38,20) NOT NULL, [Special Vac_2 Days Car_ Fwd_] [decimal](38,20) NOT NULL, [Special Vac_3 Days Car_ Fwd_] [decimal](38,20) NOT NULL, [Rem_ Vac_ Days taken] [decimal](38,20) NOT NULL, [Rem_ Vac_ Days planned] [decimal](38,20) NOT NULL, [Standard Vac_ Entitlement Hrs_] [decimal](38,20) NOT NULL, [Handic_ Vac_1 Entitlement Hrs_] [decimal](38,20) NOT NULL, [Special Vac_2 Entitlement (H)] [decimal](38,20) NOT NULL, [Std_ Vac_Car_Fwd_Prev_Y_(H)] [decimal](38,20) NOT NULL, [Handic_ Vac_1 Hours Car_ Fwd_] [decimal](38,20) NOT NULL, [Spec_ Vac_2 Hours Car_ Fwd_] [decimal](38,20) NOT NULL, [Rem_ Vac_ Hours taken] [decimal](38,20) NOT NULL, [Rem_ Vac_ Hrs_ Planned] [decimal](38,20) NOT NULL, [Plan Continuation Active] [tinyint] NOT NULL, [Rem_ Handic_ Vac_ Days taken] [decimal](38,20) NOT NULL, [Rem_ Handic_ Vac_ Days planned] [decimal](38,20) NOT NULL, [Options Auto_ Day Finished] [int] NOT NULL, [Coming Auto_ Day Finished] [datetime] NOT NULL, [Leaving Auto_ Day Finished] [datetime] NOT NULL, [Order Continuation Inactive] [tinyint] NOT NULL, [Soft-Terminal Vac_ Inactive] [tinyint] NOT NULL, [Soft-Terminal Passw_ Inactive] [tinyint] NOT NULL, [Soft-Terminal Order Inactive] [tinyint] NOT NULL, [Payroll Integration Inactive] [tinyint] NOT NULL, [Absent Integration Inactive] [tinyint] NOT NULL, [End of Last Plan Continuation] [datetime] NOT NULL, [End of last Special Day Cont_] [datetime] NOT NULL, [Date of Last Change] [datetime] NOT NULL, [Time of Last Change] [datetime] NOT NULL, [User No_ of Last Change] [varchar](20) NOT NULL, [Date of Last Processing] [datetime] NOT NULL, [Duty Planning Inactive] [tinyint] NOT NULL, [Synchronization Inactive] [tinyint] NOT NULL, [Access Data Active] [tinyint] NOT NULL, [All Modules Inactive] [tinyint] NOT NULL, [Employee Planning Inactive] [tinyint] NOT NULL, [Terminal Acquisition Inactive] [tinyint] NOT NULL, [Time Processing Inactive] [tinyint] NOT NULL, [Values Car_ Fwd_ Inactive] [tinyint] NOT NULL, [Payroll_Absent Int_ Inactive] [tinyint] NOT NULL, [Reports Inactive] [tinyint] NOT NULL, [Autom_ Plan Cont_ Inactive] [tinyint] NOT NULL, [Integration FDC Inactive] [tinyint] NOT NULL, [Integr_ FDC unprod_ Inactive] [tinyint] NOT NULL, [Soft Terminal Password] [varchar](20) NOT NULL, [Monday Absent Days Hours] [decimal](38,20) NOT NULL, [Tuesday Absent Days Hours] [decimal](38,20) NOT NULL, [Wednesday Absent Days Hours] [decimal](38,20) NOT NULL, [Thursday Absent Days Hours] [decimal](38,20) NOT NULL, [Friday Absent Days Hours] [decimal](38,20) NOT NULL, [Saturday Absent Days Hours] [decimal](38,20) NOT NULL, [Sunday Absent Days Hours] [decimal](38,20) NOT NULL, [Monday Absent Days Minutes] [decimal](38,20) NOT NULL, [Tuesday Absent Days Minutes] [decimal](38,20) NOT NULL, [Wednesday Absent Days Minutes] [decimal](38,20) NOT NULL, [Thursday Absent Days Minutes] [decimal](38,20) NOT NULL, [Friday Absent Days Minutes] [decimal](38,20) NOT NULL, [Saturday Absent Days Minutes] [decimal](38,20) NOT NULL, [Sunday Absent Days Minutes] [decimal](38,20) NOT NULL, [VIP] [tinyint] NOT NULL, [Month of Birth] [int] NOT NULL, [Day of Birth] [int] NOT NULL, [Last Total Key] [varchar](120) NOT NULL, [Last Order Clocking] [varchar](20) NOT NULL, [Last Task Clocking] [varchar](20) NOT NULL, [Date of Last Order Clocking] [datetime] NOT NULL, [Date of Last Task Clocking] [datetime] NOT NULL, [Counter] [int] NOT NULL, [SP_Target Hours] [decimal](38,20) NOT NULL, [SP_Target Shifts] [decimal](38,20) NOT NULL, [SP_Early Shifts] [decimal](38,20) NOT NULL, [SP_Late Shifts] [decimal](38,20) NOT NULL, [SP_Night Shifts] [decimal](38,20) NOT NULL, [SP_Special Shifts] [decimal](38,20) NOT NULL, [SP_Vacation] [decimal](38,20) NOT NULL, [SP_Sick] [decimal](38,20) NOT NULL, [SP_Misc_] [decimal](38,20) NOT NULL, [SP_Total Shifts] [decimal](38,20) NOT NULL, [SP_Total Hours] [decimal](38,20) NOT NULL, [Coming - Order Begin] [int] NOT NULL, [Com-Order_Num_Days before] [int] NOT NULL, [Last Clocking Dimension 1] [varchar](20) NOT NULL, [Last Clocking Dimension 2] [varchar](20) NOT NULL, [Last Clocking Dimension 3] [varchar](20) NOT NULL, [Last Clocking Dimension 4] [varchar](20) NOT NULL, [Date of Last Clocking Dim_ 1] [datetime] NOT NULL, [Date of Last Clocking Dim_ 2] [datetime] NOT NULL, [Date of Last Clocking Dim_ 3] [datetime] NOT NULL, [Date of Last Clocking Dim_ 4] [datetime] NOT NULL, [Present] [tinyint] NOT NULL, [Absent] [tinyint] NOT NULL, [Address No_] [int] NOT NULL, [Action triggered by Card form] [tinyint] NOT NULL, [Updated by User ID] [varchar](20) NOT NULL, [Update Company] [varchar](30) NOT NULL, [Department Code] [varchar](10) NOT NULL, [Make Code] [varchar](10) NOT NULL, [Default Task Type Code] [varchar](10) NOT NULL, [Place of Birth] [varchar](30) NOT NULL, [Task Type Group] [varchar](10) NOT NULL, [Efficiency %] [decimal](38,20) NOT NULL, [Time Acquisition activated] [tinyint] NOT NULL, [Booking of Endstamp afterw] [tinyint] NOT NULL, [Break Clocking] [int] NOT NULL, [Break tolerance %] [decimal](38,20) NOT NULL, [Resource No_] [varchar](20) NOT NULL, [Rating PEREAS] [decimal](38,20) NOT NULL, [PrintFromTimeClock] [tinyint] NOT NULL, [User ID] [varchar](20) NOT NULL, [Client_DB] [varchar](50) NOT NULL DEFAULT ('1') ,CONSTRAINT [Employee_T$0] PRIMARY KEY CLUSTERED ([No_], [Client_DB]) ) GO