C11/System/WERWISO/IQD/OP/Personal.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,werwiso
DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\op\Personal.imr
TITLE,Personal.imr
BEGIN SQL
select T1."Filial_ID" as c1,
	   T1."Personalnummer" as c2,
	   T1."Name" as c3,
	   T1."Vorname" as c4,
	   T1."Personalart" as c5,
	   T1."Leistungsgruppe" as c6,
	   T1."Status" as c7,
	   T1."Eintrittsdatum" as c8,
	   T1."Austrittsdatum" as c9,
	   (asciiz(round(T1."Personalnummer",0,0),4)) as c10,
	   CASE WHEN ((substring(((asciiz(round(T1."Personalnummer",0,0),4))) from 1 for 1)) = '0') THEN ((substring(((asciiz(round(T1."Personalnummer",0,0),4))) from 2 for 3))) ELSE ((substring(((asciiz(round(T1."Personalnummer",0,0),4))) from 1 for 4))) END as c11
from "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."personal" T1

END SQL
COLUMN,0,Filial Id
COLUMN,1,Personalnummer
COLUMN,2,Name
COLUMN,3,Vorname
COLUMN,4,Personalart
COLUMN,5,Leistungsgruppe
COLUMN,6,Status
COLUMN,7,Eintrittsdatum
COLUMN,8,Austrittsdatum
COLUMN,9,Pers-Nr_zwischen
COLUMN,10,Pers-Nr