C11/System/LOCOSOFT/IQD/Zeit/Zeit_Sollzeit.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Locosoft_GC
DATASOURCENAME,C:\GlobalCube\System\LOCOSOFT\IQD\zeit\Zeit_Sollzeit.imr
TITLE,Zeit_Sollzeit.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,
	   '1' as c9,
	   '01' as c10,
	   (rtrim((cast_numberToString(cast_integer(T1."employee_number"))))) || ' - ' || T1."name" as c11,
	   'Sollzeit' as c12,
	   '' as c13,
	   T2."is_latest_record" as c14,
	   T2."employee_number" as c15,
	   T2."validity_date" as c16,
	   T2."dayofweek" as c17,
	   T2."work_duration" as c18,
	   T2."worktime_start" as c19,
	   T2."worktime_end" as c20,
	   T3."datum" as c21,
	   T3."wochentage_id" as c22,
	   T2."work_duration" as c23,
	   T3."datum" as c24,
	   '1' as c25,
	   'AH Lutz' as c26,
	   '01' as c27,
	   'FFB' as c28,
	   'Monteure' as c29,
	   'Monteure' as c30,
	   'Sollzeit' as c31,
	   '' as c32,
	   'Sollzeit' as c33
from "dbo"."employees" T1,
	"LOCOSOFT"."dbo"."employees_worktimes" T2,
	QSS."C:\GlobalCube\System\LOCOSOFT\IQD\Belege\current_date_fuer_ims.ims" T3
where (T1."employee_number" = T2."employee_number")
and (((T3."arbeitstag_mofr" = 1) and (T2."dayofweek" = (cinteger(nconvert(T3."wochentage_id"),0)))) and (T3."datum" >= TIMESTAMP '2023-05-01 00:00:00.000'))
order by c1 asc,c21 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,Hauptbetrieb
COLUMN,9,Standort
COLUMN,10,Monteur
COLUMN,11,Zeitkategorie
COLUMN,12,Zeitkategorie2
COLUMN,13,Is Latest Record
COLUMN,14,Employee Number
COLUMN,15,Validity Date
COLUMN,16,Dayofweek
COLUMN,17,Work Duration
COLUMN,18,Worktime Start
COLUMN,19,Worktime End
COLUMN,20,Datum
COLUMN,21,Wochentage Id
COLUMN,22,Soll-Zeit
COLUMN,23,Invoice Date
COLUMN,24,Hauptbetrieb_ID
COLUMN,25,Hauptbetrieb_Name
COLUMN,26,Standort_ID
COLUMN,27,Standort_Name
COLUMN,28,Monteur_Gruppe
COLUMN,29,Monteur_Gruppe_2
COLUMN,30,Activity_Codes_Group1
COLUMN,31,Activity_Codes_Group2
COLUMN,32,Activity_Desc