-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathoz.sql
executable file
·3507 lines (3464 loc) · 208 KB
/
oz.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 4.2.5
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Erstellungszeit: 31. Mai 2015 um 12:24
-- Server Version: 5.5.43-0ubuntu0.14.04.1
-- PHP-Version: 5.5.21
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Datenbank: `oz`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `arbeitsfrei`
--
CREATE TABLE IF NOT EXISTS `arbeitsfrei` (
`aid` int(20) NOT NULL,
`bezeichnung` varchar(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Abwesenheitsgruende' AUTO_INCREMENT=100 ;
--
-- Daten für Tabelle `arbeitsfrei`
--
INSERT INTO `arbeitsfrei` (`aid`, `bezeichnung`) VALUES
(1, 'Gleittag'),
(2, 'Urlaub'),
(3, 'krank'),
(88, 'nicht erfasst'),
(99, 'anwesend'),
(4, 'Fortbildung');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `behoerde`
--
CREATE TABLE IF NOT EXISTS `behoerde` (
`bid` int(11) NOT NULL COMMENT 'Behoerden ID',
`art` varchar(30) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`verantwortlich` char(30) DEFAULT NULL,
`rahmenzeit_beginn` time NOT NULL,
`rahmenzeit_ende` time NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
--
-- Daten für Tabelle `behoerde`
--
INSERT INTO `behoerde` (`bid`, `art`, `name`, `verantwortlich`, `rahmenzeit_beginn`, `rahmenzeit_ende`) VALUES
(1, 'Senatsverwaltung', 'Finanzen', 'Hr. Nussbaum', '06:00:00', '19:30:00'),
(2, 'Senatsverwaltung', 'Inneres und Sport', 'Hr. Henkel', '06:00:00', '19:30:00'),
(3, 'Senatsverwaltung', 'Arbeit, Integration und Frauen', 'Fr. Kolat', '06:00:00', '19:30:00'),
(4, 'Senatsverwaltung', 'Justiz und Verbraucherschutz', 'Hr. Heilmann', '06:00:00', '20:00:00'),
(5, 'Senatsverwaltung', 'Wirtschaft, Technologie und Forschung', 'Fr. Yzer', '06:00:00', '19:30:00'),
(6, 'Senatsverwaltung', 'Bildung, Jugend und Wissenschaft', 'Fr. Scheeres', '06:00:00', '19:30:00'),
(7, 'Senatsverwaltung', 'Gesundheit und Soziales', 'Hr. Czaja', '06:00:00', '19:30:00'),
(8, 'Senatsverwaltung', 'Stadtentwicklung und Umwelt', 'Hr. Müller', '06:00:00', '19:00:00'),
(9, 'Bezirksamt', 'Charlottenburg-Wilmersdorf', 'Hr. Naumann', '06:00:00', '20:00:00'),
(10, 'Bezirksamt', 'Friedrichshain-Kreuzberg', 'Fr. Herrmann', '06:00:00', '20:00:00'),
(11, 'Bezirksamt', 'Lichtenberg', 'Hr. Geisel', '06:00:00', '19:00:00'),
(12, 'Bezirksamt', 'Neukölln', 'Hr. Buschkowsky', '06:30:00', '20:00:00'),
(13, 'Bezirksamt', 'Pankow', 'Hr. Köhne', '06:00:00', '19:30:00'),
(14, 'Bezirksamt', 'Spandau', 'Hr. Kleebank', '06:00:00', '19:30:00'),
(15, 'Bezirksamt', 'Treptow-Köpenick', 'Hr. Igel', '06:00:00', '20:00:00'),
(16, 'Bezirksamt', 'Mitte', 'Hr. Hanke', '06:00:00', '20:00:00'),
(17, 'Bezirksamt', 'Marzahn-Hellersdorf', 'Hr. Komoß', '06:00:00', '19:30:00'),
(18, 'Bezirksamt', 'Reinickendorf', 'Hr. Balzer', '06:00:00', '19:00:00'),
(19, 'Bezirksamt', 'Tempelhof-Schöneberg', 'Fr. Schöttler', '06:00:00', '19:30:00'),
(20, 'Bezirksamt', 'Steglitz-Zehlendorf', 'Hr. Kopp', '06:00:00', '20:30:00'),
(21, 'Nachgeordnete/Sonderbehörde', 'Polizei', 'Hr. Kandt', '06:00:00', '19:30:00'),
(22, 'Nachgeordnete/Sonderbehörde', 'Landesamt für Bürger- und Ordnungsangelegenheiten', 'Fr. Langenheide', '06:00:00', '19:30:00'),
(23, 'Nachgeordnete/Sonderbehörde', 'Landesamt für Gesundheit und Soziales', 'Hr. Allert', '06:00:00', '19:30:00');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `erfassung`
--
CREATE TABLE IF NOT EXISTS `erfassung` (
`eid` int(11) NOT NULL COMMENT 'Erfassungs ID',
`maid` int(11) DEFAULT NULL,
`datum` date DEFAULT NULL,
`beginn` time DEFAULT NULL,
`ende` time DEFAULT NULL,
`maneintrag` int(11) DEFAULT NULL,
`bemerkung` varchar(50) DEFAULT NULL,
`aid` int(11) DEFAULT NULL COMMENT 'Arbeitsfrei ID',
`pause` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3252 ;
--
-- Daten für Tabelle `erfassung`
--
INSERT INTO `erfassung` (`eid`, `maid`, `datum`, `beginn`, `ende`, `maneintrag`, `bemerkung`, `aid`, `pause`) VALUES
(2, 112, '2014-06-11', '06:00:00', '12:00:00', NULL, '', 2, NULL),
(6, 112, '2014-06-10', '07:00:00', '14:20:00', NULL, '', 1, NULL),
(8, 112, '2014-06-02', '05:33:00', '12:00:00', NULL, '', 2, NULL),
(9, 112, '2014-06-06', '00:00:00', '14:20:00', NULL, '', 99, NULL),
(11, 112, '2014-06-12', '08:52:00', '12:44:00', NULL, '', 99, NULL),
(12, 112, '2014-06-09', '08:00:00', '16:00:00', NULL, 'Homeoffice', 99, NULL),
(13, 112, '2014-06-17', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(15, 112, '2014-06-16', '05:33:00', '13:23:00', NULL, '', 99, NULL),
(16, 112, '2014-06-03', '06:00:00', '14:20:00', NULL, '', 99, NULL),
(17, 2, '2014-10-01', NULL, NULL, NULL, NULL, 88, NULL),
(18, 2, '2014-10-02', NULL, NULL, NULL, NULL, 88, NULL),
(19, 2, '2014-10-03', NULL, NULL, NULL, NULL, 88, NULL),
(20, 2, '2014-10-06', NULL, NULL, NULL, NULL, 88, NULL),
(21, 2, '2014-10-07', NULL, NULL, NULL, NULL, 88, NULL),
(22, 2, '2014-10-08', NULL, NULL, NULL, NULL, 88, NULL),
(23, 2, '2014-10-09', NULL, NULL, NULL, NULL, 88, NULL),
(24, 2, '2014-10-10', NULL, NULL, NULL, NULL, 88, NULL),
(25, 2, '2014-10-13', NULL, NULL, NULL, NULL, 88, NULL),
(26, 2, '2014-10-14', NULL, NULL, NULL, NULL, 88, NULL),
(27, 2, '2014-10-15', NULL, NULL, NULL, NULL, 88, NULL),
(28, 2, '2014-10-16', NULL, NULL, NULL, NULL, 88, NULL),
(29, 2, '2014-10-17', NULL, NULL, NULL, NULL, 88, NULL),
(30, 2, '2014-10-20', NULL, NULL, NULL, NULL, 88, NULL),
(31, 2, '2014-10-21', NULL, NULL, NULL, NULL, 88, NULL),
(32, 2, '2014-10-22', NULL, NULL, NULL, NULL, 88, NULL),
(33, 2, '2014-10-23', NULL, NULL, NULL, NULL, 88, NULL),
(34, 2, '2014-10-24', NULL, NULL, NULL, NULL, 88, NULL),
(35, 2, '2014-10-27', NULL, NULL, NULL, NULL, 88, NULL),
(36, 2, '2014-10-28', NULL, NULL, NULL, NULL, 88, NULL),
(37, 2, '2014-10-29', NULL, NULL, NULL, NULL, 88, NULL),
(38, 2, '2014-10-30', NULL, NULL, NULL, NULL, 88, NULL),
(39, 2, '2014-10-31', NULL, NULL, NULL, NULL, 88, NULL),
(40, 3, '2014-10-01', NULL, NULL, NULL, NULL, 88, NULL),
(41, 3, '2014-10-02', NULL, NULL, NULL, NULL, 88, NULL),
(42, 3, '2014-10-03', NULL, NULL, NULL, NULL, 88, NULL),
(43, 3, '2014-10-06', NULL, NULL, NULL, NULL, 88, NULL),
(44, 3, '2014-10-07', NULL, NULL, NULL, NULL, 88, NULL),
(45, 3, '2014-10-08', NULL, NULL, NULL, NULL, 88, NULL),
(46, 3, '2014-10-09', NULL, NULL, NULL, NULL, 88, NULL),
(47, 3, '2014-10-10', NULL, NULL, NULL, NULL, 88, NULL),
(48, 3, '2014-10-13', NULL, NULL, NULL, NULL, 88, NULL),
(49, 3, '2014-10-14', NULL, NULL, NULL, NULL, 88, NULL),
(50, 3, '2014-10-15', NULL, NULL, NULL, NULL, 88, NULL),
(51, 3, '2014-10-16', NULL, NULL, NULL, NULL, 88, NULL),
(52, 3, '2014-10-17', NULL, NULL, NULL, NULL, 88, NULL),
(53, 3, '2014-10-20', NULL, NULL, NULL, NULL, 88, NULL),
(54, 3, '2014-10-21', NULL, NULL, NULL, NULL, 88, NULL),
(55, 3, '2014-10-22', NULL, NULL, NULL, NULL, 88, NULL),
(56, 3, '2014-10-23', NULL, NULL, NULL, NULL, 88, NULL),
(57, 3, '2014-10-24', NULL, NULL, NULL, NULL, 88, NULL),
(58, 3, '2014-10-27', NULL, NULL, NULL, NULL, 88, NULL),
(59, 3, '2014-10-28', NULL, NULL, NULL, NULL, 88, NULL),
(60, 3, '2014-10-29', NULL, NULL, NULL, NULL, 88, NULL),
(61, 3, '2014-10-30', NULL, NULL, NULL, NULL, 88, NULL),
(62, 3, '2014-10-31', NULL, NULL, NULL, NULL, 88, NULL),
(63, 112, '2014-10-01', NULL, NULL, NULL, NULL, 88, NULL),
(64, 112, '2014-10-02', NULL, NULL, NULL, NULL, 88, NULL),
(65, 112, '2014-10-03', NULL, NULL, NULL, NULL, 88, NULL),
(66, 112, '2014-10-06', NULL, NULL, NULL, NULL, 88, NULL),
(67, 112, '2014-10-07', NULL, NULL, NULL, NULL, 88, NULL),
(68, 112, '2014-10-08', NULL, NULL, NULL, NULL, 88, NULL),
(69, 112, '2014-10-09', NULL, NULL, NULL, NULL, 88, NULL),
(70, 112, '2014-10-10', NULL, NULL, NULL, NULL, 88, NULL),
(71, 112, '2014-10-13', NULL, NULL, NULL, NULL, 88, NULL),
(72, 112, '2014-10-14', NULL, NULL, NULL, NULL, 88, NULL),
(73, 112, '2014-10-15', NULL, NULL, NULL, NULL, 88, NULL),
(74, 112, '2014-10-16', NULL, NULL, NULL, NULL, 88, NULL),
(75, 112, '2014-10-17', NULL, NULL, NULL, NULL, 88, NULL),
(76, 112, '2014-10-20', NULL, NULL, NULL, NULL, 88, NULL),
(77, 112, '2014-10-21', NULL, NULL, NULL, NULL, 88, NULL),
(78, 112, '2014-10-22', NULL, NULL, NULL, NULL, 88, NULL),
(79, 112, '2014-10-23', NULL, NULL, NULL, NULL, 88, NULL),
(80, 112, '2014-10-24', NULL, NULL, NULL, NULL, 88, NULL),
(81, 112, '2014-10-27', NULL, NULL, NULL, NULL, 88, NULL),
(82, 112, '2014-10-28', NULL, NULL, NULL, NULL, 88, NULL),
(83, 112, '2014-10-29', NULL, NULL, NULL, NULL, 88, NULL),
(84, 112, '2014-10-30', NULL, NULL, NULL, NULL, 88, NULL),
(85, 112, '2014-10-31', NULL, NULL, NULL, NULL, 88, NULL),
(86, 113, '2014-10-01', NULL, NULL, NULL, NULL, 88, NULL),
(87, 113, '2014-10-02', NULL, NULL, NULL, NULL, 88, NULL),
(88, 113, '2014-10-03', NULL, NULL, NULL, NULL, 88, NULL),
(89, 113, '2014-10-06', NULL, NULL, NULL, NULL, 88, NULL),
(90, 113, '2014-10-07', NULL, NULL, NULL, NULL, 88, NULL),
(91, 113, '2014-10-08', NULL, NULL, NULL, NULL, 88, NULL),
(92, 113, '2014-10-09', NULL, NULL, NULL, NULL, 88, NULL),
(93, 113, '2014-10-10', NULL, NULL, NULL, NULL, 88, NULL),
(94, 113, '2014-10-13', NULL, NULL, NULL, NULL, 88, NULL),
(95, 113, '2014-10-14', NULL, NULL, NULL, NULL, 88, NULL),
(96, 113, '2014-10-15', NULL, NULL, NULL, NULL, 88, NULL),
(97, 113, '2014-10-16', NULL, NULL, NULL, NULL, 88, NULL),
(98, 113, '2014-10-17', NULL, NULL, NULL, NULL, 88, NULL),
(99, 113, '2014-10-20', NULL, NULL, NULL, NULL, 88, NULL),
(100, 113, '2014-10-21', NULL, NULL, NULL, NULL, 88, NULL),
(101, 113, '2014-10-22', NULL, NULL, NULL, NULL, 88, NULL),
(102, 113, '2014-10-23', NULL, NULL, NULL, NULL, 88, NULL),
(103, 113, '2014-10-24', NULL, NULL, NULL, NULL, 88, NULL),
(104, 113, '2014-10-27', NULL, NULL, NULL, NULL, 88, NULL),
(105, 113, '2014-10-28', NULL, NULL, NULL, NULL, 88, NULL),
(106, 113, '2014-10-29', NULL, NULL, NULL, NULL, 88, NULL),
(107, 113, '2014-10-30', NULL, NULL, NULL, NULL, 88, NULL),
(108, 113, '2014-10-31', NULL, NULL, NULL, NULL, 88, NULL),
(109, 118, '2014-10-03', '07:00:00', '15:00:00', NULL, '', 2, NULL),
(110, 118, '2014-10-27', '07:30:00', '14:30:00', NULL, '', 99, NULL),
(111, 119, '2014-10-28', '06:50:00', '15:30:00', NULL, '', 99, NULL),
(112, 119, '2014-10-27', '02:20:00', '15:30:00', NULL, 'Felder sollten größer sein', 99, NULL),
(113, 119, '2014-10-25', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(114, 119, '2014-10-26', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(115, 118, '2014-10-24', '07:24:00', '16:00:00', NULL, '', 99, NULL),
(116, 118, '2014-10-28', '07:55:00', '16:23:00', NULL, '', 99, NULL),
(117, 118, '2014-10-23', '08:14:00', '16:45:00', NULL, '', 99, NULL),
(118, 118, '2014-10-22', '07:01:00', '15:46:00', NULL, '', 99, NULL),
(119, 118, '2014-10-21', '08:11:00', '16:47:00', NULL, '', 99, NULL),
(120, 118, '2014-10-21', '08:28:00', '16:51:00', NULL, '', 99, NULL),
(121, 118, '2014-10-20', '08:28:00', '16:51:00', NULL, '', 99, NULL),
(122, 118, '2014-10-17', '08:07:00', '15:41:00', NULL, '', 99, NULL),
(123, 118, '2014-10-17', '08:30:00', '16:15:00', NULL, '', 99, NULL),
(124, 118, '2014-10-17', '08:07:00', '15:41:00', NULL, '', 99, NULL),
(125, 118, '2014-10-16', '08:30:00', '16:15:00', NULL, '', 99, NULL),
(126, 118, '2014-10-15', '06:52:00', '15:48:00', NULL, '', 99, NULL),
(127, 118, '2014-10-14', '08:58:00', '15:27:00', NULL, '', 99, NULL),
(128, 118, '2014-10-13', '07:15:00', '15:43:00', NULL, '', 99, NULL),
(129, 118, '2014-10-10', '08:32:00', '16:07:00', NULL, '', 99, NULL),
(130, 118, '2014-10-09', '07:35:00', '16:41:00', NULL, '', 99, NULL),
(131, 118, '2014-10-08', '07:33:00', '15:56:00', NULL, '', 99, NULL),
(132, 118, '2014-10-07', '08:38:00', '15:59:00', NULL, '', 99, NULL),
(133, 118, '2014-10-02', '08:32:00', '17:01:00', NULL, '', 99, NULL),
(134, 118, '2014-10-01', '07:40:00', '16:07:00', NULL, '', 99, NULL),
(135, 118, '2014-10-06', '07:43:00', '16:09:00', NULL, '', 99, NULL),
(136, 118, '2014-10-29', '08:30:00', '17:05:00', NULL, '', 99, NULL),
(137, 118, '2014-10-30', '11:00:00', '17:15:00', NULL, '', 99, NULL),
(138, 118, '2014-10-31', '00:00:00', '00:00:00', NULL, '', 1, NULL),
(139, 118, '2014-11-04', '00:00:00', '00:00:00', NULL, '', 1, NULL),
(140, 116, '2014-11-03', '07:50:00', '17:00:00', NULL, '', 99, NULL),
(141, 116, '2014-11-03', '07:50:00', '17:00:00', NULL, '', 99, NULL),
(142, 115, '2014-11-01', '07:00:00', '15:00:00', NULL, '', 88, NULL),
(143, 115, '2014-11-03', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(144, 122, '2014-11-03', '09:09:00', '17:55:00', NULL, '', 99, NULL),
(145, 122, '2014-11-04', '08:57:00', '17:53:00', NULL, '', 99, NULL),
(146, 122, '2014-11-05', '08:49:00', '17:40:00', NULL, '', 99, NULL),
(147, 122, '2014-11-06', '09:31:00', '17:31:00', NULL, '', 99, NULL),
(148, 122, '2014-11-07', '09:33:00', '17:31:00', NULL, '', 99, NULL),
(149, 122, '2014-11-10', '08:53:00', '17:46:00', NULL, '', 99, NULL),
(150, 122, '2014-11-11', '09:48:00', '16:03:00', NULL, '', 99, NULL),
(151, 122, '2014-11-12', '09:00:00', '17:24:00', NULL, '', 99, NULL),
(152, 122, '2014-11-13', '08:57:00', '17:37:00', NULL, '', 99, NULL),
(153, 122, '2014-11-14', '09:02:00', '17:14:00', NULL, '', 99, NULL),
(154, 122, '2014-11-17', '09:46:00', '17:58:00', NULL, '', 99, NULL),
(155, 122, '2014-11-18', '09:45:00', '17:29:00', NULL, '', 99, NULL),
(156, 122, '2014-11-19', '09:03:00', '17:58:00', NULL, '', 99, NULL),
(157, 122, '2014-11-20', '10:00:00', '18:00:00', NULL, '', 99, NULL),
(158, 122, '2014-11-21', '10:00:00', '18:00:00', NULL, '', 99, NULL),
(159, 122, '2014-11-24', '10:30:00', '16:00:00', NULL, '', 99, NULL),
(160, 122, '2014-11-25', '09:20:00', '16:50:00', NULL, '', 99, NULL),
(161, 122, '2014-11-26', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(162, 122, '2014-11-28', '09:13:00', '13:49:00', NULL, '', 99, NULL),
(163, 122, '2014-11-27', '09:04:00', '17:02:00', NULL, '', 99, NULL),
(164, 121, '2014-11-02', '00:00:00', '00:00:00', NULL, '', 88, NULL),
(165, 121, '2014-11-03', '08:30:00', '15:00:00', NULL, '', 99, NULL),
(166, 121, '2014-11-04', '08:10:00', '17:05:00', NULL, '', 99, NULL),
(167, 115, '2014-11-04', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(168, 116, '2014-11-04', '08:00:00', '17:00:00', NULL, '', 99, NULL),
(169, 116, '2014-11-05', '08:10:00', '17:00:00', NULL, '', 99, NULL),
(170, 119, '2014-11-03', '07:10:00', '15:30:00', NULL, '', 99, NULL),
(171, 119, '2014-11-04', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(172, 119, '2014-11-05', '07:00:00', '15:15:00', NULL, '', 99, NULL),
(173, 119, '2014-11-06', '07:05:00', '15:30:00', NULL, '', 99, NULL),
(174, 115, '2014-11-05', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(175, 115, '2014-11-06', '09:30:00', '18:15:00', NULL, '', 99, NULL),
(176, 116, '2014-11-06', '07:30:00', '15:00:00', NULL, '', 99, NULL),
(177, 116, '2014-11-07', '07:30:00', '15:20:00', NULL, '', 99, NULL),
(178, 117, '2014-10-27', '08:00:00', '16:40:00', NULL, '', 99, NULL),
(179, 117, '2014-10-28', '08:00:00', '17:10:00', NULL, '', 99, NULL),
(180, 117, '2014-10-29', '08:00:00', '16:20:00', NULL, '', 99, NULL),
(181, 117, '2014-10-30', '08:00:00', '16:20:00', NULL, '', 99, NULL),
(182, 117, '2014-10-31', '08:00:00', '16:10:00', NULL, '', 99, NULL),
(183, 117, '2014-11-03', '08:00:00', '16:45:00', NULL, '', 99, NULL),
(184, 117, '2014-11-04', '08:00:00', '16:20:00', NULL, '', 99, NULL),
(185, 117, '2014-11-05', '08:00:00', '16:40:00', NULL, '', 99, NULL),
(186, 117, '2014-11-06', '08:00:00', '16:40:00', NULL, '', 99, NULL),
(187, 117, '2014-11-07', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(188, 117, '2014-11-10', '08:00:00', '00:00:00', NULL, '', 99, NULL),
(189, 118, '2014-11-03', '07:41:00', '16:32:00', NULL, '', 99, NULL),
(190, 118, '2014-11-05', '07:42:00', '15:02:00', NULL, '', 99, NULL),
(191, 118, '2014-11-06', '09:02:00', '16:31:00', NULL, '', 99, NULL),
(192, 118, '2014-11-07', '08:11:00', '16:34:00', NULL, '', 99, NULL),
(193, 116, '2014-11-10', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(194, 115, '2014-11-07', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(195, 115, '2014-11-10', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(196, 119, '2014-11-07', '07:10:00', '14:10:00', NULL, '', 99, NULL),
(197, 119, '2014-11-10', '06:40:00', '14:05:00', NULL, '', 99, NULL),
(198, 119, '2014-11-11', '06:10:00', '16:00:00', NULL, '', 99, NULL),
(199, 115, '2014-11-11', '09:30:00', '18:00:00', NULL, '', 99, NULL),
(200, 116, '2014-11-11', '08:00:00', '17:00:00', NULL, '', 99, NULL),
(201, 119, '2014-11-12', '06:10:00', '16:00:00', NULL, '', 99, NULL),
(202, 121, '2014-11-05', '09:00:00', '18:30:00', NULL, '', 99, NULL),
(203, 121, '2014-11-06', '09:00:00', '19:30:00', NULL, '', 99, NULL),
(204, 121, '2014-11-07', '09:45:00', '15:10:00', NULL, '', 99, NULL),
(205, 121, '2014-11-10', '08:30:00', '15:30:00', NULL, '', 99, NULL),
(206, 121, '2014-11-11', '09:15:00', '17:45:00', NULL, '', 99, NULL),
(207, 121, '2014-11-12', '08:00:00', '00:00:00', NULL, '', 99, NULL),
(208, 115, '2014-11-12', '09:30:00', '17:45:00', NULL, '', 99, NULL),
(209, 116, '2014-11-12', '07:45:00', '17:00:00', NULL, '', 99, NULL),
(210, 116, '2014-11-13', '08:00:00', '17:30:00', NULL, '', 99, NULL),
(211, 119, '2014-11-13', '06:10:00', '17:00:00', NULL, '', 99, NULL),
(212, 119, '2014-11-14', '06:10:00', '14:00:00', NULL, '', 99, NULL),
(213, 118, '2014-11-10', '08:01:00', '16:55:00', NULL, '', 99, NULL),
(214, 118, '2014-11-11', '08:19:00', '17:47:00', NULL, '', 99, NULL),
(215, 118, '2014-11-12', '07:54:00', '17:08:00', NULL, '', 99, NULL),
(216, 118, '2014-11-13', '09:04:00', '16:32:00', NULL, '', 99, NULL),
(217, 116, '2014-11-14', '00:00:00', '00:00:00', NULL, '', 88, NULL),
(218, 116, '2014-11-14', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(219, 119, '2014-11-17', '06:10:00', '13:00:00', NULL, '', 99, NULL),
(220, 115, '2014-11-13', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(221, 115, '2014-11-14', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(222, 115, '2014-11-17', '09:30:00', '17:45:00', NULL, '', 99, NULL),
(223, 119, '2014-11-18', '06:10:00', '13:00:00', NULL, '', 99, NULL),
(224, 119, '2014-11-19', '06:10:00', '15:30:00', NULL, '', 99, NULL),
(225, 121, '2014-11-13', '08:00:00', '19:10:00', NULL, '', 99, NULL),
(226, 121, '2014-11-13', '08:30:00', '19:10:00', NULL, '', 99, NULL),
(227, 121, '2014-11-14', '08:00:00', '19:10:00', NULL, '', 99, NULL),
(228, 121, '2014-11-17', '08:30:00', '16:50:00', NULL, '', 99, NULL),
(229, 115, '2014-11-18', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(230, 116, '2014-11-17', '08:00:00', '17:00:00', NULL, '', 99, NULL),
(231, 115, '2014-11-19', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(232, 116, '2014-11-18', '07:50:00', '16:00:00', NULL, '', 99, NULL),
(233, 116, '2014-11-19', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(234, 117, '2014-11-11', '08:00:00', '16:20:00', NULL, '', 99, NULL),
(235, 117, '2014-11-12', '08:00:00', '16:20:00', NULL, '', 99, NULL),
(236, 117, '2014-11-13', '08:00:00', '16:40:00', NULL, '', 99, NULL),
(237, 117, '2014-11-14', '08:00:00', '16:15:00', NULL, '', 99, NULL),
(238, 117, '2014-11-17', '08:00:00', '16:20:00', NULL, '', 99, NULL),
(239, 117, '2014-11-18', '07:10:00', '15:05:00', NULL, '', 99, NULL),
(240, 117, '2014-11-19', '07:20:00', '15:45:00', NULL, '', 99, NULL),
(241, 115, '2014-11-20', '09:30:00', '18:00:00', NULL, '', 99, NULL),
(242, 116, '2014-11-20', '08:15:00', '17:15:00', NULL, '', 99, NULL),
(243, 119, '2014-11-20', '06:20:00', '14:40:00', NULL, '', 99, NULL),
(244, 115, '2014-11-21', '09:30:00', '18:00:00', NULL, '', 99, NULL),
(245, 116, '2014-11-21', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(246, 122, '2014-12-22', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(247, 122, '2014-12-23', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(248, 122, '2014-12-24', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(249, 122, '2014-12-29', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(250, 122, '2014-12-30', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(251, 115, '2014-11-24', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(252, 115, '2014-11-25', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(253, 116, '2014-11-24', '07:50:00', '16:30:00', NULL, '', 99, NULL),
(254, 116, '2014-11-25', '08:00:00', '16:50:00', NULL, '', 99, NULL),
(255, 115, '2014-11-26', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(256, 116, '2014-11-26', '08:05:00', '16:30:00', NULL, '', 99, NULL),
(257, 116, '2014-11-27', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(258, 115, '2014-11-27', '09:30:00', '17:50:00', NULL, '', 99, NULL),
(259, 115, '2014-11-28', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(260, 116, '2014-11-28', '08:00:00', '17:00:00', NULL, '', 99, NULL),
(261, 122, '2014-12-01', '09:29:00', '15:02:00', NULL, '', 99, NULL),
(262, 115, '2014-12-01', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(263, 122, '2014-12-02', '09:29:00', '17:02:00', NULL, '', 99, NULL),
(264, 115, '2014-12-02', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(265, 122, '2014-12-03', '09:00:00', '17:24:00', NULL, '', 99, NULL),
(266, 115, '2014-12-03', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(267, 116, '2014-12-01', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(268, 116, '2014-12-02', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(269, 116, '2014-12-03', '08:00:00', '17:00:00', NULL, '', 99, NULL),
(270, 122, '2014-12-04', '09:00:00', '17:02:00', NULL, '', 99, NULL),
(271, 116, '2014-12-04', '08:00:00', '16:40:00', NULL, '', 99, NULL),
(272, 115, '2014-12-04', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(273, 122, '2014-12-05', '09:00:00', '17:02:00', NULL, '', 99, NULL),
(274, 117, '2014-11-20', '07:05:00', '15:35:00', NULL, '', 99, NULL),
(275, 117, '2014-11-21', '07:05:00', '15:40:00', NULL, '', 99, NULL),
(276, 117, '2014-11-24', '07:00:00', '15:25:00', NULL, '', 99, NULL),
(277, 117, '2014-11-25', '07:00:00', '15:30:00', NULL, '', 99, NULL),
(278, 117, '2014-11-26', '07:00:00', '15:25:00', NULL, '', 99, NULL),
(279, 117, '2014-11-27', '07:00:00', '15:00:00', NULL, '', 99, NULL),
(280, 117, '2014-11-28', '07:20:00', '15:35:00', NULL, '', 99, NULL),
(281, 117, '2014-12-01', '07:00:00', '15:30:00', NULL, '', 99, NULL),
(282, 117, '2014-12-02', '07:00:00', '15:30:00', NULL, '', 99, NULL),
(283, 117, '2014-12-03', '07:15:00', '15:45:00', NULL, '', 99, NULL),
(284, 117, '2014-12-04', '07:15:00', '15:40:00', NULL, '', 99, NULL),
(285, 115, '2014-12-05', '09:45:00', '17:30:00', NULL, '', 99, NULL),
(286, 122, '2014-12-08', '09:29:00', '18:00:00', NULL, '', 99, NULL),
(287, 114, '2014-10-01', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(288, 114, '2014-10-02', '08:30:00', '17:00:00', NULL, '', 99, NULL),
(289, 114, '2014-10-03', '08:00:00', '16:27:00', NULL, 'Feiertag', 99, NULL),
(290, 114, '2014-10-06', '08:00:00', '16:27:00', NULL, '', 99, NULL),
(291, 114, '2014-10-07', '08:00:00', '16:27:00', NULL, '', 99, NULL),
(292, 114, '2014-10-08', '07:40:00', '17:00:00', NULL, '', 99, NULL),
(293, 114, '2014-10-09', '07:30:00', '16:30:00', NULL, '', 99, NULL),
(294, 114, '2014-10-10', '07:20:00', '15:35:00', NULL, '', 99, NULL),
(295, 114, '2014-10-13', '07:30:00', '17:00:00', NULL, '', 99, NULL),
(296, 114, '2014-10-14', '07:10:00', '17:00:00', NULL, '', 99, NULL),
(297, 114, '2014-10-15', '07:15:00', '16:45:00', NULL, '', 99, NULL),
(298, 114, '2014-10-16', '07:10:00', '17:00:00', NULL, '', 99, NULL),
(299, 114, '2014-10-17', '07:15:00', '12:00:00', NULL, '', 99, NULL),
(300, 114, '2014-10-20', '07:15:00', '16:45:00', NULL, '', 99, NULL),
(301, 114, '2014-10-21', '07:15:00', '16:40:00', NULL, '', 99, NULL),
(302, 114, '2014-10-22', '07:15:00', '16:30:00', NULL, '', 99, NULL),
(303, 114, '2014-10-23', '07:00:00', '16:10:00', NULL, '', 99, NULL),
(304, 114, '2014-10-24', '12:00:00', '16:00:00', NULL, '', 99, NULL),
(305, 114, '2014-10-27', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(306, 114, '2014-10-28', '07:20:00', '16:45:00', NULL, '', 99, NULL),
(307, 114, '2014-10-29', '07:15:00', '16:40:00', NULL, '', 99, NULL),
(308, 114, '2014-10-30', '08:00:00', '16:27:00', NULL, '', 99, NULL),
(309, 114, '2014-10-31', '07:30:00', '14:30:00', NULL, '', 99, NULL),
(310, 114, '2014-11-03', '07:30:00', '16:00:00', NULL, '', 99, NULL),
(311, 114, '2014-11-04', '07:15:00', '16:40:00', NULL, '', 99, NULL),
(312, 114, '2014-11-05', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(313, 114, '2014-11-06', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(314, 114, '2014-11-07', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(315, 114, '2014-11-10', '07:10:00', '16:30:00', NULL, '', 99, NULL),
(316, 114, '2014-11-10', '07:15:00', '16:30:00', NULL, '', 99, NULL),
(317, 114, '2014-11-11', '07:15:00', '16:30:00', NULL, '', 99, NULL),
(318, 114, '2014-11-12', '07:05:00', '16:30:00', NULL, '', 99, NULL),
(319, 114, '2014-11-13', '07:10:00', '16:30:00', NULL, '', 99, NULL),
(320, 114, '2014-11-14', '07:10:00', '14:00:00', NULL, '', 99, NULL),
(321, 114, '2014-11-17', '07:10:00', '16:30:00', NULL, '', 99, NULL),
(322, 114, '2014-11-18', '07:30:00', '16:00:00', NULL, '', 99, NULL),
(323, 114, '2014-11-19', '07:00:00', '15:30:00', NULL, '', 99, NULL),
(324, 114, '2014-11-20', '07:00:00', '16:30:00', NULL, '', 99, NULL),
(325, 114, '2014-11-21', '07:00:00', '12:30:00', NULL, '', 99, NULL),
(326, 114, '2014-11-24', '07:15:00', '16:30:00', NULL, '', 99, NULL),
(327, 114, '2014-11-25', '07:00:00', '16:30:00', NULL, '', 99, NULL),
(328, 114, '2014-11-26', '07:00:00', '16:00:00', NULL, '', 99, NULL),
(329, 114, '2014-11-27', '07:15:00', '16:15:00', NULL, '', 99, NULL),
(330, 114, '2014-11-28', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(331, 114, '2014-12-01', '07:15:00', '16:00:00', NULL, '', 99, NULL),
(332, 114, '2014-12-02', '06:35:00', '16:00:00', NULL, '', 99, NULL),
(333, 114, '2014-12-03', '07:10:00', '16:30:00', NULL, '', 99, NULL),
(334, 114, '2014-12-04', '10:05:00', '18:30:00', NULL, '', 99, NULL),
(335, 114, '2014-12-05', '06:00:00', '12:00:00', NULL, '', 99, NULL),
(336, 114, '2014-12-08', '06:30:00', '15:00:00', NULL, '', 99, NULL),
(337, 115, '2014-12-08', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(338, 116, '2014-12-05', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(339, 116, '2014-12-08', '08:05:00', '17:00:00', NULL, '', 99, NULL),
(340, 122, '2014-12-09', '09:09:00', '17:24:00', NULL, '', 99, NULL),
(341, 115, '2014-12-09', '09:30:00', '17:45:00', NULL, '', 99, NULL),
(342, 122, '2014-12-10', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(343, 115, '2014-12-10', '09:30:00', '17:45:00', NULL, '', 99, NULL),
(344, 122, '2014-12-11', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(345, 114, '2014-12-09', '07:00:00', '16:00:00', NULL, '', 99, NULL),
(346, 114, '2014-12-10', '06:00:00', '00:00:00', NULL, '', 99, NULL),
(347, 114, '2014-12-10', '06:00:00', '15:30:00', NULL, '', 99, NULL),
(348, 114, '2014-12-11', '06:00:00', '15:30:00', NULL, '', 99, NULL),
(349, 115, '2014-12-11', '09:30:00', '19:00:00', NULL, '', 99, NULL),
(350, 122, '2014-12-12', '09:13:00', '17:24:00', NULL, '', 99, NULL),
(351, 114, '2014-12-12', '09:00:00', '15:00:00', NULL, '', 99, NULL),
(352, 115, '2014-12-12', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(353, 115, '2014-12-15', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(354, 115, '2014-12-16', '09:30:00', '14:00:00', NULL, '', 99, NULL),
(355, 114, '2014-12-15', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(356, 114, '2014-12-16', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(357, 114, '2014-12-17', '06:00:00', '15:30:00', NULL, '', 99, NULL),
(358, 115, '2014-12-17', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(359, 114, '2014-12-18', '06:00:00', '15:30:00', NULL, '', 99, NULL),
(360, 114, '2014-12-19', '06:00:00', '12:00:00', NULL, '', 99, NULL),
(361, 115, '2014-12-18', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(362, 115, '2014-12-19', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(363, 116, '2014-12-09', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(364, 116, '2014-12-10', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(365, 116, '2014-12-11', '07:50:00', '16:30:00', NULL, '', 99, NULL),
(366, 116, '2014-12-12', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(367, 116, '2014-12-15', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(368, 116, '2014-12-16', '07:50:00', '16:00:00', NULL, '', 99, NULL),
(369, 116, '2014-12-17', '07:50:00', '17:00:00', NULL, '', 99, NULL),
(370, 116, '2014-12-18', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(371, 116, '2014-12-19', '07:30:00', '16:50:00', NULL, '', 99, NULL),
(372, 116, '2014-12-22', '07:50:00', '16:00:00', NULL, '', 99, NULL),
(373, 116, '2014-12-22', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(374, 116, '2014-12-23', '08:00:00', '17:00:00', NULL, '', 99, NULL),
(375, 114, '2014-12-22', '07:00:00', '16:30:00', NULL, '', 99, NULL),
(376, 114, '2014-12-23', '06:00:00', '15:30:00', NULL, '', 99, NULL),
(377, 114, '2014-12-29', '06:30:00', '00:00:00', NULL, '', 99, NULL),
(378, 114, '2014-12-29', '06:30:00', '15:30:00', NULL, '', 99, NULL),
(379, 114, '2014-12-30', '07:00:00', '15:30:00', NULL, '', 99, NULL),
(380, 122, '2015-01-01', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(381, 122, '2015-01-02', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(382, 122, '2015-01-05', '09:00:00', '17:02:00', NULL, '', 99, NULL),
(383, 115, '2015-01-01', '09:30:00', '17:30:00', NULL, 'Feiertag', 88, NULL),
(384, 115, '2015-01-02', '09:30:00', '17:30:00', NULL, '', 2, NULL),
(385, 115, '2015-01-05', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(386, 122, '2015-01-06', '09:00:00', '17:24:00', NULL, '', 99, NULL),
(387, 115, '2015-01-06', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(388, 122, '2015-01-07', '09:00:00', '17:15:00', NULL, '', 99, NULL),
(389, 122, '2015-01-03', '00:00:00', '00:00:00', NULL, '', 88, NULL),
(390, 115, '2015-01-07', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(391, 122, '2015-01-08', '09:29:00', '17:24:00', NULL, '', 99, NULL),
(392, 122, '2015-01-09', '09:13:00', '16:00:00', NULL, '', 99, NULL),
(393, 122, '2015-01-12', '09:00:00', '16:00:00', NULL, '', 99, NULL),
(394, 115, '2015-01-12', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(395, 122, '2015-01-13', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(396, 122, '2015-01-14', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(397, 122, '2015-01-15', '09:29:00', '18:00:00', NULL, '', 99, NULL),
(398, 122, '2015-01-16', '09:00:00', '17:15:00', NULL, '', 99, NULL),
(399, 122, '2015-01-19', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(400, 122, '2015-01-20', '09:29:00', '17:15:00', NULL, '', 99, NULL),
(401, 115, '2015-01-08', '09:30:00', '18:00:00', NULL, '', 99, NULL),
(402, 115, '2015-01-09', '09:30:00', '17:50:00', NULL, '', 99, NULL),
(403, 115, '2015-01-13', '09:30:00', '17:50:00', NULL, '', 99, NULL),
(404, 115, '2015-01-14', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(405, 115, '2015-01-15', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(406, 115, '2015-01-16', '09:30:00', '17:30:00', NULL, '', 2, NULL),
(407, 115, '2015-01-19', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(408, 115, '2015-01-20', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(409, 115, '2015-01-21', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(410, 122, '2015-01-21', '09:30:00', '16:45:00', NULL, 'Veranstaltung', 99, NULL),
(411, 122, '2015-01-22', '08:30:00', '18:00:00', NULL, '', 99, NULL),
(412, 115, '2015-01-22', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(413, 122, '2015-01-23', '09:00:00', '17:15:00', NULL, '', 99, NULL),
(414, 122, '2015-01-26', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(415, 115, '2015-01-23', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(416, 115, '2015-01-26', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(417, 122, '2015-01-27', '09:29:00', '17:24:00', NULL, '', 99, NULL),
(418, 118, '2015-01-01', '00:00:00', '00:00:00', NULL, '', 1, NULL),
(419, 118, '2015-01-02', '00:00:00', '00:00:00', NULL, '', 1, NULL),
(420, 118, '2015-01-05', '08:02:00', '16:26:00', NULL, '', 99, NULL),
(421, 118, '2015-01-06', '08:07:00', '17:07:00', NULL, '', 99, NULL),
(422, 118, '2015-01-07', '07:06:00', '16:07:00', NULL, '', 99, NULL),
(423, 118, '2015-01-08', '07:03:00', '16:18:00', NULL, '', 99, NULL),
(424, 118, '2015-01-09', '07:13:00', '15:24:00', NULL, '', 99, NULL),
(425, 118, '2015-01-12', '07:04:00', '15:54:00', NULL, '', 99, NULL),
(426, 118, '2015-01-13', '07:03:00', '15:40:00', NULL, '', 99, NULL),
(427, 118, '2015-01-14', '07:57:00', '17:04:00', NULL, '', 99, NULL),
(428, 118, '2015-01-15', '07:15:00', '16:33:00', NULL, '', 99, NULL),
(429, 118, '2015-01-16', '08:14:00', '15:19:00', NULL, '', 99, NULL),
(430, 118, '2015-01-19', '07:58:00', '15:28:00', NULL, '', 99, NULL),
(431, 118, '2015-01-20', '07:18:00', '16:38:00', NULL, '', 99, NULL),
(432, 118, '2015-01-21', '07:31:00', '17:01:00', NULL, '', 99, NULL),
(433, 118, '2015-01-22', '08:39:00', '16:26:00', NULL, '', 99, NULL),
(434, 118, '2015-01-23', '08:21:00', '15:16:00', NULL, '', 99, NULL),
(435, 118, '2015-01-26', '08:05:00', '15:33:00', NULL, '', 99, NULL),
(436, 115, '2015-01-27', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(437, 122, '2015-01-28', '08:49:00', '18:00:00', NULL, '', 99, NULL),
(438, 115, '2015-01-28', '09:30:00', '18:00:00', NULL, '', 99, NULL),
(439, 122, '2015-01-29', '09:00:00', '14:30:00', NULL, 'Veranstaltung', 99, NULL),
(440, 115, '2015-01-29', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(441, 122, '2015-01-30', '09:00:00', '15:02:00', NULL, '', 99, NULL),
(442, 122, '2015-02-02', '09:00:00', '12:30:00', NULL, '', 99, NULL),
(443, 115, '2015-02-02', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(444, 115, '2015-02-03', '09:30:00', '18:00:00', NULL, '', 99, NULL),
(445, 115, '2015-02-04', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(446, 116, '2015-01-01', '00:00:00', '00:00:00', NULL, '', 88, NULL),
(447, 114, '2015-02-02', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(448, 114, '2015-01-02', '00:00:00', '00:00:00', NULL, '', 1, NULL),
(449, 115, '2015-02-05', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(450, 115, '2015-02-06', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(451, 116, '2015-02-06', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(452, 116, '2015-02-05', '07:50:00', '15:30:00', NULL, '', 99, NULL),
(453, 116, '2015-02-04', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(454, 116, '2015-02-03', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(455, 116, '2015-02-02', '07:30:00', '16:30:00', NULL, '', 99, NULL),
(456, 116, '2015-01-02', '00:00:00', '00:00:00', NULL, '', 1, NULL),
(457, 116, '2015-01-05', '07:50:00', '16:30:00', NULL, '', 99, NULL),
(458, 116, '2015-01-06', '07:30:00', '15:30:00', NULL, '', 99, NULL),
(459, 116, '2015-01-07', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(460, 116, '2015-01-08', '07:50:00', '16:30:00', NULL, '', 99, NULL),
(461, 116, '2015-01-09', '07:30:00', '16:00:00', NULL, '', 99, NULL),
(462, 116, '2015-01-12', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(463, 116, '2015-01-13', '07:50:00', '16:30:00', NULL, '', 99, NULL),
(464, 116, '2015-01-14', '07:50:00', '16:00:00', NULL, '', 99, NULL),
(465, 116, '2015-01-15', '08:15:00', '16:30:00', NULL, '', 99, NULL),
(466, 116, '2015-01-16', '07:30:00', '17:00:00', NULL, '', 99, NULL),
(467, 116, '2015-01-19', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(468, 116, '2015-01-20', '08:05:00', '16:50:00', NULL, '', 99, NULL),
(469, 116, '2015-01-21', '08:05:00', '16:30:00', NULL, '', 99, NULL),
(470, 116, '2015-01-22', '07:50:00', '17:00:00', NULL, '', 99, NULL),
(471, 116, '2015-01-23', '07:30:00', '15:30:00', NULL, '', 99, NULL),
(472, 116, '2015-01-26', '00:00:00', '00:00:00', NULL, '', 1, NULL),
(473, 116, '2015-01-27', '07:30:00', '16:50:00', NULL, '', 99, NULL),
(474, 116, '2015-01-28', '07:30:00', '16:30:00', NULL, '', 99, NULL),
(475, 116, '2015-01-29', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(476, 116, '2015-01-30', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(477, 114, '2015-01-05', '06:00:00', '15:30:00', NULL, '', 99, NULL),
(478, 114, '2015-01-06', '06:00:00', '14:30:00', NULL, '', 99, NULL),
(479, 114, '2015-01-07', '06:00:00', '16:00:00', NULL, '', 99, NULL),
(480, 114, '2015-01-08', '06:00:00', '15:30:00', NULL, '', 99, NULL),
(481, 114, '2015-01-09', '06:00:00', '12:00:00', NULL, '', 99, NULL),
(482, 114, '2015-01-12', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(483, 114, '2015-01-13', '06:00:00', '00:00:00', NULL, '', 99, NULL),
(484, 114, '2015-01-13', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(485, 114, '2015-01-14', '06:00:00', '14:30:00', NULL, '', 99, NULL),
(486, 114, '2015-01-15', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(487, 114, '2015-01-16', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(488, 114, '2015-01-19', '06:00:00', '14:30:00', NULL, '', 99, NULL),
(489, 114, '2015-01-20', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(490, 114, '2015-01-21', '06:00:00', '15:30:00', NULL, '', 99, NULL),
(491, 114, '2015-01-22', '06:00:00', '15:30:00', NULL, '', 99, NULL),
(492, 114, '2015-01-23', '06:00:00', '16:00:00', NULL, '', 99, NULL),
(493, 114, '2015-01-26', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(494, 114, '2015-01-27', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(495, 114, '2015-01-28', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(496, 114, '2015-01-29', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(497, 114, '2015-01-30', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(498, 114, '2015-02-03', '06:00:00', '14:30:00', NULL, '', 99, NULL),
(499, 114, '2015-02-04', '06:00:00', '15:30:00', NULL, '', 99, NULL),
(500, 114, '2015-02-04', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(501, 114, '2015-02-05', '06:00:00', '16:00:00', NULL, '', 99, NULL),
(502, 114, '2015-02-06', '06:00:00', '12:00:00', NULL, '', 99, NULL),
(503, 114, '2015-02-09', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(504, 114, '2015-02-10', '06:00:00', '16:00:00', NULL, '', 99, NULL),
(505, 114, '2015-02-11', '06:00:00', '15:30:00', NULL, '', 99, NULL),
(506, 114, '2015-02-12', '06:00:00', '16:00:00', NULL, '', 99, NULL),
(507, 114, '2015-02-13', '06:00:00', '16:00:00', NULL, '', 99, NULL),
(508, 114, '2015-02-16', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(509, 114, '2015-02-17', '06:00:00', '14:30:00', NULL, '', 99, NULL),
(510, 114, '2015-02-18', '06:00:00', '14:30:00', NULL, '', 99, NULL),
(511, 114, '2015-02-19', '06:00:00', '15:30:00', NULL, '', 99, NULL),
(512, 114, '2015-02-20', '06:00:00', '12:00:00', NULL, '', 99, NULL),
(513, 115, '2015-02-09', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(514, 116, '2015-02-09', '08:05:00', '16:30:00', NULL, '', 99, NULL),
(515, 115, '2015-02-10', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(516, 115, '2015-02-12', '09:30:00', '17:30:00', NULL, '', 2, NULL),
(517, 115, '2015-02-13', '09:30:00', '17:30:00', NULL, '', 2, NULL),
(518, 115, '2015-02-16', '09:30:00', '17:30:00', NULL, '', 2, NULL),
(519, 115, '2015-02-17', '09:30:00', '17:30:00', NULL, '', 2, NULL),
(520, 115, '2015-02-11', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(521, 116, '2015-02-10', '07:00:00', '22:00:00', NULL, '', 99, NULL),
(522, 116, '2015-02-11', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(523, 116, '2015-02-12', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(524, 116, '2015-02-13', '08:00:00', '17:00:00', NULL, '', 99, NULL),
(525, 122, '2015-02-03', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(526, 122, '2015-02-04', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(527, 122, '2015-02-05', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(528, 122, '2015-02-06', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(529, 122, '2015-02-09', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(530, 122, '2015-02-10', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(531, 122, '2015-02-11', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(532, 122, '2015-02-12', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(533, 122, '2015-02-13', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(534, 122, '2015-02-16', '09:30:00', '18:00:00', NULL, '', 99, NULL),
(535, 122, '2015-02-17', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(536, 116, '2015-02-16', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(537, 116, '2015-02-17', '07:50:00', '16:00:00', NULL, '', 99, NULL),
(538, 116, '2015-02-18', '07:30:00', '16:00:00', NULL, '', 99, NULL),
(539, 122, '2015-02-18', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(540, 122, '2015-02-19', '09:00:00', '18:00:00', NULL, '', 88, NULL),
(541, 115, '2015-02-18', '09:30:00', '17:30:00', NULL, 'Fortbildung', 99, NULL),
(542, 115, '2015-02-19', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(543, 122, '2015-02-20', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(544, 116, '2015-02-19', '07:50:00', '16:00:00', NULL, '', 99, NULL),
(545, 116, '2015-02-20', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(546, 116, '2015-02-23', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(547, 122, '2015-02-23', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(548, 115, '2015-02-23', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(549, 123, '2015-01-01', '00:00:00', '00:00:00', NULL, 'Neujahr', 1, NULL),
(550, 123, '2015-01-02', '00:00:00', '00:00:00', NULL, '', 1, NULL),
(551, 123, '2015-01-04', '00:00:00', '00:00:00', NULL, '', 88, NULL),
(552, 123, '2015-01-05', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(553, 123, '2015-01-06', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(554, 123, '2015-01-07', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(555, 123, '2015-01-08', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(556, 123, '2015-01-09', '06:00:00', '14:00:00', NULL, '', 99, NULL),
(557, 123, '2015-01-11', '06:00:00', '15:00:00', NULL, '', 88, NULL),
(558, 123, '2015-01-12', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(559, 123, '2015-01-13', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(560, 123, '2015-01-14', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(561, 123, '2015-01-15', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(562, 123, '2015-01-16', '06:00:00', '14:00:00', NULL, '', 99, NULL),
(563, 123, '2015-01-18', '06:00:00', '15:00:00', NULL, '', 88, NULL),
(564, 123, '2015-01-19', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(565, 123, '2015-01-20', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(566, 123, '2015-01-21', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(567, 123, '2015-01-22', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(568, 123, '2015-01-23', '06:00:00', '14:00:00', NULL, '', 99, NULL),
(569, 123, '2015-01-25', '06:00:00', '15:00:00', NULL, '', 88, NULL),
(570, 123, '2015-01-26', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(571, 123, '2015-01-27', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(572, 123, '2015-01-28', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(573, 123, '2015-01-29', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(574, 123, '2015-01-30', '06:00:00', '14:00:00', NULL, '', 99, NULL),
(575, 123, '2015-02-02', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(576, 123, '2015-02-03', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(577, 123, '2015-02-04', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(578, 123, '2015-02-05', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(579, 123, '2015-02-06', '06:00:00', '14:00:00', NULL, '', 99, NULL),
(580, 123, '2015-02-09', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(581, 123, '2015-02-10', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(582, 123, '2015-02-11', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(583, 123, '2015-02-12', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(584, 123, '2015-02-13', '06:00:00', '14:00:00', NULL, '', 99, NULL),
(585, 123, '2015-02-16', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(586, 123, '2015-02-17', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(587, 123, '2015-02-18', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(588, 123, '2015-02-19', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(589, 123, '2015-02-20', '06:00:00', '14:00:00', NULL, '', 99, NULL),
(590, 123, '2015-02-23', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(591, 117, '2015-01-02', '07:00:00', '15:20:00', NULL, '', 99, NULL),
(592, 117, '2015-01-05', '07:05:00', '15:40:00', NULL, '', 99, NULL),
(593, 117, '2015-01-06', '07:15:00', '15:35:00', NULL, '', 99, NULL),
(594, 117, '2015-01-07', '07:00:00', '15:30:00', NULL, '', 99, NULL),
(595, 117, '2015-01-08', '07:00:00', '15:30:00', NULL, '', 99, NULL),
(596, 117, '2015-01-09', '07:00:00', '15:30:00', NULL, '', 99, NULL),
(597, 117, '2015-01-12', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(598, 117, '2015-01-13', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(599, 117, '2015-01-14', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(600, 117, '2015-01-15', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(601, 117, '2015-01-16', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(602, 117, '2015-01-19', '07:00:00', '15:30:00', NULL, '', 99, NULL),
(603, 117, '2015-01-20', '07:05:00', '15:25:00', NULL, '', 99, NULL),
(604, 117, '2015-01-21', '07:05:00', '15:25:00', NULL, '', 99, NULL),
(605, 117, '2015-01-22', '07:05:00', '15:30:00', NULL, '', 99, NULL),
(606, 117, '2015-01-23', '07:20:00', '15:30:00', NULL, '', 99, NULL),
(607, 117, '2015-01-26', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(608, 117, '2015-01-27', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(609, 122, '2015-02-24', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(610, 117, '2015-01-28', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(611, 117, '2015-01-29', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(612, 117, '2015-01-30', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(613, 117, '2015-02-02', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(614, 117, '2015-02-03', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(615, 117, '2015-02-04', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(616, 117, '2015-02-05', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(617, 117, '2015-02-06', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(618, 117, '2015-02-09', '07:15:00', '15:45:00', NULL, '', 99, NULL),
(619, 117, '2015-02-10', '07:15:00', '15:40:00', NULL, '', 99, NULL),
(620, 117, '2015-02-11', '06:15:00', '14:35:00', NULL, '', 99, NULL),
(621, 117, '2015-02-12', '07:15:00', '15:40:00', NULL, '', 99, NULL),
(622, 117, '2015-02-13', '07:15:00', '15:40:00', NULL, '', 99, NULL),
(623, 117, '2015-02-16', '07:15:00', '15:40:00', NULL, '', 99, NULL),
(624, 117, '2015-02-17', '07:15:00', '15:40:00', NULL, '', 99, NULL),
(625, 117, '2015-02-18', '07:15:00', '14:45:00', NULL, '', 99, NULL),
(626, 117, '2015-02-19', '07:00:00', '15:40:00', NULL, '', 99, NULL),
(627, 117, '2015-02-20', '07:15:00', '15:40:00', NULL, '', 99, NULL),
(628, 117, '2015-02-23', '07:15:00', '15:45:00', NULL, '', 99, NULL),
(629, 115, '2015-02-24', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(630, 122, '2015-02-25', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(631, 115, '2015-02-25', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(632, 116, '2015-02-24', '07:50:00', '16:00:00', NULL, '', 99, NULL),
(633, 116, '2015-02-25', '07:50:00', '17:30:00', NULL, '', 99, NULL),
(634, 116, '2015-02-26', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(635, 116, '2015-02-27', '07:50:00', '16:30:00', NULL, '', 99, NULL),
(636, 122, '2015-02-26', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(637, 115, '2015-02-26', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(638, 115, '2015-02-20', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(639, 122, '2015-02-27', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(640, 115, '2015-02-27', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(641, 123, '2015-02-24', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(642, 123, '2015-02-25', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(643, 123, '2015-02-26', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(644, 123, '2015-02-27', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(645, 122, '2015-03-02', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(646, 115, '2015-03-02', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(647, 116, '2015-03-02', '08:00:00', '17:00:00', NULL, '', 99, NULL),
(648, 116, '2015-03-03', '07:50:00', '16:30:00', NULL, '', 99, NULL),
(649, 116, '2015-03-04', '08:00:00', '16:50:00', NULL, '', 99, NULL),
(650, 116, '2015-03-05', '07:30:00', '16:50:00', NULL, '', 99, NULL),
(651, 116, '2015-03-06', '07:50:00', '16:00:00', NULL, '', 99, NULL),
(652, 123, '2015-03-02', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(653, 122, '2015-03-03', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(654, 115, '2015-03-03', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(655, 121, '2015-03-02', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(656, 121, '2015-01-01', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(657, 121, '2015-01-02', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(658, 121, '2015-01-05', '09:00:00', '15:00:00', NULL, '', 99, NULL),
(659, 121, '2015-01-06', '08:00:00', '14:55:00', NULL, '', 99, NULL),
(660, 121, '2015-01-07', '08:00:00', '17:00:00', NULL, 'Homeoffice', 99, NULL),
(661, 123, '2015-03-03', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(662, 122, '2015-03-04', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(663, 115, '2015-03-04', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(664, 116, '2015-03-09', '08:00:00', '17:00:00', NULL, '', 99, NULL),
(665, 116, '2015-03-10', '08:00:00', '15:30:00', NULL, '', 99, NULL),
(666, 116, '2015-03-11', '08:00:00', '17:00:00', NULL, '', 99, NULL),
(667, 116, '2015-03-12', '08:00:00', '15:30:00', NULL, '', 99, NULL),
(668, 116, '2015-03-13', '07:30:00', '17:30:00', NULL, '', 99, NULL),
(669, 116, '2015-03-16', '07:30:00', '16:00:00', NULL, '', 99, NULL),
(670, 116, '2015-03-17', '08:00:00', '15:30:00', NULL, '', 99, NULL),
(671, 116, '2015-03-18', '07:30:00', '17:00:00', NULL, '', 99, NULL),
(672, 116, '2015-03-19', '07:30:00', '16:30:00', NULL, '', 99, NULL),
(673, 116, '2015-03-20', '07:30:00', '17:00:00', NULL, '', 99, NULL),
(674, 116, '2015-03-23', '07:50:00', '16:00:00', NULL, '', 99, NULL),
(675, 116, '2015-03-24', '07:50:00', '16:30:00', NULL, '', 99, NULL),
(676, 116, '2015-03-25', '07:50:00', '16:30:00', NULL, '', 99, NULL),
(677, 116, '2015-03-26', '07:50:00', '17:00:00', NULL, '', 99, NULL),
(678, 116, '2015-03-27', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(679, 116, '2015-03-30', '07:50:00', '17:00:00', NULL, '', 99, NULL),
(680, 116, '2015-03-31', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(681, 123, '2015-03-04', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(682, 122, '2015-03-05', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(683, 115, '2015-03-05', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(684, 114, '2015-02-23', '06:00:00', '14:30:00', NULL, '', 99, NULL),
(685, 114, '2015-02-24', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(686, 114, '2015-02-25', '06:00:00', '14:30:00', NULL, '', 99, NULL),
(687, 114, '2015-02-26', '06:00:00', '16:00:00', NULL, '', 99, NULL),
(688, 114, '2015-02-27', '06:00:00', '12:00:00', NULL, '', 99, NULL),
(689, 114, '2015-03-02', '06:00:00', '15:30:00', NULL, '', 99, NULL),
(690, 114, '2015-03-03', '06:00:00', '14:30:00', NULL, '', 99, NULL),
(691, 114, '2015-03-04', '06:00:00', '15:30:00', NULL, '', 99, NULL),
(692, 114, '2015-03-05', '08:45:00', '18:15:00', NULL, '', 99, NULL),
(693, 114, '2015-03-06', '06:00:00', '12:00:00', NULL, '', 99, NULL),
(694, 122, '2015-03-06', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(695, 115, '2015-03-06', '13:00:00', '18:00:00', NULL, '', 99, NULL),
(696, 122, '2015-03-09', '09:00:00', '17:15:00', NULL, '', 99, NULL),
(697, 123, '2015-03-05', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(698, 123, '2015-03-06', '06:00:00', '14:00:00', NULL, '', 99, NULL),
(699, 115, '2015-03-09', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(700, 122, '2015-03-10', '09:00:00', '17:15:00', NULL, '', 99, NULL),
(701, 115, '2015-03-10', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(702, 122, '2015-03-11', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(703, 115, '2015-03-11', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(704, 122, '2015-03-12', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(705, 115, '2015-03-12', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(706, 122, '2015-03-13', '09:00:00', '16:45:00', NULL, '', 99, NULL),
(707, 123, '2015-03-09', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(708, 123, '2015-03-10', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(709, 123, '2015-03-11', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(710, 123, '2015-03-12', '06:00:00', '15:00:00', NULL, '', 99, NULL),
(711, 123, '2015-03-13', '06:00:00', '14:00:00', NULL, '', 99, NULL),
(712, 122, '2015-03-16', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(713, 115, '2015-03-16', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(714, 115, '2015-03-13', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(715, 122, '2015-03-17', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(716, 115, '2015-03-17', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(717, 122, '2015-03-18', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(718, 115, '2015-03-18', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(719, 122, '2015-03-19', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(720, 115, '2015-03-19', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(721, 115, '2015-03-20', '09:30:00', '17:30:00', NULL, '', 2, NULL),
(722, 122, '2015-03-20', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(723, 122, '2015-03-23', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(724, 122, '2015-03-24', '09:00:00', '18:00:00', NULL, '', 99, NULL),
(725, 115, '2015-03-23', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(726, 115, '2015-03-24', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(727, 115, '2015-03-25', '09:30:00', '14:00:00', NULL, '', 99, NULL),
(728, 115, '2015-03-26', '09:30:00', '17:30:00', NULL, '', 2, NULL),
(729, 115, '2015-03-27', '09:30:00', '17:30:00', NULL, '', 2, NULL),
(730, 121, '2015-01-08', '08:00:00', '17:00:00', NULL, '', 99, NULL),
(731, 121, '2015-01-09', '07:00:00', '14:30:00', NULL, '', 99, NULL),
(732, 121, '2015-01-12', '09:00:00', '17:30:00', NULL, '', 99, NULL),
(733, 121, '2015-01-13', '08:00:00', '15:30:00', NULL, '', 99, NULL),
(734, 121, '2015-01-14', '08:30:00', '18:30:00', NULL, '', 99, NULL),
(735, 121, '2015-01-15', '08:00:00', '16:20:00', NULL, '', 99, NULL),
(736, 121, '2015-01-16', '07:00:00', '14:02:00', NULL, '', 99, NULL),
(737, 121, '2015-01-19', '08:30:00', '16:20:00', NULL, '', 99, NULL),
(738, 121, '2015-01-20', '09:20:00', '15:00:00', NULL, '', 99, NULL),
(739, 121, '2015-01-21', '07:00:00', '15:42:00', NULL, '', 99, NULL),
(740, 121, '2015-01-22', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(741, 121, '2015-01-23', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(742, 121, '2015-01-26', '07:30:00', '17:30:00', NULL, '', 99, NULL),
(743, 121, '2015-01-26', '08:00:00', '15:30:00', NULL, '', 99, NULL),
(744, 121, '2015-01-27', '08:00:00', '14:02:00', NULL, '', 99, NULL),
(745, 121, '2015-01-28', '07:32:00', '19:00:00', NULL, '', 99, NULL),
(746, 121, '2015-01-29', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(747, 121, '2015-01-30', '08:00:00', '14:30:00', NULL, '', 99, NULL),
(748, 121, '2015-02-02', '08:00:00', '16:20:00', NULL, '', 99, NULL),
(749, 121, '2015-02-03', '09:20:00', '17:30:00', NULL, '', 99, NULL),
(750, 121, '2015-02-04', '08:30:00', '19:00:00', NULL, '', 99, NULL),
(751, 121, '2015-02-05', '07:32:00', '15:30:00', NULL, '', 99, NULL),
(752, 121, '2015-02-06', '07:00:00', '14:30:00', NULL, '', 99, NULL),
(753, 121, '2015-02-09', '08:00:00', '16:20:00', NULL, '', 99, NULL),
(754, 121, '2015-02-10', '00:00:00', '00:00:00', NULL, '', 1, NULL),
(755, 121, '2015-02-11', '08:30:00', '16:54:00', NULL, '', 99, NULL),
(756, 121, '2015-02-12', '07:30:00', '16:20:00', NULL, '', 99, NULL);
INSERT INTO `erfassung` (`eid`, `maid`, `datum`, `beginn`, `ende`, `maneintrag`, `bemerkung`, `aid`, `pause`) VALUES
(757, 121, '2015-02-13', '07:32:00', '15:42:00', NULL, '', 99, NULL),
(758, 121, '2015-02-16', '09:20:00', '18:00:00', NULL, 'Worhshop', 99, NULL),
(759, 121, '2015-02-17', '09:20:00', '17:30:00', NULL, 'Workshop', 99, NULL),
(760, 121, '2015-02-18', '08:30:00', '14:30:00', NULL, '', 99, NULL),
(761, 121, '2015-02-19', '08:30:00', '17:00:00', NULL, '', 99, NULL),
(762, 121, '2015-02-20', '08:30:00', '15:57:00', NULL, '', 99, NULL),
(763, 121, '2015-02-23', '07:30:00', '15:42:00', NULL, 'Dienstreise', 99, NULL),
(764, 121, '2015-02-24', '07:30:00', '15:30:00', NULL, 'Dienstreise', 99, NULL),
(765, 121, '2015-02-24', '07:30:00', '15:42:00', NULL, 'Dienstreise', 99, NULL),
(766, 121, '2015-02-25', '07:30:00', '15:42:00', NULL, 'Dienstreise', 99, NULL),
(767, 121, '2015-02-26', '08:00:00', '16:12:00', NULL, '', 99, NULL),
(768, 121, '2015-02-27', '08:00:00', '14:20:00', NULL, '', 99, NULL),
(769, 121, '2015-03-03', '08:30:00', '16:20:00', NULL, '', 99, NULL),
(770, 121, '2015-03-04', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(771, 121, '2015-03-05', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(772, 121, '2015-03-06', '08:20:00', '12:00:00', NULL, '', 99, NULL),
(773, 121, '2015-03-09', '08:00:00', '15:30:00', NULL, '', 99, NULL),
(774, 121, '2015-03-10', '07:55:00', '17:04:00', NULL, '', 99, NULL),
(775, 121, '2015-03-11', '09:02:00', '17:04:00', NULL, '', 99, NULL),
(776, 121, '2015-03-12', '07:55:00', '15:44:00', NULL, '', 99, NULL),
(777, 121, '2015-03-13', '09:00:00', '14:45:00', NULL, '', 99, NULL),
(778, 121, '2015-03-16', '09:20:00', '17:30:00', NULL, '', 99, NULL),
(779, 121, '2015-03-17', '08:30:00', '15:00:00', NULL, '', 99, NULL),
(780, 121, '2015-03-18', '07:50:00', '16:30:00', NULL, '', 99, NULL),
(781, 121, '2015-03-19', '00:00:00', '00:00:00', NULL, '', 1, NULL),
(782, 121, '2015-03-20', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(783, 121, '2015-03-23', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(784, 121, '2015-03-24', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(785, 121, '2015-03-25', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(786, 121, '2015-03-26', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(787, 121, '2015-03-27', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(788, 115, '2015-03-30', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(789, 115, '2015-03-31', '09:30:00', '17:30:00', NULL, '', 99, NULL),
(790, 119, '2015-01-01', '00:00:00', '00:00:00', NULL, '', 88, NULL),
(791, 119, '2015-01-02', '00:00:00', '00:00:00', NULL, '', 1, NULL),
(792, 119, '2015-01-05', '06:20:00', '15:30:00', NULL, '', 99, NULL),
(793, 119, '2015-01-06', '07:30:00', '17:25:00', NULL, '', 99, NULL),
(794, 119, '2015-01-07', '06:00:00', '15:15:00', NULL, '', 99, NULL),
(795, 119, '2015-01-08', '06:20:00', '15:00:00', NULL, '', 99, NULL),
(796, 119, '2015-01-09', '06:20:00', '15:00:00', NULL, '', 99, NULL),
(797, 119, '2015-01-12', '06:25:00', '15:35:00', NULL, '', 99, NULL),
(798, 119, '2015-01-13', '06:20:00', '14:30:00', NULL, '', 99, NULL),
(799, 119, '2015-01-14', '06:20:00', '14:25:00', NULL, '', 99, NULL),
(800, 119, '2015-01-15', '06:30:00', '15:15:00', NULL, '', 99, NULL),
(801, 119, '2015-01-16', '06:20:00', '13:15:00', NULL, '', 99, NULL),
(802, 119, '2015-01-19', '07:00:00', '16:50:00', NULL, '', 99, NULL),
(803, 119, '2015-01-20', '06:55:00', '12:05:00', NULL, '', 99, NULL),
(804, 119, '2015-01-21', '07:05:00', '16:20:00', NULL, '', 99, NULL),
(805, 119, '2015-01-22', '07:00:00', '14:00:00', NULL, '', 99, NULL),
(806, 119, '2015-01-23', '06:30:00', '12:30:00', NULL, '', 99, NULL),
(807, 119, '2015-01-26', '06:20:00', '16:30:00', NULL, '', 99, NULL),
(808, 119, '2015-01-27', '06:00:00', '13:10:00', NULL, '', 99, NULL),
(809, 119, '2015-01-28', '06:20:00', '15:45:00', NULL, '', 99, NULL),
(810, 119, '2015-01-29', '06:00:00', '16:30:00', NULL, '', 99, NULL),
(811, 119, '2015-01-30', '06:30:00', '15:30:00', NULL, '', 99, NULL),
(812, 119, '2015-02-02', '07:00:00', '16:20:00', NULL, '', 99, NULL),
(813, 119, '2015-02-03', '06:25:00', '13:00:00', NULL, '', 99, NULL),
(814, 119, '2015-02-04', '07:00:00', '15:00:00', NULL, '', 99, NULL),
(815, 119, '2015-02-05', '07:00:00', '15:00:00', NULL, '', 99, NULL),
(816, 119, '2015-02-06', '07:05:00', '14:20:00', NULL, '', 99, NULL),
(817, 119, '2015-02-09', '06:20:00', '14:35:00', NULL, '', 99, NULL),
(818, 119, '2015-02-10', '06:00:00', '14:00:00', NULL, '', 99, NULL),
(819, 119, '2015-02-11', '06:00:00', '14:20:00', NULL, '', 99, NULL),
(820, 119, '2015-02-12', '06:30:00', '16:45:00', NULL, '', 99, NULL),
(821, 119, '2015-02-13', '06:15:00', '14:50:00', NULL, '', 99, NULL),
(822, 119, '2015-02-16', '06:50:00', '16:40:00', NULL, '', 99, NULL),
(823, 119, '2015-02-17', '06:30:00', '16:00:00', NULL, '', 99, NULL),
(824, 119, '2015-02-18', '06:30:00', '15:20:00', NULL, '', 99, NULL),
(825, 119, '2015-02-19', '06:10:00', '14:30:00', NULL, '', 99, NULL),
(826, 119, '2015-02-20', '06:30:00', '12:30:00', NULL, '', 99, NULL),
(827, 119, '2015-02-23', '06:00:00', '17:20:00', NULL, '', 99, NULL),
(828, 119, '2015-02-24', '05:50:00', '13:00:00', NULL, '', 99, NULL),
(829, 119, '2015-02-25', '06:00:00', '16:00:00', NULL, '', 99, NULL),
(830, 119, '2015-02-26', '06:00:00', '16:30:00', NULL, '', 99, NULL),
(831, 119, '2015-02-27', '09:00:00', '15:00:00', NULL, '', 99, NULL),
(832, 119, '2015-03-02', '06:00:00', '16:15:00', NULL, '', 99, NULL),
(833, 119, '2015-03-03', '05:50:00', '12:45:00', NULL, '', 99, NULL),
(834, 119, '2015-03-04', '06:15:00', '16:15:00', NULL, '', 99, NULL),
(835, 119, '2015-03-05', '05:55:00', '13:00:00', NULL, '', 99, NULL),
(836, 119, '2015-03-06', '09:00:00', '15:20:00', NULL, '', 99, NULL),
(837, 119, '2015-03-09', '00:00:00', '00:00:00', NULL, '', 3, NULL),
(838, 119, '2015-03-10', '06:10:00', '11:45:00', NULL, '', 99, NULL),
(839, 119, '2015-03-11', '06:00:00', '14:50:00', NULL, '', 99, NULL),
(840, 119, '2015-03-12', '05:50:00', '15:20:00', NULL, '', 99, NULL),
(841, 119, '2015-03-13', '09:00:00', '14:45:00', NULL, '', 99, NULL),
(842, 119, '2015-03-16', '07:00:00', '13:00:00', NULL, '', 99, NULL),
(843, 119, '2015-03-17', '07:00:00', '11:30:00', NULL, '', 99, NULL),
(844, 120, '2015-01-04', '00:00:00', '00:00:00', NULL, '', 88, NULL),
(845, 120, '2015-01-05', '08:13:00', '16:50:00', NULL, '', 99, NULL),
(846, 120, '2015-01-06', '07:00:00', '16:00:00', NULL, '', 99, NULL),
(847, 120, '2015-01-07', '08:15:00', '15:00:00', NULL, '', 99, NULL),
(848, 120, '2015-01-08', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(849, 120, '2015-01-09', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(850, 120, '2015-02-16', '09:00:00', '16:00:00', NULL, 'Schulung', 4, NULL),
(851, 120, '2015-02-17', '09:00:00', '16:00:00', NULL, 'Schulung', 4, NULL),
(852, 120, '2015-02-18', '09:00:00', '16:00:00', NULL, 'Schulung', 4, NULL),
(853, 120, '2015-01-12', '08:00:00', '16:45:00', NULL, '', 99, NULL),
(854, 120, '2015-01-02', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(855, 120, '2015-02-02', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(856, 120, '2015-02-03', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(857, 120, '2015-02-04', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(858, 120, '2015-02-05', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(859, 120, '2015-02-06', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(860, 120, '2015-02-24', '00:00:00', '00:00:00', NULL, 'geschenkter Urlaubstag aufgr. von Geburtstag', 2, NULL),
(861, 120, '2015-01-13', '08:15:00', '16:45:00', NULL, '', 99, NULL),
(862, 120, '2015-01-14', '07:50:00', '16:00:00', NULL, '', 99, NULL),
(863, 120, '2015-01-15', '07:35:00', '16:15:00', NULL, '', 99, NULL),
(864, 120, '2015-01-16', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(865, 120, '2015-01-19', '07:36:00', '16:45:00', NULL, '', 99, NULL),
(866, 120, '2015-01-20', '07:00:00', '16:00:00', NULL, '', 99, NULL),
(867, 120, '2015-01-21', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(868, 120, '2015-01-22', '08:00:00', '15:30:00', NULL, '', 99, NULL),
(869, 120, '2015-01-23', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(870, 120, '2015-01-26', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(871, 120, '2015-01-27', '07:00:00', '15:30:00', NULL, '', 99, NULL),
(872, 120, '2015-01-28', '07:00:00', '15:30:00', NULL, '', 99, NULL),
(873, 120, '2015-01-29', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(874, 120, '2015-01-30', '08:15:00', '16:40:00', NULL, '', 99, NULL),
(875, 120, '2015-02-09', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(876, 120, '2015-02-10', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(877, 120, '2015-02-11', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(878, 120, '2015-02-12', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(879, 120, '2015-02-13', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(880, 120, '2015-02-19', '07:35:00', '16:00:00', NULL, '', 99, NULL),
(881, 120, '2015-02-20', '08:00:00', '15:30:00', NULL, '', 99, NULL),
(882, 120, '2015-02-23', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(883, 120, '2015-02-25', '08:00:00', '16:30:00', NULL, '', 99, NULL),
(884, 120, '2015-02-26', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(885, 120, '2015-02-27', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(886, 120, '2015-03-30', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(887, 120, '2015-03-31', '00:00:00', '00:00:00', NULL, '', 2, NULL),
(888, 120, '2015-03-27', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(889, 120, '2015-03-18', '10:00:00', '21:00:00', NULL, 'Hospitation IT-Stelle', 99, NULL),
(890, 120, '2015-03-26', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(891, 120, '2015-03-25', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(892, 120, '2015-03-24', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(893, 120, '2015-03-23', '08:00:00', '16:00:00', NULL, '', 99, NULL),
(894, 120, '2015-03-20', '08:00:00', '16:00:00', NULL, '', 99, NULL),