COGNOS QUERY
STRUCTURE,1,1
DATABASE,Locosoft_GC
DATASOURCENAME,C:\Gaps_Locosoft_neu\Portal\System\IQD\Zeit\Zeit_Abwesenheit.imr
TITLE,Zeit_Abwesenheit.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."date" as c10,
	   T2."type" as c11,
	   T2."is_payed" as c12,
	   T2."day_contingent" as c13,
	   T2."reason" as c14,
	   T2."booking_flag" as c15,
	   T3."id" as c16,
	   T3."description" as c17,
	   T3."is_annual_vacation" as c18,
	   T4."type" as c19,
	   T4."description" as c20,
	   '1' as c21,
	   '01' as c22,
	   (cast_numberToString(cast_integer(T1."employee_number"))) || ' - ' || T1."name" as c23,
	   8 as c24,
	   T2."day_contingent" * 8 as c25,
	   'Abwesenheit' as c26,
	   T3."id" || ' - ' || T3."description" as c27,
	   (T2."day_contingent" * 8) as c28,
	   T2."date" as c29,
	   '' as c30
from "dbo"."employees" T1,
	(("dbo"."absence_calendar" T2 left outer join "dbo"."absence_reasons" T3 on T2."reason" = T3."id") left outer join "dbo"."absence_types" T4 on T2."type" = T4."type")
where (T1."employee_number" = T2."employee_number")
and (T1."mechanic_number" IS NOT NULL)
order by c1 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_Absence_Cal
COLUMN,9,Date_Absence_Cal
COLUMN,10,Type_Absence_Cal
COLUMN,11,Is Payed_Absence_Cal
COLUMN,12,Day Contingent_Absence_Cal
COLUMN,13,Reason_Absence_Cal
COLUMN,14,Booking Flag_Absence_Cal
COLUMN,15,Id_Absence_Reas
COLUMN,16,Description_Absence_Reas
COLUMN,17,Is Annual Vacation_Absence_Reas
COLUMN,18,Type_Absence_Types
COLUMN,19,Description_Absence_Types
COLUMN,20,Hauptbetrieb
COLUMN,21,Standort
COLUMN,22,Monteur
COLUMN,23,Dummy_Arbeitszeit_Tag
COLUMN,24,Abwesenheit
COLUMN,25,Zeitkategorie
COLUMN,26,Zeitkategorie2
COLUMN,27,Ges. Std.
COLUMN,28,Datum
COLUMN,29,Order Number