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.