True True PIP1 941703be0a83455a861635a31827a3b9 PIP1 C:\Users\mgroenendijk\OneDrive - WorkforceIT\Klanten en Projecten\ALDI - PIP Rapport\PIP1\Xmls\27._ALDI_PIP_X_3 (halen week 53).xml ADDITIONALINFO KEY,System.String VALUE,System.String f8e8c95dc7d44d9db83076258a6a2c9e ADDITIONALINFO PIP1.ADDITIONALINFO CALENDARFLAT DATE,System.DateTime SPXDATE,System.Int32 DAYTYPE_ID,System.String DAYTYPE_NAME,System.String BORDERCOLOR,System.String BACKGROUNDCOLOR,System.String ISHOLIDAY,System.Int32 SPECIALDAY_NAME,System.String COMMENT,System.String 378a0344d55e4b2ea6f1fd25f2b9bd82 CALENDARFLAT PIP1.CALENDARFLAT CONTRACTFLAT EMPLOYEE_ID,System.String CONTRACT_ID,System.String CONTRACT_NAME,System.String DATE,System.DateTime bf15a337fe8f4f5a849909482ebc8869 CONTRACTFLAT PIP1.CONTRACTFLAT CONTRACTHISTORY EMPLOYEE_ID,System.String CONTRACT_ID,System.String CONTRACT_NAME,System.String FROMDATE,System.DateTime TODATE,System.DateTime 6f5e74532d1d48bea26016e9b4483e77 CONTRACTHISTORY PIP1.CONTRACTHISTORY CONTRACTS CONTRACT_ID,System.String CONTRACT_NAME,System.String TARGETHOURTYPE,System.Int32 TARGETWORKDAYS,System.Decimal TARGETHOURS,System.Decimal e7957f5521914eb683365dec1f7d35b8 CONTRACTS PIP1.CONTRACTS COSTCENTERFLAT EMPLOYEE_ID,System.String COSTCENTER_ID,System.String COSTCENTER_NAME,System.String DATE,System.DateTime 444d777be26748dbac4d39ea4e4f4cac COSTCENTERFLAT PIP1.COSTCENTERFLAT COSTCENTERHISTORY EMPLOYEE_ID,System.String COSTCENTER_ID,System.String COSTCENTER_NAME,System.String FROMDATE,System.DateTime TODATE,System.DateTime f49b6e715ca545fe92bd43599e21216c COSTCENTERHISTORY PIP1.COSTCENTERHISTORY COSTCENTERS COSTCENTER_ID,System.String COSTCENTER_NAME,System.String LONGNAME,System.String 607b6c02014446e1a171bd6001c60c33 COSTCENTERS PIP1.COSTCENTERS CURVEDEFINITION CURVE_ID,System.String CURVE_NAME,System.String DESCRIPTION,System.String CURVE_TYPE,System.String COLOR,System.String 7b73ebb5745d47e198a02f8f16d32795 CURVEDEFINITION PIP1.CURVEDEFINITION CURVEVALUES SCHEDULEGROUP_ID,System.String CURVE_ID,System.String FORECAST,System.Decimal CURRENT,System.Decimal ACTUAL,System.Decimal FROMDATE,System.DateTime TODATE,System.DateTime 42d9416e66a0456fa15096142d6e7cb4 CURVEVALUES PIP1.CURVEVALUES EMPLOYEEPHONENUMBERS EMPLOYEE_ID,System.String EMPLOYEE_NUMBER,System.String DESCRIPTION,System.String PHONENUMBER,System.String 0b9edbecfe644c338af3dc4acda5373f EMPLOYEEPHONENUMBERS PIP1.EMPLOYEEPHONENUMBERS EMPLOYEES EMPLOYEE_ID,System.String EMPLOYEE_NUMBER,System.String SALUTATION,System.String LASTNAME,System.String FIRSTNAME,System.String DATEOFBIRTH,System.DateTime ENTRYDATE,System.DateTime EXITDATE,System.DateTime STREET,System.String STREETNUMBER,System.String POSTALCODE,System.String CITY,System.String STATE,System.String STATEABB,System.String EMAIL,System.String MARITALSTATUS,System.String CHILDREN,System.Int32 MOBILITY,System.String DISTANCETIME,System.Int32 d8f35af679ad42b0b5ace2fc59829d7c EMPLOYEES PIP1.EMPLOYEES EMPLOYEEWAGEACCOUNTVALUES EMPLOYEE_ID,System.String WAGEACCOUNT_ID,System.String WAGEACCOUNT_NAME,System.String RASTER,System.String VALUE,System.Decimal UNIT,System.String FROMDATE,System.DateTime TODATE,System.DateTime 999c9b4e24334bba997d0e9613a9e6f2 EMPLOYEEWAGEACCOUNTVALUES PIP1.EMPLOYEEWAGEACCOUNTVALUES FUNCTIONFLAT EMPLOYEE_ID,System.String FUNCTION_ID,System.String FUNCTION_NAME,System.String DATE,System.DateTime 9ce84fbca97440a1a467b8aa559c36b3 FUNCTIONFLAT PIP1.FUNCTIONFLAT FUNCTIONHISTORY EMPLOYEE_ID,System.String FUNCTION_ID,System.String FUNCTION_NAME,System.String FROMDATE,System.DateTime TODATE,System.DateTime e81205efe7e64d4db0500ae44de0836f FUNCTIONHISTORY PIP1.FUNCTIONHISTORY FUNCTIONS FUNCTION_ID,System.String FUNCTION_NAME,System.String LONGNAME,System.String d4abf56542a74f4c8913c0ecb08b9261 FUNCTIONS PIP1.FUNCTIONS HISTUSERFIELDFLAT EMPLOYEE_ID,System.String USERFIELD_ID,System.String USERFIELD_NAME,System.String DATE,System.DateTime VALUE,System.String 5458457b52ed456680c0b296453197ac HISTUSERFIELDFLAT PIP1.HISTUSERFIELDFLAT HISTUSERFIELDHISTORY EMPLOYEE_ID,System.String USERFIELD_ID,System.String USERFIELD_NAME,System.String FROMDATE,System.DateTime TODATE,System.DateTime VALUE,System.String 8d7f2261fea14da3a3dc4880b5b17c3e HISTUSERFIELDHISTORY PIP1.HISTUSERFIELDHISTORY QUALIFICATIONFLAT EMPLOYEE_ID,System.String QUALIFICATION_ID,System.String QUALIFICATION_NAME,System.String DATE,System.DateTime 582bccff28a946e798ee51c11a108800 QUALIFICATIONFLAT PIP1.QUALIFICATIONFLAT QUALIFICATIONHISTORY EMPLOYEE_ID,System.String QUALIFICATION_ID,System.String QUALIFICATION_NAME,System.String FROMDATE,System.DateTime TODATE,System.DateTime 69d3cbe84a1945bdbe190ae9c94e9c28 QUALIFICATIONHISTORY PIP1.QUALIFICATIONHISTORY QUALIFICATIONS QUALIFICATION_ID,System.String QUALIFICATION_NAME,System.String LONGNAME,System.String 31afea2c657340b09fa9bd512ef76914 QUALIFICATIONS PIP1.QUALIFICATIONS SCHEDULEGROUPFLAT EMPLOYEE_ID,System.String SCHEDULEGROUP_ID,System.String SCHEDULEGROUP_NAME,System.String DATE,System.DateTime fc317f50257e4bd9b8a5f9bcb119254f SCHEDULEGROUPFLAT PIP1.SCHEDULEGROUPFLAT SCHEDULEGROUPHISTORY EMPLOYEE_ID,System.String SCHEDULEGROUP_ID,System.String SCHEDULEGROUP_NAME,System.String FROMDATE,System.DateTime TODATE,System.DateTime 9a1d718831dd4d1eaa9d4959b8a0e5e7 SCHEDULEGROUPHISTORY PIP1.SCHEDULEGROUPHISTORY SCHEDULEGROUPS SCHEDULEGROUP_ID,System.String SCHEDULEGROUP_NAME,System.String DESCRIPTION,System.String 0f6514e0b68b4d84850844d1a3a7f348 SCHEDULEGROUPS PIP1.SCHEDULEGROUPS SCHEDULEGROUPWAGEACCOUNTVALUES SCHEDULEGROUP_ID,System.String WAGEACCOUNT_ID,System.String WAGEACCOUNT_NAME,System.String RASTER,System.String VALUE,System.Decimal UNIT,System.String FROMDATE,System.DateTime TODATE,System.DateTime 218febfce9194f2a8f01dafe0f8c63f0 SCHEDULEGROUPWAGEACCOUNTVALUES PIP1.SCHEDULEGROUPWAGEACCOUNTVALUES SCHEDULESHIFTGROUPS EMPLOYEE_ID,System.String DATE,System.DateTime LEVEL,System.Int32 SHIFT_NUMBER,System.Int32 SCHEDULEGROUP_ID,System.String SCHEDULEGROUP_NAME,System.String 6181ce63dd964533989cc6aaf71b6651 SCHEDULESHIFTGROUPS PIP1.SCHEDULESHIFTGROUPS SCHEDULESHIFTS ORIGINAL,EMPLOYEE_ID,EMPLOYEE_ID,EMPLOYEE_ID,System.String,_x0031_afbeb05b0474f34abdf84201f6a3ba0 ORIGINAL,DATE,DATE,DATE,System.DateTime,_x0030_bc4c88f311247328d3e6c1348c19b7d ORIGINAL,LEVEL,LEVEL,LEVEL,System.Int32,_x0039_d683bdee8be40d09a3fc7cc1d17b218 ORIGINAL,SHIFT_NUMBER,SHIFT_NUMBER,SHIFT_NUMBER,System.Int32,ea351d7435a64b6daba8f0d27dc86cfb ORIGINAL,SHIFTTYPE_ID,SHIFTTYPE_ID,SHIFTTYPE_ID,System.String,c7d83f744b264f08a85de7ff27edcd8d ORIGINAL,SHIFTTYPE_NAME,SHIFTTYPE_NAME,SHIFTTYPE_NAME,System.String,fe7ff0caaee24ccdadfcb1e7ab04770a ORIGINAL,FUNCTION_ID,FUNCTION_ID,FUNCTION_ID,System.String,baaaee4b4efb4e77be8b4664b9540c2b ORIGINAL,FUNCTION_NAME,FUNCTION_NAME,FUNCTION_NAME,System.String,_x0030_be46a91f1df4fd2b57a577e471413a1 ORIGINAL,COMMENT,COMMENT,COMMENT,System.String,_x0039_43c090b2bad4c6789357de4cdfe1528 ORIGINAL,BEGIN,BEGIN,BEGIN,System.Int32,_x0039_71c532e6d0742eb95aaf16cd1e609e1 ORIGINAL,END,END,END,System.Int32,e8d9b8b4fa8440bc90173e4bd9438f8e 62ff9d8beea645dd83d5a10506069e20 SCHEDULESHIFTS PIP1.SCHEDULESHIFTS SCHEDULETIMEINTERVALS EMPLOYEE_ID,System.String DATE,System.DateTime LEVEL,System.Int32 SHIFT_NUMBER,System.Int32 FROM,System.Int32 TO,System.Int32 DURATION,System.Int32 TIMETYPE_ID,System.String TIMETYPE_NAME,System.String TIMETYPE_TYPE,System.Int32 012a35a2ffc440b397711dcc1d5609d8 SCHEDULETIMEINTERVALS PIP1.SCHEDULETIMEINTERVALS SHIFTPATTERNFLAT EMPLOYEE_ID,System.String SHIFTPATTERN_ID,System.String SHIFTPATTERN_NAME,System.String SHIFTPATTERN_NUMBER,System.Int32 DATE,System.DateTime 14b0122a4a0a4685b9016346564826ee SHIFTPATTERNFLAT PIP1.SHIFTPATTERNFLAT SHIFTPATTERNHISTORY EMPLOYEE_ID,System.String SHIFTPATTERN_ID,System.String SHIFTPATTERN_NAME,System.String SHIFTPATTERN_NUMBER,System.Int32 FROMDATE,System.DateTime TODATE,System.DateTime 12af849f78aa4b5a890e79dc12373d79 SHIFTPATTERNHISTORY PIP1.SHIFTPATTERNHISTORY SHIFTSETS SHIFTSET_ID,System.String SHIFTSET_NAME,System.String DESCRIPTION,System.String d8f2879b849443d68006e45d3618dadb SHIFTSETS PIP1.SHIFTSETS SHIFTTYPES SHIFTTYPE_ID,System.String SHIFTTYPE_NAME,System.String ORIGINAL,SHIFTTYPE_TYPE,SHIFTTYPE_TYPE,SHIFTTYPE_TYPE,System.Int32,_x0032_f27dd92a72e49219e6b776702f9841e LONGNAME,System.String VIEWNAME,System.String FONTCOLOR,System.String BACKCOLOR,System.String 14eeedf6f2084388a10b701cabfd05e8 SHIFTTYPES PIP1.SHIFTTYPES STAFFINGFULLDAYVALUES SCHEDULEGROUP_ID,System.String SHIFTTYPE_ID,System.String SHIFTSET_ID,System.String FUNCTION_ID,System.String MIN,System.Decimal TARGET,System.Decimal MAX,System.Decimal ACTUAL,System.Decimal DATE,System.DateTime dfabb966e1c14e67ad4803354ea286e8 STAFFINGFULLDAYVALUES PIP1.STAFFINGFULLDAYVALUES STAFFINGINTRADAYVALUES SCHEDULEGROUP_ID,System.String TIMETYPE_ID,System.String MIN,System.Decimal TARGET,System.Decimal MAX,System.Decimal ACTUAL,System.Decimal FROMDATE,System.DateTime TODATE,System.DateTime 50f27e92ffe444af9f2b1da8c2516562 STAFFINGINTRADAYVALUES PIP1.STAFFINGINTRADAYVALUES TIMEBOOKINGS EMPLOYEE_ID,System.String TIMEEVENT_ID,System.String TIMEEVENT_NAME,System.String DATE,System.DateTime COMMENT,System.String USER,System.String DELETED,System.String MANUAL,System.String APPROVED,System.String CHANGED,System.String 6b5ed7b77300493facfd19555590fe72 TIMEBOOKINGS PIP1.TIMEBOOKINGS TIMETYPES TIMETYPE_ID,System.String TIMETYPE_NAME,System.String LONGNAME,System.String TIMETYPE_TYPE,System.Int32 COLOR,System.String 56620739afae4fc0ac1daeb7b5e795da TIMETYPES PIP1.TIMETYPES USERFIELDHISTORY EMPLOYEE_ID,System.String USERFIELD_ID,System.String USERFIELD_NAME,System.String VALUE,System.String eed4214ba0124fc9bd115d9254b9b9f1 USERFIELDHISTORY PIP1.USERFIELDHISTORY WAGEACCOUNTGROUPS WAGEACCOUNTGROUP_ID,System.String WAGEACCOUNTGROUP_NAME,System.String LONGNAME,System.String UNIT_NAME,System.String UNIT_TYPE,System.Int32 037e9bcfc8314fee88652d7ed2319dce WAGEACCOUNTGROUPS PIP1.WAGEACCOUNTGROUPS WAGEACCOUNTGROUPSTOWAGEACCOUNTS WAGEACCOUNTGROUP_ID,System.String WAGEACCOUNTGROUP_NAME,System.String WAGEACCOUNT_ID,System.String WAGEACCOUNT_NAME,System.String POSITION,System.Int32 5448a05b4544447a90c9ed8db5ad3fc3 WAGEACCOUNTGROUPSTOWAGEACCOUNTS PIP1.WAGEACCOUNTGROUPSTOWAGEACCOUNTS WAGEACCOUNTS WAGEACCOUNT_ID,System.String WAGEACCOUNT_NAME,System.String LONGNAME,System.String DEFINITION,System.String UNIT_NAME,System.String TIMESHIFT,System.Int32 TIMESHIFT_UNIT,System.String TIMESHIFT_TYPE,System.String 5f21de6261a74b9d923df393268a6fa9 WAGEACCOUNTS PIP1.WAGEACCOUNTS WORKFLOWOVERVIEW WORKFLOW_ID,System.String WORKFLOWTYPE_ID,System.String WORKFLOWTYPE_NAME,System.String WORKFLOWTYPE_TYPE,System.String CREATED,System.DateTime REQUEST_START,System.DateTime REQUEST_END,System.DateTime REQUESTER_ID,System.String REQUESTER_NAME,System.String REQUESTREQUESTER_ID,System.String REQUESTREQUESTER_NAME,System.String REQUEST_CONTENT,System.String STATUS,System.String COMMENT,System.String SUBSTITUTE_ID,System.String SUBSTITUTE_NAME,System.String 01ac2061227d4bceb7f8b2483fcd9953 WORKFLOWOVERVIEW PIP1.WORKFLOWOVERVIEW WORKFLOWSPERGROUP SCHEDULEGROUP_ID,System.String SCHEDULEGROUP_NAME,System.String WORKFLOWTYPE_ID,System.String WORKFLOWTYPE_NAME,System.String WORKFLOWTYPE_TYPE,System.String STATUS,System.String COUNT,System.Int32 e1ba31543c7849df88b9dde0662a7178 WORKFLOWSPERGROUP PIP1.WORKFLOWSPERGROUP Datenquelle1 EMPLOYEE_ID,System.String DATE,System.DateTime DURATION.Sum,System.Int64 _x007B_SCHEDULETIMEINTERVALS.TIMETYPE_NAME_x0020__x003D__x003D__x0020__x0022_Pauze_x0022__x007C__x007C__x000D__x000A_SCHEDULETIMEINTERVALS.TIMETYPE_NAME_x0020__x003D__x003D__x0020__x0022_Pause_x0022__x007D_ LEVEL,EqualTo,_x0039_9,,String EMPLOYEE_ID DATE 0d9960ad5a8d4af789e3771546704273 Datenquelle1 SCHEDULETIMEINTERVALS DURATION Sum DURATION.Sum test minmax ORIGINAL,TIMETYPE_NAME,TIMETYPE_NAME,TIMETYPE_NAME,System.String,bc4e32490d7d4411995b549431e0efcd ORIGINAL,DATE,DATE,DATE,System.DateTime,_x0035_4aaaecde7e24f55aabd1975023d4b13 ORIGINAL,EMPLOYEE_ID,EMPLOYEE_ID,EMPLOYEE_ID,System.String,_x0036_14974b460534d54bd09906892f7e575 ORIGINAL,FROM.Min,FROM.Min,FROM.Min,System.Int64,b6bfdaa7cdcb4117906b23b188274817 ORIGINAL,TO.Max,TO.Max,TO.Max,System.Int64,_x0034_b148808977d49c0b1f60d97508269ce ORIGINAL,DURATION.Sum,DURATION.Sum,DURATION.Sum,System.Int64,_x0034_44a29103a33447c88e0085635df9b95 TIMETYPE_NAME DATE EMPLOYEE_ID 7bcc596208754ccab8c7e6ec39af3fd2 test minmax SCHEDULETIMEINTERVALS FROM Min FROM.Min TO Max TO.Max DURATION Sum DURATION.Sum Comp in decimalen EMPLOYEE_ID,System.String WAGEACCOUNT_NAME,System.String VALUE,System.Decimal EMPLOYEE_ID WAGEACCOUNT_NAME abda26e52a7348b8876666ef8d951c2b Comp in decimalen EMPLOYEEWAGEACCOUNTVALUES VALUE VALUE totalen ORIGINAL,TIMETYPE_NAME,TIMETYPE_NAME,TIMETYPE_NAME,System.String,_x0030_b6a1f17bfbc4803873dc456e50164ac ORIGINAL,EMPLOYEE_ID,EMPLOYEE_ID,EMPLOYEE_ID,System.String,ca29ed6c1f294c13a11e734f190fa1b4 ORIGINAL,DURATION.Sum,DURATION.Sum,DURATION.Sum,System.Decimal,_x0032_108e128fc9c4e87b1eeb1e0ef69cbb1 TIMETYPE_NAME EMPLOYEE_ID a53964a5eb5044beba77271136036990 totalen SCHEDULETIMEINTERVALS DURATION Sum DURATION.Sum Minmax EMPLOYEE_ID,System.String DATE,System.DateTime FROM.Min,System.Int64 TO.Max,System.Int64 EMPLOYEE_ID DATE ac4d1da9965344d988e73be4a39680bc Minmax SCHEDULETIMEINTERVALS FROM Min FROM.Min TO Max TO.Max CONTRACTS CONTRACT_ID CONTRACTS ConId_CONTRACTFLAT CONTRACT_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_CONTRACTFLAT EMPLOYEE_ID CONTRACTS CONTRACT_ID CONTRACTS ConId_CONTRACTHISTORY CONTRACT_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_CONTRACTHISTORY EMPLOYEE_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_EMPLOYEEPHONENUMBERS EMPLOYEE_ID WAGEACCOUNTS WAGEACCOUNT_ID WAGEACCOUNTS WA_EMPLOYEEWAGEACCOUNTVALUES WAGEACCOUNT_ID EMPLOYEES EMPLOYEE_ID 19fcda872de848adb5db6aeea9adc75a EMPLOYEES EmpId_EMPLOYEEWAGEACCOUNTVALUES EMPLOYEE_ID FUNCTIONS FUNCTION_ID FUNCTIONS FunId_FUNCTIONFLAT FUNCTION_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_FUNCTIONFLAT EMPLOYEE_ID FUNCTIONS FUNCTION_ID FUNCTIONS FunId_FUNCTIONHISTORY FUNCTION_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_FUNCTIONHISTORY EMPLOYEE_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_HISTUSERFIELDFLAT EMPLOYEE_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_HISTUSERFIELDHISTORY EMPLOYEE_ID QUALIFICATIONS QUALIFICATION_ID QUALIFICATIONS QualId_QUALIFICATIONFLAT QUALIFICATION_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_QUALIFICATIONFLAT EMPLOYEE_ID QUALIFICATIONS QUALIFICATION_ID QUALIFICATIONS QualId_QUALIFICATIONHISTORY QUALIFICATION_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_QUALIFICATIONHISTORY EMPLOYEE_ID SCHEDULEGROUPS SCHEDULEGROUP_ID 01fc07f9d3694301ba38c6ae0f58733e SCHEDULEGROUPS SchedGrId_SCHEDULEGROUPFLAT SCHEDULEGROUP_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_SCHEDULEGROUPFLAT EMPLOYEE_ID SCHEDULEGROUPS SCHEDULEGROUP_ID SCHEDULEGROUPS SchedGrId_SCHEDULEGROUPHISTORY SCHEDULEGROUP_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_SCHEDULEGROUPHISTORY EMPLOYEE_ID WAGEACCOUNTS WAGEACCOUNT_ID WAGEACCOUNTS WA_SCHEDULEGROUPWAGEACCOUNTVALUES WAGEACCOUNT_ID SCHEDULEGROUPS SCHEDULEGROUP_ID SCHEDULEGROUPS SchedGrId_SCHEDULEGROUPWAGEACCOUNTVALUES SCHEDULEGROUP_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_SCHEDULESHIFTGROUPS EMPLOYEE_ID SHIFTTYPES SHIFTTYPE_ID 1b57d25228e4425b9ea4694185bd3d35 SHIFTTYPES ST_SCHEDULESHIFTS SHIFTTYPE_ID FUNCTIONS FUNCTION_ID 77d1fa8ae16247c795c7feeb2f6bc807 FUNCTIONS FunId_SCHEDULESHIFTS FUNCTION_ID EMPLOYEES EMPLOYEE_ID e22ec41721e441cdae3d911fb298791a EMPLOYEES EmpId_SCHEDULESHIFTS EMPLOYEE_ID TIMETYPES TIMETYPE_ID 0fc68eb0d5094434a8fad3d5085b266c TIMETYPES TT_SCHEDULETIMEINTERVALS TIMETYPE_ID EMPLOYEES EMPLOYEE_ID 41bd5175db204ba4a6d3099cd3e86877 EMPLOYEES EmpId_SCHEDULETIMEINTERVALS EMPLOYEE_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_SHIFTPATTERNFLAT EMPLOYEE_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_SHIFTPATTERNHISTORY EMPLOYEE_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_TIMEBOOKINGS EMPLOYEE_ID EMPLOYEES EMPLOYEE_ID EMPLOYEES EmpId_USERFIELDHISTORY EMPLOYEE_ID WAGEACCOUNTS WAGEACCOUNT_ID WAGEACCOUNTS WA_WAGEACCOUNTGROUPSTOWAGEACCOUNTS WAGEACCOUNT_ID WAGEACCOUNTGROUPS WAGEACCOUNTGROUP_ID WAGEACCOUNTGROUPS WAG_WAGEACCOUNTGROUPSTOWAGEACCOUNTS WAGEACCOUNTGROUP_ID SCHEDULEGROUPS SCHEDULEGROUP_ID SCHEDULEGROUPS SchedGrId_WORKFLOWSPERGROUP SCHEDULEGROUP_ID Name EMPLOYEE_ID DATE Name Beziehung EMPLOYEE_ID DATE Break EMPLOYEE_ID DATE b94ee4d00666449cabdd3d9c7b6095c4 Break Beziehung2 EMPLOYEE_ID DATE contract en comp EMPLOYEE_ID 12a3329a315843beaca7e32e8b75f746 contract en comp contract en comp EMPLOYEE_ID regime EMPLOYEE_ID e3a60c6037304128a149449d996b1433 regime regime EMPLOYEE_ID intervals EMPLOYEE_ID DATE e825aa66e8e04123ad3f899aa74ad50b intervals intervals EMPLOYEE_ID DATE minmaxtijden DATE EMPLOYEE_ID TIMETYPE_NAME 8ce51dbc80df4d509298d696f13d3e7c minmaxtijden minmaxtijden DATE EMPLOYEE_ID TIMETYPE_NAME Naam EMPLOYEE_ID Naam Relatie EMPLOYEE_ID Name EMPLOYEE_ID 13c7230a93ec4050bbfc4e59f5f50e20 Name Relation EMPLOYEE_ID Name EMPLOYEE_ID 56dff1cd1f294557b102da1b0a2df10f Name Beziehung3 EMPLOYEE_ID groep EMPLOYEE_ID DATE LEVEL SHIFT_NUMBER groep Scheduleshiftgroup EMPLOYEE_ID DATE LEVEL SHIFT_NUMBER Minmax EMPLOYEE_ID DATE Minmax Relatie2 EMPLOYEE_ID DATE functieNaam EMPLOYEE_ID functieNaam functie EMPLOYEE_ID ,dayOfWeek,dayOfWeek,,System.Int64,_x0030_,False,False,False,False EngineV2 b417072c69e747af88fcc21abd87d84c None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,27.7,1.4 Transparent 0,0.2,8.8,0.6 Arial,14,Bold 0,0,0,0 Text1 {EMPLOYEES.FIRSTNAME} {EMPLOYEES.LASTNAME} Black Expression Transparent 9.4,0,8.6,0.6 Arial,16,Bold 0,0,0,0 Text2 PIP WEEK {WeekOfYear(SCHEDULESHIFTS.DATE)} Black Expression All;Black;1;Solid;False;4;Black Transparent 24,0.4,3.2,1.4 Arial,8 Center 0,0,0,0 Text60 mw Black Expression Transparent 0,0.8,3.8,0.6 Arial,8 0,0,0,0 Text42 {EMPLOYEES.EMPLOYEE_NUMBER} Black Center Transparent 3.8,0.8,1.6,0.6 Arial,8 Center 0,0,0,0 Text56 {EMPLOYEES.functieNaam.FUNCTION_NAME} Black Center {EMPLOYEES.EMPLOYEE_ID} GroupHeaderBand1 True Transparent 0,2.6,27.7,13.6 Transparent 0,4,27.6,3.8 All;Black;1;Solid;False;4;Black Transparent 0,1.2,2,1.2 Arial,8 Center 0,0,0,0 Text5 Afwijking - 5d Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black Transparent 0,0,2,1.2 Arial,8 Center 0,0,0,0 Text4 Afwijking + 5d Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black Transparent 0,2.4,2,1.2 Arial,8 Center 0,0,0,0 Text6 Wijziging tikking Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black Transparent 5,0,0.6,1.2 Arial,8 Center 0,0,0,0 Text10 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 2.8,0,2.2,1.2 Arial,8 0,0,0,0 Text9 Black Expression All;Black;1;Solid;False;4;Black Transparent 5,1.2,0.6,1.2 Arial,8 Center 0,0,0,0 Text26 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 2.8,1.2,2.2,1.2 Arial,8 0,0,0,0 Text27 Black Expression All;Black;1;Solid;False;4;Black Transparent 2,2.4,3,1.2 Arial,8 0,0,0,0 Text43 Black Expression All;Black;1;Solid;False;4;Black Transparent 5,2.4,0.6,1.2 Arial,8 Center 0,0,0,0 Text44 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 6.4,0,2.2,1.2 Arial,8 0,0,0,0 Text7 Black Expression All;Black;1;Solid;False;4;Black Transparent 6.4,1.2,2.2,1.2 Arial,8 0,0,0,0 Text8 Black Expression All;Black;1;Solid;False;4;Black Transparent 5.6,2.4,3,1.2 Arial,8 0,0,0,0 Text11 Black Expression All;Black;1;Solid;False;4;Black Transparent 8.6,0,0.6,1.2 Arial,8 Center 0,0,0,0 Text12 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 8.6,1.2,0.6,1.2 Arial,8 Center 0,0,0,0 Text13 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 8.6,2.4,0.6,1.2 Arial,8 Center 0,0,0,0 Text14 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 12.2,0,0.6,1.2 Arial,8 Center 0,0,0,0 Text15 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 10,0,2.2,1.2 Arial,8 0,0,0,0 Text16 Black Expression All;Black;1;Solid;False;4;Black Transparent 12.2,1.2,0.6,1.2 Arial,8 Center 0,0,0,0 Text17 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 10,1.2,2.2,1.2 Arial,8 0,0,0,0 Text18 Black Expression All;Black;1;Solid;False;4;Black Transparent 9.2,2.4,3,1.2 Arial,8 0,0,0,0 Text19 Black Expression All;Black;1;Solid;False;4;Black Transparent 12.2,2.4,0.6,1.2 Arial,8 Center 0,0,0,0 Text20 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 13.6,1.2,2.2,1.2 Arial,8 0,0,0,0 Text22 Black Expression All;Black;1;Solid;False;4;Black Transparent 12.8,2.4,3,1.2 Arial,8 0,0,0,0 Text23 Black Expression All;Black;1;Solid;False;4;Black Transparent 15.8,0,0.6,1.2 Arial,8 Center 0,0,0,0 Text24 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 15.8,1.2,0.6,1.2 Arial,8 Center 0,0,0,0 Text25 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 15.8,2.4,0.6,1.2 Arial,8 Center 0,0,0,0 Text28 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 19.4,0,0.6,1.2 Arial,8 Center 0,0,0,0 Text29 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 17.2,0,2.2,1.2 Arial,8 0,0,0,0 Text30 Black Expression All;Black;1;Solid;False;4;Black Transparent 19.4,1.2,0.6,1.2 Arial,8 Center 0,0,0,0 Text31 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 17.2,1.2,2.2,1.2 Arial,8 0,0,0,0 Text32 Black Expression All;Black;1;Solid;False;4;Black Transparent 16.4,2.4,3,1.2 Arial,8 0,0,0,0 Text33 Black Expression All;Black;1;Solid;False;4;Black Transparent 19.4,2.4,0.6,1.2 Arial,8 Center 0,0,0,0 Text34 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 20.8,0,2.2,1.2 Arial,8 0,0,0,0 Text35 Black Expression All;Black;1;Solid;False;4;Black Transparent 20.8,1.2,2.2,1.2 Arial,8 0,0,0,0 Text36 Black Expression All;Black;1;Solid;False;4;Black Transparent 20,2.4,3,1.2 Arial,8 0,0,0,0 Text37 Black Expression All;Black;1;Solid;False;4;Black Transparent 23,0,0.6,1.2 Arial,8 Center 0,0,0,0 Text38 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 23,1.2,0.6,1.2 Arial,8 Center 0,0,0,0 Text39 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 23,2.4,0.6,1.2 Arial,8 Center 0,0,0,0 Text40 mw wm Black Expression Center All;Black;1;Solid;False;4;Black Transparent 2,0,0.8,1.2 Arial,8 0,0,0,0 Text3 Black Expression All;Black;1;Solid;False;4;Black Transparent 2,1.2,0.8,1.2 Arial,8 0,0,0,0 Text41 Black Expression All;Black;1;Solid;False;4;Black Transparent 5.6,0,0.8,1.2 Arial,8 0,0,0,0 Text45 Black Expression All;Black;1;Solid;False;4;Black Transparent 5.6,1.2,0.8,1.2 Arial,8 0,0,0,0 Text46 Black Expression All;Black;1;Solid;False;4;Black Transparent 9.2,0,0.8,1.2 Arial,8 0,0,0,0 Text48 Black Expression All;Black;1;Solid;False;4;Black Transparent 9.2,1.2,0.8,1.2 Arial,8 0,0,0,0 Text49 Black Expression All;Black;1;Solid;False;4;Black Transparent 12.8,0,0.8,1.2 Arial,8 0,0,0,0 Text51 Black Expression All;Black;1;Solid;False;4;Black Transparent 12.8,1.2,0.8,1.2 Arial,8 0,0,0,0 Text52 Black Expression All;Black;1;Solid;False;4;Black Transparent 16.4,1.2,0.8,1.2 Arial,8 0,0,0,0 Text55 Black Expression All;Black;1;Solid;False;4;Black Transparent 20,0,0.8,1.2 Arial,8 0,0,0,0 Text57 Black Expression All;Black;1;Solid;False;4;Black Transparent 20,1.2,0.8,1.2 Arial,8 0,0,0,0 Text58 Black Expression All;Black;1;Solid;False;4;Black Transparent 13.6,0,2.2,1.2 Arial,8 0,0,0,0 Text21 Black Expression All;Black;1;Solid;False;4;Black Transparent 16.4,0,0.8,1.2 Arial,8 0,0,0,0 Text54 Black Expression Panel1 All;Black;1;Solid;False;4;Black Transparent 0,3,23.6,1 dayOfWeek = 0; Transparent 0,0.4,23.6,0.4 Transparent 0,0,2,0.4 All;Black;1;Solid;False;4;Black Transparent 0,0,2,0.6 Arial,8 Center 0,0,0,0 Text47 {test_minmax.TIMETYPE_NAME} Black Expression Center CrossHeaderBand1 if(dayOfWeek == (int) test_minmax.DATE.DayOfWeek && test_minmax.TIMETYPE_NAME == Format("{0}",Next(test_minmax,"TIMETYPE_NAME")) ) test_minmax.Next(); if(dayOfWeek<6) dayOfWeek++; else dayOfWeek = 0; All;Black;1;Solid;False;4;Black Transparent 2,0,2.8,0.4 All;Black;1;Solid;False;4;Black Transparent 0.8,0,2.8,0.6 test_minmax.FROM_Min,EqualTo,_x0030_,,Numeric,Transparent,Transparent,Arial_x002C_8,True,False,,,None Arial,8 Center 0,0,0,0 Text50 {IIF(dayOfWeek == (int) test_minmax.DATE.DayOfWeek,Left(TimeSerial(0,test_minmax.FROM_Min,0),5) + " - " + Left(TimeSerial(0,test_minmax.TO_Max,0),5),null)} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 0,0,0.8,0.6 Arial,8 Center 0,0,0,0 Text53 {IIF(dayOfWeek == (int) test_minmax.DATE.DayOfWeek,Left(TimeSerial(0,test_minmax.DURATION_Sum,0),5),null)} Black Expression Center 6 CrossDataBand1 Beziehung3 test minmax TIMETYPE_NAME,NotEqualTo,Pauze,,String TIMETYPE_NAME,NotEqualTo,Normwerktijd,,String TIMETYPE_NAME,NotEqualTo,W,,String TIMETYPE_NAME,NotEqualTo,T,,String TIMETYPE_NAME,NotEqualTo,Temps_x0020_normal,,String TIMETYPE_NAME,NotEqualTo,Pause,,String Datatest_minmax DESC {test_minmax.TIMETYPE_NAME == "WV"} DESC {test_minmax.TIMETYPE_NAME == "UW7"} DESC {test_minmax.TIMETYPE_NAME == "AO"} DESC {test_minmax.TIMETYPE_NAME == "SOL"} DESC {test_minmax.TIMETYPE_NAME == "WMB"} DESC {test_minmax.TIMETYPE_NAME == "OPL"} DESC {test_minmax.TIMETYPE_NAME == "Prodis opleiding"} DESC {test_minmax.TIMETYPE_NAME == "Z"} ASC DATE Panel3 All;Black;1;Solid;False;4;Black Transparent True 23.6,1.2,4.1,1.2 All;Black;1;Solid;False;4;Black White 0,0.5,2.22,0.4 Arial,8 234d74bebd0a41709be40481524c4733 0,0,0,0 2.22,0 CrossTab2_SummaryTitle AllowMove, AllowResize, AllowSelect, AllowChange COMPENSATIE Black Expression SummaryTitle All;[155:155:155];1;Solid;False;4;Black [255:255:255] 5.65,0.05,0,0.4 False Arial,8 455486c029084f5d8728259e0278fc41 0,0,0,0 CrossTab2_ColTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;Black;1;Solid;False;4;Black White 0,0.05,2.2,0.4 Arial,8 81c5d221e9ac41b0bdd1ba5d18226d39 0,0,0,0 CrossTab2_Column1_Title AllowMove, AllowResize, AllowSelect, AllowChange REGIME Black Expression Col:CrossTab2_Column1 TARGETHOURS All;[155:155:155];1;Solid;False;4;Black White 2.25,0.05,2.4,0.4 {SCHEDULESHIFTS.regime.CONTRACTS.TARGETHOURS} Arial,8 82080e5b712245f09f864a28fd62164e 0,0,0,0 CrossTab2_Column1 AllowMove, AllowResize, AllowSelect, AllowChange TARGETHOURS Black 455486c029084f5d8728259e0278fc41 {SCHEDULESHIFTS.regime.CONTRACTS.TARGETHOURS} VALUE All;[155:155:155];1;Solid;False;4;Black [255:255:255] 2.25,0.5,2.4,0.4 Arial,8 5ad802bfec914680be8fb8aba2c984cb 0,0,0,0 0.5,0 CrossTab2_Sum1 AllowMove, AllowResize, AllowSelect, AllowChange

None

0 Black 2 : . 1 DecimalDigits, DecimalSeparator {Truncate(SCHEDULESHIFTS.contract_en_comp.VALUE) + (SCHEDULESHIFTS.contract_en_comp.VALUE - Truncate(SCHEDULESHIFTS.contract_en_comp.VALUE))/10*6} EmpId_SCHEDULESHIFTS SCHEDULESHIFTS CrossTab2 All;Black;1;Solid;False;4;Black Transparent True 23.6,3,2.8,1 All;[155:155:155];1;Solid;False;4;Black White 2.65,0.05,2.4,0.4 False Arial,8 d8c8c6d6b087448f803ddc18f3b7d052 0,0,0,0 CrossTab3_SummaryTitle AllowMove, AllowResize, AllowSelect, AllowChange DURATION.Sum [105:105:105] Expression SummaryTitle All;Black;1;Solid;False;4;Black [255:255:255] 0,0.9,2.6,0 False Arial,8 9085456f335a4f5182ccffc3587e46b1 0,0,0,0 1,0 CrossTab3_RowTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;Black;1;Solid;False;4;Black White 0,0.05,2.6,0.4 False Arial,8 328430007fe4410b8c0ac430bea85ba5 0,0,0,0 CrossTab3_Row1_Title AllowMove, AllowResize, AllowSelect, AllowChange Total Black Expression Row:CrossTab3_Row1 TIMETYPE_NAME All;Black;1;Solid;False;4;Black White 0,0.5,2.6,0.6 {IIF(totalen.TIMETYPE_NAME != "Normwerktijd",totalen.TIMETYPE_NAME,"Planning")} Arial,8 3a69ed3da4014333abc0edc70485cb6e 0,0,0,0 2.2,0.5 CrossTab3_Row1 AllowMove, AllowResize, AllowSelect, AllowChange None TIMETYPE_NAME Black 9085456f335a4f5182ccffc3587e46b1 {totalen.TIMETYPE_NAME} DURATION.Sum All;[155:155:155];1;Solid;False;4;Black [255:255:255] 2.65,0.5,2.4,0.6 Arial,8 5db56bbb2ac84d6f9d7f4dcc20590f6c 0,0,0,0 1,0 CrossTab3_Sum1 AllowMove, AllowResize, AllowSelect, AllowChange 0 Black 2 : . 1 DecimalDigits, DecimalSeparator {Truncate((totalen.DURATION_Sum/60)) + ((totalen.DURATION_Sum/60) - Truncate((totalen.DURATION_Sum/60)))/10*6} Relation totalen TIMETYPE_NAME,NotEqualTo,Pauze,,String TIMETYPE_NAME,NotEqualTo,Normwerktijd,,String TIMETYPE_NAME,NotEqualTo,W,,String TIMETYPE_NAME,NotEqualTo,Pause,,String TIMETYPE_NAME,NotEqualTo,T,,String TIMETYPE_NAME,NotEqualTo,Temps_x0020_normal,,String CrossTab3 False DESC {totalen.TIMETYPE_NAME == "WV"} DESC {totalen.TIMETYPE_NAME == "UW7"} DESC {totalen.TIMETYPE_NAME == "AO"} DESC {totalen.TIMETYPE_NAME == "SOL"} DESC {totalen.TIMETYPE_NAME == "WMB"} DESC {totalen.TIMETYPE_NAME == "OPL"} DESC {totalen.TIMETYPE_NAME == "Prodis opleiding"} DESC {totalen.TIMETYPE_NAME == "Z"} All;Black;1;Solid;False;4;Black Transparent True 23.6,2,4,1.4 All;[155:155:155];1;Solid;False;4;Black White 3.45,0.05,1.2,0.4 False Arial,8 124e18fa04c1482d83ba6c8fc903d678 0,0,0,0 CrossTab4_SummaryTitle AllowMove, AllowResize, AllowSelect, AllowChange VALUE [105:105:105] SummaryTitle All;Black;1;Solid;False;4;Black [255:255:255] 0,0.9,3.4,0 False Arial,8 a5edfffb505745518ddb3a6359a799d4 0,0,0,0 CrossTab4_RowTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;Black;1;Solid;False;4;Black White 0,0.05,3.4,0.4 False Arial,8 51aa4875ddea438cad84a914243ffd56 0,0,0,0 CrossTab4_Row1_Title AllowMove, AllowResize, AllowSelect, AllowChange WAGEACCOUNT_NAME Black Row:CrossTab4_Row1 WAGEACCOUNT_NAME All;Black;1;Solid;False;4;Black White 0,0.5,3.4,0.4 TOTALE TIJD Arial,8 5b5747f517f24e3d8f13186f59c0dc1e 0,0,0,0 2.22,0 CrossTab4_Row1 AllowMove, AllowResize, AllowSelect, AllowChange WAGEACCOUNT_NAME Black a5edfffb505745518ddb3a6359a799d4 {EMPLOYEEWAGEACCOUNTVALUES.WAGEACCOUNT_NAME} VALUE All;[155:155:155];1;Solid;False;4;Black [255:255:255] 3.45,0.5,1.2,0.4 Arial,8 2631f244208540c49ebca81789080817 0,0,0,0 0.5,0 CrossTab4_Sum1 AllowMove, AllowResize, AllowSelect, AllowChange

None

0 Black 2 : . 1 DecimalDigits, DecimalSeparator {Truncate(EMPLOYEEWAGEACCOUNTVALUES.VALUE) + (EMPLOYEEWAGEACCOUNTVALUES.VALUE - Truncate(EMPLOYEEWAGEACCOUNTVALUES.VALUE))/10*6} EmpId_EMPLOYEEWAGEACCOUNTVALUES EMPLOYEEWAGEACCOUNTVALUES WAGEACCOUNT_NAME,EqualTo,Totale_x0020_tijd,,String CrossTab4 All;Black;1;Solid;False;4;Black Transparent True 0,1.2,26.3,1.8 All;Black;1;Solid;False;4;Black [255:255:255] 3.05,0.05,0,0.4 False Arial,8 5a9a0aac1ca348b68cf47d95282c33ac 0,0,0,0 CrossTab1_ColTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;Black;1;Solid;False;4;Black White 1.85,0.45,0.6,0.4 False Arial,8 fd22ff37665e4068b9098af897c69b61 0,0,0,0 CrossTab1_SumHeader1 AllowMove, AllowResize, AllowSelect, AllowChange 1 Black All;Black;1;Solid;False;4;Black White 2.45,0.45,0.6,0.4 False Arial,8 0990208e2ac94545b6d913974b3dcc44 0,0,0,0 CrossTab1_SumHeader2 AllowMove, AllowResize, AllowSelect, AllowChange 2 Black All;Black;1;Solid;False;4;Black White 0,0.45,2,0.4 False Arial,8 8cae79ad3ef546d28330457fa7bccf1b 0,0,0,0 2,0 CrossTab1_Row1_Title AllowMove, AllowResize, AllowSelect, AllowChange SHIFT_NUMBER Black Row:CrossTab1_Row1 All;Black;1;Solid;False;4;Black White 0,0,2.8,0.4 False Arial,8 621c8136931a4ea586ef4f72c12d7f5c 0,0,0,0 CrossTab1_LeftTitle AllowMove, AllowResize, AllowSelect, AllowChange SCHEDULESHIFTS Black LeftTitle All;Black;1;Solid;False;4;Black [255:255:255] 0,1.3,3.6,0 False Arial,8 d0d02af3f4294fd78a243d5c34cfd1dc 0,0,0,0 CrossTab1_RowTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;Black;1;Solid;False;4;Black White 2.85,0,3.6,0.4 Arial,8 cf2922041916410ca72853556e49868b 0,0,0,0 CrossTab1_RightTitle AllowMove, AllowResize, AllowSelect, AllowChange DATE Black RightTitle SCHEDULEGROUP_NAME All;Black;1;Solid;False;4;Black White 0,0.9,2,0.8 {SCHEDULESHIFTS.groep.SCHEDULEGROUP_NAME} Arial,8 5ed67086743a4ec79e70534d593fd918 0,0,0,0 2,0 2,0 CrossTab1_Row1 AllowMove, AllowResize, AllowSelect, AllowChange SCHEDULEGROUP_NAME Black ,,,,WordWrap=True,A=0 d0d02af3f4294fd78a243d5c34cfd1dc {SCHEDULESHIFTS.groep.SCHEDULEGROUP_NAME} DATE All;Black;1;Solid;False;4;Black White 2.85,0.45,3.6,0.4 {DayOfWeek(SCHEDULESHIFTS.DATE)} {Format("{0:dd.MM.yyyy}", SCHEDULESHIFTS.DATE)} Arial,8 deef2346d62f4e88b2a405a1677a2fb6 0,0,0,0 CrossTab1_Column1 AllowMove, AllowResize, AllowSelect, AllowChange None ByValue DATE Black yy 5a9a0aac1ca348b68cf47d95282c33ac {DayOfWeek(SCHEDULESHIFTS.DATE)} {SCHEDULESHIFTS.DATE} BEGIN All;Black;1;Solid;False;4;Black [255:255:255] 2.85,0.9,0.8,0.8 _x007B_value.ToString_x0028__x0029_.Contains_x0028__x0020__x0022_00:00_x0022__x0029__x007D_,Transparent,Brown,Arial_x002C_8,True,False,,,None,TextColor Arial,8 9b19f88f179d470dae2e5c19c13a58bf 0,0,0,0 0.8,0 CrossTab1_Sum1 AllowMove, AllowResize, AllowSelect, AllowChange

None

0 Black {Left(TimeSerial(0,SCHEDULESHIFTS.Minmax.TO_Max - SCHEDULESHIFTS.Minmax.FROM_Min - SCHEDULESHIFTS.Break.DURATION_Sum,0),5)} END All;Black;1;Solid;False;4;Black [255:255:255] 3.65,0.9,2.8,0.8 Arial,8 ff8e7b3281914c23b1486c868d2d1a09 Center 0,0,0,0 0,1 2.8,0 CrossTab1_Sum2 AllowMove, AllowResize, AllowSelect, AllowChange

None

0 Black {​​IIF(SCHEDULESHIFTS.Break.DURATION_Sum == 0,SCHEDULESHIFTS.SHIFTTYPES.SHIFTTYPE_NAME,null)}​​{​​IIF(​​SCHEDULESHIFTS.Minmax.TO_Max > 0, Left(TimeSerial(0,SCHEDULESHIFTS.Minmax.FROM_Min,0),5) + " - " + Left(TimeSerial(0,​​SCHEDULESHIFTS.Minmax.TO_Max,0),5),null)}​​ EmpId_SCHEDULESHIFTS SCHEDULESHIFTS LEVEL,EqualTo,_x0039_9,,String CrossTab1 LeftToRight EMPLOYEES DataBand1 b6ce0993634945d69277b1cf83cc0f3d 1,1,1,1 Page1 Landscape 21 29.7 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 12/29/2020 9:09:27 AM 9/29/2020 3:43:52 PM C:\Users\mgroenendijk\OneDrive - WorkforceIT\Klanten en Projecten\ALDI - PIP Rapport\PIP1\Definitieve versie\def definitief\PIP1.15nederlands.mrt 804e86358b3642afa2ae850561e63c02 Report Centimeters 2020.3.2.0 CSharp