Interpretation OracleCXRT 5Qy7jNVxMXl6axUQ+YSs4+MaaS3dedIB8nohTPS0LLv8OGkCUHz6pPd3faVwSeyf/1SRoV93wk3zeykEc7Qs99w4iw1efJJde25tRPXs67/kLJHvTwN63Xx86Cg= OracleCXRT Q_MASTER_CX FLIGHT_NO_IN,System.String FLIGHT_NO_OUT,System.String DAY_PERIOD,System.String STA_HRS,System.String TASK_START_HRS,System.String TASK_END_HRS,System.String FULLNAME_W_SKILL,System.String FULLNAME,System.String NAME_WITH_ERN,System.String SECONDSORTSHIFTTASKLIST,System.String FLIGHTNOANDTASKREMARK,System.String FLIGHTNOANDTASKREMARKANDLOC,System.String TASK_START,System.DateTime TASK_END,System.DateTime TASK_DURATION,System.Decimal TASK_REMARK,System.String TASK_TYPE,System.String TASK_REQUIREMENT,System.String TASK_STATE,System.String TASK_DEPT,System.String WORK_AREA,System.String TASK_START_LOC,System.String TASK_END_LOC,System.String NAME,System.String FIRST_NAME,System.String STAFF_NO,System.String SHIFT_START_SCH,System.DateTime SHIFT_END_SCH,System.DateTime SHIFT_START_ACT,System.DateTime SHIFT_END_ACT,System.DateTime AIRLINE_IN,System.String FLN_IN,System.String STA,System.DateTime ATA,System.DateTime ARR_FM,System.String ESTIMATED_START,System.DateTime ESTIMATED_END,System.DateTime ACTUAL_SHIFT_START,System.String ACTUAL_SHIFT_END,System.String ACTUAL_DUTY_TIME,System.String AIRLINE_OUT,System.String FLN_OUT,System.String STD,System.DateTime DEP_TO,System.String HIDDEN_SKILL,System.String ETA,System.DateTime ETD,System.DateTime DB_ID_IN,System.String DB_ID_OUT,System.String END_MUTATION_CODE,System.String MAIN_MUTATION_CODE,System.String START_MUTATION_CODE,System.String SHIFT_STATUS,System.String SHIFT_REMARK,System.String REASON_CODE,System.String STAFF_SKILL,System.String SDC_Y_MPO,System.Decimal STAFF_QUALIFICATION,System.String STAFF_WORKAREA,System.String SHIFT_WORKAREA,System.String MAINORDERNO,System.Decimal SUBORDERNO,System.Decimal SUBORDERAUTOID,System.Decimal MAIN_MUTATION,System.String END_MUTATION,System.String START_MUTATION,System.String OVERTIME_START,System.String OVERTIME_END,System.String TIMEOFF_START,System.String TIMEOFF_END,System.String TIMEOFF_MAIN,System.String OT_TOTAL,System.String OT_TOTAL_MINUTES,System.Decimal DAY_OFF,System.String TO_TOTAL,System.String TKT_SORT_LIST,System.String SHIFT,System.String SORT_BY_TASK_REMARK,System.String SORT_SUPV_BY_TASK_REMARK,System.String SORTING_TASK,System.String SORTING_SUPV_TASK,System.String SORT_CSO_CHKIN,System.String SORT_TE_TW,System.String 600 4383733f9ed1433bb5fb6f153867df2c Query_MASTER_CX_LIVE OracleCXRT PTask_end,vTaskEnd,106,25 PTask_start,vTaskStart,106,25 select D.*, case when ((D.overtime_start is not null) and (instr(D.START_MUTATION,'Overtime')>0)) OR ((D.overtime_end is not null) and (instr(D.END_MUTATION,'Overtime')>0)) OR (instr(D.MAIN_MUTATION_CODE,'Overtime')>0) then case when (instr(D.MAIN_MUTATION_CODE,'Overtime')>0) then to_char(trunc(((D.Estimated_End - D.Estimated_Start))*1440/60, 0), 'FM00') || ':' || to_char(Mod(((D.Estimated_End - D.Estimated_Start))*1440, 60), 'FM00') when ((D.overtime_start is not null) and (D.overtime_end is not null)) then to_char(trunc(((D.Shift_Start_Sch - D.Estimated_Start)+(D.Estimated_End - D.Shift_End_Sch))*1440/60, 0), 'FM00') || ':' || to_char(Mod(((D.Shift_Start_Sch - D.Estimated_Start)+(D.Estimated_End - D.Shift_End_Sch))*1440, 60), 'FM00') when (D.overtime_start is not null) then D.overtime_start when (D.overtime_end is not null) then D.overtime_end else null end else null end as OT_Total, case when ((D.overtime_start is not null) and (instr(D.START_MUTATION,'Overtime')>0)) OR ((D.overtime_end is not null) and (instr(D.END_MUTATION,'Overtime')>0)) OR (instr(D.MAIN_MUTATION_CODE,'Overtime')>0) then case when (instr(D.MAIN_MUTATION_CODE,'Overtime')>0) then trunc((D.Estimated_End - D.Estimated_Start)*1440) when ((D.overtime_start is not null) and (D.overtime_end is not null)) then trunc(((D.Shift_Start_Sch - D.Estimated_Start)+(D.Estimated_End - D.Shift_End_Sch))*1440) when (D.overtime_start is not null) then to_number(substr(D.overtime_start,1,2))*60 + to_number(substr(D.overtime_start,4,5)) when (D.overtime_end is not null) then to_number(substr(D.overtime_end,1,2))*60 + to_number(substr(D.overtime_end,4,5)) else 0 end else 0 end as OT_Total_Minutes, case when substr(D.Main_Mutation_Code, 5, 8 )='Overtime' then 'OFF' else null end as DAY_OFF, case when ((D.timeoff_start is not null) and (instr(D.START_MUTATION,'Time Off')>0)) OR ((D.timeoff_end is not null) and (instr(D.END_MUTATION,'Time Off')>0)) OR ((D.timeoff_main is not null) and (instr(D.MAIN_MUTATION_CODE,'Time Off')>0)) then case when ((D.timeoff_start is not null) and (D.timeoff_end is not null)) and (D.Timeoff_main is not null) then to_char(trunc(((D.Estimated_End - D.Estimated_Start))*1440/60, 0), 'FM00') || ':' || to_char(Mod(((D.Estimated_End - D.Estimated_Start))*1440, 60), 'FM00') when ((D.timeoff_start is not null) and (D.timeoff_end is not null)) and (D.Timeoff_main is null) then to_char(trunc(((D.Shift_Start_Sch - D.Estimated_Start)+(D.Estimated_End - D.Shift_End_Sch))*1440/60, 0), 'FM00') || ':' || to_char(Mod(((D.Shift_Start_Sch - D.Estimated_Start)+(D.Estimated_End - D.Shift_End_Sch))*1440, 60), 'FM00') when (D.timeoff_start is not null) then D.timeoff_start when (D.timeoff_end is not null) then D.timeoff_end when (D.timeoff_main is not null) then D.timeoff_main else null end else null end as TO_Total, case when instr(D.Task_remark,'CX')>0 then '01' when instr(D.Task_remark,'CA')>0 then '02' when instr(D.Task_remark,'TKTG')>0 then '03' when instr(D.Task_remark,'ITCH')>0 then '04' when instr(D.Task_remark,'ITCK')>0 then '04' else '99' end as tkt_sort_list, to_char(D.Estimated_Start,'HH24:MI') || ' - ' || to_char(D.Estimated_End,'HH24:MI') as shift, case when instr(D.Task_remark,'A E D')>0 then '01' when instr(D.Task_remark,'Staff')>0 then '02' when instr(D.Task_remark,'IQP')>0 then '03' when instr(D.Task_remark,'S E P')>0 then '04' when instr(D.Task_remark,'CUSS')>0 then '05' when instr(D.Task_remark,'Queue Comb')>0 then '06' when instr(D.Task_remark,'SSBD')>0 then '07' when instr(D.Task_remark,'Bag Drop')>0 then '08' when instr(D.Task_remark,'LBC')>0 then '08' when instr(D.Task_remark,'F C L')>0 then '09' when instr(D.Task_remark,'C C L')>0 then '10' when instr(D.Task_remark,'Online Check C C L')>0 then '11' when instr(D.Task_remark,'P E Y')>0 then '12' when instr(D.Task_remark,'Online Check')>0 then '13' when instr(D.Task_remark,'S I P')>0 then '14' when instr(D.Task_remark,'YCL')>0 then '15' when instr(D.Task_remark,'V N')>0 then '16' when instr(D.Task_remark,'Group')>0 then '17' when instr(D.Task_remark,'Online Group')>0 then '18' when instr(D.Task_remark,'O O G')>0 then '19' when instr(D.Task_remark,'Ambassador')>0 then '20' when instr(D.Task_remark,'Y C L (U S)')>0 then '21' when instr(D.Task_remark,'PEY/Y C L(U S)')>0 then '22' when instr(D.Task_remark,'CCL (U S)')>0 then '23' when instr(D.Task_remark,'FCL (U S)')>0 then '23' else '99' end as Sort_by_task_remark, case when instr(D.Task_remark,'FCL')>0 then '01' when instr(D.Task_remark,'CCL-B')>0 then '02' when instr(D.Task_remark,'YCL-C')>0 then '03' when instr(D.Task_remark,'YCL-B')>0 then '03' when instr(D.Task_remark,'YCL-F')>0 then '03' when instr(D.Task_remark,'YCL-G')>0 then '03' when instr(D.Task_remark,'YCL-H')>0 then '03' when instr(D.Task_remark,'YCL-I')>0 then '03' when instr(D.Task_remark,'YCL-J')>0 then '03' when instr(D.Task_remark,'YCL-D')>0 then '03' when instr(D.Task_remark,'YCL-E')>0 then '03' when instr(D.Task_remark,'YCL-A')>0 then '03' when instr(D.Task_remark,'YCL- Aisle A')>0 then '04' when instr(D.Task_remark,'YCL- Group')>0 then '05' when instr(D.Task_remark,'YCL- GROUP')>0 then '05' when instr(D.Task_remark,'Group')>0 then '05' when instr(D.Task_remark,'YCL-YA')>0 then '05' when instr(D.Task_remark,'Supv-H1')>0 then '06' when instr(D.Task_remark,'Supv-H2')>0 then '07' when instr(D.Task_remark,'Supv-H3')>0 then '08' when instr(D.Task_remark,'Supv-F')>0 then '09' when instr(D.Task_remark,'Supv-G')>0 then '09' when instr(D.Task_remark,'Supv-J')>0 then '10' when instr(D.Task_remark,'YCL-Staff Standby')>0 then '11' when instr(D.Task_remark,'Staff Standby')>0 then '13' when instr(D.Task_remark,'IQP')>0 then '14' when instr(D.Task_remark,'Lounge Wing')>0 then '18' when instr(D.Task_remark,'Lounge Pier FRCL')>0 then '19' when instr(D.Task_remark,'Lounge Pier CCL')>0 then '20' when instr(D.Task_remark,'Lounge Cabin')>0 then '21' when instr(D.Task_remark,'Lounge Bridge')>0 then '22' when instr(D.Task_remark,'Lounge Deck')>0 then '23' when instr(D.Task_remark,'T E')>0 then '24' when instr(D.Task_remark,'T W')>0 then '25' when instr(D.Task_remark,'Briefing')>0 then '26' when instr(D.Task_remark,'Flight')>0 then '27' when instr(D.Task_remark,'Sky')>0 then '28' when instr(D.Task_remark,'ITCH')>0 then '29' when instr(D.Task_remark,'ITC-H')>0 then '29' when instr(D.Task_remark,'ITCK')>0 then '30' when instr(D.Task_remark,'ITC-K')>0 then '30' else '99' end as Sort_supv_by_task_remark, case when instr(D.Task_remark,'A E D')>0 then '01' when instr(D.Task_remark,'STF')>0 then '02' when instr(D.Task_remark,'IQP')>0 then '03' when instr(D.Task_remark,'S E P')>0 then '04' when instr(D.Task_remark,'QCK')>0 then '05' when instr(D.Task_remark,'QCM')>0 then '06' when instr(D.Task_remark,'CCL')>0 then '07' when instr(D.Task_remark,'D')>0 then '08' when instr(D.Task_remark,'SIP')>0 then '09' when instr(D.Task_remark,'OLC')>0 then '10' when instr(D.Task_remark,'YCL')>0 then '11' when instr(D.Task_remark,'GROUP')>0 then '12' when instr(D.Task_remark,'OLGC')>0 then '13' when instr(D.Task_remark,'O O G')>0 then '14' when instr(D.Task_remark,'Ambassador')>0 then '15' else '99' end as Sorting_Task, case when instr(D.Task_remark,'FCL')>0 then '01' when instr(D.Task_remark,'B')>0 then '02' when instr(D.Task_remark,'C')>0 then '03' when instr(D.Task_remark,'D')>0 then '04' when instr(D.Task_remark,'LGE_W')>0 then '05' when instr(D.Task_remark,'LGE_P')>0 then '06' when instr(D.Task_remark,'TW')>0 then '07' when instr(D.Task_remark,'TE')>0 then '08' when instr(D.Task_remark,'SKY')>0 then '09' when instr(D.Task_remark,'BFG')>0 then '10' when instr(D.Task_remark,'FC')>0 then '11' when instr(D.Task_remark,'ITCH')>0 then '12' when instr(D.Task_remark,'ITCK')>0 then '13' else '99' end as Sorting_SUPV_Task, case when instr(D.Task_Start_Loc,'AED')>0 then '01' when instr(D.Task_Start_Loc,'STF')>0 then '02' else null end as Sort_CSO_chkin, case when instr(D.Task_remark,'T E')>0 then '01' when instr(D.Task_remark,'T W')>0 then '02' when instr(D.Task_remark,'Airline')>0 then '03' when instr(D.Task_remark,'MSC')>0 then '04' when instr(D.Task_remark,'MPO')>0 then '05' when instr(D.Task_remark,'Telex')>0 then '06' else '99' end as Sort_TE_TW from ( SELECT case when instr(AL12.DATABASE_ID,'*')>1 then AL14.ID||AL12.TRIP||'*' else AL14.ID||AL12.TRIP end as Flight_No_In, case when instr(AL13.DATABASE_ID,'*')>1 then AL15.ID||AL13.TRIP||'*' else AL15.ID||AL13.TRIP end as Flight_No_Out, case when (to_char(AL1.START_TIME,'HH24:MI') > '0400') and (to_char(AL1.START_TIME,'HH24:MI') < '1000') then '1 Morning' when (to_char(AL1.START_TIME,'HH24:MI') > '1000') and (to_char(AL1.START_TIME,'HH24:MI') < '1900') then '2 Afternoon' else '3 Night' end as Day_Period, to_char(AL12.ST,'HH24:MI') as STA_HRS, to_char(AL1.START_TIME,'HH24:MI') as TASK_START_HRS, to_char(AL1.END_TIME,'HH24:MI') as TASK_END_HRS, upper(AL9.NAME)||' '||AL9.ADDITIONAL_NAME||decode(AL9.REMARK,'','',' ('||AL9.REMARK||')') as FullName_w_Skill, upper(AL9.NAME)||' '||AL9.ADDITIONAL_NAME as FullName, upper(AL9.NAME)||' '||AL9.ADDITIONAL_NAME||' ('||AL9.HOST_ID||')' as Name_with_ERN, to_char(AL10.ESTIMATED_START,'HH24MI') as SecondSortShiftTaskList, nvl( case when instr(AL12.DATABASE_ID,'*')>1 then AL14.ID||AL12.TRIP||'*' else AL14.ID||AL12.TRIP end, -- Flight_No_In case when instr(AL13.DATABASE_ID,'*')>1 then AL15.ID||AL13.TRIP||'*' else AL15.ID||AL13.TRIP end -- Flight_No_Out ) || ' ('|| AL1.REMARK ||')' as FlightNoAndTaskRemark, nvl( case when instr(AL12.DATABASE_ID,'*')>1 then AL14.ID||AL12.TRIP||'*' else AL14.ID||AL12.TRIP end, -- Flight_No_In case when instr(AL13.DATABASE_ID,'*')>1 then AL15.ID||AL13.TRIP||'*' else AL15.ID||AL13.TRIP end -- Flight_No_Out ) || ' ('|| AL1.REMARK ||')@(' || AL7.ID || ')' as FlightNoAndTaskRemarkAndLoc, AL1.START_TIME as task_start, AL1.END_TIME as task_end, AL1.DURATION / 60 as task_duration, AL1.REMARK as task_remark, AL2.NAME task_type, AL3.NAME as task_requirement, AL4.NAME as task_state, AL5.ID as task_dept, AL6.ID as work_area, AL7.ID as task_start_loc, AL8.ID as task_end_loc, AL9.NAME as name, AL9.ADDITIONAL_NAME as first_name, AL9.HOST_ID as staff_no, AL10.SCHEDULED_START as shift_start_sch, AL10.SCHEDULED_END as shift_end_sch, AL10.START_TIME as shift_start_act, AL10.END_TIME as shift_end_act, AL14.ID as airline_in, AL12.TRIP as fln_in, AL12.ST as sta, AL12.AT as ata, AL12.ROU as arr_fm, AL10.ESTIMATED_START as estimated_start, AL10.ESTIMATED_END as estimated_end, to_char(AL10.ESTIMATED_START,'HH24:MI') as Actual_shift_start, to_char(AL10.ESTIMATED_END,'HH24:MI') as Actual_shift_end, to_char(AL10.ESTIMATED_START,'HH24:MI') || ' - ' || to_char(AL10.ESTIMATED_END,'HH24:MI') as Actual_Duty_Time, AL15.ID as airline_out, AL13.TRIP as fln_out, AL13.ST as std, AL13.ROU as dep_to, AL9.REMARK as hidden_skill, AL12.ET as eta, AL13.ET as etd, AL12.DATABASE_ID as db_id_in, AL13.DATABASE_ID as db_id_out, AL16.DESCRIPTION as end_mutation_code, AL23.DESCRIPTION as main_mutation_code, AL17.DESCRIPTION as start_mutation_code, AL18.ID as shift_status, AL20.REMARK as shift_remark, AL19.ID as reason_code, AL21.ID as staff_skill, AL13.SDC_Y_MPO as sdc_y_mpo, AL21.NAME as staff_qualification, AL22.ID as staff_workarea, AL11.ID as shift_workarea, AL24.NO as mainorderno, AL1.SUB_NO as suborderno, AL1.AUTOID as suborderautoid, AL23.ID as MAIN_MUTATION, AL16.DESCRIPTION as END_MUTATION, AL17.DESCRIPTION as START_MUTATION, case when (AL10.ESTIMATED_START is not null) and (AL10.SCHEDULED_START != AL10.ESTIMATED_START) and (instr(AL17.DESCRIPTION,'Overtime')>0) then case when (AL10.SCHEDULED_START > AL10.ESTIMATED_START) then to_char( trunc((AL10.SCHEDULED_START - AL10.ESTIMATED_START)*1440/60, 0), 'FM00') || ':' || to_char(mod((AL10.SCHEDULED_START - AL10.ESTIMATED_START)*1440, 60), 'FM00') else '-'||to_char( trunc(-1*(AL10.SCHEDULED_START - AL10.ESTIMATED_START)*1440/60, 0), 'FM00') || ':' || to_char(mod(-1*(AL10.SCHEDULED_START - AL10.ESTIMATED_START)*1440, 60), 'FM00') end else null end as overtime_start, case when (AL10.ESTIMATED_END is not null) and (AL10.SCHEDULED_END != AL10.ESTIMATED_END) and (instr(AL16.DESCRIPTION,'Overtime')>0) then case when (AL10.SCHEDULED_END < AL10.ESTIMATED_END) then to_char( trunc((AL10.ESTIMATED_END - AL10.SCHEDULED_END)*1440/60, 0), 'FM00') || ':' || to_char(mod((AL10.ESTIMATED_END - AL10.SCHEDULED_END)*1440, 60), 'FM00') else '-'||to_char( trunc(-1*(AL10.ESTIMATED_END - AL10.SCHEDULED_END)*1440/60, 0), 'FM00') || ':' || to_char(mod(-1*(AL10.ESTIMATED_END - AL10.SCHEDULED_END)*1440, 60), 'FM00') end else null end as overtime_end, case when (AL10.ESTIMATED_START is not null) and (AL10.SCHEDULED_START != AL10.ESTIMATED_START) and (instr(AL17.DESCRIPTION,'Time Off')>0) then case when (AL10.SCHEDULED_START > AL10.ESTIMATED_START) then to_char( trunc((AL10.SCHEDULED_START - AL10.ESTIMATED_START)*1440/60, 0), 'FM00') || ':' || to_char(mod((AL10.SCHEDULED_START - AL10.ESTIMATED_START)*1440, 60), 'FM00') else '-'||to_char( trunc(-1*(AL10.SCHEDULED_START - AL10.ESTIMATED_START)*1440/60, 0), 'FM00') || ':' || to_char(mod(-1*(AL10.SCHEDULED_START - AL10.ESTIMATED_START)*1440, 60), 'FM00') end else null end as timeoff_start, case when (AL10.ESTIMATED_END is not null) and (AL10.SCHEDULED_END != AL10.ESTIMATED_END) and (instr(AL16.DESCRIPTION,'Time Off')>0) then case when (AL10.SCHEDULED_END < AL10.ESTIMATED_END) then to_char( trunc((AL10.ESTIMATED_END - AL10.SCHEDULED_END)*1440/60, 0), 'FM00') || ':' || to_char(mod((AL10.ESTIMATED_END - AL10.SCHEDULED_END)*1440, 60), 'FM00') else '-'||to_char( trunc(-1*(AL10.ESTIMATED_END - AL10.SCHEDULED_END)*1440/60, 0), 'FM00') || ':' || to_char(mod(-1*(AL10.ESTIMATED_END - AL10.SCHEDULED_END)*1440, 60), 'FM00') end else null end as timeoff_end, case when (instr(AL23.DESCRIPTION,'Time Off')>0) then to_char( trunc((AL10.SCHEDULED_END - AL10.SCHEDULED_START)*1440/60, 0), 'FM00') || ':' || to_char(mod((AL10.SCHEDULED_END - AL10.SCHEDULED_START)*1440, 60), 'FM00') else null end as timeoff_main FROM TB_SUB_ORDERS AL1, TB_ORDER_TYPES AL2, TB_SUB_ORDER_REQUIREMENTS AL3, TB_ORDER_STATES AL4, TB_DEPARTMENTS AL5, TB_WORKAREAS AL6, TB_LOCATIONS AL7, TB_LOCATIONS AL8, TB_RESOURCES AL9, TB_SHIFTS AL10, TB_WORKAREAS AL11, TB_FLIGHTS AL12, TB_FLIGHTS AL13, TB_AIRLINES AL14, TB_AIRLINES AL15, TB_MUTATION_CODES AL16, TB_MUTATION_CODES AL17, TB_SHIFT_STATES AL18, TB_REASONCODE AL19, TB_MAIN_SHIFTS AL20, TB_RES_QUALIFICATIONS AL21, TB_WORKAREAS AL22, TB_MUTATION_CODES AL23, TB_MAIN_ORDERS AL24 WHERE ( AL2.AUTOID(+) = AL1.ORDER_TYPE_REF AND AL1.SUB_ORDER_REQ_REF = AL3.AUTOID(+) AND AL4.AUTOID(+) = AL1.ORDER_STATE_REF AND AL1.WORK_AREA_REF = AL6.AUTOID(+) AND AL1.START_LOC_REF = AL7.AUTOID(+) AND AL1.DEST_LOC_REF = AL8.AUTOID(+) AND AL1.RES_ASSIGNED_TO_REF = AL9.AUTOID(+) AND AL1.SHIFT_ASSIGNED_TO_REF = AL10.AUTOID(+) AND AL10.WORK_AREA_REF = AL11.AUTOID(+) AND AL12.AUTOID(+) = AL1.INBOUND_REF AND AL13.AUTOID(+) = AL1.OUTBOUND_REF AND AL14.AUTOID(+) = AL12.AIRLINE AND AL15.AUTOID(+) = AL13.AIRLINE AND AL10.END_MUTATION_CODE_REF = AL16.AUTOID(+) AND AL10.START_MUTATION_CODE_REF = AL17.AUTOID(+) AND AL18.AUTOID(+) = AL10.SHIFT_STATE_REF AND AL10.REASON_CODE_REF = AL19.AUTOID(+) AND AL10.MAIN_SHIFT_REF = AL20.AUTOID(+) AND AL9.QUALIFICATION = AL21.AUTOID(+) AND AL9.DEFAULT_WORK_AREA_REF = AL22.AUTOID(+) AND AL10.MAIN_MUTATION_CODE_REF = AL23.AUTOID(+) AND AL1.DEPARTMENT_REF=AL5.AUTOID AND AL1.MAIN_ORDER_REF=AL24.AUTOID ) ) D where (1=1) and (D.FlightNoAndTaskRemark not in (' (@PostShift CA_LS_CSO)',' (@PostShift CX_AS)',' (@PostShift CX_LS_CSO)',' (@PreShift CA_AS)',' (@PreShift CA_LS_CSO)',' (@PreShift CA_LS_S)',' (@PreShift CX_AS)', ' (@PreShift CX_LS_CSO)',' (@PreShift CX_LS_S)', ' (@PreShit CX_LS_CSO)' ) ) and ((D.staff_qualification like '%CX%') or (D.staff_qualification like '%KA_AS_CSO%') or (D.staff_qualification like '%KA_LS_CSO%') ) -- and (D.task_start <= to_date('11.10.2019 03:00:00','dd.mm.yyyy HH24:MI:SS') and D.task_end >= to_date('10.10.2019 03:00:00','dd.mm.yyyy HH24:MI:SS') ) and (D.task_start <= :PTask_end and D.task_end >= :PTask_start ) order by Staff_qualification, D.Estimated_start, D.FullName, D.Task_Start Q_SHIFT_CX_OT_CUMULATIVE OT_TOTAL__CXAS_CSO,System.String OT_TOTAL__CXAS_SUPV,System.String OT_TOTAL__CXLS_SUPV,System.String OT_TOTAL__CXLS_CSO,System.String OT_TOTAL__CX_MSC_CSO,System.String OT_TOTAL__CX_ROST,System.String OT_TOTAL__CX_TKT,System.String OT_TOTAL__CX_LS_CSO_CAL2,System.String OT_TOTAL__CX_CAAIR_S,System.String OT_TOTAL__CX_SPCL,System.String OT_TOTAL__CX_AS_SVCL,System.String OT_TOTAL__CX_LS_SVCL,System.String OT_TOTAL__CX_LS_PST,System.String OT_TOTAL__CX_LS_FC_SUPV,System.String OT_TOTAL__CX_LS_PST_SUPV,System.String OT_TOTAL__CX_TKT_CSO,System.String OT_TOTAL__CX_TKT_SUPV,System.String OT_TOTAL__CX_ALL_LS_SUPV,System.String OT_TOTAL__CX_ALL_AS,System.String OT_TOTAL__CX_ALL_LS_CSO,System.String OT_TOTAL__CX_ALL_TKT_CSO,System.String OT_TOTAL__CX_LS_AND_PST_SUPV,System.String OT_TOTAL__CX_ALL,System.String OT_TOTAL_MINUTES_CXAS_CSO,System.Decimal OT_TOTAL_MINUTES_CXAS_SUPV,System.Decimal OT_TOTAL_MINUTES_CXLS_SUPV,System.Decimal OT_TOTAL_MINUTES_CXLS_CSO,System.Decimal OT_TOTAL_MINUTES_CX_MSC_CSO,System.Decimal OT_TOTAL_MINUTES_CX_ROST,System.Decimal OT_TOTAL_MINUTES_CX_TKT,System.Decimal OT_TOTAL_MINUTES_CX_LS_CSO_CAL2,System.Decimal OT_TOTAL_MINUTES_CX_CAAIR_S,System.Decimal OT_TOTAL_MINUTES_CX_SPCL,System.Decimal OT_TOTAL_MINUTES_CX_AS_SVCL,System.Decimal OT_TOTAL_MINUTES_CX_LS_SVCL,System.Decimal OT_TOTAL_MINUTES_CX_LS_PST,System.Decimal OT_TOTAL_MINUTES_CX_LS_FC_SUPV,System.Decimal OT_TOTAL_MINUTES_CX_LS_PST_SUPV,System.Decimal OT_TOTAL_MINUTES_CX_TKT_CSO,System.Decimal OT_TOTAL_MINUTES_CX_TKT_SUPV,System.Decimal OT_TOTAL_MINUTES_CX_ALL_LS_SUPV,System.Decimal OT_TOTAL_MINUTES_CX_ALL_AS,System.Decimal OT_TOTAL_MINUTES_CX_ALL_LS_CSO,System.Decimal OT_TOTAL_MINUTES_CX_ALL_TKT_CSO,System.Decimal OT_TOTAL_MINUTES_CX_LS_AND_PST_SUPV,System.Decimal OT_TOTAL_MINUTES_CX_ALL,System.Decimal COUNT_CXAS_SUPV,System.Decimal COUNT_CXLS_SUPV,System.Decimal COUNT_CXLS_PST_SUPV,System.Decimal COUNT_CXLS_FC_SUPV,System.Decimal COUNT_ALL_CXLS_SUPV,System.Decimal COUNT_CXAS_SVCL,System.Decimal COUNT_CXAS_CSO,System.Decimal COUNT_ALL_CXAS_CSO,System.Decimal COUNT_CXLS_SVCL,System.Decimal COUNT_CXLS_CSO,System.Decimal COUNT_CXLS_PST_CSO,System.Decimal COUNT_ALL_CXLS_CSO,System.Decimal COUNT_CX_MSC_CSO,System.Decimal COUNT_CX_TKT_SUPV,System.Decimal COUNT_CX_TKT_CSO,System.Decimal COUNT_ALL_CX_TKT_CSO,System.Decimal 600 199827fff845421a908d5efe3c81634f Query_SHIFT_CX_LIVE_OT_CUMULATIVE OracleCXRT PShiftStart,vTaskStart,106,25 PShiftEnd,vTaskEnd,106,25 select to_char(trunc(DST.OT_TOTAL_minutes_CXAS_CSO/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CXAS_CSO, 60), 'FM00') as OT_TOTAL__CXAS_CSO ,to_char(trunc(DST.OT_TOTAL_minutes_CXAS_SUPV/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CXAS_SUPV, 60), 'FM00') as OT_TOTAL__CXAS_SUPV ,to_char(trunc(DST.OT_TOTAL_minutes_CXLS_SUPV/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CXLS_SUPV, 60), 'FM00') as OT_TOTAL__CXLS_SUPV ,to_char(trunc(DST.OT_TOTAL_minutes_CXLS_CSO/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CXLS_CSO, 60), 'FM00') as OT_TOTAL__CXLS_CSO ,to_char(trunc(DST.OT_TOTAL_minutes_CX_MSC_CSO/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_MSC_CSO, 60), 'FM00') as OT_TOTAL__CX_MSC_CSO ,to_char(trunc(DST.OT_TOTAL_minutes_CX_ROST/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_ROST, 60), 'FM00') as OT_TOTAL__CX_ROST ,to_char(trunc(DST.OT_TOTAL_minutes_CX_TKT/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_TKT, 60), 'FM00') as OT_TOTAL__CX_TKT ,to_char(trunc(DST.OT_TOTAL_minutes_CX_LS_CSO_CAL2/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_LS_CSO_CAL2, 60), 'FM00') as OT_TOTAL__CX_LS_CSO_CAL2 ,to_char(trunc(DST.OT_TOTAL_minutes_CX_CAAIR_S/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_CAAIR_S, 60), 'FM00') as OT_TOTAL__CX_CAAIR_S ,to_char(trunc(DST.OT_TOTAL_minutes_CX_SPCL/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_SPCL, 60), 'FM00') as OT_TOTAL__CX_SPCL ,to_char(trunc(DST.OT_TOTAL_minutes_CX_AS_SVCL/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_AS_SVCL, 60), 'FM00') as OT_TOTAL__CX_AS_SVCL ,to_char(trunc(DST.OT_TOTAL_minutes_CX_LS_SVCL/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_LS_SVCL, 60), 'FM00') as OT_TOTAL__CX_LS_SVCL ,to_char(trunc(DST.OT_TOTAL_minutes_CX_LS_PST/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_LS_PST, 60), 'FM00') as OT_TOTAL__CX_LS_PST ,to_char(trunc(DST.OT_TOTAL_minutes_CX_LS_FC_SUPV/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_LS_FC_SUPV, 60), 'FM00') as OT_TOTAL__CX_LS_FC_SUPV ,to_char(trunc(DST.OT_TOTAL_minutes_CX_LS_PST_SUPV/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_LS_PST_SUPV, 60), 'FM00') as OT_TOTAL__CX_LS_PST_SUPV ,to_char(trunc(DST.OT_TOTAL_minutes_CX_TKT_CSO/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_TKT_CSO, 60), 'FM00') as OT_TOTAL__CX_TKT_CSO ,to_char(trunc(DST.OT_TOTAL_minutes_CX_TKT_SUPV/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_TKT_SUPV, 60), 'FM00') as OT_TOTAL__CX_TKT_SUPV ,to_char(trunc(DST.OT_TOTAL_minutes_CX_ALL_LS_SUPV/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_ALL_LS_SUPV, 60), 'FM00') as OT_TOTAL__CX_ALL_LS_SUPV ,to_char(trunc(DST.OT_TOTAL_minutes_CX_ALL_AS/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_ALL_AS, 60), 'FM00') as OT_TOTAL__CX_ALL_AS ,to_char(trunc(DST.OT_TOTAL_minutes_CX_ALL_LS_CSO/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_ALL_LS_CSO, 60), 'FM00') as OT_TOTAL__CX_ALL_LS_CSO ,to_char(trunc(DST.OT_TOTAL_minutes_CX_ALL_TKT_CSO/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_ALL_TKT_CSO, 60), 'FM00') as OT_TOTAL__CX_ALL_TKT_CSO ,to_char(trunc(DST.OT_TOTAL_minutes_CX_LS_AND_PST_SUPV/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_LS_AND_PST_SUPV, 60), 'FM00') as OT_TOTAL__CX_LS_AND_PST_SUPV ,to_char(trunc(DST.OT_TOTAL_minutes_CX_ALL/60, 0), 'FM9900') || ':' || to_char(Mod(DST.OT_TOTAL_minutes_CX_ALL, 60), 'FM00') as OT_TOTAL__CX_ALL ,DST.* from ( select sum( case when ((DS.Staff_Qualification like '%CXAS CSO%') or (DS.Staff_Qualification like '%KA_AS_CSO%')) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CXAS_CSO, sum( case when ((DS.Staff_Qualification like '%CXAS SUPV%')) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CXAS_SUPV, sum( case when ((DS.Staff_Qualification like '%CXLS SUPV%')) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CXLS_SUPV, sum( case when ((DS.Staff_Qualification like '%CXLS CSO%') or (DS.Staff_Qualification like '%KA_LS_CSO%')) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CXLS_CSO, sum( case when ((DS.Staff_Qualification like '%CX MSC CSO%')) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_MSC_CSO, sum( case when ((DS.WorkArea like '%CX_ROST%')) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_ROST, sum( case when ((DS.Staff_Qualification like '%CX TKT CSO%') or (DS.Staff_Qualification like '%CX TKT SUPV%')) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_TKT, sum( case when ((DS.WorkArea like '%CX%') and (DS.Staff_Qualification like '%CX_CAL2%')) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_LS_CSO_CAL2, sum( case when ((DS.WorkArea like '%CX%') and (DS.Staff_Qualification like '%CX_CAAIR_S%')) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_CAAIR_S, sum( case when ((DS.WorkArea like '%CX%') and (DS.Staff_Qualification like '%CX SPECIAL HLDG CSO%')) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_SPCL, sum( case when ((DS.WorkArea_Group like '%CX%AS%CSO%') and (DS.Staff_Qualification like '%CX%AS%SVCL%')) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_AS_SVCL, sum( case when ((DS.Staff_Qualification like '%CX%LS%SVCL%') or (DS.Staff_Qualification like '%CX%SVCL%FLIGHT%CONTROL%')) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_LS_SVCL, sum( case when ( (DS.Staff_Qualification like '%CXLS%PST%CSO%') ) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_LS_PST, sum( case when ( (DS.Staff_Qualification like '%CXLS%FC%SUPV%') ) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_LS_FC_SUPV, sum( case when ( (DS.Staff_Qualification like '%CXLS%PST%SUPV%') ) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_LS_PST_SUPV, sum( case when ( (DS.Staff_Qualification like '%CX%TKT%CSO%') ) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_TKT_CSO, sum( case when ( (DS.Staff_Qualification like '%CX%TKT%SUPV%') ) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_TKT_SUPV, sum( case when ( (DS.Staff_Qualification like '%CXLS SUPV%') or (DS.Staff_Qualification like '%CXLS%FC%SUPV%') or (DS.Staff_Qualification like '%CXLS%PST%SUPV%') ) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_ALL_LS_SUPV, sum( case when ( (DS.Staff_Qualification like '%CX%SPECIAL%HLDG%CSO%') or (DS.Staff_Qualification like '%CXAS%CSO%') or (DS.Staff_Qualification like '%CXAS%SVCL%') or (DS.Staff_Qualification like '%KA_AS_CSO%') ) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_ALL_AS, sum( case when ( (DS.Staff_Qualification like '%CX%LS%SVCL%') or (DS.Staff_Qualification like '%CX%SVCL%FLIGHT%CONTROL%') or (DS.Staff_Qualification like '%CX%LS%CSO%') or (DS.Staff_Qualification like '%CXLS%PST%CSO%') or (DS.Staff_Qualification like '%KA_LS_CSO%') ) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_ALL_LS_CSO, sum( case when ( (DS.Staff_Qualification like '%CX%TKT%SUPV%') or (DS.Staff_Qualification like '%CX%TKT%CSO%') ) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_ALL_TKT_CSO, sum( case when ( (DS.Staff_Qualification like '%CXLS%PST%SUPV%') or (DS.Staff_Qualification like '%CXLS%SUPV%') ) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_LS_AND_PST_SUPV, sum( case when ( (DS.Staff_Qualification like '%CX%TKT%CSO%') or (DS.Staff_Qualification like '%CX%MSC%CSO%') or (DS.Staff_Qualification like '%CX%SPECIAL%HLDG%CSO%') or (DS.Staff_Qualification like '%CX%SVCL%FLIGHT%CONTROL%') or (DS.Staff_Qualification like '%CX%TKT%SUPV%') or (DS.Staff_Qualification like '%CXAS%CSO%') or (DS.Staff_Qualification like '%CXAS%SUPV%') or (DS.Staff_Qualification like '%CXAS%SVCL%') or (DS.Staff_Qualification like '%CXLS%CSO%') or (DS.Staff_Qualification like '%CXLS%FC%SUPV%') or (DS.Staff_Qualification like '%CXLS%PST%CSO%') or (DS.Staff_Qualification like '%CXLS%PST%SUPV%') or (DS.Staff_Qualification like '%CXLS%SUPV%') or (DS.Staff_Qualification like '%CXLS%SVCL%') or (DS.Staff_Qualification like '%KA_AS_CSO%') or (DS.Staff_Qualification like '%KA_LS_CSO%') ) then DS.OT_Total_minutes else 0 end ) as OT_TOTAL_minutes_CX_ALL, sum(DS.HCount_CXAS_SUPV) as count_CXAS_SUPV, sum(DS.HCount_CXLS_SUPV) as count_CXLS_SUPV, sum(DS.HCount_CXLS_PST_SUPV) as count_CXLS_PST_SUPV, sum(DS.HCount_CXLS_FC_SUPV) as count_CXLS_FC_SUPV, sum(DS.HCount_ALL_CXLS_SUPV) as count_ALL_CXLS_SUPV, sum(DS.HCount_CXAS_SVCL) as count_CXAS_SVCL, sum(DS.HCount_CXAS_CSO) as count_CXAS_CSO, sum(DS.HCount_ALL_CXAS_CSO) as count_ALL_CXAS_CSO, sum(DS.HCount_CXLS_SVCL) as count_CXLS_SVCL, sum(DS.HCount_CXLS_CSO) as count_CXLS_CSO, sum(DS.HCount_CXLS_PST_CSO) as count_CXLS_PST_CSO, sum(DS.HCount_ALL_CXLS_CSO) as count_ALL_CXLS_CSO, sum(DS.HCount_CX_MSC_CSO) as count_CX_MSC_CSO, sum(DS.HCount_CX_TKT_SUPV) as count_CX_TKT_SUPV, sum(DS.HCount_CX_TKT_CSO) as count_CX_TKT_CSO, sum(DS.HCount_ALL_CX_TKT_CSO) as count_ALL_CX_TKT_CSO from ( SELECT case when (D.WorkArea in ('CX_AS','CX_LS','CX_MSC','CX_ROST','CX_SP_CSO','CX_TKT')) and (D.Staff_Qualification like '%CXAS SVCL%') then 1 else 0 end as HCount_CXAS_SVCL, case when (D.Staff_Qualification like '%CXAS SUPV%') then 1 else 0 end as HCount_CXAS_SUPV, case when (D.Staff_Qualification like '%CXLS SUPV%') then 1 else 0 end as HCount_CXLS_SUPV, case when (D.Staff_Qualification like '%CXLS PST SUPV%') then 1 else 0 end as HCount_CXLS_PST_SUPV, case when (D.Staff_Qualification like '%CXLS FC SUPV%') then 1 else 0 end as HCount_CXLS_FC_SUPV, case when (D.WorkArea in ('CX_AS','CX_LS','CX_MSC','CX_ROST','CX_SP_CSO','CX_TKT')) and ((D.Staff_Qualification like '%CXAS CSO%') or (D.Staff_Qualification like '%KA_AS_CSO%')) then 1 else 0 end as HCount_CXAS_CSO, case when (D.WorkArea in ('CX_AS','CX_LS','CX_MSC','CX_ROST','CX_SP_CSO','CX_TKT')) and ((D.Staff_Qualification like '%CXLS CSO%') or (D.Staff_Qualification like '%KA_LS_CSO%')) then 1 else 0 end as HCount_CXLS_CSO, case when (D.WorkArea in ('CX_AS','CX_LS','CX_MSC','CX_ROST','CX_SP_CSO','CX_TKT')) and ((D.Staff_Qualification like '%CX%SVCL%FLIGHT%CONTROL%') or (D.Staff_Qualification like '%CXLS%SVCL%')) then 1 else 0 end as HCount_CXLS_SVCL, case when (D.WorkArea in ('CX_AS','CX_LS','CX_MSC','CX_ROST','CX_SP_CSO','CX_TKT')) and ((D.Staff_Qualification like '%CXLS%PST%CSO%') ) then 1 else 0 end as HCount_CXLS_PST_CSO, case when (D.WorkArea in ('CX_AS','CX_LS','CX_MSC','CX_ROST','CX_SP_CSO','CX_TKT')) and ((D.Staff_Qualification like '%CX%TKT%CSO%') ) then 1 else 0 end as HCount_CX_TKT_CSO, case when (D.WorkArea in ('CX_AS','CX_LS','CX_MSC','CX_ROST','CX_SP_CSO','CX_TKT')) and ((D.Staff_Qualification like '%CX%MSC%CSO%') ) then 1 else 0 end as HCount_CX_MSC_CSO, case when (D.WorkArea in ('CX_AS','CX_LS','CX_MSC','CX_ROST','CX_SP_CSO','CX_TKT')) and ((D.Staff_Qualification like '%CX%TKT%SUPV%') ) then 1 else 0 end as HCount_CX_TKT_SUPV, case when (D.WorkArea in ('CX_AS','CX_LS','CX_MSC','CX_ROST','CX_SP_CSO','CX_TKT')) and ((D.Staff_Qualification like '%CX%SPECIAL%HLDG%CSO%') ) then 1 else 0 end as HCount_CX_SPCL_CSO, case when (D.Staff_Qualification like '%CXLS SUPV%') or (D.Staff_Qualification like '%CXLS%FC%SUPV%') or (D.Staff_Qualification like '%CXLS%PST%SUPV%') then 1 else 0 end as HCount_ALL_CXLS_SUPV, case when (D.WorkArea in ('CX_AS','CX_LS','CX_MSC','CX_ROST','CX_SP_CSO','CX_TKT')) and ((D.Staff_Qualification like '%CXAS CSO%') or (D.Staff_Qualification like '%CXAS SVCL%') or (D.Staff_Qualification like '%KA_AS_CSO%')) then 1 else 0 end as HCount_ALL_CXAS_CSO, case when (D.WorkArea in ('CX_AS','CX_LS','CX_MSC','CX_ROST','CX_SP_CSO','CX_TKT')) and ( (D.Staff_Qualification like '%CXLS SVCL%') or (D.Staff_Qualification like '%KA_LS_CSO%') or (D.Staff_Qualification like '%CXLS%PST%CSO%') or (D.Staff_Qualification like '%CXLS CSO%') or (D.Staff_Qualification like '%CX%SVCL%FLIGHT%CONTROL%') ) then 1 else 0 end as HCount_ALL_CXLS_CSO, case when (D.WorkArea in ('CX_AS','CX_LS','CX_MSC','CX_ROST','CX_SP_CSO','CX_TKT')) and ((D.Staff_Qualification like '%CX%TKT%CSO%') or (D.Staff_Qualification like '%CX%TKT%SUPV%') ) then 1 else 0 end as HCount_ALL_CX_TKT_CSO, D.*, case when ((D.overtime_start is not null) and (instr(D.START_MUTATION,'Overtime')>0)) OR ((D.overtime_end is not null) and (instr(D.END_MUTATION,'Overtime')>0)) OR (instr(D.MAIN_MUTATION,'OVERTIME')>0) then case when (instr(D.MAIN_MUTATION,'OVERTIME')>0) then to_char(trunc(((D.Estimated_End - D.Estimated_Start))*1440/60, 0), 'FM00') || ':' || to_char(Mod(((D.Estimated_End - D.Estimated_Start))*1440, 60), 'FM00') when ((D.overtime_start is not null) and (D.overtime_end is not null)) then to_char(trunc(((D.Shift_Start_Sch - D.Estimated_Start)+(D.Estimated_End - D.Shift_End_Sch))*1440/60, 0), 'FM00') || ':' || to_char(Mod(((D.Shift_Start_Sch - D.Estimated_Start)+(D.Estimated_End - D.Shift_End_Sch))*1440, 60), 'FM00') when (D.overtime_start is not null) then D.overtime_start when (D.overtime_end is not null) then D.overtime_end else null end else null end as OT_Total, case when ((D.overtime_start is not null) and (instr(D.START_MUTATION,'Overtime')>0)) OR ((D.overtime_end is not null) and (instr(D.END_MUTATION,'Overtime')>0)) OR (instr(D.MAIN_MUTATION,'OVERTIME')>0) then case when (instr(D.MAIN_MUTATION,'OVERTIME')>0) then trunc((D.Estimated_End - D.Estimated_Start)*1440) when ((D.overtime_start is not null) and (D.overtime_end is not null)) then trunc(((D.Shift_Start_Sch - D.Estimated_Start)+(D.Estimated_End - D.Shift_End_Sch))*1440) when (D.overtime_start is not null) then to_number(substr(D.overtime_start,1,2))*60 + to_number(substr(D.overtime_start,4,5)) when (D.overtime_end is not null) then to_number(substr(D.overtime_end,1,2))*60 + to_number(substr(D.overtime_end,4,5)) else 0 end else 0 end as OT_Total_Minutes FROM ( SELECT AL3.NAME as NAME, AL3.ADDITIONAL_NAME as ADDITIONAL_NAME, AL1.SCHEDULED_START as SHIFT_START_SCH, AL1.START_TIME as SHIFT_START_ACT, AL1.SCHEDULED_END as SHIFT_END_SCH, AL1.END_TIME as SHIFT_END_ACT, AL2.NAME as SHIFT_STATUS, AL5.DESCRIPTION as START_MUTATION, AL6.DESCRIPTION as END_MUTATION, AL7.ID as WORKAREA, AL8.ID as REASON_CODE, AL1.ACTIVATION_CONF_TIME as CLOCK_IN_, AL1.FINISH_CONF_TIME as CLOCK_OUT, AL4.REMARK as MAIN_SHIFT_REMARK, AL3.HOST_ID as STAFF_ERN_, AL1.REMARK as SHIFT_REMARK, AL1.ESTIMATED_START as ESTIMATED_START, AL1.ESTIMATED_END as ESTIMATED_END, AL9.NAME as STAFF_QUALIFICATION, AL3.REMARK as HIDDEN_SKILL, AL11.ID as MAIN_MUTATION, AL14.DEVICE_ADDRESS1 as PHONE, to_char(AL1.ESTIMATED_START,'HH24MI')||'-'||to_char(AL1.ESTIMATED_END,'HH24MI') as SHIFT, case when (AL1.ESTIMATED_START is not null) and (AL1.SCHEDULED_START != AL1.ESTIMATED_START) then case when (AL1.SCHEDULED_START > AL1.ESTIMATED_START) then to_char( trunc((AL1.SCHEDULED_START - AL1.ESTIMATED_START)*1440/60, 0), 'FM00') || ':' || to_char(mod((AL1.SCHEDULED_START - AL1.ESTIMATED_START)*1440, 60), 'FM00') else '-'||to_char( trunc(-1*(AL1.SCHEDULED_START - AL1.ESTIMATED_START)*1440/60, 0), 'FM00') || ':' || to_char(mod(-1*(AL1.SCHEDULED_START - AL1.ESTIMATED_START)*1440, 60), 'FM00') end else null end as overtime_start, case when (AL1.ESTIMATED_END is not null) and (AL1.SCHEDULED_END != AL1.ESTIMATED_END) then case when (AL1.SCHEDULED_END < AL1.ESTIMATED_END) then to_char( trunc((AL1.ESTIMATED_END - AL1.SCHEDULED_END)*1440/60, 0), 'FM00') || ':' || to_char(mod((AL1.ESTIMATED_END - AL1.SCHEDULED_END)*1440, 60), 'FM00') else '-'||to_char( trunc(-1*(AL1.ESTIMATED_END - AL1.SCHEDULED_END)*1440/60, 0), 'FM00') || ':' || to_char(mod(-1*(AL1.ESTIMATED_END - AL1.SCHEDULED_END)*1440, 60), 'FM00') end else null end as overtime_end, case when (AL7.ID='CA_AS') then case when AL9.NAME like '%CSO%' then 'CA AS CSO' when AL9.NAME like '%SUPV%' then 'CA AS SUPV' when AL9.NAME like '%SVCL%' then 'CA AS CSO' else 'CA AS Unknown' end when (AL7.ID='CX_AS') then case when AL9.NAME like '%CSO%' then 'CX AS CSO' when AL9.NAME like '%SUPV%' then 'CX AS SUPV' when AL9.NAME like '%SVCL%' then 'CX AS CSO' else 'CX AS Unknown' end when (AL7.ID='CA_LS') then case when AL9.NAME like '%CSO%' then 'CA LS CSO' when AL9.NAME like '%SUPV%' then 'CA LS SUPV' when AL9.NAME like '%SVCL%' then 'CA LS CSO' else 'CA LS Unknown' end when (AL7.ID='CX_LS') then case when AL9.NAME like '%CSO%' then 'CX LS CSO' when AL9.NAME like '%SUPV%' then 'CX LS SUPV' when AL9.NAME like '%SVCL%' then 'CX LS CSO' else 'CX LS Unknown' end when (AL7.ID='CX_ROST') then 'CX Rostering' when (AL7.ID='CX_SP_CSO') then 'CX Special' when (AL7.ID='CX_MOD') then 'CX MOD' when (AL7.ID='CX_TKT') then 'CX Ticketing' when (AL7.ID='CX_STCL') then 'CX Station Control' when (AL7.ID='CX_BS') then 'CX Baggage' else 'Workarea Unknown' end as Workarea_Group FROM TB_SHIFTS AL1, TB_SHIFT_STATES AL2, TB_RESOURCES AL3, TB_MAIN_SHIFTS AL4, TB_MUTATION_CODES AL5, TB_MUTATION_CODES AL6, TB_WORKAREAS AL7, TB_REASONCODE AL8, TB_RES_QUALIFICATIONS AL9, TB_MUTATION_CODES AL11, TB_DEVICESHIFTRELATIONS AL12, TB_DEVICES AL14 WHERE ( AL1.SHIFT_STATE_REF = AL2.AUTOID (+) AND AL1.MAIN_SHIFT_REF = AL4.AUTOID (+) AND AL5.AUTOID (+)= AL1.START_MUTATION_CODE_REF AND AL6.AUTOID (+)= AL1.END_MUTATION_CODE_REF AND AL1.WORK_AREA_REF = AL7.AUTOID (+) AND AL1.REASON_CODE_REF = AL8.AUTOID (+) AND AL4.RESOURCE_REF = AL3.AUTOID (+) AND AL3.QUALIFICATION = AL9.AUTOID (+) AND AL11.AUTOID (+)= AL1.MAIN_MUTATION_CODE_REF AND AL14.AUTOID (+)= AL12.DEVICE_REF AND AL12.SHIFT_REF (+)= AL1.AUTOID ) --AND ((AL1.SCHEDULED_START>=to_date('10-10-2019 03:00:00','DD-MM-YYYY HH24:MI:SS') AND AL1.SCHEDULED_END<=to_date('11-10-2019 03:00:00','DD-MM-YYYY HH24:MI:SS'))) and (AL2.NAME != 'Canceled') ) D where (1=1) and (D.SHIFT_START_SCH>=:PShiftStart) and (D.SHIFT_END_SCH<=:PShiftEnd) order by SHIFT_START_SCH,shift ) DS ) DST Name=CathayLogo, Alias=CathayLogo, AvailableInTheViewer=True, Content=lCDCDA3YBMDovrUp4rVbqnk0cvgs68gi2IqkmXUQtTJznFUCCXQ7TWKC53KEtvH2au1JfA_x002B_i3yFCmYQk2s1I4BPoDpLcWeKgRZlfYNRw_x002F_D4BfmpilQ5HcssxAab_x002B_F16iAxxV41P9md3w0_x002F_joYneuw5bq4YJTBvhNjd0ySzPP1rXUZhHLHwwieitokMG0oY_x002F_z7GqHKCRHXmJKD2hkOhjBTJkWLS5EN2Dk8h37yIRAMOTOwNuoSENDES4MEBYxBpm65UwS5Uk6c5pF_x002F_6y5_x002F_HtIXDHDlcxfQmqqgZi1h5PLezgV7GgtlwJyJKJA0ZETycX0QzIbgLX_x002B_j4JZ7vbwSnNfUEx8UoZGAcAiS49s44hVz_x002F_Sn8qCfcB3N83BQ7yAVYI5JsViCa4hICGf_x002B_LmSlNcoYpg0_x002F_y37gVZJtf8mi6vdVQ0HHIvUD_x002F_EWybsMy4N9lZeeoeJ94UEfHe6LXIwWJdL_x002F_KnoN_x002F_ULXVYyNLL8hiKATvLXVJ54A0ESNJYMFSN4j2lNdZw6j6pdNNnha34SxkHxna4jN8_x002F_HeWCkvcMlC5C9kycv34nq0H_x002F_zr0_x002B_A_x002F_ZVoGSCKBQE_x002B_c7l4I4lXiUh9TRnGwklrCy2sYTqy9KC_x002B_Wf_x002B_RJhCRJtakN860x_x002F_g0oAD5M15STtc6vizszCkyUrk64SFJxL9OO5tJhNbWyRdFFXRojt3WLiCC_x002B_h8o7lFwRHaCvoDxoXm6ehXIeDVdxzmhuHgfhISrD03ozZtJ32hrY9zk2xOvnuSfN9QfN3wlnMQNnEe1K0sXYentOWMfmLTk1G_x002F_MQo5UP_x002F_9ojm77bPZ3k3MufDPgE7vnf21J43Gfj8BkD4jdjJKmwzfO9mCbSHFHP8qiez4NI3fxHbLaAfECP_x002B_wxji_x002B_9MjTeUO3IY5c70vtzk0fheveM7F2175cyzLBvzoOlRFhN_x002B_RKwLgM_x002F_nPCVsXTw0HzUf3Y7oymrnqtRODdqqLH7hQNZ3wveFpIW5n_x002B_rISX36mjZL4P3hg77SR_x002F_fCaf1fauTmDGm9tSsIoaJtW1NqBCNBU955hBQDTdK12jiCEvT30xAgkNUccZ82fo8PaLAhEas6GjrZODshK_x002F__x002F_PWq4Hgzs3xVLPNdmMCKsBcVdlqH7OoURaHCOeBcOlxKc4pRGOxWfQs_x002B_cuTyffmErTMFYmZcTB30eCK9H6Mjk9RSQghPEww_x002F_8aNUxiEi1G6I6zlPgVbqag8n8x_x002B_JfBNG1pA7_x002F_WQNWwzFaPNX3d_x002B_P_x002F_LaGFXT16iLFy9kVUPRBNeAyJ0umYnQnWxuwMAzlxG1_x002B_PPHd_x002B_h8CT50t0s91zFlrD6wbF4UTTQ9fy6m82hhvXOwV4yfPwJdxs7XuGUCDTXEL4N4glAjLQrknJFDhWwz4nSTOszAfeFYymrSYGcGND3qei2GXNpPMz5SPfYeABrXVQWlYdkt8rHGrsHiw87aSlrYHUTxTi8Zhl93ifb7FSyUCwrEelEDlgFyFC0Ex0J5hPhfJWVg9VK1Pd_x002F_3U72MS94En9j_x002F_Cc0N87RMhusDw_x002F_9JF717WAU06qAMmBttcPfvCE0Vhsy4Z6AezBiSyi1M1sJJ0Rd07n1KMEGJUAXDuocuJQQEb2J4UsD2Il7Pi6iHcB8v_x002B_waGkB9_x002F_JcPfVcjvXkYSRsWl8pO8Z32XVQ8rxJ8_x002B_TPDFViYJym9g4t3FqTB2ios7kH82JKvsHP1Qq7QqYubt2X_x002B_a0VeqIoW5GD8LaEU8C2HwHYBIEcBUIS_x002F_Ik1P8bo5P_x002B_uXEJOAEmsVX62DSfQfPlUfso2XHrTjYmXHcCMqqHAKpmlDHR6mcvbql7Yvd2TjHez0zarm5pMlhkChLRgY30FTvtkV8yK2SqBPgl7MmCBRrM2WB_x002B_sYpcVWlNWWUneru7Z8dFHIBx35CfIBXKXoF_x002B_cIfb5XlBWNFPmqLdYV9f2oZP6LGqZ0uXQlGjcEhb7cR_x002F_o04OfrrtZ2tHS1Y1eOY0xXBxLwRCxZaBgMswRsXfPHQG5ZeCH120YpxBZppCeySp2cmdf4E_x002F_Djoyifz_x002F_ODFe9_x002F_ahskJcHYOmek6HbqQaf0cWrbUY2Mh72wuo83EBOOkKKmmXCVLZcfyQXv8ckL7_x002F_uj3DjP5aAx7Fp0z4PfZy3_x002B_y7Fc4wLxGoT_x002F_kApXvQE7M081YJBRSKZhX9OHDROf0rRr6vX641ZX_x002F_lBjeuYYF81X1h1d4rMeSBAYj4GfqBDdnOu4YyCZZhu8MqdbvZ70RgFezboM4wnGQjSO9eyhQOPXBW17zYrz4uoNlZ1f1uYAgeo94dnZ3vujN67GJfYUbxuT8q8huFbvIfG0_x002B_uRRftaAGtVd1yBmYbaBjb3UPUR7K_x002F_kVx2X2mBDGa7Pq5XNOUbiAmOrUn_x002B_m4zT3ijGdIBX52_x002B_FbquurZa33kNXw_x002F__x002B_BTxBqXxu6dMXWB0O8mDayG6j_x002F_M2xcxnd5rMpBgjVuq6zZ0gZ8HtrJmPluLvEDYT3h_x002F_RaUnziio5zdWsQ3_x002F_WlZ7qvb_x002B_kBSNKxURNjEtBagVNyAMBgcAd3BTbGULJJxopJymjMgRUF5WZK_x002F_3d05BBO1RNHMKZPlraRYbeI0K_x002B_z_x002F_AhSbeNmtllXsveeFlndtGROYliT7ev_x002F_Er8IU5hdVPfpDQaeFBZ3VENNQQwAdLjfd8VTPf607Q43RKbAHPDEACWyCiR_x002B_4isj_x002B_cYGfnZchnXRo9Kvs89jYV_x002F_dDrgF1A9G_x002F_wCPVZ5yVZh5TbZZM10fpfyJhZs5zZPJq_x002B_AC1MVqZ70juxG1RHkOiLts5sb_x002F_78VkSaWeoD63vPga5Xs3TmnXWVtzUtMg1B400d_x002F_po_x002F_OEBSe851CDXmlqhueqskkDjVGDJ7x5tjjRtYCu4gcvxgDTQrrb8gIXnHhHCE3WygZ5A7TI7TIHMvxfahq2fTAnIb815DBO9wB3M5IqyZH_x002B_Kfae8xUsUgB3eW9_x002F_WXNjKCZcCX6JuWWoWgO4P8IyAmGhUigviy_x002F_87ouV7ynr93y78ul2u49kUAHDYl3xNXqj0nmezUWTJXDt_x002B_ngyob8unxiWNT7ud7vXWdOIIQf5Gj5J1VjUvC17xzov_x002B_yfjO_x002F_B7c9or6uUD_x002F_WFC3iSH8MlCR0oYb3idbKRogW90p2Fl8K0QhVnv5_x002F_UN2chNq55m5AitN0il0EmJL0MyfQL7E_x002F_VTSDUfBo4Po5UDXukm0hSeUKFmEXqNcStOmRR986T3lOxnCnnfJI775u51yV17teTCCWQwdlWjIh_x002B_m152Kpq29tYJGD4RRzu_x002F_2_x002F_qNG6nkLlDKm_x002F_sopyC5t84qLNtjBzILVYQpTRH_x002F_h95BAP4uAKHXohFrYPIFvb5KASwJc056vL214iW5Z_x002B_g2w7ZSJXHVD0QAMB5mSTIJA939OiBDTLUIhj2JI6dJRnm2IkVNT7_x002F_oKUP3KZc7CzcLzwH44FTNNXurJoHck5XZOHtl_x002B_2MTuLTyUSawKMhVOE7b0iaTJVSJnRE3YEH76tK33cAr08Gfx_x002F_yF_x002F_7uXKfoNnSK5qiPguTVt3Ylqe0nLNbfhiFulmzJFnOyJcTpVk993qORoi4GDukdAbGwL4I89K_x002B_Yn5Ygg1mrm_x002F_HSnB4EwpFwAGXX59w_x002F_6l6PI5Xo86nLuEzGbZpPMnmqv2jF_x002F_5rHIwB39gJMntNfFeCBqBJaIDzKcjUh9N7jaUiogDJQUfbtomqkx5Ir8CbKQddv_x002F_CY4iKUHRDWeSxP_x002B_ZvXZ_x002B_rZrxvCs94MNz4jfSCPidNg8cUx0lfHTEyHxc3_x002F_kRLgtnpD7bMFwGlz9SAFPm5FMI96Vqc2z8uzCn3HEXB6WLlK5xX_x002F_jXPVuJuRCSAA271ghqzWolKuwPL4EXvvxbd_x002B_FMDIzaJJ584VhAfxeNt7DadUI2HXYe_x002B_NnBnoMSe_x002B_DoM9gdYJslOn0hqAzTTFbo5yBJHxuBYH_x002F_Hw4k6wpHyWc_x002F_3KxMf7TnDPLfwIzi3ObxMYV5B8Wl9T5S9Y3zAcHOPUGZmfImctJQsHTqGK8YtV2w_x002F_nm9SLT3PIZeIjIhRjXBAwIm2TOODRHWx0MHFsueajBpdoP0_x002B_4f_x002B_Uti9XaEz1DWEn0kP7HF6VeCu0zcjrHXut37BOzuAnEAwhBOVn0cXQ44tA1fVLqJIrwc3ZY0nStFCQka3mcu5eX_x002B_YAtKOSYVczhD6BFQrNpYMcr4IGlmTQ6_x002F_S4sZqbqe6VS6jAkeD2LRdEbrC6Yi7YJJjzg6hNR_x002F_4QrtXT71a7EEhFUMaUAbpkP7l80Mpv_x002B_s5fnkj1_x002F_XqMdQ5OZx7u7Hg_x002F_yAkrGeICwXmC6nEkqdU66IErgZ6e9hAMZETkvbuAlICCpbYdCqxSq4TuDRXTzrISa2EGZxB5XwL4EOvxAof46ACrgG0BiDKovlMyjIiqlz_x002F_CZi1whgpIXRbZepSh0bhLdvRxcVlT17Xbza3johyUd1SOM1EoREqnS8GOiVW2Ia7YB7xM26bfI1bYlyXarq21hrJsecCYfv8pG8zYDZDlAWY2Gu0kvyWtlhDBAa_x002F_e_x002B_T_x002F_dNkBZG8od44MKyGOADCuuba4rnlrvoqIGrSQy4uBqgPYGiRmdnkdAWqDuTQNWwmxmiW24T4UbkpDMf5DfWpu6KnVdnedw_x002B_xZHctN0QO6KygG8oEjCKQf0ZsQc0AMBdeQs_x002F_MstZDkRxQVI8xFt9AdHYOKuX9ws3HnB6jtt5wDqtHFZkhXA6iYZzt8yIPHCrtcfnJZmesZd3YGcDOBb6M2FTM_x002F__x002B_NK35ZKTqcMuWQMhilsAwo44dZblHBTXgQzRyRIzdYYsssMw2zGvJWiDfplF_x002F_y5Yc2mrG9NWQKGqdgZr1AQIJj1bvNJyAQ9x1TIfjisyuk_x002F_XTJ7MOIuPY6je5lqf2d5FpccefXeF9ID889sMncudxx4K8yi97OcZPjCaJOLMUp8_x002F_U30LAQgBmLxrLBIQCJpIh6LFRGNdnedNbW5sLyFKp5fEHPlzdP7jthjKpeZhLehlJMG4pdT4JZDGOqyTEqJtqKsm_x002F_83rvSCsUIL5n9DjPPNfV17Q1Fx1T87FuS0NkHk_x002F_1d3rCom2AbdFZuQ_x002F_aibcBWI8CKQvXdyQChVhAkuIhYAzuhPivrqsZEXI6urbXtXaCv2f_x002B_OSoVZGGWAx8cxper5rgTox6_x002F__x002B_B5ueDyIHulvhYkwgJF1Jz1Pcrsz257jEtCKHM5n3ZE5ZqLCptX5WkMEWR4x5d1mikXIUXfd1jKyI2uO6thc65641CWy7HZx9uxW5SB5upF0utm2LYWUUuO4jYZMXERmjOSgsEKZ2i5kH_x002F_aXw9U47Y_x002F_116Kd1yAH1z_x002B_vCFZlPUJzwz14Qsq_x002F_8xy226zLWNIqTo_x002B_GN3nZk9siTKo_x002F_Vx7Zd0PAc74Rl_x002F_llA_x002F_92tOdJ_x002B_wIYKXSg_x002F_gBxWt7evHPKtC32HnKMegEzlfusFkHzIWmkLWUCMo0devLzup_x002B_cnmh08jk2BYyyNZhQ_x002B_i9o8ARob8VkUIfIEW9sOUY7NVHDqlk0xYXL8mKNgKsPB4N5Q_x002F_APGThc8eMl_x002B_p21LdaOkj8joI_x002B_akozvXamCJ8oPGYHTI_x002F_AFtMZEwxaSYKVgs_x002B_D1HP3FLyFEsX08lR8xfcY7QLhP_x002F_5JtoajA4mGQ0hJNod9JWp2ykGBjvfHp2h5N66qhhtTvWKlSUpnsIxaWj7OtODY_x002B_oudaJbf9yXjuNvwBECuQD3U2OZ5T46Frc815nEzVCzsKGF_x002B_GNmWUC_x002F_ArYQfoNPfPIzYHrY5lklnVwtfsKT8cvuyBcVkXPESukzYAPDVZAGCGH2xl_x002F_GTUFHl8MhD_x002B_p6HE2VAV_x002B_4KtLfzw6NuoxXEm_x002B_sHS3TVFajshtHNWxwYSAzMSDVBna25VBgoTSbYN0w7tiVm9RenuBuq_x002B_L8IV43SEXTE66B5kg6ip1n3zTfLaaZ49mUI810nZd95baA4FBkJb07dUFeZYqbXZUd8AQRXmK3KJpJCKEZIFs6hkumxZkbDqq9RZfDmqywqYEUJu12CV9lb5eZMPJ4_x002B_jh8CjzLjsrVa_x002B_j2TLwsRWQEDOZ0pzVUkAe3y4xpa12lyB_x002F_jO0hzCjDwp_x002F_GIGHB3gxqc1tlhN1h_x002B_JuLjvNBYAwFVzEX7AQSuh9iw5u9RDOQULbd1dPbQxZTsvdy_x002B_ZnDA7WkYcnqBIDB2dGRX7sk2L8kurbvQQ4lYhdjCkQPF8TsvDifUTEzAN_x002B_G4ZAW2IcdhACLRH9uSPQ3ilbVaxPyRDOmtY2VxGNOqgolLZtg_x002B_p8PR8kAfElV2SCnt2PxyJiG2dksOUYQl_x002F_gHQC7cuc3VfxEJLZcUf_x002F_DN8C4UVjQG24R_x002F_JVG7GRYWMCMwvrkhqyuMFapH86H0Bp5Y7f3lDyAEQE_x002F_jH3p_x002F_OcAyJeH6oqx_x002B_6TsGqD5KRJZL_x002B_Zo2_x002B_w_x002F_Slv1OTaZo8hprkTIQBcqZUFKioecMrAwgRAn65jewFwjX8EFkdgrSzg8_x002B_d6nqgrBh9ZD3uWthmeSeCJG4u_x002F_mxhrvT3PGBfNOJxLxfE_x002F_2tkNfYUjZO81rIdhYeUavyj6x6QTUnjnxboT1J_x002F_g86n_x002F__x002B_azwZY_x002B_qub4QTg_x002B_ph_x002F_XQPG7YdLE6032uMyRqaNMZ4wULU7yTWdvhCysyWlsPV6R4dC8FogrUSwyoTdZjC_x002F_uEcd0VzmqYSZdydZ04dhuNd6lgqb1JH5dndKOv3XVbGTxZDsORLd27SueAJQFs_x002B_ybAzsZizQqPGkqTccqtfI4yUp3ZYOBo0P8svQWrnW3BUBPJmq3Au9s1Yv_x002B_FAU2h_x002F_B8yS8iw9v5BW89H49YxeLk3vbKORLW13aFOKCZTFlQktitXOS_x002F_Bl8cJTJGsdtCpTOQkQ1tCVM708tnSDewoYUetxCf6spi5UUBvfIJh2W1j21NWeSDp81AZnmaj4vVkM_x002F_auHQqV_x002B_NK7ju_x002F_sf6Fh8sLQ8h_x002B_ABVH351wIrTHanaMCbHHefKBK6XfPiKeFtXEAyVLJUPoBXSTrVXK5O6iaT95ikPBS7dkLXtNw2lxLaKGyekhtZCCoBO_x002F_BPk76hyLPkcxm8QgR2H5UDGOu2Vv5wTeDsBZjfqqKPQ2Wl9wjqqhkaQ0IK32FskmoZY8EoPS7zucjgoaW6oGAFtpeqtpioINLjVf56Fi7Ao_x002F_ZgmxhXyJLhQ_x002B_4GfYnbV_x002B_NZ12cDLz3_x002F_OKwvjn5oa3thVfdUGZb1t6SvWFhfr4lvHmeuQ9JMIwyIs_x002B_jduW_x002B_ZghhFeePKcGE5Ux1HjxMsYnwocYFWMvR3s4Enc2SWc0D9WwGJjt3l421twLQxhP3mFIaTZXruucONLvlbL3HWtUCEYmGwYQ39dblVuFHswRnuCBCCIyHt9Z5zEEONgNjwfrTmEfGPia4hpXRj8rOLFOdjy8WFN7SYnHLaubDtAZHZM0QbSEt1b1RWyXlzAzkz9srYNFUaAFv4IlKwst4HEKr9tzud4zC6K1oEtcvrXqgh4irQpkT9HjKOgUtXM13_x002F_zIsGeumoTyf8NEGIK_x002B_sYKtlMWoU401Xt8k8aRkfXdyd7g5psqD5TAGjqe4VQVnqf9oV8MC53wZdBr2gjPipeVkko1nI3JOG8OA2wT4LbdB8cSMQ6bZIrBxY_x002F_z9prldIxDnYTjgCSFsPCpiAw7WYmw0S8MqLMRHZ0EIHfOJ25kQVF_x002F_TmddU4h0Kes0YUBKbT9bp3o4YU8N9LhFTL3I6yOLCkjywB087BDrWqDvHSnHt4s2ObtLCfp2bOxhOGPyYUwhrzIxJbRUkjaBQRkj5B6obXL_x002B_Z0B0x_x002F_OZtbk6qlBEetj8L1oLX523NisDjMaSxvFw5q8r2_x002B_xBHvMKZwkj1vU_x002B_mFsHrTwXgnXKxMe4FhAwJXOgY9w0RscoWKte4nyTRCa_x002B_f4nLgxFbCET6jrNi907FYr5Ffznwhg37AYPP4MZ1EcTM_x002B_MNdxsNJTmHS0oqZJdXKfzdOsEVwfDo6AVwWV_x002B_nRLm0KSn8p_x002F_zW169zW4iEXCOTV7PbWHgPylwYVzq_x002B_oBlRQ_x002F_k6FmySD1lW3_x002F_65DwXl59joMgI0ppzuQwI9eKq3_x002F_xNhdajPbDqkgJBKD6pNe8QVTWAgQzeDbiy3A8Hb12ZyRbTEixTAdQp12d6XU_x002F_9euzqGSZfEO_x002B_EEztZaJBjdX9pEJK2OLw0X9LFI2mTTNUit29pN7jYm3l_x002F_umDjux8TMFMKrkoc0kuQKO4cGtQZOD_x002B_DMEU1_x002B_KeArBiXVq4uJdP5_x002F_VFMm_x002B_rk3c4bgGpGQDv953wMmapBI9UgmiepToRj1IhmXEJMb1tXOMpuBQCLBtFkxn9_x002F_P_x002F_i_x002B_G_x002B_NH4NQ9pM69enP2mC_x002B_Q8A7muluCU2gYVpNKy4sSP4ni0QCUZ4cya1hG8EgubkvfGgD1VMtZYanwQtnJ36ZynpTcv6IADJULsMWdtfUlI3ddkyWxIltuS3O_x002F_Dq3pgj2eEohai654DaqUnMVldsWBasYsFnQACzCB3ZKvpUS7bTtQhGymhPgiJwdUVmTZDPheLlRl8lJ14tM_x002F_Xp68Yp5C7h4bOpu_x002B_Ctc0Q3s4e2JkO31QoOfZJ6qbKEZA6UxhoOMuXvgkza6iJmwUiuEG_x002B_jtAEs4pZc_x002F_xt10l5jT65KIp76bHqvG58bCFZFiEtzp45cNVzoWM6tbJWxDDbt3gmjzkM23AYRmQkiZLAd_x002F_ThCKcwSjRWUxSsKf5KpkeiPDCl3GjQiAwx0hIT8J7RO7hH3YE_x002F_2_x002F_KiFe_x002B_e61mqVMtcnoMya3XgYMJvORzn3ktvzrOEVMHE70xOs6QYuStsnsRUqVu9Cf_x002B_XG7yY1k6N8uDx5puvnhsPregKvazvSbHAgpGGKaZiblECPVw7nLR9EX8s8UbcVp7tczALiiYL2VYZUBbZga8R3cKGYXGSlHSst5ibNz3PWq0R1AhOjHARvFWCyO6_x002B_iilYix4q2NL6ep_x002B_FFcuCgBWPnktjg4AfCmdQRugqOVk_x002B_TjlIDo_x002F_rU1avgjkaBckg2vlCL_x002F_OktIUCTn8NgkkmX2cU_x002B_jQ2M_x002B_yBX5dAfK3jvB1gFr9nZUMJi9E5oKOxW9REze3RI7j0ldFnL4OZJdtJIwnSO_x002F_ReLQVm6aKkoEqnVUUUXKOKXQEyuvA9GvgTupSE1hp4gKpQdf6SpKLPm9ecc_x002F_aHAMfQR7HDO8UTD2NEnKYsQvxRuxyUPAdEWx7YBksNoFsCA7wLsK9hHqd_x002B_rgJQ23b4dzTeHtrp9ALaPZqtM0As_x002B_71X1_x002F_ehH3JRTu1rmcSjgdeY6uOAUMUPxDARtJ_x002F_sUrsYBoE_x002F_LaeK0RyUh7Xm0tNAeHF_x002F_nJpH_x002F_wMbyY8j5eVYuqv7yE6VIhaxcQuFmTtXAqiRe93_x002F_KQjKr13mtXsbXqw8zGqTBDLT3wZJAYZtqloO77huvZ61eyilUbx1nq8R_x002F_nSIQyPGaczCT6CsXLMuGlCks_x002F_WiaMIVdkpepGD7xDOSCgL5VNoi7LTfrh_x002B_uaDG8Amuq_x002B_VN94lfpsPqzGtsroNs7NjHATw6tKMRXzimhC0HbVl2vGxRvzZaWl69pxBKLRWC9fQ0mmb4p2TxTHPpPMFkyFBw58tLzpJvkfbtvy3cwTzK_x002B_zOS_x002B_J9fgyL2idG534UOulO4yyu_x002F_s1kQMsPobHf8tA8RzJ7uUSRMAPBFuuzhQjfptPVyex1NseL9TcXgbSj13n5aO_x002F_uxM2iWKsgUQYUmSXVAFgyuhHgntE0qWBbJ6vxivI_x002B_g8qzRRKEE8wR9q5_x002B_FyfmJgDbajZawjBK_x002B_7gBzOHHHE_x002F_t4k_x002B_4yjs5rcB8QmEhIO0byTWzzGNJIVL_x002F_4jLFWnJmZI7rHXtKZ52cQWonfjbIUUnL9E9VRwBA_x002B_Bi5ZxG9AK8xtYAXE_x002F_ThT93z11y68an_x002F_E6EItF_x002B_4FDIjqwT6l91226NchVuJgpKsi1cLwpKriv32vshEMFJCNPzw2_x002B_9k3WoIf60aJxqWX9uRuE1atsuTSz0cbEkw_x002F_mLlyN2KsQeihSIrtLaqQf_x002B_Ql0sVoELXJtJhTfxvEy65QfJ_x002F_swrC33icuL8zHxSnDjSMDQsB3MPmNIqlMjhjlfVzI49UqTlUXPz5_x002B_M6pcmbcStlJqlfVGpmeXAdeqQuTV4MwgfV_x002B_Ae1Njca9VH1_x002F_vs_x002F_luEFkV0Z9ATsKUsWILihUoThdiFSRb0Vk80V3LHEsjDwG_x002F_OV_x002F_io5J9MhbUrW7Fy2hbeZWXA54I7PPczmKHEJCWXUOYQEqxYIIM5GS_x002B_hQWXCgeW0n4SMU322FgWy_x002F_FEPHVsMPPex0HYvgsnas3wXfGqLMXkTA579GH3afPI6k31WxfgNZuf5v9OlXNVPm13y_x002F_uoQfxy_x002B_4fb_x002B_MbDAD5WE6KQWqY_x002B_7yiEyt0Oe64sjBeSy3kzYet0GFLVLmuYr_x002B_GgZBli_x002B_pLgtI29FyYlT_x002B__x002F_L3P1KCpO3CrgJjkrFXc_x002F_vSTXXMcYdGo_x002B_KkIXwT1fopEFdw4gLlLqIL5jvINYq_x002B_9bpSQhExNFnDz7A7eHMyqZ0ZhJ_x002F_5Q0cWPv2vcJ8bnEk39e_x002F_hl0qA3sMvpxIgERbtMorItX2wi0RobKoXmyQQaRQwjcwhNfcMZZdPcXKgX3dADiKIserOLcZhVOi1QpOM4S2xoSgGY8wdQDjFRSmXzd_x002B_d3Wu6PkmW0_x002F_4_x002F_AaCErcs1XOylbBoVApX5oUHhBYM_x002F__x002F_E4_x002F_H0ycBoHkJxaHmkrja5kaxcHGIVBT6IQtseNmwoJwSRuleCMuEBPnZ23cliEPf1AnASaGuSAct9EplDHup382GGPlp60P8Qciwi84yL3SAV2icFRp0kYdTb7l6Q9RXXEQ0H6z9sC5QbiSx_x002F_RcUw7MscqrJ3s3rWSvUXn6azqDJWiXlpIaIbNjnHF_x002F_zW6Xp83jZePTAW0NDvMslROTlINl1MgAGCGPruIGZekWs1PCK2fwtBmYiD4G_x002F_1_x002B_l_x002F_WPUIXewkEQkfUjSFPRQ0m9AVW8xkJq7ii_x002B_6YRULxkaik67LQ8_x002B_dfVpKnjPSfYdg1ZVRkBdOgS7wBxiW9BFhDK7J14b_x002B__x002F_gvoFWY2nIO9JZwYP4YOj3dX1A0Hw_x002F_ZOwS_x002B_F4lZgS4p4SxODhYciUvp1B8DAw9k9c12ILDJmR4A_x002B_T1goGVDFnbIu_x002F_GRj7kPNwHPbfaLs5lAFv_x002B_dGqOILAX7bfxFdZQ18dbOkgjrmlXxKEM80JYkpdax_x002F_cPnEFIMAYYla69PYHHSpr_x002B_Er3yV_x002F_A8rBPz_x002B_SaCn_x002F_JS5V1uO_x002B_gVhHYJBbETDDRcxUD_x002F_hX5b_x002F_x7ZNoxzHgg8Nakk8Z8FxPMaw5hh4u34OaevWsWh1H55ZMAXIKXAv0_x002F_2mUy7pMy4Dbi4qs8MokErecdWruNQIKUJsZph5nVxRkY_x002B_nf2EmGMn7_x002F_MxclfSyzW9mNaWlJQq6vi036avcZ0v_x002B_5G4sVsjO5PyFQrXfmxMHoxpXbGB_x002F_0CsDb19eIOfn9JNEeekJFCyt773HrLm3My46DMnLjUta6wHLGRybm_x002F_X1mqFH4rjY8VSHDTNKi2clBZ_x002B_Qrl_x002F_z117Vmg_x002F_C8Nzx_x002F_v4jHQ2EdyRodjq6tczGv5Jzi0PMZHO_x002B_pEfxxM7C_x002B_RTcSfM1NT1_x002B_uqA2Sn_x002F_lYOjPOOg66s8ABlylmJrS0sOJ8G7ZMofa9kJcjyrK7sbChbVmQ6AjsIn6Egv_x002F_M_x002F_zw6_x002B_0uNhk67S9l_x002F_lNoWOucW5QS1oQRJgM9z85UL3CmZfFWxC9Oq5LMF7n8SCF5f2a_x002F_SVUM424Iout_x002B_0HilRrhB3dTxP8PGEJffPCyB_x002F_ohASNOeeQPfMS62nORbGfrJ2ILGmaaMp_x002F_ioYgr35LpSJ4OPhx8_x002F_IhtGqsMPKMPESx5U5TSD2sMQ4Ipm1zWKlU_x002F_IZ2nwbFOqnXP51y6jBjy9kFrM4mBiGMCj9akt4I38TFVdczlFiAfQQI3YbBtHFSOWCH8phqfPkaABVF02Gu5Tbcoeh2tBrzf_x002F_WQWNWO79F582Mf4kOWt7cKdhij1xzD4SdiGfg5DoBepLd3qpwWkcQBzgNhmrjABv9BM7y6R9NARPy1VYDNfliEGFzERJ_x002F_RP5HnUv2XcD5S40XzFDNZNvdDPTny0D3IwAdhFQkwmD1z80cXya625SGf50D5wO19_x002F_Ik3xwrQQoV86_x002F_ioq3JLbbdmG9kll6ODcoMfee6y5rVzsfDUbXu167H1CseqcXWbQQ4bJTHNxBFdZHuhfvTr7zWeADs5cdjCBFV_x002F_vYZfouuu9kLcmXaa3leD4GPI2Erx7aJ0hIV7S40BgsnA17pUF1PKLEbKg6l42O1uf38rrlztmd6GsWt6fhTm1AYUooWKXe9NIrDwuigVcmXrtmy68cWGE1sf3XA204JrA_x002F_3T8nCQII3xk6nAta1RqVTAvELxZgNKHjkCxsRqwfFDCyVOtJM_x002B_gyDOLAaTDtl0uZA3I3CKwo_x002F_nT_x002B_q2YumUtJuEzqDBlviAQzeqmG2IU9hJloKt3KDvqUqtVrKqhN0m5Bbl3MgAUCyYacNoNG_x002B_z_x002B_n7swQd_x002F_hJwPDL55q_x002F_FYvn095WajXQjKnWM99r0zLMrqzsoT2lz3fc0L3hitET_x002B_7VbqF5uMV_x002F_DlnvhybtKLNj0ZfNKe_x002B_DddlH_x002F_UGL0VtzDK3usaxQBlYKn719Nmm4juw4sN4TzsXxLe5CWCVaPUScO8f4aiErmQ4CVGqpe8ihmGR5rLzChXk_x002B_v3HqvrUOdWuQG2qACBxicXZRLVvdHN4fxKA_x002F_GQQBzXlwhHhOc8QUYpAySe3b8vafhq_x002F_3SuSC0dMrLq_x002F_JqL8GJmdx8bU2pdNvOMlOTBMi1syxZOy1tntiTvIGH2wuKHZ23SYGLhmNTbhprBu0YlS_x002B_Ue_x002F_phLbevfIkk1t1hRpegXuhHJmaZ1Xy3lc27TznWOPq6F5w4Y2mwfstVPMSbxvKvRPWdv3jhnm_x002F__x002B_CbdOQ9WpoWF5ZxJv0PSD6EkgN9eyrLo3RyXHGzdjCJzdZwd6F57BZ50abdS0smvuCgW0geSq2pS1_x002B_wydI9N7_x002B_Q3w07TLyZVSMzH8s2GvpqSRkZ05Ibfnn1E5IfbDLx_x002F_wTAI5IVD6e9dspL6uSQPtxzy8ZaZ8f6950_x002F_2YoeeNWv6_x002B_pq76Q24CWk4icVLC9ppDXisJZJiOwGdJ96daLdzN2wvt020tslfW6jPk9T7fTP1pmL2gXYq40qYmPk2zcoFFRSK8xTAJ44ZjKpIr92y_x002B_QtMGTrMFEnIIhqrWIymV2QhKcr6tXIkmRrRhkkl8XlOysFaHbS1jrPdCt9evqs6_x002B_qlanjiCFi596q6MiwcAlEWEuhbec8wzWUlnwDBXKqYNMuWayANfDORjVCKj9utz2dWvJ0dUhye8nY8pt_x002F_LjY0CGSdfatFklH2Wi3C7ZRzSEp33exDVlcTi1_x002F_CaCzcpEoEQJl2jJQOurZetlVSmhxbcR2V6Kwn7w7ZBJwob9T2Ft43dpQrDPDNqJb7nCyenCV2a9pUyfmaPqcUge4laJcsgCdKKp_x002B_d_x002F_7DkgyAd2uI2ZXfWsC5fAVyDVTkRprV4o2hH4gotc0jE_x002B_zgmL8uvdeJT5b_x002B_UL3SVzHqVKbeg4NB8AnZ6bZjoBaGUczLFLyiuL5XNElkVLadgh7UT_x002F_G4CeKOJ7dt2sSx9m1lgnKahfRePDHC2ICIcgkOdwyq7mT24H8lZnbSIkLEs5Czg21LYElRh7Xc3BXbx6g4lkdsnjzKd_x002B_oI9qyKWZ5vCOJoWV_x002F_PIeYK1o905SNaRKlaabhQdqukhwyv_x002F_V_x002F_tQT4tNmQELP1BwQ9NiZbYZtf6w_x002B_Hyo9SfMlL3peQudhLuOC2KUNKuLSovLri1WWrcZkfYdCA4Mpt3S4Vv6Q8JyqIDSCYqzKTIpaudZol4ujw658eAUeXZ4e39kKEl_x002F_2fGWbpO6U8Gxme_x002B__x002B_7jhNpqcWn_x002B_vVYUaNCJLpMsKPqBsNf3ZNoM5Cm98tuq2jNcSn_x002B_o508m0i54R0vTfVPLFxzdZR4h_x002F_0vVCxMi6AEsisgzHDmCsY_x002F_7J_x002F_vE7QdXk0t2Of82cwdz37UgtF1YT1S_x002B_Y5aNKwDrI1MyW1F7f_x002B_M5Zbktle_x002B__x002F_Tru_x002B_7bYwtQqsmVw_x002F_qlbAQEqW7l2Bxstq6ZdYbuWgdHuS5vIzjxpugYQExxe61xn3bAmot5ateu3fWj1f6YhznJliuuVsz8qaHDyu8jkSouHhwzEuXIFC6ygUH_x002F_ItUXcNkiCShqI2rLlvab_x002B_p_x002B_X4S1RLp_x002B_7JjTGNGaDTboJ2pUVgG_x002B_4onXbtipN0Ix_x002F_yUu5Ym8SXa1X1BsghUC_x002B_fP3mZWMUPkn07WjYRz7WdpnjtsBVsfJXXXQo9f2f_x002B_rxIX056Q_x002F_lpTqBPg46Q3rweBe_x002B_ugRM88o_x002F_IUpDonA71qfMR48Fl7Cbfao7WTbYrV6LsnudYC49nKdvqkUHN8A6VKC6iG34Y_x002F_3Iv5eFoYhzjVuMa2yX4mNAQNnOlmFfZcAFp_x002F_Eu1Ry0o_x002B_1OezKM1pTa7zRb0iKI8xPuFTAyOO08J54ploAk7rUJoPt0FF13_x002F_ucbsUnA5xFzNpDeP0bREvnAqTgSvQRCCZX3UbmxT33eblgBIXXydgzqFIi4Re3rfbRVlJXlowno2bxVE7ys0WKByWkzjqssk9B6pm916kK6BnmaKQ8T_x002F_wSFCrbZ1IZV36g3IwHITo6ziW40KU70LR69LqqE9tP6m_x002F_H9NBH9jhHOP0v8IzE17DpJI9aPpfvflh22c_x002F_zyD_x002B_jqtFvShIWXhKDUeTz7tbwgOTAuA5H8MOUttekXRdN1zqkjAosDpu_x002F_7do8xEmnTjMOSuqtjoZnr_x002B_SnbhTWuGFpZ0H3ABuXJu51VKilpATAG0tf6IuexuJzknvRxmQtCVsHRiZGXNvHGj2qCt_x002F_BeFB_x002F_hHnjsy3_x002B_imEZoU1MGY1rnN5Q8xfemtqFO3QBg6cWIiaZly4HhWy7Adds7dM0y4DkhzjI0DLtLsVenGwt0YhPiwezxPWaOG6XvOzjhC_x002B_cA_x002B_cIUpYc0NyscKVHgNnLgtbiAbU5Pt_x002B_OYC6PZVjPdKYvEu8NGifqbpBCNrZNxGGPH8xTNPk6tpOUnmcQsEtOyHzZV9Xa1KJooDFVcYIxVZkReEUgjt4hahXPu9E_x002B_SY9g9Lo1DPhw22f_x002B_HPFIbwMHsc5HVQ0JlBVXmUxBmTxVkAQc973eDxQzdBV2ISJvZ_x002B_bAx4svGbb4pje6OfNEDZcBmkTnqAv7n8FQSJMWrxglDi_x002B__x002B_JFmObpouFzGc35BBolo4jKcuCJiUHnoVvCef2VqcLcarBWAXbsgV3fqF_x002F__x002F_t5OUu0WjIMLGiU2ITRGD1BMyzLbd0ZtmfsWv8cV58QmQR9jtKMAkYMAvD6_x002F_EeCzQ9nmZ0uu5W8ZPFvQwmu2oQzKUlq5goLxd6OvaADJiboAGFajaduh63uNprCA7a8yutjHBDkOh2101p2Sx8xIptjukimWjm78XW_x002F_gvarxdkXWUPMMd_x002F_3zNpsDDLNFOnOjASQYI20Bu3gORfl8BdqyEzvgPWRrAngqBkvLuWSGOHi6xhjsCbC_x002B_mIJCFIN3_x002B_RX_x002F_BS34a02ywt0HzN7KyQl82YKJCPwp7FsXbTE1ZFFLRi2i6rHbqzY0aQL48gZiD7J4Qzn_x002B_AoRsBkNjSRDRfB2cNt1Se_x002B_VLAXNk5n219IC30cgblCzRtcPyJXf3L5GpXanPF4k_x002F_kaFXv28ffVnAM7rMSfM4zKKH4_x002B_oPtsEuqJxZCYixidfFXhCwHRbGnjd1zf_x002B_OOJwpS7yUfVbHfPcEp0_x002B_Vjhc_x002F_TJbCmvjbqjTRv2fH6xJJhwNZ_x002F_b8XNjavOx_x002B_t_x002F_2avzBNG_x002B_UcQRiLCNFLZ_x002F__x002F_DAZROv_x002B_Rhe6JSkKufao0CQjwtqb3cESyrfFDz3U0zbG5ZFKBOsdZoX_x002F_lM_x002F_e8yQrJpxqX228aNMaFpnYG0FBrSh2XRuVVuQsUFxtJwCeMjg14N5_x002F_YJcYlyasdbCy_x002B_fnWPKAEsjUIseHJBK1ag45h16944YHqzydNeNzNbMWX2k2wUF0VdZhncjT3qkSLGxk0_x002F_lc4zgJqSTsZFw1gAX8hfd5YjdyYp2yUauqUMnNB8prIFTltvxesTXq8vr3bmnaA4NFYK5up9R0TuFoBelUUXkxoKmxisPqHaCVORRPu0z_x002B_QLKjPc_x002B_UKlBKa1fnTW34kBH_x002F_CfqXryUlco49yQZO3ZIEJVAu5qUzEn_x002B_M8Xl5y16FbM3UsxmEG0pnupNLv0tEp6mXH5PYWbHP63gDGJtcDTrd1UagvnDWTAXmNYfhT0eRRQT9sWo5A0meBN_x002B_Lw18_x002F_kIagAa8_x002B_BLxFD4fye6QbbQxZWv6gnA9a3P5Tg0eyyEnP5rb2oLIh2urSDuu1_x002F_U0wWIbStw_x002F__x002B_DHsVBVx6JbsseGfiRdJ1B6A33RIclPWOw3HM6_x002F_nA8I7GaAmwc9pnNCMH2C5ye8cQzH_x002F_EfkHRvGyMXNz5cc_x002F_fcX3HjvcIoWvuHVzHupp8U3ko5EtNQP1T_x002F_q2kawqZPOm5HYEj8bBBYz3wM5m7Zl3X1_x002F_webLtzaTCkFevb_x002F_6MtyWH6aEUUpn8RfV2S2JDTXs1zLDMcRnHrYKVowHQzgecGRTgAFHoArSjUbJTPskOVjalWEDHUGG65R3PKYq13kmFfpZIUM7TuzJycY9dBTnNVnneg3eIZMg_x002F_8Jiqg0e0bwAXVFz8Y5R7ucb4gmJFU_x002B_hGAn86T1GYyaIMGvpXOxLBSYxGt2OKuNgdf39vQIlDBBvGSqjLMPyIggYvw5KTbvA4oKrdAp14LBJekqM5rpFU3mrNKd_x002B_6F1M46CQapNuqU2_x002B_rX4D60WBrzar4iq7QHZ3BW_x002F_wxqVxn0MYjI0doSL2Z4b0yQlLmCPpbcou8hCDKwpFKvVGpRGdaE_x002F_mJSs5h3NnUiAnZ5Ti9dqC2mcVXV_x002B_3ToD2cPGNhzh_x002B_Zsya4tulIMDUEgC7k8WRqKBmU1LFleZH2AMraa94M4yEZfdovx8uJtIeabY4yTT9o7d3QWbcDoLax3fIxm_x002B_jnAWCM0gOIJRoYBGNXd0u7g8L8cKuJYSqwBSmkHiof_x002F_4PctJMLOdUcp82ZuO4G5N2PC82EpuQwoEqv9HHMwR5wWxZdM4lNY1FU6bjhbmU2QY4Taz64Tklem6cnJsgHWOFrZOCIeN8SzvK7CxMoLSip9tPSRwcW4BmyqrJCd2VDpRUPQG8oQjETiNs0RLZ49eCUocNyC8DW6zDbOWvvAj4pUTxQRwWvnRnKF0op7yALIMUhm0krezfwUSeO7byGRkjhjQL7Jw0jW_x002B_N3L9D4wBEhPR2MR75WB_x002F_XzSihOHI1zjqej_x002B_kEDYXm9fzG4eRYTh2f47HSG6v5XkEvj3_x002F_YuAyAc6ehsCBNlYAYQAoa3PMaAwLQsMELI4_x002B_iGkt1SIxzCzHKJfflATg5zCJ6nNfye_x002F_ZmgUT7b7et69t_x002B_re6yXFq0eFPxebF5dExZXIVC_x002B_TRMNVE1JA0rUUc97zI4a78WWA7gM9tlGivdEDBY3LCAibuxiPNS_x002B_aVMGUszzNqyOkRD0qh7ebI6g1yr783_x002B_Kb39tZN7_x002F_Hqgn5_x002F_rxAwARMEBQwbJJa1nq_x002F__x002F_9QeILKFp5UULZ5vdQlHo9HwRtL9rnWHp0h57TW0qqBZPDOESUk1_x002F_fUtGQb7l_x002B_iITdT_x002B_Rre2QcL_x002F_kHuJyJS6DvlTvx89xKDCtFmgT0pmWd_x002F_d7NmFgH_x002F_r67wGb_x002F_MJQNW8ADXYTjxHWjU_x002B_OD1Ae3C_x002B_3y1uW3PJzvChXE89ppkMmR2E2cHeusHwE_x002B_zUixqyVeWWG4Ze8XKjFrk_x002B_vZONK073o6rJhffqyVNz2xqODKXI38Yfd7o5DSJRG3WG1m3JkG3YsIzfKu6WrHCkNnWzfSF_x002F_S_x002F_AC_x002F_bsxjNX1nT6LeZpUQS3NPFqtX4faDvw8uvTz46ZMq3PUuDSSOtGjgWpqzLLDWTDg2wcDRVxZ0URJfWMUGPFgoeJYbHY3MvfLot7JtXJyQvglIJ_x002F_rGpDrn3lVa5Qi9C2fXt0htM76xlsbFtyQu3_x002B_aN1MlVTJNT8VACvCgWpNKBdoswz2t3ITTd1KvU9xuIna5R3Q4h7NqxnSBADvwZ6sPapQPF24vvVyNi5bHtbZHDyo0N32m6SRGJGHdeZwYnO7RqK_x002F_lbVpRQuwm3f0fDiBzYWxRHM_x002B_Wd5qFGdcJlxfBtiCnhfsXj0vttOrEheipbg2fuBkUXCHcngyV45kdlMCIlltQ_x002F_GY7u1dDVXjM7flPU4Qu7PVfdv8PUXujBbVpUFDHuRwBy5_x002F_LBd8WbuUNItyIknNf9be2J3Pr5Brfw2UgJODYiTx6oKsl17jPfqnm6LUQngxkjLNzRfKwY3dEgTaqJd_x002F_V3_x002B_LCp0KdSWK8IfLu6olTfWZ_x002F_85zu6Q_x002B_O9EN7Trf8DzAUeUpdE1ZfR_x002B__x002F_Pu_x002B_nYHP_x002F_vyLHsWDpeJvUMerOOkdqDDXkWGti8Ir_x002B_F0fmG_x002B_4Sxo5G81kX3sUgyN1L55g6LS5FFOSbYd9BpaxD09RGm_x002F_an4oYMkDvpmQf0HRZNRm75njRv_x002B_mpoLD8JOV8cBsOy_x002F_TsVtQC6GNyUj1Af8_x002B_0bA8CmeK_x002B_boODnjA_x002F_RmmkwcJkY_x002F_RZNPg4pDOxdAnXUzCcoNHMuk_x002B_Bn7KZcy4oRG1quRZkdGEd_x002B_LVYLpUp5aBm8NIzjFCTxBWK7tSum3NegAU2AMkcPepFboQfvAOEkGES1o2vLfChLajOxKcz5wm25GRYZGS9rlUTqJSyJeLohS_x002B_2VWwPITaB6OzljPLlTrCH4E4lEuwv5FGEjW7IbTRpnTt0gPNclWofB_x002F_v7P7YogWzP35VklEUJ_x002F_F6FbSidhF0l_x002F_KOwdVtXiOr9M5eruFcehwqFd6JQ1dE9YU4MbWHmIxP8kCDxeCFu1Cs6ZunJotSwRUb8dSLu8Tk3FJgM5ogB1V48paheilbquwe6dvof3tswRBmjXCWa9B2wIq_x002B_K91uoxkO9iKIjUcPAPB3KrlE0iTFNgM3K4_x002F_1ae_x002B_s5ZRXulwjJGSMxdYEr1v3gggODl_x002F_2yfu1ithuWFRcavYzWXNPs_x002F_WH0OuOHxsSt8dAL1iPKT7JV_x002F_M_x002B_r3snDjRBc_x002F_9ngmH9_x002F_FKFDZRviWeViFa3uTA943KKsV4V6btkO4kUkVkYdYsckJdrY1zpxmX_x002F_jgGTpeXCo7Z7yXanag50xA0uWM2rGi3dcfZOGLNgQ8wA3U2bxVLlF8n52mYezDoDu8uMxBqKGgBkYcoorOlSoNXIYzecaULxJJ_x002B_4mRjF_x002F_oXSYx9VOdmSlNNQjUyr8hJBfj4idzzLDOMYV_x002B_4_x002B_5w9Y6BnXc336rsk7cTv9ac7DS65r9g2OgEFleJbDr5_x002B_1m5eRtCY_x002F_DDp_x002B_zihkTkCGjqHaia2zAbXCcUz86_x002B__x002F_C_x002F_17VcHkjlhEd6HybhZO3xKVXfUhD9ySLwa4tdoN1Uju6GMypZn6jD8dskkwYKWX7i_x002B_sf_x002F_fNGuf87I5uRupf3zdwhgAtdUTW9e2w_x002B_CO9lG9DLQ8XhjuQrcZWy_x002F_KCZAxUwFYCYdW5uY4B_x002B_Okz4dnvKzqqpYGTVN4HEPwhkqaUCbd_x002F_OlU_x002B_AKLcFwd2jMOheUdfbqu_x002B_HIqN_x002B_AeYNK0lHMi5FdzHmmoysXa7mE4924Y_x002F_9MjkFDWRNtpuk4vJd5yeUbvBYyl_x002B_cQJ_x002F_FFN2ovliHFuBmLC73IIgoH57FynfplVbomsDgf8hiPYy2vLrIZA_x002B_JVaxRmUgpjkc2H1fzKrlkTAJbrQbAVVtW29AW9YgEUXlDkvccstwMh40hY_x002B__x002F_kovjxeOr21_x002F_fKho5U570U_x002B_tE3HC5eOP5Fc4j3JRjFW6WU8kP7anyB8cGNRKwrJeFEXO3cZdhhiln2103_x002F_4BOVnfBE8W5z7poCXjIqh_x002F_bCavK_x002B_7rJvDiHJTsJnVybcAxWpuRQyY8b_x002F_gbAPuYd23x0L_x002F_Ba8NGvCQWv91d_x002B_ZAXsbnwa85fAGgb6Nqi29oc3BOh46tvsuRGW_x002F_MhIv8kRuuPHeA2FX2XlBWq3fgNMai4be4anQznpPzZm0jRBEum4YbZGZhkmC19W8LCO1twaX5_x002B_2vJXBvweVcdZ3cqU3YurftpAEokccO9z0xDGri_x002F_Fs2OmTen3_x002B_lQkmUimWwnpJUY_x002B_9bWMggU9fFluqt8PDhG1xx3Mqc6tuLfHuEWLc_x002F_KnFp4NMOkYYrkrbxxWt4GwGqNZPy3LeYUQ0qC1A9jzw7WLa41MSH6blignyBJv9wio5bhO7ZA61hyu_x002F_w45DECQa0iQAWZf_x002B_3_x002B_HdN94Ruo0myPYu2PUHLQGV4D4sECdhRutMfVmXifB9NupTSdm5tnmfENWEkefjBLU8pD5j10pf2AqlCOosbSdFFUIyCffZBb6uT4CFmHBEdVT7_x002B_1tsJsK3ZbxRZvvHxEW0T4YT4eJOMjo5Z7ckZSzahhVR1TQWg9KhS8heACzpdbgAvY1f8Gg1WhUp1HYFK2I3ONn_x002F_xy_x002B_lYY90IuwYmRUsMpdbgeIGYa6leabZedIzph2sEfcMIND5qwNjP2l8MSacHeRrufM_x002B_Bb0vBFpWQwffVIPL_x002F_JKGQAa_x002B_lpqjRUbKjv5YTAk9Zct_x002F_g4d0w72cUg5NhnBHezE7uF9PUEGM1t8bmJ36tdJzJhIGH9OmJ9LYOcPiZ_x002B_u2P707D2xSuscT1ZuIyFgWNvbf5FByb8vgcZVgJyFDTt3Xsw6eOIaI_x002B_KtPlQvV0arBNCjqCEq4zO8KaotJ8hmsj0fQJqIbfJQmM7fhqcw36LGnwByByeBaEqHYJMxrudGWYPureyey_x002F_ZNQxkVjE_x002F_hEquxspxtWClfoG5XEQ1JG1vM4dq_x002F_uuqkwtxD5ZJrAVkxCKlL0HVpUjcCUTrRq5zXO3eTXC8tMXbOEojgkdfkWpKcmtUJaxQA9QulMGGbnKhkc8HUDoCCFvj8iz09zywt_x002F_B_x002F_oweCovBIYT_x002F_290Whx6NcrEdh8rzHArRxzrn2DGP4hNsvcFS64gv2XxCdDscK56Uur_x002F_zFKswMOpabFaEacMmgMIQPKv9toXVXkLLS47G2wTVPtD0QOsuT9jd5zVcchl_x002B_Qf3ah0Gt4x9_x002F_wT0wGS_x002F_HdGKNUfuey4mBp6PnBl1Xwj_x002B_9aTyhZebu5p9w_x002B_N6xrGqZujSBk_x002B_krEsoVFOtkr7z6CN_x002F_IKKTnUecxQiohPfkGtk8PDofJISJxHAO3NUpxzR1_x002F_gPmpkS_x002F_qgmMDZmSovWO92Y2cEwOemoKCH_x002F_iG4FmzLl210lonsFNc_x002B_d2GX88jmfmpcthXezn_x002B_ra1DagifwV2NIpaB_x002B_MhvHMt2iWQDYTwPSQuALRLc9pFVm1KXtH7If2oOdFARrZEgFELfcLYGDRauMGfweaUDvIivJQTQ1EkkMWA0GEY4QqxxTXwrJSJ_x002B_cEr5PktFNI7B6uaDrpVwD1QQpSd_x002B_G74cm4u_x002B_7nUhXd94bBqZfVEYO8Bk7KEWJwU7Vy4MPuCF_x002F_pNvlFixogQr4nUoJFHRnrIdkhuvAxBrBTBMgKpQP1m6NSJ_x002F_XR6jaB0_x002F_PewFH7mUFTe9pzkmzw_x002B_L0a1UeMtnW4KpJSEPEEqAlNLJR9sjNQTxlzVW3_x002F_fQGvMbX_x002F_7UBs8k3Vvo2YH3LM1vBpV26ePlbJFQyCAJJoGHkBs3gW2L0cq7NqufvzzNAyXvAK4RHPGY55L5RSLB_x002B_JHI0w3LiZs7sswODwt6t7OYzfKfu5Dt1R_x002B_Y6m_x002B_tyPsR7dMNyKsEesJHf_x002F_PLMLx4Ko6YqoXhNodSOueBk7XoAQetPCIG7pqmL4auZjr57OupSe6gtVwrHwNAhQ927Z9_x002B_Kps0kMmBdIfBnWNs0lVScCNiYvDTE7Su6ly1y25j7PMGJEJ1GFAyaDPqVTOEFgYKbJtU31lSSce_x002B_eqixFIEEGp0H_x002F_sO23GG18abWLwWZY8ggJ51_x002F_PYrZSAQnlEcRZ0TKPcFXjOmDG_x002B_lO9dhxH_x002F_Koq2lp3ICaszIwa_x002F__x002B_7nuB_x002B_Fde_x002F_RJ3wuLqT_x002B_DBszyE0dwxFLK815_x002F_CXty_x002B_taXBql0mpitxP1Vw5xDzsf_x002F_yz8P_x002B_WO7y_x002F_iLSZpOEO3_x002B_raHIMn744IHf0d4WOpulIdI5DA2lghGpIdkOXDrM1KdKP5BGG7C4CpIcmzzdBQw7OsVrKddp_x002F_y1KDsr5sW3tO4f2gFXdw1pM0m_x002F_m_x002B_WGlLL_x002F_hYVREkKvMi1YrCj7tjyo3y_x002B_28ZpPC3PsaE2p4mGKySYrk_x002B_fGMlrJJtEhLcl_x002B_vJwuHTrA7RuFEkhyLVr6ndM7jK8I4KE8RWVrPXrz8gEH_x002B_srzZtpoYrQ89prv8wGqhvCUFubzdanzzfi4Z4e6vQ9q0F1D4zuKc8Dte4wEhw6SRIBjw3efK9wmLqACS3vURX5eAaF0dtEkQap9VAzM5f6Oiiqg2KfnCsBP3ITOmjlV7WfboWYTncdkDTabKtstAJYUAQl1rD4NzVS5IHMmvyEaJG2SF2TGqipCYo1BpG3Jrkb5I9X_x002F_I2OMiHRaoXLxt42GZNzVxATw4UDeVrzKqz8abgjPDMc7eEO6_x002B_Losy5sAFPY8FveWqzjSRf2oeZuE6s0tdwzvwhMk9B_x002B_BNEm40EmFvgeYgPjax8CeSpFPiBDNDGyLgTIWVDbAPCGJl_x002F_vTQ0GSycHFZEzwsxxqxAQflgGyxokmBhnvfNoh6Umg1Ygscu1BEDYQc4Q8Cn4LuwJnpUN_x002F_KLVe3duJpPE_x002B_Cd9MIOB9A_x002B_pdYUtNTGv6Ch8GnR0TrMTQv4f8oVInXP4cuxWsazSzGp_x002F_SEFlpw0knTs8qkhFDYF7EiGqsym23Y0wVZh0B3uYEB7jEXwc9ToMwEtfMnJ51A7VIAVtq4dUlgKfKtAX_x002B_lDfc_x002B_gs3bqubn6mKbnqOPnExAVtVAhroej1W87h4DK820OUZthGy_x002F_Zct_x002F_270Fw2ZVGAqOzY4mOIX56W7JE4uEa8oylLl95ZOmewS_x002F_27TyG2s4crilJm631JI35_x002B_ksaVcbm2hAQY9cwayaukzYmiCIJQTP_x002B_9R0adsVPQ4Jt6UsNDp7pMw0KewdUXoYvHxQrLemkCmmq3ZFxVvNZlU8PpKLrvRSSkpgLnFfyNuQPfqq4BH1FmuB_x002F_hqzd3b1ewpcZ3dxqEJismH_x002B_c09gwcgOjSGduDBVmbD3VOl9h64W2G78TPbGsSfXMpH2hM2xfEBubBZdUfsh_x002B_O9UW7lljdWo1VCaui9KhCemuM0cKjotRf1OCFVpMhFhp6Woo9uUVR3EvvzfRTAvXp1pLAwUhOds3c9IBZYYoe_x002B_I536Hu23Drh8nVXjhnIE4ByxErGnoAWPEa20N8Zrw_x002F_fx6BjPyv4u0YFLcoFNE9pVtW_x002B_OZqrrbe_x002F_xrv9QwsJdfeHBQIuQay1FVzruLFShpdKrGwVhwmOzYc4ii1nkF6U3Aon03uVzHeL5ZOPUA815EcKt3g6Gnq98ayogzlLAsH49Fs2N52sO9lIvvsNyBbBLhq9b_x002B_VB9jgBzSrK5QE8MhjcqWu6_x002B_RA9eyS1zei5iZU0SeRDVaCc_x002B_VaS3S34cv6P52baj_x002F_hMufF3J9Od7uv8dTG0Yem0PxUvkDM2DAm_x002B_HbgSf3_x002F_rgywkoEjAONzUnM9cMi_x002F_2Yl6HzXE44xtfspouL5vX1N_x002F_UkVCIyp8zmlFMTIl3gsdXriP993fMkS5XqDdCoHSlC6dHaANQnZ3Bw7zhUdcRdctlFq3gnPHJkzd6FpeqbQW1sX4v7qdsXLedP2Z6tQbsJxc_x002F_8Nu0RCrSXGOOa3Q_x002F_6PfMTW0MP5CAK7Ue7jgBLSdxoDaQeTi9oDg_x002B_VknD9izIW5dPI_x002F_MYq6wEdopVC4NPFLpeiFIxEVHrW_x002F_7EzwEtZY_x002B_hSr6Azkvmvfr6w52mlLgBb035fZN75iBrfqiVa8uO4eV3j9AKFDRc0pNAYdhUkVSBPIT83WsyjaZHX7nXKTs_x002F_X5YPASx9p66ddyt9vYunlFLjwbI_x002B_iwNkyEx8n2VTt9SMEaYfuvhsZpjkUJfOuvOwiP4sn67glUeUSDl_x002B_tVq6hXq07e1iVIj0KBYKzpOCfXqxq3NkSqFgJFZoXsHWqETl1kGO4YDk21TI1tCrLf9x5Wohwm63xpBmfp3r0lexTY0hoNiPkE_x002F_F8cUvsXeycpPdXXcWBQC1lXR19rqlO689b_x002B_3kitZmbbKeks_x002F_JZQQloL2_x002B_UAp8ZQhAeyLBQRU6zFVDP3KLCEubSyHl7WoxuQNDiwYR4_x002B_JghkNX_x002F_ds40fesfQ5gRe0s_x002B_6dcVgnR7_x002F_ZP45Mw1HIFx5U15PimU85ScnzOAESH1i67kRs0CCR_x002B_12WyZso1MRjHE_x002F_MNmzSax90gvOyBvQVue9uxm07dChL3p7xQpF4SxPP8D6_x002B_VttZDP0bsj4vrcR52pETfqsQTVQj73jgM8e9Lztz_x002F_w6axLvINT_x002B_FPKVRHuQ1prYzMRnIR1oo9_x002F_RSDqPfkmNv3uGHtnFnRQqKeFNIhchyxV_x002F__x002F_TC6_x002B_9RycyQMUxc9tdRUZRFB1_x002B_NILhcha9byb6LZM8LuU_x002B_VFtGoONeMoapdpxhSYFqli9x2piiOwNam_x002B_18vn0Otokeea1CsZtheUPeYI1ArsA2WnzKSOgm6a4Yi07YNqMe7cq2ktJVP_x002B_W77MaXq3YUsUlWS9hCB0WlANKs1fzmJIOvWDXe5Wl0Dm_x002B_tBOMgdzuL8OUvz_x002F_qVb0ol0thoNYbhVi6d6rhJuPF_x002B_V0VYlG0tP51cir_x002B_meU4amYTc1RuhGGEzzgvmJlgPC2kvvasQmrHniH7M_x002F_cYazeHC2PjLaybSMLuMdAkMPEI91uRYqWtPpR26xe65fuL12Z0IwXI4bJOw7I0cI3poi12M9reHnsR0Fwe0NaoeBCg66Eu91dETHUqWNl8McZ8RbSYk0jWcxiiGoHMaPQBr62MNuUtX9YJIm4SZszFCnvPzW5uEz_x002F_oWd_x002B_f452fpuet6EdAhcqdY0s9w8Bi92oeqVOXnKpIEYSxVAVy0IQLpyLF5myxConIrvY_x002B_TWXwH_x002F_UEj1ezKvSmVhEu5OTgE8rzsgD6P8ZrVEPq0eSsVvomEXuf08VCrkMi26yqaLk7IR3vddc5_x002B_8cGlsPhhHlNQXbRc7bhI77pvsXl2zy_x002B_hZPp_x002F_2VY365wjEI8aMDuJLJqJp0D3FX12hCFmRUeh0V_x002F_ZiVV_x002B_LYV9nJBOjPRRtrZsSvUOK9100TOiT_x002F_LNuIAPS5mPSAD2jGak1YYjghCvEM0630cSngfj7CbAwY2NG7rRkF4CiKNlAy88OXuSz1vqzdgw4SNdWLiTut4kk8M65NWPBdBvMMP7MnhBDHrBSy1ii0TLuylBYir4McDl3XNfnNNux_x002B_c4EWvSF_x002B_ONjDxNjITuZupC0mquAPZSGvwnY_x002F_DmKsGeu2XdUz0A74CwmbpAJgm4DFP_x002B_ZcCTgjIlsTbdUpGr3WOrgApYCYObFPqeZZpR7vfXp_x002F_v5hRqefD6yrui7LyfOyiQmPXGl2BgUcr5V674ZRY1Ned_x002F_Pm2O1anMRbsNR_x002B_MPWt_x002F_ZnIcB1QgJSqhwuSbqDrKsej1m0Jh_x002B_EuLZuP3Q8_x002F_yna0zTMC9uj_x002F_uYRdUxtWEBR96r_x002B_gclQPmyKeQFCB00L0iEVYC7v8az7fYYsyREkxxpgZ3G373m6C3SULrmSpX73_x002F_sZruwbNBQDbyjZCZqodD5GT6h1WrEDWPJSytKZE_x002B_pDtNVWD22Ex662cyBVQq0TGgvi_x002F_b1oBzecpN_x002F_U8dy_x002F_bSgn1l8hiWZ3t4a7TrxY61KAaEUEFmsejBRfiIepG2LR11dAN2YEDPQTtbspiaVe6Y4WsYv7AG6mO1J5BpRymGzk_x002F_UfFU7nLAp3o2wUYtCDURNKvP5eSKQguc4qqOdcEgexGZBDjCTQVWmT80k28dAUWClGB_x002F__x002B_nYD_x002F_ZB1O3kp2Ghso0ZH8sTeJtHkjryz3uGeVTE8gDTwIcX_x002F_TVmYtJgDeYe_x002F_opoLs9Ryhe7cd4mrROBuN2wacwsHHjZ_x002B_U_x002F_qT70meuf8xobzvZINmWRXiJS5LtGn4X_x002B_TyTX4RYonf1FNTxKIxJcOlQGKApRf3MA7h81frLK1emkCP9HRv_x002B_7bFYZOweVasuypf7HjjsZh_x002B_Agqpfnk99Epx_x002F_hHuhEeV42irY1J_x002B_3MqivFigjNWZk1cEct50hhEWSaMBStwvrRy3pqNM06vb2R0AXm0yn3vovfs3w5SkGJPSTQ_x002B_R6KoU89qNIcoIG1uDA3DRp90E9vslcm2PQ6aac_x002B_FJdALCVlomJSwkTqNkGEdCQB42iy4PuqbReBFmIcdW0f4da8i51yjBolbckYC3KStpBHiyA0IyMcaRvWkcuuA_x002B_FGKelsbAbgKt3u9DgJWmOm8qO_x002F_DS1IayMFMjzAisCfF6Pua7_x002B_ZaDPkzmso1nqcJ4wVBuQBIUGcCeIJezlVIYc7rssHOSTW9c_x002B_jKHYCms_x002F_hawQXXi9z0jcGx_x002B_up6MtYOX3JzDMjoVWtOPcbvibI6s0Zj_x002B_w2ffKEede_x002F_2geVUJPAgS1aHSa2plXnLJeK4iqYF2uGrkQmT5Zs_x002F_rbz8oKVIfLsMPBWNdZhTmE7fxcgNCTZnvDBbL1njuxzfWD9iivg7wo_x002F_M_x002B_ZOk9Jv7YbiRVqlsUV2SB46lCnxuCd3KCVfDLPnqkqcKdi4O_x002B_PIFLpSHbMs9jK9mAlW60VhlaYrrNqhUSt_x002B_OdgwEnpq3h3zmJ4iv6UdPnY7uJD_x002B_rutlVp4QPuuPLfGZdk9l_x002F_OMdgBsKiIGNodCXhVpQMniBold6nc7Uuw9v8AR7VF9d3GeKvDCWzVVSxBKCped79M5rQWv64VxFwae2oNVMaQ_x002F_LBm_x002F_Js9FNMdRlkxu_x002B_xW_x002B_WjVkp2mp_x002F_CfnyHq_x002F_0CCCG3SK6_x002B_N_x002F_6ZQlo4ujq_x002B_Oo6qFlt8JXlLZfRbmKgXJcGvM2p_x002B_Y1ktMrJ8ut3cf3ZAi9eWt5LhTZjDROqoulpFtMhuG4HG8zmWF20_x002F_OWVyjCMoYREdS8ZGLyzX8G8cczvsWF0675DkUQkao52Q49a7IIMzgUGfLfUDalqd2FVVWk5Cr9d9dn8oT0dp_x002B_ljf_x002B_NvAi59rpCPFRCUKZnEbB3oy_x002F_5aNyEinD5EtsFGKMOFFnut9BZGmLQz1YTArVEusqzT_x002F_k7rZyzSi_x002B_ws5qllxZhhQTN5E0UWtaPGsP0mv4oYONNApO7o8SyQ_x002B_K2VG7lQj2yXI9ydQXrTFE3BSjqczlY_x002B_iAveRZ42fBizxp1jdOS4c1KimyjLYr0gIjF9IIldk9eR78lLJtYsEIRwE33awGRbkOLsALwOxzUFBLgN6bQFFIRTQnSCLHiXCYERH1VQ6f2mm87_x002B_6PvrpUzIE5Jq0pdFqGIO3huA5p_x002F_qY_x002F_WGAuM2K1OyatEO1ggDXrlgtc_x002B_YLCaflZBZ122DIg6uZz7mZYOSOu1n1WgYz_x002F_0twI4ussZ_x002B_9JSshaBHPy5NW3iJjUEciT1_x002B_v9u_x002B_VXeI_x002F_WsPt_x002F_6XIA44UIKq8ZOlNizbCsPlGnLTYwTZc0TGEjCvntoeTO3Jwn_x002F_Db4B0Tep87Kmfkt6_x002B_Z2VME8TK2ycLf0djJrgYv_x002F_g3mSOU4sWXpoKG8A_x002F_BJgtKG_x002F_9Zm4vyA9lTwPBcn0MN_x002F_UX2vGKk2GuY2wXUILQUwUpslhZF_x002B_DBKpjXB1QYpnR6_x002F_63KFQG1lSjQ0LfUojXGEMBVRQuFXd4pq_x002F_GMFr8URon1jiRMvTURVtyaDA_x002F__x002B_ItY4ycxfxXuWPbbojXKmo_x002F_t9dtbEUJCifnR6ChfhIa57xsJiLkKB_x002F_3kv8lH82W5rWUKMYubof7YzjAZ_x002F_P9euensYH6GB2X2qZGkDqhgjpp8_x002F_ICBcfadJVUaBPq5lniythAuot2qE9loaDJ28NYegBUGzb0HyuKQaY4Fu2_x002F_TbSt4xzMQM9jku8pRGQ5P9x1vCFSD7cuFDoSTe_x002B_tRl7JtYNcAwicFCSylsMBLk8zoYyZcoqJWf5Ffq_x002B_za8Y2brv4O73y5DCpYVu4oBNMcpvwIai5_x002B_otPbfssm59lMMo_x002B_FFBhAn_x002F_juO_x002F_85IF9dXOZKLEUCdjcIieIzSL52mLtUZRyUorfaXUzui_x002F_DmLRXXt2ZIWAMHD8kCywjtjlLK9vRoG7fLJzwPxdKztHVdvbFuoMNWiKICy5IolLP7KYCkddZZekhnsyuFSKIMEtoRAojHCzdmOFgzNEkb0Rp_x002B_DczL64yGwznqM0nakE5Sb07f7Lep8tXMaUxuqmF1CpCytT0dGYc5dYLnPoFIOEGqYQsIsALgdSALOvrnXW6vAR0VrlmjEYuwaZfiIFOThGBdSWBZ_x002F_kvCL5pppbdzldpAkZIucMFmZHs5Up21geUIkcEzzb45rJQT4pMfGT1Zd1bF17K14PNbQ6ca0C_x002B_LtUfjtbR31NVwiiw5NvqMUN6DQakvT981NoY8m7BqJFd85va21B4x_x002B_tgQ_x002F_hcF6fidCFgSvNOsmBa2etTUhnA5VJIDghSg5a2ILlsnHPI2nrSgExlRRF4WpO8zRsX_x002B_2cFkLgbfiHWkU_x002B_RZVRofFxHYkAs9ArHCG3qdRag5ixDDpQjpe8qbENYwystT_x002F_TrECnqmCL84vhUZXnRuhD86vJeJa9Jko_x002B_ODulhIL_x002B_GRQDDt5ItaBDt19h2lbBLSnn27z1DF45R5_x002B_UoODNv8e9oq9eTbjiqomh1jAOuYIPD_x002F_0QTtCULJcUce7fAZnoLuul6awspFfdKt4gAtzVOkH8FO5MyV5Km_x002B_p7VfgrG3rQD3S1rJR95V1rB65_x002B_ugmxSsYWbO7VfA_x002B_VD7l6FCtz3z2O6RosXopRxkSu06FkUxqIZZwKmctf_x002F_49q4BjrqjgdR6d_x002B_LZbUW29g26Rshuqt8jTp3eJrLGwBNDqlfXfo54SYE1FnVZDh6BbsJ_x002F_m0TwqrMWH_x002F__x002F_AOYndG215DwAb5jTfNQ4iKbyROd00fh_x002B_stTJuD25l_x002F_fHIXKqVeGEV7nopD3i3s1XNN2mWKkMmwYcEMXxccHusmbbnFFG6st1q0YOGveV_x002F_GqOZVKd_x002F_8_x002F_sGWSnZ1q2cmZzlmccRO9uk6FXzwRenQToCpIVb7QuQIkAkF6nNCO57hIIZfJABxA9UXLsaIpw2PoDsE9IZ0ZR7TWVrCkiFRH3pYDvts71Aaobz7Br6OjtPT93SW04l86r7X1QLwCtam_x002B_IWa_x002B__x002B_jT7uRtedXYfobWnOeZPklSTTWwrqZ3jaqWSDIpyQfSt4nxgFSV_x002F_glh9o1xljdDjTFZhWCiAEwfqfHo5rTI8U_x002B_mIYI_x002F_itWDF6pgS16hGaVb1W_x002F_FGowwNait2ie9BUSW0mtZBXvXhCsdxeCXBC66wUGP36JN5I6YJ55O9DjWjpbT_x002F__x002F_FBKL38sjbyBQGJEmLa8yTW62dTEToKvfLpjQsGqw9F3oTHpYLkLYYEwDkYyS4ZJy_x002B_7hU7_x002B_nGm2v8pfIaQLPRD1IeFgjKZTSQHzYCrBu2_x002B_MecPXYlwGqJpT_x002F_kwGZBMWovt46unCfmclWFyRs6wDYtwvNXdYvSdciXNgceMwfipEPU7fe4ja9X_x002B_aIJwdH8Fq6Y7cJ4Vdv4YCTGeP0grSQVR5FER1uvkgdXM3_x002F__x002B_jN0gLnegHArQynRtfPRH9nTakwsZdkOxPFOk55ZAfOFdq2GErI_x002B_sKZ3N_x002B_6yJB17fYpzXqknIZLktKz0N0leRZQ0GWf7NLhX9XCTB8nEZ3_x002F_HDE3d_x002F_qsIciHG_x002B_O1bWkNqDlABoCtYJ3Z8UTG_x002B_fHlK_x002F_uX6K4QsCN63ml3P9i6LclMg0S9GQ_x002F_I6lVZGUlApTuIPHe00f2c_x002B_ba559XfLM8vQ2Kbu8Eyca4JPYCfR4V3SSz0cUzlfUIgTGgH3N10RhVHaYF9zam_x002B_6SU8FpBpMKGOIi1t1FxwsRc2dRGpkQmp8oOrTeAj9_x002F_JBNhXMGTrO6ROA69Vkerb8qEcVpYeoxRzv257Q7Rzl8AaGkT6rpr4Ky8iqkny47TswfiW0KeDZX9O2Vq1WmfuXwUVPD2CoypNDDKg14cPiLWutZeuFNNaaABYrNHLcuMvPF_x002B__x002B_kyCMG5ggS9cm9zkhBtUF32w2MitqfOOf0_x002F_7jdHO3eitbmeg_x003D__x003D_ ,vPrintStamp,vPrintStamp,Contains_x0020__x0022_Print:_x0020__x003C_system_x0020_timestamp_x003E__x0022_,System.String,_x0022_Print_x0022__x002B__x0022__x0020__x0022__x002B_Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_Today_x0029__x002B__x0022__x0020__x0022__x002B_Format_x0028__x0022__x007B_0:HH:mm:ss_x007D__x0022__x002C__x0020_Time_x0029_,False,True,False,False ,vPagesInfo,vPagesInfo,Contains_x0020__x0022_Page_x0020_xx_x0020_of_x0020_yy_x0022_,System.String,_x0022_Page_x0020__x0022__x002B_PageNumber_x002B__x0022__x0020_of_x0020__x0022__x002B_TotalPageCount,False,True,False,False ,vTaskStart,TaskStart,Task_x0020_start,System.DateTime,Today.AddDays_x0028_0.125_x0029_,False,True,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_DateTimeType_x003E_DateAndTime_x003C__x002F_DateTimeType_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_,,True ,vTaskEnd,TaskEnd,Task_x0020_end,System.DateTime,Today.AddDays_x0028_1.125_x0029_,False,True,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_DateTimeType_x003E_DateAndTime_x003C__x002F_DateTimeType_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_,,True ,Airlines,Airlines,Airline_x0020_Selection,Stimulsoft.Report.StringList,,False,False,False,False EngineV2 9a171d9ce3be4d51814e98c74ab0800f None;Black;2;Solid;False;4;Black Transparent Transparent True 0,4,277,52 Transparent True True 0,0,86,20 resource://CathayLogo 0,0,0,0 0.7 Image1 Transparent True True 90,12,60,6 Arial,14,Bold 0,0,0,0 Text18 FOR {Format("{0:dd/MM/yyyy}", MinDate(Query_MASTER_CX_LIVE.TASK_START))} {Substring(DayOfWeek(MinDate(Query_MASTER_CX_LIVE.TASK_START)),0,3)} Black Expression Transparent 216,2,36,4 Arial,8 0,0,0,0 Text19 {vPrintStamp} Black Expression Transparent 236,6,36,4 Arial,8 c0595c4e22224e729ee2dd6f84f21683 0,0,0,0 Text20 {"Page "+PageNumber+" of "+TotalPageCount} Black Expression Transparent 186,12,36,4 Arial,8 610f6603515a48e29a507d0e48a34e51 0,0,0,0 Text21 Start {vTaskStart} Black Expression Transparent 228,12,36,4 Arial,8 2f1826c5a79d4ae3b9af5a917fd64491 0,0,0,0 Text22 End {vTaskEnd} Black Expression None;[0:31:53];1;Solid;False;4;Black Transparent True True 100,4,84,6 Arial,14,Bold True f407ba34d9d8481f84c707b71bee4ec0 Center 0,0,0,0 Text4 CXLS & AS PDF File Black Expression Center Transparent True 0,20,60,36 Transparent True 0,4,60,32 2 White True 0,0,32,8 Arial,9 0 0,0,0,0 Table1_Cell1 AllowMove, AllowSelect, AllowChange Black White True 32,0,28,8 Arial,9,Bold Center 1 0,0,0,0 Table1_Cell2 AllowMove, AllowSelect, AllowChange OT Total Black Expression Bottom All;Black;1;Solid;False;4;Black White True 0,8,32,8 Arial,9,Bold 5 0,0,0,0 Table1_Cell3 AllowMove, AllowSelect, AllowChange CXAS CSO Black Expression Center All;Black;1;Solid;False;4;Black White True 32,8,28,8 Arial,9,Bold Center 6 0,0,0,0 Table1_Cell4 AllowMove, AllowSelect, AllowChange {Query_SHIFT_CX_LIVE_OT_CUMULATIVE.OT_TOTAL__CXAS_CSO} Black Expression Center All;Black;1;Solid;False;4;Black White True 0,16,32,8 Arial,9,Bold 10 0,0,0,0 Table1_Cell5 AllowMove, AllowSelect, AllowChange CXAS SUPV Black Expression Center All;Black;1;Solid;False;4;Black White True 32,16,28,8 Arial,9,Bold Center 11 0,0,0,0 Table1_Cell6 AllowMove, AllowSelect, AllowChange {Query_SHIFT_CX_LIVE_OT_CUMULATIVE.OT_TOTAL__CXAS_SUPV} Black Expression Center All;Black;1;Solid;False;4;Black White True 0,24,32,8 Arial,9,Bold 15 0,0,0,0 Table1_Cell7 AllowMove, AllowSelect, AllowChange CX AS SUPV CAAIR Black Expression Center All;Black;1;Solid;False;4;Black White True 32,24,28,8 Arial,9,Bold Center 16 0,0,0,0 Table1_Cell8 AllowMove, AllowSelect, AllowChange {Query_SHIFT_CX_LIVE_OT_CUMULATIVE.OT_TOTAL__CX_CAAIR_S} Black Expression Center 8 Table1 25 4 Panel1 Transparent True True 192,20,60,30 Transparent True 0,4,60,32 2 White True 0,0,32,8 Arial,9 a9f30cbd31aa468182a0327b12829f3b 0 0,0,0,0 TableCell1 AllowMove, AllowSelect, AllowChange Black White True 32,0,28,8 Arial,9,Bold b66ae6feb24542fb83c8556f2a89150e Center 1 0,0,0,0 TableCell2 AllowMove, AllowSelect, AllowChange OT Total Black Expression Bottom All;Black;1;Solid;False;4;Black White True 0,8,32,8 Arial,9,Bold df5ba3db0ac94b3c940ae128f785e442 5 0,0,0,0 TableCell3 AllowMove, AllowSelect, AllowChange CXLS CSO Black Expression Center All;Black;1;Solid;False;4;Black White True 32,8,28,8 Arial,9,Bold c106c5c6ce7d4ba590068fea0ce4dbd8 Center 6 0,0,0,0 TableCell4 AllowMove, AllowSelect, AllowChange {Query_SHIFT_CX_LIVE_OT_CUMULATIVE.OT_TOTAL__CXLS_CSO} Black Expression Center All;Black;1;Solid;False;4;Black White True 0,16,32,8 Arial,9,Bold d6775c274c894f3488a93a0c2c82922e 10 0,0,0,0 TableCell5 AllowMove, AllowSelect, AllowChange CX MSC CSO Black Expression Center All;Black;1;Solid;False;4;Black White True 32,16,28,8 Arial,9,Bold 41ee8de64d284906b1f127bd96d9c0e8 Center 11 0,0,0,0 TableCell6 AllowMove, AllowSelect, AllowChange {Query_SHIFT_CX_LIVE_OT_CUMULATIVE.OT_TOTAL__CX_MSC_CSO} Black Expression Center All;Black;1;Solid;False;4;Black White True 0,24,32,8 Arial,9,Bold 82a6fe4d27454b68a27ae48015f3ae74 15 0,0,0,0 TableCell7 AllowMove, AllowSelect, AllowChange CXLS SUPV Black Expression Center All;Black;1;Solid;False;4;Black White True 32,24,28,8 Arial,9,Bold 9b5cd825d36d44b38afb7993c61b1f06 Center 16 0,0,0,0 TableCell8 AllowMove, AllowSelect, AllowChange {Query_SHIFT_CX_LIVE_OT_CUMULATIVE.OT_TOTAL__CXLS_SUPV} Black Expression Center 08909128db8c4047976bfdaac917f92d 8 Table2 29 4 Panel2 PageHeaderBand1 Transparent 0,64,277,8 Top, Left, Bottom;[0:0:0:0];1;Solid;False;4;[0:0:0:0] White 0,0,14,8 Arial,9,Bold 4b0febfc21c8466d9e9893977b69ea30 Center 0,0,0,0 Text12 Dayoff OT Black ,,,,WordWrap=True,A=0 Expression Center Top, Left, Bottom;[0:0:0:0];1;Solid;False;4;[0:0:0:0] White 14,0,14,8 Arial,9,Bold fc3b55aa11d64677b69b17d4375cb091 Center 0,0,0,0 Text13 OT Total Black ,,,,WordWrap=True,A=0 Expression Center Top, Left, Bottom;[0:0:0:0];1;Solid;False;4;[0:0:0:0] White 64,0,26,8 Arial,9,Bold f754d4e4b5284741a2d5ec5d4cb1d250 Center 0,0,0,0 Text14 Actual duty time Black ,,,,WordWrap=True,A=0 Expression Center Top, Left, Bottom;[0:0:0:0];1;Solid;False;4;[0:0:0:0] White 156,0,18,8 Arial,9,Bold 0f0a3130fbdd400f93471aad3747977a Center 0,0,0,0 Text16 Task start Black ,,,,WordWrap=True,A=0 Expression Center Top, Left, Bottom;[0:0:0:0];1;Solid;False;4;[0:0:0:0] White 174,0,18,8 Arial,9,Bold bdc07a59b08e40fba17d51aa3ea28346 Center 0,0,0,0 Text17 Task end Black ,,,,WordWrap=True,A=0 Expression Center Top, Left, Bottom;[0:0:0:0];1;Solid;False;4;[0:0:0:0] White 46,0,18,8 Arial,9,Bold 6f93b7e3821844a6a39667c16f8bd47e Center 0,0,0,0 Text30 Staff No Black ,,,,WordWrap=True,A=0 Expression Center Top, Left, Bottom;[0:0:0:0];1;Solid;False;4;[0:0:0:0] White 90,0,66,8 Arial,9,Bold b70869cccde44050ad3883f5361d8933 Center 0,0,0,0 Text32 Name w Skill Black ,,,,WordWrap=True,A=0 Expression Center Top, Left, Bottom;[0:0:0:0];1;Solid;False;4;[0:0:0:0] White 192,0,85,8 Arial,9,Bold 0d0b96e8bbea4ca7af6e25f21e827135 Center 0,0,0,0 Text33 Task remark Black ,,,,WordWrap=True,A=0 Expression Center Top, Left, Bottom;[0:0:0:0];1;Solid;False;4;[0:0:0:0] White 28,0,18,8 Arial,9,Bold f44798379c79415cba32f8bfe5501c65 Center 0,0,0,0 Text11 Estimated start Black ,,,,WordWrap=True,A=0 Expression Center False ColumnHeaderBand1 Transparent 0,80,277,12 All;Black;1;Solid;False;4;Black Transparent 2,4,62,8 Arial,12,Bold 7f0c8ebbae9c4c138157a8d2142eefe8 0,0,0,0 Text23 None {Query_MASTER_CX_LIVE.STAFF_QUALIFICATION} Black Expression Center {Query_MASTER_CX_LIVE.STAFF_QUALIFICATION} GroupHeaderBand2 None Transparent 0,100,277,2 {Query_MASTER_CX_LIVE.FULLNAME} GroupHeaderBand1 None Transparent 0,110,277,4 All;Black;1;Solid;False;4;Black Transparent 90,0,68,4 Arial,8 58157d6fe8144d8abfe6aaa7b8918587 0,0,0,0 Text7 RemoveText {Query_MASTER_CX_LIVE.FULLNAME_W_SKILL} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 158,0,18,4 Arial,8 b79bf1ce17f34fbe973755e6c655afae Center 0,0,0,0 Text9 {Format("{0:HH:mm}", Query_MASTER_CX_LIVE.TASK_START)} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 14,0,14,4 Arial,8 960e634d42114b15a746d83b076e263e Center 0,0,0,0 Text8 RemoveText {Query_MASTER_CX_LIVE.OT_TOTAL} Black DataColumn Center All;Black;1;Solid;False;4;Black Transparent True 194,0,83,4 Arial,8 True d60aff34bf3844e2b95031dd9c2ba0ec 0,0,0,0 Text2 {Query_MASTER_CX_LIVE.FLIGHTNOANDTASKREMARKANDLOC} Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black Transparent 0,0,14,4 Arial,8 78372751c5fe477fa10a0f6118dd7702 Center 0,0,0,0 Text6 RemoveText {Query_MASTER_CX_LIVE.DAY_OFF} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 176,0,18,4 Arial,8 038885ef346c40829b42910c2bee9249 Center 0,0,0,0 Text10 {Format("{0:HH:mm}", Query_MASTER_CX_LIVE.TASK_END)} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 64,0,26,4 Arial,8 35008511d0334574a8cb2230d911a8b5 Center 0,0,0,0 Text15 RemoveText {Query_MASTER_CX_LIVE.ACTUAL_DUTY_TIME} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 46,0,18,4 Arial,8 3734106979164c7f80be25a6feca8ca8 Center 0,0,0,0 Text31 RemoveText {Query_MASTER_CX_LIVE.STAFF_NO} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 28,0,18,4 Arial,8 5ee20f4fa17b41c58d100d3689f6b3c4 Center 0,0,0,0 Text1 RemoveText {Format("{0:dd/MM/yy}", Query_MASTER_CX_LIVE.ESTIMATED_START)} Black Expression Center Query_MASTER_CX_LIVE False DataCSO_SHIFT_REPORT 180053728f164d51b77176fb4a8ced33 10,10,10,10 Page1 Landscape 210 297 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 10/25/2019 1:29:11 AM 7/30/2019 5:55:22 AM C:\SSReports\27_R_CX_LIVE_CXLS_and_AS_PDF_File.mrt 93a3732fae534176adb3fa49b2161902 Report Millimeters 2019.4.1.0 CSharp None;[0:31:53];1;Solid;False;4;Black Transparent Moray Text, Primitive, Image ReportTitle ComponentType, Placement, PlacementNestedLevel Arial,14,Bold Moray_Report_Title1 Red [3:81:103] None;[0:31:53];1;Solid;False;4;Black Transparent Moray Text, Primitive, Image GreaterThanOrEqualTo ReportTitle 2 ComponentType, Placement, PlacementNestedLevel Arial,10,Bold Moray_Report_Title2 Red [3:81:103] None;[0:31:53];1;Solid;False;4;Black Transparent Moray Text, Primitive, Image ReportSummary ComponentType, Placement Arial,10,Bold Moray_Report_Summary Red [3:81:103] None;[0:31:53];1;Solid;False;4;Black Transparent Moray Text, Primitive, Image PageHeader ComponentType, Placement Arial,10 Moray_Page_Header Red [3:81:103] None;[0:31:53];1;Solid;False;4;Black Transparent Moray Text, Primitive, Image PageFooter ComponentType, Placement Arial,10 Moray_Page_Footer Red [3:81:103] None;[0:31:53];1;Solid;False;4;Black Transparent Moray Text, Primitive, Image GreaterThanOrEqualTo GroupHeader ComponentType, Placement, PlacementNestedLevel Arial,13,Bold Moray_Group_Header1 Red [3:81:103] None;[0:31:53];1;Solid;False;4;Black Transparent Moray Text, Primitive, Image GroupFooter ComponentType, Placement, PlacementNestedLevel Arial,13,Bold Moray_Group_Footer1 Red [3:81:103] None;[0:31:53];1;Solid;False;4;Black;True [3:81:103] Moray Text, Primitive, Image GreaterThanOrEqualTo Header ComponentType, Placement, PlacementNestedLevel Arial,8,Bold Moray_Header1 Red White None;[0:31:53];1;Solid;False;4;Black Transparent Moray Text, Primitive, Image, CheckBox GreaterThanOrEqualTo Data ComponentType, Placement, PlacementNestedLevel Arial,8 Moray_Data1 Red [0:0:0] None;[0:31:53];1;Solid;False;4;Black [219:245:249] Moray GreaterThanOrEqualTo DataOddStyle Placement, PlacementNestedLevel Arial,8 Moray_Data1_Odd Style Red [0:0:0] None;[0:31:53];1;Solid;False;4;Black [120:219:230] Moray GreaterThanOrEqualTo DataEvenStyle Placement, PlacementNestedLevel Arial,8 Moray_Data1_Even Style Red [0:0:0] Top;[0:31:53];3;Solid;False;4;Black [219:245:249] Moray Text, Primitive, Image Footer ComponentType, Placement, PlacementNestedLevel Arial,8 Moray_Footer1 Red [0:0:0]