C11/System/ARI/Models/SQL/Time_Clock_Entry_Z_Monteure.sql

CREATE
	OR

ALTER VIEW [load].[Time_Clock_Entry]
AS
SELECT --[Entry No] AS [Entry No],
	--[Employee No] AS [Employee No],
	--[Resource No] AS [Resource No],
	--[Address No] AS [Address No],
	--[Date] AS [Date],
	--[Time] AS [Time],
	--[Sorting] AS [Sorting],
	--[Duration] AS [Duration],
	--[Task Type Code] AS [Task Type Code],
	--[Type] AS [Type],
	--[Linked To Entry No] AS [Linked To Entry No],
	--[Leaving] AS [Leaving],
	--[Service Order No] AS [Service Order No],
	--[Service Job No] AS [Service Job No],
	--[Service Line No] AS [Service Line No],
	--[Labor Standard Time Type] AS [Labor Standard Time Type],
	--[Approved] AS [Approved],
	--[Approved By Employee No] AS [Approved By Employee No],
	--[Approval Timestamp] AS [Approval Timestamp],
	--[Canceled] AS [Canceled],
	--[Canceled By User Id] AS [Canceled By User Id],
	--[Cancelation Timestamp] AS [Cancelation Timestamp],
	--[Created By User Id] AS [Created By User Id],
	--[Creation Timestamp] AS [Creation Timestamp],
	--[Productive] AS [Productive],
	--[Statistics Group] AS [Statistics Group],
	--[Considered As Working] AS [Considered As Working],
	--[Order Location Code] AS [Order Location Code],
	--[Resource Location Code] AS [Resource Location Code],
	--[Make Code] AS [Make Code],
	--[Branch Code] AS [Branch Code],
	--[Labor No] AS [Labor No],
	--[Description] AS [Description],
	--[Source Code] AS [Source Code],
	--[Efficiency] AS [Efficiency],
	--[Automatic] AS [Automatic],
	--[Passed] AS [Passed],
	--[Code_Task_Type] AS [Code_Task_Type],
	--[Description_Task_Type] AS [Description_Task_Type],
	--[No_Employee_T] AS [No_Employee_T],
	--[Name_Employee_T] AS [Name_Employee_T],
	--[Last Name_Employee_T] AS [Last Name_Employee_T],
	--[First Name_Employee_T] AS [First Name_Employee_T],
	--[Group No 1_Employee_T] AS [Group No 1_Employee_T],
	--[Group No 2_Employee_T] AS [Group No 2_Employee_T],
	--[Group No 3_Employee_T] AS [Group No 3_Employee_T],
	--[Leaving Date_Employee_T] AS [Leaving Date_Employee_T],
	--[produktiv/unproduktiv] AS [produktiv/unproduktiv],
	[Monteur] AS [Monteur],
	--[Monteur_Gruppe_ori] AS [Monteur_Gruppe_ori],
	--[Tage Heute Leaving Date] AS [Tage Heute Leaving Date],
	[Monteur_Gruppe_2] AS [Monteur_Gruppe_2],
	[Datum] AS [Datum],
	--[Monatserster] AS [Monatserster],
	--[Monatsletzter] AS [Monatsletzter],
	--[Heute] AS [Heute],
	--[Datum Tagesbericht] AS [Datum Tagesbericht],
	[Hauptbetrieb_ID] AS [Hauptbetrieb_ID],
	--[Standort] AS [Standort],
	[prod.] AS [produktiv],
	[unprod.] AS [unproduktiv],
	[Abw.] AS [abwesend],
	--[produktiv_für_Berechnung_LG] AS [produktiv_für_Berechnung_LG],
	--[Servicemobil] AS [Servicemobil],
	--[krank] AS [krank],
	--[Meistervertr.] AS [Meistervertr.],
	[Activity_Desc] AS [Activity_Desc],
	[Standort_ID] AS [Standort_ID],
	[Monteur_Gruppe] AS [Monteur_Gruppe],
	[Department No] AS [Department No],
	[Order Number] AS [Order Number],
	[Task Type Group] AS [Task Type Group],
	[Extern] AS [Extern],
	[Intern] AS [Intern],
	[Home Page 2] AS [Home Page 2],
	[Employment Date] AS [Employment Date],
	left ( [Department No] , 2 ) AS [Standort_Monteur] 
FROM [export_csv].[Time_Clock_Entry]
GO