COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Zeiten\Sollstunden_neu.imr
TITLE,Sollstunden_neu.imr
BEGIN SQL
select T1."UNIQUE_IDENT" as c1,
	   T1."PROFILE_ID" as c2,
	   T1."PROFILE_CODE" as c3,
	   T1."FUNCTION_CODE" as c4,
	   T1."TRANSACT_DATE_LONG" as c5,
	   T1."START_DATE_TIME" as c6,
	   T1."END_DATE_TIME" as c7,
	   T1."OVERWORK_PERMISSION_START" as c8,
	   T1."OVERWORK_PERMISSION_END" as c9,
	   T1."WORK_PATTERN" as c10,
	   T1."FLEX_WORK_PATTERN" as c11,
	   T1."EARLIEST_START_TIME" as c12,
	   T1."LATEST_START_TIME" as c13,
	   T1."CORE_WORKING_HOURS" as c14,
	   T1."EARLIEST_END_TIME" as c15,
	   T1."LATEST_END_TIME" as c16,
	   T1."DAY_TYPE" as c17,
	   T1."TIME_ACCOUNT" as c18,
	   T1."PUNCH_PERIOD_ENDED" as c19
from "deop01"."dbo"."PUNCH_PERIOD_START" T1

END SQL
COLUMN,0,Unique Ident
COLUMN,1,Profile Id
COLUMN,2,Profile Code
COLUMN,3,Function Code
COLUMN,4,Transact Date Long
COLUMN,5,Start Date Time
COLUMN,6,End Date Time
COLUMN,7,Overwork Permission Start
COLUMN,8,Overwork Permission End
COLUMN,9,Work Pattern
COLUMN,10,Flex Work Pattern
COLUMN,11,Earliest Start Time
COLUMN,12,Latest Start Time
COLUMN,13,Core Working Hours
COLUMN,14,Earliest End Time
COLUMN,15,Latest End Time
COLUMN,16,Day Type
COLUMN,17,Time Account
COLUMN,18,Punch Period Ended