ETL_DWH_ARI/schema/GC_ETL_ARI/views/xtract.Time_Clock_Entry.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Time_Clock_Entry] AS
SELECT [timestamp]
     , [Entry No_]
     , [Employee No_]
     , [Resource No_]
--      , [Address No_]
     , [Date]
--      , [Time]
     , [Sorting]
     , [Duration]
     , [Task Type Code]
--      , [Type]
--      , [Linked to Entry No_]
--      , [Leaving]
     , [Service Order No_]
     , [Service Job No_]
--      , [Service Line No_]
--      , [Labor Standard Time Type]
--      , [Approved]
--      , [Approved by Employee No_]
--      , [Approval Timestamp]
     , [Canceled]
--      , [Canceled by User ID]
--      , [Cancelation Timestamp]
--      , [Created by User ID]
--      , [Creation Timestamp]
--      , [Productive]
--      , [Statistics Group]
--      , [Considered as Working]
--      , [Order Location Code]
--      , [Resource Location Code]
--      , [Make Code]
--      , [Branch Code]
--      , [Labor No_]
--      , [Description]
--      , [Source Code]
     , [Efficiency _]
--      , [Automatic]
--      , [Passed]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Time_Clock_Entry]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO