C11/System/LOCOSOFT/IQD/Zeit/Zeit_Stempelungen_neu.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Locosoft_GC
DATASOURCENAME,C:\Gaps_Locosoft_neu\Portal\System\IQD\Zeit\Zeit_Stempelungen_neu.imr
TITLE,Zeit_Stempelungen_neu.imr
BEGIN SQL
select T1."employee_number" as c1,
	   T1."name" as c2,
	   T1."initials" as c3,
	   T1."mechanic_number" as c4,
	   T1."salesman_number" as c5,
	   T1."employment_date" as c6,
	   T1."termination_date" as c7,
	   T1."leave_date" as c8,
	   T2."employee_number" as c9,
	   T2."order_number" as c10,
	   T2."start_time" as c11,
	   T2."type" as c12,
	   T2."order_positions" as c13,
	   T2."end_time" as c14,
	   T2."duration_minutes" as c15,
	   T3."type" as c16,
	   T3."description" as c17,
	   T2."start_time" as c18,
	   '1' as c19,
	   '01' as c20,
	   (rtrim((cast_numberToString(cast_integer(T1."employee_number"))))) || ' - ' || T1."name" as c21,
	   CASE WHEN (T3."type" = 1) THEN (T2."duration_minutes" / 60) ELSE (0) END as c22,
	   CASE WHEN (T3."type" = 2) THEN (T2."duration_minutes" / 60) ELSE (0) END as c23,
	   CASE WHEN (T3."type" = 1) THEN (T2."duration_minutes" / 60) ELSE (0) END as c24,
	   CASE WHEN (T2."type" = 2) THEN ('produktiv') ELSE ('unproduktiv') END as c25,
	   '' as c26,
	   T2."duration_minutes" / 60 as c27,
	   T2."order_number" as c28,
	   (dayofweek(T2."start_time")) as c29,
	   T1."is_flextime" as c30,
	   T1."break_time_registration" as c31
from "dbo"."employees" T1,
	("dbo"."times" T2 left outer join "dbo"."time_types" T3 on T2."type" = T3."type")
where (T1."employee_number" = T2."employee_number")
and (T1."mechanic_number" IS NOT NULL)
order by c1 asc,c11 asc,c10 asc

END SQL
COLUMN,0,Employee Number_Employees
COLUMN,1,Name_Employees
COLUMN,2,Initials_Employees
COLUMN,3,Mechanic Number_Employees
COLUMN,4,Salesman Number_Employees
COLUMN,5,Employment Date_Employees
COLUMN,6,Termination Date_Employees
COLUMN,7,Leave Date_Employees
COLUMN,8,Employee Number_Times
COLUMN,9,Order Number_Times
COLUMN,10,Start Time_Times
COLUMN,11,Type_Times
COLUMN,12,Order Positions_Times
COLUMN,13,End Time_Times
COLUMN,14,Duration Minutes_Times
COLUMN,15,Type_Time_Types
COLUMN,16,Description_Time_Types
COLUMN,17,Datum
COLUMN,18,Hauptbetrieb
COLUMN,19,Standort
COLUMN,20,Monteur
COLUMN,21,Anwesenheit
COLUMN,22,produktiv
COLUMN,23,unproduktiv
COLUMN,24,Zeitkategorie
COLUMN,25,Zeitkategorie2
COLUMN,26,Ges. Std.
COLUMN,27,Order Number
COLUMN,28,Wochentag_Datum
COLUMN,29,Is Flextime_Employees
COLUMN,30,Break Time Registration_Employees