C11/System/WERWISO/IQD/Zeit/Stempelzeiten_Monteur.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,werwiso
DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\zeit\Stempelzeiten_Monteur.imr
TITLE,Stempelzeiten_Monteur.imr
BEGIN SQL
select T1."Filial_ID" as c1,
	   T1."MonteurNr" as c2,
	   T1."Datum" as c3,
	   T1."Beginn" as c4,
	   T1."VorgangsNummer" as c5,
	   T1."Ende" as c6,
	   T1."Differenz" as c7,
	   T1."AnzAW" as c8,
	   T1."ZeGruppe" as c9,
	   T1."Kommentar" as c10,
	   T1."Status" as c11,
	   T1."Nachgearbeitetfuer" as c12,
	   T1."Nachgearbeitetvon" as c13,
	   T1."KommentarMonteur" as c14,
	   T1."Auto" as c15,
	   T1."ToDoId" as c16,
	   T2."ModellID" as c17,
	   T2."Modellbezeichnung" as c18,
	   T2."ModellKuerzel" as c19,
	   T1."Ende" - T1."Beginn" as c20,
	   (extract(MINUTE FROM (T1."Ende" - T1."Beginn"))) as c21,
	   (extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60 as c22,
	   (extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60 as c23,
	   ((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60) as c24,
	   (((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60 as c25,
	   '1' as c26,
	   T1."Filial_ID" as c27,
	   T3."Personalart" as c28,
	   T3."Leistungsgruppe" as c29,
	   T3."Leistungsgrad" as c30,
	   CASE WHEN (T3."Personalart" IN ('Monteur                  ')) THEN ('produktiv') ELSE ('unproduktiv') END as c31,
	   CASE WHEN (T4."FunktionBez" LIKE 'Mont%') THEN ((od_left(T4."FunktionBez",7))) WHEN (T4."FunktionBez" LIKE 'Azub%') THEN ((od_left(T4."FunktionBez",13))) ELSE ('Monteur') END as c32,
	   (rtrim(T3."Name")) || ', ' || T3."Vorname" as c33,
	   T1."VorgangsNummer" as c34,
	   CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END as c35,
	   CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'unproduktiv') THEN (((ltrim(T5."Abwesenheitsart")))) WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'produktiv') THEN (T1."Status") WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'abwesend') THEN (T2."ModellKuerzel" || ' - ' || T2."Modellbezeichnung") ELSE null END as c36,
	   (ltrim(T5."Abwesenheitsart")) as c37,
	   CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'unproduktiv') THEN (T1."Kommentar") ELSE ((CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'unproduktiv') THEN (((ltrim(T5."Abwesenheitsart")))) WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'produktiv') THEN (T1."Status") WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'abwesend') THEN (T2."ModellKuerzel" || ' - ' || T2."Modellbezeichnung") ELSE null END)) END as c38,
	   '' as c39,
	   CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'produktiv') THEN (((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60)) ELSE (0) END as c40,
	   CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'unproduktiv') THEN (((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60)) ELSE (0) END as c41,
	   CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'abwesend') THEN (((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60)) ELSE (0) END as c42,
	   0 as c43,
	   0 as c44,
	   0 as c45,
	   0 as c46,
	   CASE WHEN (T4."FunktionBez" LIKE 'Mont%') THEN ((od_left(T4."FunktionBez",7))) WHEN (T4."FunktionBez" LIKE 'Azub%') THEN ((od_left(T4."FunktionBez",13))) ELSE ('Monteur') END as c47,
	   T6."Name_GC" as c48,
	   CASE WHEN ((CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'unproduktiv') THEN (T1."Kommentar") ELSE ((CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'unproduktiv') THEN (((ltrim(T5."Abwesenheitsart")))) WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'produktiv') THEN (T1."Status") WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'abwesend') THEN (T2."ModellKuerzel" || ' - ' || T2."Modellbezeichnung") ELSE null END)) END) = 'K  - Krank                                             ') THEN (((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60)) ELSE (0) END as c49,
	   (CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'produktiv') THEN (((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60)) ELSE (0) END) + (CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'unproduktiv') THEN (((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60)) ELSE (0) END) + (CASE WHEN ((CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'unproduktiv') THEN (T1."Kommentar") ELSE ((CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'unproduktiv') THEN (((ltrim(T5."Abwesenheitsart")))) WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'produktiv') THEN (T1."Status") WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'abwesend') THEN (T2."ModellKuerzel" || ' - ' || T2."Modellbezeichnung") ELSE null END)) END) = 'K  - Krank                                             ') THEN (((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60)) ELSE (0) END) as c50,
	   CASE WHEN (T1."VorgangsNummer" = 0) THEN ((round(((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60),2,0))) ELSE (0) END as c51,
	   CASE WHEN (T1."VorgangsNummer" = -1) THEN ((round(((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60),2,0))) ELSE (0) END as c52,
	   (CASE WHEN (T1."VorgangsNummer" = 0) THEN ((round(((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60),2,0))) ELSE (0) END) - (CASE WHEN (T1."VorgangsNummer" = -1) THEN ((round(((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60),2,0))) ELSE (0) END) as c53,
	   (rtrim(((rtrim(T3."Name")) || ', ' || T3."Vorname"))) || '_' || (asciiz(extract(YEAR FROM T1."Datum"),4) || '-' || asciiz(extract(MONTH FROM T1."Datum"),2) || '-' || asciiz(extract(DAY FROM T1."Datum"),2)) as c54,
	   (CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'produktiv') THEN (((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60)) ELSE (0) END) + (CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'unproduktiv') THEN (((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60)) ELSE (0) END) as c55,
	   CASE WHEN (((CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'produktiv') THEN (((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60)) ELSE (0) END) <> 0) and (T1."AnzAW" IS NULL)) THEN ((CASE WHEN ((CASE WHEN (T1."Status" IN ('Auftrag             ','AuftragEnde         ')) THEN ('produktiv') WHEN (T1."Status" IN ('Unproduktiv         ','UnproduktivEnde     ')) THEN ('unproduktiv') WHEN (T1."Status" IN ('Krank               ','Überstundenausgleich')) THEN ('abwesend') WHEN (T2."ModellID" IN (-7,-5,-4,-3,-2)) THEN ('abwesend') WHEN (T2."ModellID" IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)) THEN ('abwesend') ELSE null END) = 'produktiv') THEN (((((extract(MINUTE FROM (T1."Ende" - T1."Beginn")))) + ((extract(HOUR FROM (T1."Ende" - T1."Beginn"))) * 60) + ((extract(SECOND FROM (T1."Ende" - T1."Beginn"))) / 60)) / 60)) ELSE (0) END)) ELSE (0) END as c56
from ((((("\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."ZEITERF2" T1 left outer join "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."Zeitmodelle" T2 on (T1."Filial_ID" = T2."FilialID") and (T1."VorgangsNummer" = T2."ModellID")) left outer join "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."personal" T3 on T3."Personalnummer" = T1."MonteurNr") left outer join "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."PersonalFunktionZuord" T4 on T4."Personalnummer" = T3."Personalnummer") left outer join "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."ZeiterfUnprod" T5 on (((T1."Filial_ID" = T5."Filial_ID") and (T1."MonteurNr" = T5."MonteurNr")) and (T1."Datum" = T5."Datum")) and (T1."Beginn" = T5."Beginn")) left outer join QSS."C:\GlobalCube\System\WERWISO\IQD\Serv_Teile\Filialen_GC.ims" T6 on T1."Filial_ID" = T6."Filial_Id")
where (T3."Personalart" IN ('Monteur                  '))
order by c2 asc,c3 asc

END SQL
COLUMN,0,Filial Id
COLUMN,1,Monteurnr
COLUMN,2,Datum
COLUMN,3,Beginn
COLUMN,4,Vorgangsnummer
COLUMN,5,Ende
COLUMN,6,Differenz
COLUMN,7,Anzaw
COLUMN,8,Zegruppe
COLUMN,9,Kommentar
COLUMN,10,Status
COLUMN,11,Nachgearbeitetfuer
COLUMN,12,Nachgearbeitetvon
COLUMN,13,Kommentarmonteur
COLUMN,14,Auto
COLUMN,15,Todoid
COLUMN,16,Modellid_Zeitmodelle
COLUMN,17,Modellbezeichnung_Zeitmodelle
COLUMN,18,Modellkuerzel_Zeitmodelle
COLUMN,19,Ende - Beginn
COLUMN,20,Minute_in_Minuten
COLUMN,21,Stunde_in_Minuten
COLUMN,22,Sekunde_in_Minuten
COLUMN,23,Minuten
COLUMN,24,Stunden
COLUMN,25,Hauptbetrieb_ID
COLUMN,26,Standort_ID
COLUMN,27,Personalart
COLUMN,28,Leistungsgruppe
COLUMN,29,Leistungsgrad
COLUMN,30,Monteur_Gruppe
COLUMN,31,Monteur_Gruppe_2
COLUMN,32,Monteur
COLUMN,33,Order Number
COLUMN,34,Activity_Codes_Group_1
COLUMN,35,Activity_Codes_Group2
COLUMN,36,Abwesenheitsart_Zeiterfunprod
COLUMN,37,Activity_Desc
COLUMN,38,Kostenstelle
COLUMN,39,prod.
COLUMN,40,unprod.
COLUMN,41,Abw.
COLUMN,42,Extern
COLUMN,43,GWL
COLUMN,44,Intern
COLUMN,45,Sollzeit
COLUMN,46,Monteur_Azubi
COLUMN,47,Standort_Name
COLUMN,48,krank
COLUMN,49,Anw. + krank
COLUMN,50,Anw. gestempelt
COLUMN,51,Pause
COLUMN,52,Anw.
COLUMN,53,Monteur_Datum
COLUMN,54,prod_unprod
COLUMN,55,noch nicht verr. Std.