ETL_DWH_ARI/schema/GC_ETL_ARI/views/x_data.Mitarbeiter.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [x_data].[Mitarbeiter] AS
SELECT [Client_DB]
     , [Employee No_]
      , [Name]
      , [First Name]
      , [Last Name]
      , [Leaving Date]
      , [Task Type Group]
      , [Function Code]
      , [Group No_ 1]
      , [Group No_ 2]
      , [Group No_ 3]
	  , [aktiv]
     , [Monteur_Gruppe]
     , [Monteur_Gruppe_2]
FROM [GC_CONFIG].[ari].[Mitarbeiter]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO