COGNOS QUERY
STRUCTURE,1,1
DATABASE,werwiso
DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\zeit\Monteur_fakt_Abschluss.imr
TITLE,Monteur_fakt_Abschluss.imr
BEGIN SQL
select T1."LfdNr" as c1,
	   T1."PersonalNr" as c2,
	   T1."Datum" as c3,
	   T1."Uhrzeit" as c4,
	   T1."Art" as c5,
	   T1."Monat" as c6,
	   T1."Jahr" as c7,
	   T1."UrlaubGelpant" as c8,
	   T1."UrlaubUngeplant" as c9,
	   T1."FakturiertAW" as c10,
	   T1."FakturiertStd" as c11,
	   T1."NichtFakturiertAW" as c12,
	   T1."NichtFakturiertStd" as c13,
	   T1."VerkaufteAW" as c14,
	   T1."VerkaufteStd" as c15,
	   T1."GesamtStundenStd" as c16,
	   T1."BenutzerNr" as c17,
	   T1."Kommentar" as c18,
	   T1."Filial_ID" as c19,
	   T1."Geleistet" as c20,
	   '1' as c21,
	   T2."Filial_ID" as c22,
	   T1."Filial_ID" as c23,
	   T3."FunktionBez" as c24,
	   T2."Personalart" as c25,
	   CASE WHEN (T2."Personalart" IN ('Monteur                  ')) THEN ('produktiv') ELSE ('unproduktiv') END as c26,
	   CASE WHEN (T3."FunktionBez" LIKE 'Mont%') THEN ((od_left(T3."FunktionBez",7))) WHEN (T3."FunktionBez" LIKE 'Azub%') THEN ((od_left(T3."FunktionBez",13))) ELSE ('Monteur') END as c27,
	   T2."Name" as c28,
	   T2."Vorname" as c29,
	   (rtrim(T2."Name")) || ', ' || T2."Vorname" as c30,
	   (asciiz(round(T1."Monat",0,0),2)) as c31,
	   (asciiz(round(T1."Jahr",0,0),4)) as c32,
	   ((asciiz(round(T1."Jahr",0,0),4))) || ((asciiz(round(T1."Monat",0,0),2))) || '28' as c33,
	   (cinteger(nconvert((((asciiz(round(T1."Jahr",0,0),4))) || ((asciiz(round(T1."Monat",0,0),2))) || '28')),0)) as c34,
	   (cdate(((cinteger(nconvert((((asciiz(round(T1."Jahr",0,0),4))) || ((asciiz(round(T1."Monat",0,0),2))) || '28')),0))))) as c35,
	   T1."FakturiertStd" as c36,
	   T1."NichtFakturiertStd" as c37,
	   CASE WHEN (T3."FunktionBez" LIKE 'Mont%') THEN ((od_left(T3."FunktionBez",7))) WHEN (T3."FunktionBez" LIKE 'Azub%') THEN ((od_left(T3."FunktionBez",13))) ELSE ('Monteur') END as c38
from (("\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."PersonalAbschluss" T1 left outer join "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."personal" T2 on T2."Personalnummer" = T1."PersonalNr") left outer join "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."PersonalFunktionZuord" T3 on T3."Personalnummer" = T2."Personalnummer")
where (T2."Personalart" IN ('Monteur                  '))

END SQL
COLUMN,0,Lfdnr
COLUMN,1,Personalnr
COLUMN,2,Datum_Abschluss
COLUMN,3,Uhrzeit
COLUMN,4,Art
COLUMN,5,Monat
COLUMN,6,Jahr
COLUMN,7,Urlaubgelpant
COLUMN,8,Urlaubungeplant
COLUMN,9,Fakturiertaw
COLUMN,10,Fakturiertstd
COLUMN,11,Nichtfakturiertaw
COLUMN,12,Nichtfakturiertstd
COLUMN,13,Verkaufteaw
COLUMN,14,Verkauftestd
COLUMN,15,Gesamtstundenstd
COLUMN,16,Benutzernr
COLUMN,17,Kommentar
COLUMN,18,Filial Id
COLUMN,19,Geleistet
COLUMN,20,Hauptbetrieb_ID
COLUMN,21,Filial Id
COLUMN,22,Standort_ID
COLUMN,23,Funktionbez
COLUMN,24,Personalart
COLUMN,25,Monteur_Gruppe
COLUMN,26,Monteur_Gruppe_2
COLUMN,27,Name
COLUMN,28,Vorname
COLUMN,29,Monteur
COLUMN,30,Monat_Datum
COLUMN,31,Jahr_Zeichen
COLUMN,32,Datum_Zeichen
COLUMN,33,Datum_Zahl
COLUMN,34,Datum
COLUMN,35,verr. Zeit
COLUMN,36,noch nicht verr. Std.
COLUMN,37,Monteur_Azubi