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

CREATE
	OR

ALTER VIEW [load].[Zeit_2_Ryma]
AS
SELECT --[Employee No] AS [Employee No],
	[Datum] AS [Datum],
	--[Department No_ori] AS [Department No_ori],
	--[Time Account No] AS [Time Account No],
	--[Time Account Value] AS [Time Account Value],
	--[Ta Class (general)] AS [Ta Class (general)],
	--[Ta Class (statistics)] AS [Ta Class (statistics)],
	--[Ta Class (absent Days)] AS [Ta Class (absent Days)],
	--[Ta Class (time Processing)] AS [Ta Class (time Processing)],
	--[Ta Class (individual)] AS [Ta Class (individual)],
	--[Ta Class (employee Info)] AS [Ta Class (employee Info)],
	--[Ta Class (vacation Reduction)] AS [Ta Class (vacation Reduction)],
	--[Ta Formatting] AS [Ta Formatting],
	--[Generating Function] AS [Generating Function],
	--[Record Protected] AS [Record Protected],
	--[No] AS [No],
	--[Description] AS [Description],
	--[Description 2] AS [Description 2],
	--[Zeitdauer_ori] AS [Zeitdauer_ori],
	[Zeitdauer] AS [Zeitdauer],
	--[gesamt Stunden] AS [gesamt Stunden],
	--[krank] AS [krank],
	--[Wehr- /Zivildienst] AS [Wehr- /Zivildienst],
	--[Sonderurlaub] AS [Sonderurlaub],
	--[Berufsschule] AS [Berufsschule],
	--[Innung Azubi] AS [Innung Azubi],
	--[Feiertag] AS [Feiertag],
	--[Schulung extern] AS [Schulung extern],
	--[Urlaub] AS [Urlaub],
	--[W-fix Stunden] AS [W-fix Stunden],
	[Hauptbetrieb_ID] AS [Hauptbetrieb_ID],
	--[Standort] AS [Standort],
	--[First Name] AS [First Name],
	[Last Name] AS [Last Name],
	--[Monteur_Gruppe_ori] AS [Monteur_Gruppe_ori],
	--[Abteilung] AS [Abteilung],
	[Order Number] AS [Order Number],
	[Monteur] AS [Monteur],
	--[Zeitausgleich] AS [Zeitausgleich],
	--[Überstunden] AS [Überstunden],
	--[Leaving Date] AS [Leaving Date],
	--[Group No 1] AS [Group No 1],
	--[Group No 2] AS [Group No 2],
	--[Group No 3] AS [Group No 3],
	--[Tage Heute Leaving Date] AS [Tage Heute Leaving Date],
	[Monteur_Gruppe] AS [Monteur_Gruppe],
	--[produktiv/unproduktiv] AS [produktiv/unproduktiv],
	--[Monatserster] AS [Monatserster],
	--[Monatsletzter] AS [Monatsletzter],
	--[Heute] AS [Heute],
	--[Datum Tagesbericht] AS [Datum Tagesbericht],
	[Employment Date] AS [Employment Date],
	[Department No] AS [Department No],
	--[Datum_Monteurlisten] AS [Datum_Monteurlisten],
	--[Fehlzeiten genehm./ungenem.] AS [Fehlzeiten genehm./ungenem.],
	[Activity Desc] AS [Activity_Desc],
	[Monteur_Gruppe_2] AS [Monteur_Gruppe_2],
	[Standort_ID] AS [Standort_ID],
	left ( [Department No] , 2 ) AS [Standort_Monteur],
	[Task Type Group] AS [Task Type Group],
	[Sollzeit] AS [Sollzeit],
	[abwesend] AS [abwesend],
	[Home Page 2] AS [Home Page 2],
	--[Summe Sollzeit] AS [Summe Sollzeit] 
FROM [export_csv].[Zeit_2_Ryma]
GO