GAPS/Portal/System/IQD/Zeiten/Monteur_neu2.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Zeiten\Monteur_neu2.imr
TITLE,Monteur_neu2.imr
BEGIN SQL
select c1 as c1,
	   c2 as c2,
	   c3 as c3,
	   c4 as c4,
	   c5 as c5,
	   c6 as c6,
	   c7 as c7,
	   c8 as c8,
	   c9 as c9,
	   c10 as c10,
	   c11 as c11,
	   c12 as c12,
	   c13 as c13,
	   c14 as c14,
	   c15 as c15,
	   c16 as c16,
	   c17 as c17,
	   c18 as c18,
	   c19 as c19,
	   c20 as c20,
	   c21 as c21,
	   c22 as c22,
	   c23 as c23,
	   c24 as c24,
	   c25 as c25,
	   c26 as c26,
	   c27 as c27,
	   c28 as c28,
	   c29 as c29,
	   c30 as c30,
	   c31 as c31,
	   c32 as c32,
	   c33 as c33,
	   c34 as c34,
	   c35 as c35,
	   c36 as c36,
	   c37 as c37,
	   c38 as c38,
	   c39 as c39,
	   c40 as c40,
	   c41 as c41,
	   c42 as c42,
	   c43 as c43,
	   c44 as c44,
	   c45 as c45,
	   c46 as c46,
	   c47 as c47,
	   c48 as c48,
	   c49 as c49,
	   c50 as c50,
	   c51 as c51,
	   c52 as c52,
	   c53 as c53,
	   c54 as c54,
	   c55 as c55,
	   c56 as c56,
	   c57 as c57,
	   c58 as c58,
	   c59 as c59,
	   c60 as c60,
	   c61 as c61,
	   c62 as c62,
	   c63 as c63,
	   c64 as c64,
	   c65 as c65,
	   c66 as c66,
	   c67 as c67,
	   c68 as c68,
	   c69 as c69,
	   c70 as c70,
	   c71 as c71,
	   c72 as c72,
	   c73 as c73,
	   c74 as c74,
	   c75 as c75,
	   c76 as c76,
	   c77 as c77,
	   c78 as c78,
	   c79 as c79,
	   c80 as c80,
	   c81 as c81,
	   c82 as c82,
	   c83 as c83,
	   c84 as c84,
	   c85 as c85,
	   c86 as c86,
	   c87 as c87,
	   c88 as c88,
	   c89 as c89,
	   c90 as c90,
	   c91 as c91,
	   c92 as c92,
	   c93 as c93,
	   c94 as c94,
	   c95 as c95,
	   c96 as c96,
	   c97 as c97,
	   c98 as c98,
	   c99 as c99,
	   c100 as c100,
	   c101 as c101,
	   c102 as c102,
	   c103 as c103,
	   c104 as c104,
	   c105 as c105,
	   c106 as c106,
	   c107 as c107,
	   c108 as c108,
	   c109 as c109,
	   c110 as c110,
	   c111 as c111,
	   c112 as c112,
	   c113 as c113,
	   c114 as c114,
	   c115 as c115,
	   c116 as c116,
	   c117 as c117,
	   c118 as c118,
	   c119 as c119,
	   c120 as c120,
	   c121 as c121,
	   XMIN(c120 for c68,c3) as c122,
	   XMIN(c121 for c68,c3) as c123
from 
(select c241 as c1,
	   c240 as c2,
	   c166 as c3,
	   c239 as c4,
	   c238 as c5,
	   c237 as c6,
	   c236 as c7,
	   c235 as c8,
	   c234 as c9,
	   c233 as c10,
	   c232 as c11,
	   c231 as c12,
	   c230 as c13,
	   c229 as c14,
	   c228 as c15,
	   c227 as c16,
	   c226 as c17,
	   c225 as c18,
	   c224 as c19,
	   c223 as c20,
	   c222 as c21,
	   c221 as c22,
	   c220 as c23,
	   c219 as c24,
	   c218 as c25,
	   c217 as c26,
	   c216 as c27,
	   c215 as c28,
	   c214 as c29,
	   c213 as c30,
	   c212 as c31,
	   c211 as c32,
	   c210 as c33,
	   c209 as c34,
	   c208 as c35,
	   c207 as c36,
	   c206 as c37,
	   c205 as c38,
	   c204 as c39,
	   c203 as c40,
	   c202 as c41,
	   c201 as c42,
	   c200 as c43,
	   c199 as c44,
	   c198 as c45,
	   c197 as c46,
	   c196 as c47,
	   c195 as c48,
	   c194 as c49,
	   '' as c50,
	   '' as c51,
	   c193 as c52,
	   c192 as c53,
	   c191 as c54,
	   c190 as c55,
	   c189 as c56,
	   c188 as c57,
	   c187 as c58,
	   c186 as c59,
	   c185 as c60,
	   c184 as c61,
	   c183 as c62,
	   '1' as c63,
	   c182 as c64,
	   c181 as c65,
	   c180 as c66,
	   c179 as c67,
	   c178 as c68,
	   c177 as c69,
	   c176 as c70,
	   c175 as c71,
	   c174 as c72,
	   c173 as c73,
	   c172 as c74,
	   c171 as c75,
	   c170 as c76,
	   c169 as c77,
	   c168 as c78,
	   c167 as c79,
	   c166 as c80,
	   c165 as c81,
	   c164 as c82,
	   c163 as c83,
	   c162 as c84,
	   c161 as c85,
	   c160 as c86,
	   c159 as c87,
	   c158 as c88,
	   c157 as c89,
	   c156 as c90,
	   c155 as c91,
	   c154 as c92,
	   c153 as c93,
	   c140 as c94,
	   c152 as c95,
	   c151 as c96,
	   c150 as c97,
	   c149 as c98,
	   c148 as c99,
	   c147 as c100,
	   c146 as c101,
	   c145 as c102,
	   c144 as c103,
	   c143 as c104,
	   c142 as c105,
	   c141 as c106,
	   c140 as c107,
	   c139 as c108,
	   c138 as c109,
	   c137 as c110,
	   c136 as c111,
	   c135 as c112,
	   c134 as c113,
	   c133 as c114,
	   c132 as c115,
	   c131 as c116,
	   c130 as c117,
	   c129 as c118,
	   XSUM(c196 for c128) as c119,
	   XSUM(c170 for c128) as c120,
	   CASE WHEN ((XSUM(c196 for c128)) = 0) THEN ((XSUM(c170 for c128))) ELSE ((XSUM(c196 for c128))) END as c121
from 
(select ((asciiz(extract(YEAR FROM T1."WORK_TRANS_DATE"),4) || '-' || asciiz(extract(MONTH FROM T1."WORK_TRANS_DATE"),2) || '-' || asciiz(extract(DAY FROM T1."WORK_TRANS_DATE"),2)) || (CASE WHEN (T4."SEL_NAME" IS NOT NULL) THEN (T4."SEL_NAME") ELSE (T1."PERSON_NUMBER") END)) as c128,
	   ((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) / 60 as c129,
	   (((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100)) as c130,
	   ((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100) as c131,
	   ((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100) as c132,
	   ((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100) as c133,
	   (intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100 as c134,
	   (intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100 as c135,
	   (intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100 as c136,
	   (intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100 as c137,
	   (intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100 as c138,
	   (intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100 as c139,
	   T7."EMPLOYEE_GROUP" as c140,
	   T7."CONV_FLAG" as c141,
	   T7."PROGRAM" as c142,
	   T7."FUNCTION_CODE" as c143,
	   T7."HANDLER" as c144,
	   T7."TRANSACT_DATE" as c145,
	   T7."CH_WORK_PATTERN_ALLOWED" as c146,
	   T7."FLEX_PATTERN_ALLOWED" as c147,
	   T7."MIN_FLEX_HOURS" as c148,
	   T7."MAX_FLEX_HOURS" as c149,
	   T7."TRAINEE_YEARS" as c150,
	   T7."EXTERNAL_PERSON_NO" as c151,
	   T7."WORKSHOP_TEAM" as c152,
	   T7."WORK_LEADER_GROUP_ID" as c153,
	   T7."PROFESSION_GROUP_ID" as c154,
	   T7."JOB_END_DATE" as c155,
	   T7."JOB_START_DATE" as c156,
	   T7."EFFICIENCY_PRC" as c157,
	   T7."WAGE_NO" as c158,
	   T7."OVERWORK_CODE" as c159,
	   T7."FLEX_BALANCE" as c160,
	   T7."PERSON_ID" as c161,
	   T7."UNIQUE_IDENT" as c162,
	   CASE WHEN (T1."WORK_ACT_CODE" = '159 ') THEN (T1."WORK_USED_TIME") ELSE (0) END as c163,
	   CASE WHEN (T1."WORK_ACT_CODE" = '998 ') THEN (T1."WORK_USED_TIME") ELSE (0) END as c164,
	   CASE WHEN (T1."WORK_ACT_CODE" = '095 ') THEN (T1."WORK_USED_TIME") ELSE (0) END as c165,
	   T1."WORK_TRANS_DATE" as c166,
	   CASE WHEN (T7."EMPLOYEE_GROUP" IN ('D ')) THEN ('Lehrling Lgb.') WHEN (T7."EMPLOYEE_GROUP" IN ('E ')) THEN ('Lehrling H.haus') WHEN (T7."EMPLOYEE_GROUP" IN ('F ')) THEN ('Meister Lgb.') WHEN (T7."EMPLOYEE_GROUP" IN ('G ')) THEN ('Meister H.haus') WHEN (T7."EMPLOYEE_GROUP" IN ('H ')) THEN ('Gesellen Lgb.') WHEN (T7."EMPLOYEE_GROUP" IN ('I ')) THEN ('Gesellen H.haus') WHEN (T7."EMPLOYEE_GROUP" IN ('J ')) THEN ('Karosserie') WHEN (T7."EMPLOYEE_GROUP" IN ('K ')) THEN ('Lack') WHEN (T7."EMPLOYEE_GROUP" IN ('L ')) THEN ('ausgeschieden') WHEN (T7."EMPLOYEE_GROUP" IN ('12')) THEN ('Test') ELSE null END as c167,
	   (CASE WHEN ((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" <> 0.00)) THEN (T1."WORK_USED_TIME") WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 330)) THEN (5.5) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 450)) THEN (7.5) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 240)) THEN (4) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 435)) THEN (7.25) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 375)) THEN (6.25) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 300)) THEN (5) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 390)) THEN (6.5) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 420)) THEN (7) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 315)) THEN (5.25) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 345)) THEN (5.75) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 360)) THEN (6) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 465)) THEN (7.75) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 480)) THEN (8) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 495)) THEN (8.25) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 510)) THEN (8.5) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 630)) THEN (10.5) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 660)) THEN (11) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 750)) THEN (12.5) ELSE (0) END) + (CASE WHEN ((T1."WORK_ACT_CODE" = '101 ') and (T1."WORK_USED_TIME" <> 0.00)) THEN (T1."WORK_USED_TIME") WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 330)) THEN (5.5) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 450)) THEN (7.5) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 240)) THEN (4) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 435)) THEN (7.25) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 375)) THEN (6.25) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 300)) THEN (5) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 390)) THEN (6.5) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 420)) THEN (7) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 315)) THEN (5.25) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 345)) THEN (5.75) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 360)) THEN (6) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 465)) THEN (7.75) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 480)) THEN (8) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 495)) THEN (8.25) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 510)) THEN (8.5) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 630)) THEN (10.5) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 660)) THEN (11) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 750)) THEN (12.5) ELSE (0) END) + (CASE WHEN (T1."WORK_ACT_CODE" = '102 ') THEN (T1."WORK_USED_TIME") ELSE (0) END) + (CASE WHEN ((T1."WORK_ACT_CODE" = '105 ') and (T1."WORK_USED_TIME" <> 0.00)) THEN (T1."WORK_USED_TIME") WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 330)) THEN (5.5) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 450)) THEN (7.5) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 240)) THEN (4) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 435)) THEN (7.25) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 375)) THEN (6.25) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 300)) THEN (5) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 390)) THEN (6.5) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 420)) THEN (7) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 315)) THEN (5.25) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 345)) THEN (5.75) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 360)) THEN (6) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 465)) THEN (7.75) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 480)) THEN (8) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 495)) THEN (8.25) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 510)) THEN (8.5) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 630)) THEN (10.5) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 660)) THEN (11) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 750)) THEN (12.5) ELSE (0) END) + (CASE WHEN (T1."WORK_ACT_CODE" = '107 ') THEN (T1."WORK_USED_TIME") ELSE (0) END) + (CASE WHEN (T1."WORK_ACT_CODE" = '120 ') THEN (T1."WORK_USED_TIME") ELSE (0) END) + (CASE WHEN (T1."WORK_ACT_CODE" = '095 ') THEN (T1."WORK_USED_TIME") ELSE (0) END) + (CASE WHEN ((T1."WORK_ACT_CODE" = '113 ') and (T1."WORK_USED_TIME" <> 0.00)) THEN (T1."WORK_USED_TIME") WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 330)) THEN (5.5) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 450)) THEN (7.5) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 240)) THEN (4) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 435)) THEN (7.25) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 375)) THEN (6.25) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 300)) THEN (5) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 390)) THEN (6.5) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 420)) THEN (7) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 315)) THEN (5.25) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 345)) THEN (5.75) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 360)) THEN (6) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 465)) THEN (7.75) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 480)) THEN (8) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 495)) THEN (8.25) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 510)) THEN (8.5) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 630)) THEN (10.5) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 660)) THEN (11) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 750)) THEN (12.5) ELSE (0) END) as c168,
	   (CASE WHEN ((od_left(T1."WORK_ACT_CODE",2)) = '02') THEN (T1."WORK_USED_TIME") WHEN (T1."WORK_ACT_CODE" IN ('24','25')) THEN (T1."WORK_USED_TIME") ELSE (0) END) + (CASE WHEN (T1."WORK_ACT_CODE" IN ('011 ','013')) THEN (T1."WORK_USED_TIME") ELSE (0) END) + (CASE WHEN (T1."WORK_ACT_CODE" IN ('999','012','014')) THEN (T1."WORK_USED_TIME") ELSE (0) END) + (CASE WHEN ((od_left(T1."WORK_ACT_CODE",2)) IN ('06','05')) THEN (T1."WORK_USED_TIME") ELSE (0) END) + (CASE WHEN (T1."WORK_ACT_CODE" IN ('091 ')) THEN (T1."WORK_USED_TIME") ELSE (0) END) + (CASE WHEN ((od_left(T1."WORK_ACT_CODE",3)) = '092') THEN (T1."WORK_USED_TIME") ELSE (0) END) + (CASE WHEN (T1."WORK_ACT_CODE" = '159 ') THEN (T1."WORK_USED_TIME") ELSE (0) END) + (CASE WHEN (T1."WORK_ACT_CODE" IN ('250','251','252','253','254','255','257','258')) THEN (T1."WORK_USED_TIME") ELSE (0) END) + (CASE WHEN (T1."WORK_ACT_CODE" = '998 ') THEN (T1."WORK_USED_TIME") ELSE (0) END) as c169,
	   (CASE WHEN ((CASE WHEN ((T6."CUSTOMER_GROUP" BETWEEN '10' AND '59') or (T6."CUSTOMER_GROUP" LIKE '7%')) THEN ('extern') WHEN (T6."CUSTOMER_GROUP" LIKE '6%') THEN ('GWL') WHEN (((T6."CUSTOMER_GROUP" LIKE '9%') or (T6."PMT_TERM" = 'IN')) or ((od_left(T6."CUSTOMER_GROUP",1)) BETWEEN 'A' AND 'Z')) THEN ('intern') ELSE null END) = 'extern') THEN (T1."WORK_USED_TIME") ELSE (0) END) + (CASE WHEN ((CASE WHEN ((T6."CUSTOMER_GROUP" BETWEEN '10' AND '59') or (T6."CUSTOMER_GROUP" LIKE '7%')) THEN ('extern') WHEN (T6."CUSTOMER_GROUP" LIKE '6%') THEN ('GWL') WHEN (((T6."CUSTOMER_GROUP" LIKE '9%') or (T6."PMT_TERM" = 'IN')) or ((od_left(T6."CUSTOMER_GROUP",1)) BETWEEN 'A' AND 'Z')) THEN ('intern') ELSE null END) = 'GWL') THEN (T1."WORK_USED_TIME") ELSE (0) END) + (CASE WHEN ((CASE WHEN ((T6."CUSTOMER_GROUP" BETWEEN '10' AND '59') or (T6."CUSTOMER_GROUP" LIKE '7%')) THEN ('extern') WHEN (T6."CUSTOMER_GROUP" LIKE '6%') THEN ('GWL') WHEN (((T6."CUSTOMER_GROUP" LIKE '9%') or (T6."PMT_TERM" = 'IN')) or ((od_left(T6."CUSTOMER_GROUP",1)) BETWEEN 'A' AND 'Z')) THEN ('intern') ELSE null END) = 'intern') THEN (T1."WORK_USED_TIME") ELSE (0) END) as c170,
	   CASE WHEN (T1."WORK_ACT_CODE" IN ('250','251','252','253','254','255','257','258')) THEN (T1."WORK_USED_TIME") ELSE (0) END as c171,
	   CASE WHEN ((CASE WHEN ((T6."CUSTOMER_GROUP" BETWEEN '10' AND '59') or (T6."CUSTOMER_GROUP" LIKE '7%')) THEN ('extern') WHEN (T6."CUSTOMER_GROUP" LIKE '6%') THEN ('GWL') WHEN (((T6."CUSTOMER_GROUP" LIKE '9%') or (T6."PMT_TERM" = 'IN')) or ((od_left(T6."CUSTOMER_GROUP",1)) BETWEEN 'A' AND 'Z')) THEN ('intern') ELSE null END) = 'intern') THEN (T1."WORK_USED_TIME") ELSE (0) END as c172,
	   CASE WHEN ((CASE WHEN ((T6."CUSTOMER_GROUP" BETWEEN '10' AND '59') or (T6."CUSTOMER_GROUP" LIKE '7%')) THEN ('extern') WHEN (T6."CUSTOMER_GROUP" LIKE '6%') THEN ('GWL') WHEN (((T6."CUSTOMER_GROUP" LIKE '9%') or (T6."PMT_TERM" = 'IN')) or ((od_left(T6."CUSTOMER_GROUP",1)) BETWEEN 'A' AND 'Z')) THEN ('intern') ELSE null END) = 'GWL') THEN (T1."WORK_USED_TIME") ELSE (0) END as c173,
	   CASE WHEN ((CASE WHEN ((T6."CUSTOMER_GROUP" BETWEEN '10' AND '59') or (T6."CUSTOMER_GROUP" LIKE '7%')) THEN ('extern') WHEN (T6."CUSTOMER_GROUP" LIKE '6%') THEN ('GWL') WHEN (((T6."CUSTOMER_GROUP" LIKE '9%') or (T6."PMT_TERM" = 'IN')) or ((od_left(T6."CUSTOMER_GROUP",1)) BETWEEN 'A' AND 'Z')) THEN ('intern') ELSE null END) = 'extern') THEN (T1."WORK_USED_TIME") ELSE (0) END as c174,
	   CASE WHEN ((T6."CUSTOMER_GROUP" BETWEEN '10' AND '59') or (T6."CUSTOMER_GROUP" LIKE '7%')) THEN ('extern') WHEN (T6."CUSTOMER_GROUP" LIKE '6%') THEN ('GWL') WHEN (((T6."CUSTOMER_GROUP" LIKE '9%') or (T6."PMT_TERM" = 'IN')) or ((od_left(T6."CUSTOMER_GROUP",1)) BETWEEN 'A' AND 'Z')) THEN ('intern') ELSE null END as c175,
	   T6."CUSTOMER_GROUP" as c176,
	   T6."ORDER_NUMBER" as c177,
	   CASE WHEN (T4."SEL_NAME" IS NOT NULL) THEN (T4."SEL_NAME") ELSE (T1."PERSON_NUMBER") END as c178,
	   (substring(T5."DEPARTMENT_TYPE_ID" from 4 for 1)) as c179,
	   T5."DESCRIPTION" as c180,
	   T5."DEPARTMENT_TYPE_ID" as c181,
	   (od_left(T5."DEPARTMENT_TYPE_ID",2)) as c182,
	   CASE WHEN (T1."WORK_ACT_CODE" = '120 ') THEN (T1."WORK_USED_TIME") ELSE (0) END as c183,
	   CASE WHEN ((T1."WORK_ACT_CODE" = '113 ') and (T1."WORK_USED_TIME" <> 0.00)) THEN (T1."WORK_USED_TIME") WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 330)) THEN (5.5) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 450)) THEN (7.5) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 240)) THEN (4) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 435)) THEN (7.25) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 375)) THEN (6.25) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 300)) THEN (5) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 390)) THEN (6.5) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 420)) THEN (7) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 315)) THEN (5.25) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 345)) THEN (5.75) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 360)) THEN (6) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 465)) THEN (7.75) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 480)) THEN (8) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 495)) THEN (8.25) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 510)) THEN (8.5) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 630)) THEN (10.5) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 660)) THEN (11) WHEN ((((T1."WORK_ACT_CODE" IN ('113 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 750)) THEN (12.5) ELSE (0) END as c184,
	   CASE WHEN (T1."WORK_ACT_CODE" = '107 ') THEN (T1."WORK_USED_TIME") ELSE (0) END as c185,
	   CASE WHEN ((T1."WORK_ACT_CODE" = '105 ') and (T1."WORK_USED_TIME" <> 0.00)) THEN (T1."WORK_USED_TIME") WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 330)) THEN (5.5) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 450)) THEN (7.5) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 240)) THEN (4) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 435)) THEN (7.25) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 375)) THEN (6.25) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 300)) THEN (5) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 390)) THEN (6.5) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 420)) THEN (7) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 315)) THEN (5.25) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 345)) THEN (5.75) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 360)) THEN (6) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 465)) THEN (7.75) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 480)) THEN (8) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 495)) THEN (8.25) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 510)) THEN (8.5) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 630)) THEN (10.5) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 660)) THEN (11) WHEN ((((T1."WORK_ACT_CODE" IN ('105 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 750)) THEN (12.5) ELSE (0) END as c186,
	   CASE WHEN (T1."WORK_ACT_CODE" = '102 ') THEN (T1."WORK_USED_TIME") ELSE (0) END as c187,
	   CASE WHEN ((T1."WORK_ACT_CODE" = '101 ') and (T1."WORK_USED_TIME" <> 0.00)) THEN (T1."WORK_USED_TIME") WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 330)) THEN (5.5) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 450)) THEN (7.5) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 240)) THEN (4) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 435)) THEN (7.25) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 375)) THEN (6.25) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 300)) THEN (5) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 390)) THEN (6.5) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 420)) THEN (7) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 315)) THEN (5.25) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 345)) THEN (5.75) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 360)) THEN (6) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 465)) THEN (7.75) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 480)) THEN (8) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 495)) THEN (8.25) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 510)) THEN (8.5) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 630)) THEN (10.5) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 660)) THEN (11) WHEN ((((T1."WORK_ACT_CODE" IN ('101 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 750)) THEN (12.5) ELSE (0) END as c188,
	   CASE WHEN ((od_left(T1."WORK_ACT_CODE",3)) = '092') THEN (T1."WORK_USED_TIME") ELSE (0) END as c189,
	   CASE WHEN ((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" <> 0.00)) THEN (T1."WORK_USED_TIME") WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 330)) THEN (5.5) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 450)) THEN (7.5) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 240)) THEN (4) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 435)) THEN (7.25) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 375)) THEN (6.25) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 300)) THEN (5) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 390)) THEN (6.5) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 420)) THEN (7) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 315)) THEN (5.25) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 345)) THEN (5.75) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 360)) THEN (6) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 465)) THEN (7.75) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 480)) THEN (8) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 495)) THEN (8.25) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 510)) THEN (8.5) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 630)) THEN (10.5) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 660)) THEN (11) WHEN ((((T1."WORK_ACT_CODE" IN ('090 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 750)) THEN (12.5) ELSE (0) END as c190,
	   CASE WHEN (T1."WORK_ACT_CODE" IN ('091 ')) THEN (T1."WORK_USED_TIME") ELSE (0) END as c191,
	   CASE WHEN ((od_left(T1."WORK_ACT_CODE",2)) IN ('06','05')) THEN (T1."WORK_USED_TIME") ELSE (0) END as c192,
	   CASE WHEN ((od_left(T1."WORK_ACT_CODE",2)) = '02') THEN (T1."WORK_USED_TIME") WHEN (T1."WORK_ACT_CODE" IN ('24','25')) THEN (T1."WORK_USED_TIME") ELSE (0) END as c193,
	   CASE WHEN (T1."WORK_ACT_CODE" IN ('999','012','014')) THEN (T1."WORK_USED_TIME") ELSE (0) END as c194,
	   CASE WHEN (T1."WORK_ACT_CODE" IN ('011 ','013')) THEN (T1."WORK_USED_TIME") ELSE (0) END as c195,
	   CASE WHEN ((T1."WORK_ACT_CODE" IN ('000 ')) and (T1."WORK_USED_TIME" <> 0.00)) THEN (T1."WORK_USED_TIME") WHEN ((((T1."WORK_ACT_CODE" IN ('000 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 330)) THEN (5.5) WHEN ((((T1."WORK_ACT_CODE" IN ('000 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 450)) THEN (7.5) WHEN ((((T1."WORK_ACT_CODE" IN ('000 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 240)) THEN (4) WHEN ((((T1."WORK_ACT_CODE" IN ('000 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 435)) THEN (7.25) WHEN ((((T1."WORK_ACT_CODE" IN ('000 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 375)) THEN (6.25) WHEN ((((T1."WORK_ACT_CODE" IN ('000 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 300)) THEN (5) WHEN ((((T1."WORK_ACT_CODE" IN ('000 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 390)) THEN (6.5) WHEN ((((T1."WORK_ACT_CODE" IN ('000 ')) and (T1."WORK_USED_TIME" = 0.00)) and (T1."FUNCTION_CODE" = 'E390')) and (((((intdiv(T1."DAYTIME_END_1",100)) * 60 + T1."DAYTIME_END_1" - (intdiv(T1."DAYTIME_END_1",100)) * 100) - ((intdiv(T1."DAYTIME_START_1",100)) * 60 + T1."DAYTIME_START_1" - (intdiv(T1."DAYTIME_START_1",100)) * 100)) + (((intdiv(T1."DAYTIME_END_2",100)) * 60 + T1."DAYTIME_END_2" - (intdiv(T1."DAYTIME_END_2",100)) * 100) - ((intdiv(T1."DAYTIME_START_2",100)) * 60 + T1."DAYTIME_START_2" - (intdiv(T1."DAYTIME_START_2",100)) * 100)) + (((intdiv(T1."DAYTIME_END_3",100)) * 60 + T1."DAYTIME_END_3" - (intdiv(T1."DAYTIME_END_3",100)) * 100) - ((intdiv(T1."DAYTIME_START_3",100)) * 60 + T1."DAYTIME_START_3" - (intdiv(T1."DAYTIME_START_3",100)) * 100))) = 420)) THEN (7) ELSE (0) END as c196,
	   T4."SEL_FAMILY_NAME" as c197,
	   T4."SEL_FIRST_NAME" as c198,
	   T4."SEL_DEPARTMENT" as c199,
	   T4."SEL_NAME" as c200,
	   T4."SELLER_CODE" as c201,
	   T3."WORKLEADER_TEXT" as c202,
	   T3."WORK_LEADER_GROUP" as c203,
	   T2."ACTIVITY_TEXT" as c204,
	   T2."ACT_CODE" as c205,
	   T1."UNIQUE_IDENT" as c206,
	   T1."CONV_FLAG" as c207,
	   T1."FUNCTION_CODE" as c208,
	   T1."CLOCK_IN_PROGRAM" as c209,
	   T1."PROGRAM" as c210,
	   T1."REDUCE_TIME" as c211,
	   T1."EXTRACTED" as c212,
	   T1."DAYTIME_END_5" as c213,
	   T1."DAYTIME_START_5" as c214,
	   T1."DAYTIME_END_4" as c215,
	   T1."DAYTIME_START_4" as c216,
	   T1."DAYTIME_END_3" as c217,
	   T1."DAYTIME_START_3" as c218,
	   T1."DAYTIME_END_2" as c219,
	   T1."DAYTIME_START_2" as c220,
	   T1."DAYTIME_END_1" as c221,
	   T1."DAYTIME_START_1" as c222,
	   T1."WORK_SALESPRICE" as c223,
	   T1."WORK_PRINT_INVOICE" as c224,
	   T1."WORK_ESTIM_TIME" as c225,
	   T1."WORK_INVOICED_TIME" as c226,
	   T1."WORK_USED_TIME" as c227,
	   T1."WORK_ORDER_TIME" as c228,
	   T1."REPAIR_NAME" as c229,
	   T1."REPAIR_CODE" as c230,
	   T1."WORK_END_TIME" as c231,
	   T1."WORK_END_DATE" as c232,
	   T1."WORK_ACT_TEXT" as c233,
	   T1."WORK_ACT_CODE" as c234,
	   T1."HANDLER" as c235,
	   T1."WORK_STATE_CODE" as c236,
	   T1."LINE_NUMBER" as c237,
	   T1."ORDER_NUMBER" as c238,
	   T1."WORK_START_TIME" as c239,
	   T1."PERSON_NUMBER" as c240,
	   T1."PERSON_GROUP" as c241
from ((((((("deop01"."dbo"."TIME_CONTROL_END" T1 left outer join "deop01"."dbo"."vPP93" T2 on T1."WORK_ACT_CODE" = T2."ACT_CODE") left outer join "deop01"."dbo"."vPP43" T4 on T1."PERSON_NUMBER" = T4."SELLER_CODE") left outer join "deop01"."dbo"."PROFILE" T8 on T8."PROFILE_CODE" = T4."SELLER_CODE") left outer join "deop01"."dbo"."EMPLOYEE" T7 on T7."PERSON_ID" = T8."PERSON_ID") left outer join "deop01"."dbo"."vPP91" T3 on T7."WORK_LEADER_GROUP_ID" = T3."WORK_LEADER_GROUP") left outer join "deop01"."dbo"."DEPARTMENT_TYPE" T5 on T4."SEL_DEPARTMENT" = T5."DEPARTMENT_TYPE_ID") left outer join "deop01"."dbo"."ORDER_HEADER" T6 on T1."ORDER_NUMBER" = T6."ORDER_NUMBER")
where (T1."WORK_TRANS_DATE" >= TIMESTAMP '2018-01-01 00:00:00.000')
) D2
) D1
order by c68 asc,c80 asc

END SQL
COLUMN,0,Person Group
COLUMN,1,Person Number
COLUMN,2,Work Trans Date
COLUMN,3,Work Start Time
COLUMN,4,Order Number
COLUMN,5,Line Number
COLUMN,6,Work State Code
COLUMN,7,Handler
COLUMN,8,Work Act Code
COLUMN,9,Work Act Text
COLUMN,10,Work End Date
COLUMN,11,Work End Time
COLUMN,12,Repair Code
COLUMN,13,Repair Name
COLUMN,14,Work Order Time
COLUMN,15,Work Used Time
COLUMN,16,Work Invoiced Time
COLUMN,17,Work Estim Time
COLUMN,18,Work Print Invoice
COLUMN,19,Work Salesprice
COLUMN,20,Daytime Start 1
COLUMN,21,Daytime End 1
COLUMN,22,Daytime Start 2
COLUMN,23,Daytime End 2
COLUMN,24,Daytime Start 3
COLUMN,25,Daytime End 3
COLUMN,26,Daytime Start 4
COLUMN,27,Daytime End 4
COLUMN,28,Daytime Start 5
COLUMN,29,Daytime End 5
COLUMN,30,Extracted
COLUMN,31,Reduce Time
COLUMN,32,Program
COLUMN,33,Clock In Program
COLUMN,34,Function Code
COLUMN,35,Conv Flag
COLUMN,36,Unique Ident
COLUMN,37,Act Code
COLUMN,38,Activity Text
COLUMN,39,Work Leader Group
COLUMN,40,Workleader Text
COLUMN,41,Seller Code
COLUMN,42,Sel Name
COLUMN,43,Sel Department
COLUMN,44,Sel First Name
COLUMN,45,Sel Family Name
COLUMN,46,Anwesenheit
COLUMN,47,Nacharbeit
COLUMN,48,Wartezeit
COLUMN,49,Prob.fahrt/Endkontr._
COLUMN,50,GW-Bewertung_
COLUMN,51,Unproduktiv
COLUMN,52,Hilfslohn
COLUMN,53,Schulung intern
COLUMN,54,Schulung extern
COLUMN,55,Betriebsrat
COLUMN,56,Krank
COLUMN,57,Arzt
COLUMN,58,Urlaub
COLUMN,59,Sonderurlaub
COLUMN,60,Feiertag
COLUMN,61,Fehlstunden
COLUMN,62,Hauptbetrieb
COLUMN,63,Standort
COLUMN,64,Department Type Id
COLUMN,65,Description
COLUMN,66,Kostenstelle
COLUMN,67,Monteur
COLUMN,68,Order Number_Auftrag
COLUMN,69,Customer Group
COLUMN,70,Umsatzart
COLUMN,71,Extern
COLUMN,72,GWL
COLUMN,73,Intern
COLUMN,74,Überstunden
COLUMN,75,produktiv
COLUMN,76,unproduktiv
COLUMN,77,abwesend
COLUMN,78,Monteur_Gruppe
COLUMN,79,Datum
COLUMN,80,Überstundenabbau
COLUMN,81,Mehrarbeit
COLUMN,82,Sucharbeit/Endkontrolle
COLUMN,83,Unique Ident
COLUMN,84,Person Id
COLUMN,85,Flex Balance
COLUMN,86,Overwork Code
COLUMN,87,Wage No
COLUMN,88,Efficiency Prc
COLUMN,89,Job Start Date
COLUMN,90,Job End Date
COLUMN,91,Profession Group Id
COLUMN,92,Work Leader Group Id
COLUMN,93,Employee Group
COLUMN,94,Workshop Team
COLUMN,95,External Person No
COLUMN,96,Trainee Years
COLUMN,97,Max Flex Hours
COLUMN,98,Min Flex Hours
COLUMN,99,Flex Pattern Allowed
COLUMN,100,Ch Work Pattern Allowed
COLUMN,101,Transact Date
COLUMN,102,Handler
COLUMN,103,Function Code_Employee
COLUMN,104,Program
COLUMN,105,Conv Flag
COLUMN,106,Employee Group
COLUMN,107,Start1
COLUMN,108,End1
COLUMN,109,Start2
COLUMN,110,End2
COLUMN,111,Start3
COLUMN,112,End3
COLUMN,113,DiffDaytime1
COLUMN,114,DiffDaytime2
COLUMN,115,DiffDaytime3
COLUMN,116,Summe in Minuten
COLUMN,117,Summe in Stunden
COLUMN,118,Summe Anwesenheit
COLUMN,119,Summe produktiv
COLUMN,120,Summe Anwes_neu
COLUMN,121,prod. gestemp.
COLUMN,122,anwesend