COGNOS QUERY
STRUCTURE,1,1
DATABASE,GC_AUTOLINE
DATASOURCENAME,C:\GlobalCube\System\Autoline\IQD\zeiten\Abwesenheitszeiten.imr
TITLE,Abwesenheitszeiten.imr
BEGIN SQL
select T1."Type" as c1,
	   T1."Resource" as c2,
	   T1."Date" as c3,
	   T1."Active001" as c4,
	   T1."Active002" as c5,
	   T1."Active003" as c6,
	   T1."Active004" as c7,
	   T1."Active005" as c8,
	   T1."Active006" as c9,
	   T1."Active007" as c10,
	   T1."Active008" as c11,
	   T1."Active009" as c12,
	   T1."Active010" as c13,
	   T1."Client_DB" as c14,
	   T2."Code" as c15,
	   T2."NameDescription" as c16,
	   T2."Type" as c17,
	   T2."AnalysisCode" as c18,
	   T2."ResignedDate" as c19,
	   T2."NameDescription" as c20,
	   CASE WHEN (T1."Client_DB" BETWEEN '10' AND '19') THEN ('10') WHEN (T1."Client_DB" BETWEEN '20' AND '29') THEN ('20') WHEN (T1."Client_DB" BETWEEN '30' AND '39') THEN ('30') WHEN (T1."Client_DB" BETWEEN '40' AND '49') THEN ('40') WHEN (T1."Client_DB" BETWEEN '50' AND '59') THEN ('50') ELSE null END as c21,
	   '' as c22,
	   T1."Client_DB" as c23,
	   T3."LocationCode" as c24,
	   T3."Description" as c25,
	   T3."Description" as c26,
	   T1."Resource" || '_' || T1."Client_DB" as c27,
	   'abw.' as c28,
	   T4."Code" as c29,
	   T4."Description001" as c30,
	   T4."Description002" as c31,
	   CASE WHEN (T4."Code" IS NULL) THEN (T1."Active001") ELSE (T4."Code" || ' - ' || T4."Description002") END as c32,
	   (CASE WHEN (T4."Code" IS NULL) THEN (T1."Active001") ELSE (T4."Code" || ' - ' || T4."Description002") END) as c33,
	   '' as c34,
	   1 as c35,
	   T1."Date" as c36,
	   (CASE WHEN (T5."UserID" IS NOT NULL) THEN ('unproduktiv') ELSE ('produktiv') END) as c37,
	   T2."AnalysisCode" as c38,
	   T5."UserID" as c39,
	   T5."JobTitle" as c40,
	   CASE WHEN (T5."UserID" IS NOT NULL) THEN ('unproduktiv') ELSE ('produktiv') END as c41
from (((("AUTOLINE"."import"."WL_ExtraAvailability" T1 left outer join "AUTOLINE"."import"."WL_WorkshopResources" T2 on (T1."Resource" = T2."Code") and (T1."Client_DB" = T2."Client_DB")) left outer join "AUTOLINE"."import"."GB_CompanyLocations" T3 on T3."LocationCode" = T2."Client_DB") left outer join "AUTOLINE"."import"."WL_ReasonForXvail" T4 on (T1."Active001" = T4."Code") and (T1."Client_DB" = T4."Client_DB")) left outer join "AUTOLINE"."import"."GB_UserDetails" T5 on (od_left(T2."Code",6)) = T5."UserID")
where (((T1."Date" >= TIMESTAMP '2022-01-01 00:00:00.000') and (T1."Type" = 'R')) and (T2."Code" IS NOT NULL))

END SQL
COLUMN,0,Type
COLUMN,1,Resource
COLUMN,2,Date
COLUMN,3,Active001
COLUMN,4,Active002
COLUMN,5,Active003
COLUMN,6,Active004
COLUMN,7,Active005
COLUMN,8,Active006
COLUMN,9,Active007
COLUMN,10,Active008
COLUMN,11,Active009
COLUMN,12,Active010
COLUMN,13,Client Db
COLUMN,14,Code_Resource
COLUMN,15,Namedescription_Resource
COLUMN,16,Type_Resource
COLUMN,17,Analysiscode_Resource
COLUMN,18,Resigneddate_Resource
COLUMN,19,Monteur
COLUMN,20,Hauptbetrieb_ID
COLUMN,21,Hauptbetrieb_Name
COLUMN,22,Standort_ID
COLUMN,23,Locationcode
COLUMN,24,Description
COLUMN,25,Standort_Name
COLUMN,26,Monteur_eindeutig
COLUMN,27,Activity_Codes_Group1
COLUMN,28,Code_Reason
COLUMN,29,Description001_Reason
COLUMN,30,Description002_Reason
COLUMN,31,Activity_Codes_Group2
COLUMN,32,Activity_Desc
COLUMN,33,Kostenstelle
COLUMN,34,Abw.
COLUMN,35,Datum
COLUMN,36,Monteur_Gruppe
COLUMN,37,Monteur_Gruppe_2
COLUMN,38,Userid
COLUMN,39,Jobtitle
COLUMN,40,produktiv_unproduktiv