(2502,'2012-02-11 06:35:52',1222,55463,'Jong Mun Jung','Baulkham Hills','2012-02-12',39713,'Training - 3179'),(2503,'2012-02-11 07:39:58',1223,50221,'Daniel Mcburney','Dundas Valley','2012-02-12',47573,'Customer Connections Services - 1666'),(2504,'2012-02-11 09:02:05',NULL,42963,'Felicity Chater','Heathcote','2012-02-12',43014,'Meter Data Quality - 4950'),(2505,'2012-02-11 09:04:40',NULL,33277,'Michael Wathen','Heathcote','2012-02-12',43014,'Meter Data Quality - 4950'),(2506,'2012-02-11 09:05:05',NULL,46932,'Terry Tran','Bankstown','2012-02-12',46918,'Meter Data Quality - 4950'),(2507,'2012-02-11 09:05:19',NULL,40785,'Tony Kelly','Minchinbury','2012-02-12',43014,'Meter Data Quality - 4950'),(2508,'2012-02-11 09:06:13',NULL,46425,'Sandra Stivala','Smithfield','2012-02-12',46932,'Meter Data Quality - 4950'),(2509,'2012-02-11 09:07:00',NULL,46931,'Bernie Kisnorbo','Lakemba','2012-02-12',46932,'Meter Data Quality - 4950'),(2510,'2012-02-11 09:07:00',NULL,43200,'Rowena Macaraeg','Quakers Hill','2012-02-12',43014,'Meter Data Quality - 4950'),(2511,'2012-02-11 09:05:51',1224,47971,'Michael Harvey','Como','2012-02-12',47311,'Customer Connections Services - 1669'),(2512,'2012-02-04 14:28:56',1225,49336,'Alan Ferguson','Bexley','2012-02-05',47311,'Customer Connections Services - 1669'),(2513,'2012-02-11 09:08:58',NULL,42479,'Annabelle Colina','Glenwood','2012-02-12',43014,'Meter Data Quality - 4950'),(2514,'2012-02-11 09:08:58',NULL,41078,'Ken Ross','Richmond','2012-02-12',46932,'Meter Data Quality - 4950'),(2515,'2012-02-11 09:11:21',NULL,37990,'Glenn Sherwood','St Marys','2012-02-12',46932,'Meter Data Quality - 4950'),(2516,'2012-02-11 09:11:30',NULL,37500,'Grant Flawith','North Ryde','2012-02-05',36592,'Field Services - 1632'),(2517,'2012-02-11 09:12:53',NULL,43014,'Darren Lewis','Kirrawee','2012-02-12',46918,'Meter Data Quality - 4950'),(2518,'2012-02-11 09:14:57',NULL,37990,'Glenn Sherwood','St Marys Industrial','2012-02-12',46932,'Meter Data Quality - 4950'),(2519,'2012-02-11 09:24:47',NULL,43177,'Mark Anderson','Peakhurst','2012-02-12',46932,'Meter Data Quality - 4950'),(2520,'2012-02-11 07:39:49',1226,47575,'Mark Surridge','North Avoca','2012-02-12',47573,'Customer Connections Services - 1666'),(2521,'2012-02-11 07:39:19',1227,49331,'Terry Hudson','kanwal','2012-02-12',47573,'Customer Connections Services - 1666'),(2522,'2012-02-11 10:05:25',NULL,42081,'Steve Murray','Eagle Vale','2012-02-12',43014,'Meter Data Quality - 4950'),(2523,'2012-02-11 10:56:59',NULL,47311,'Stephen Burns','Kareela','2012-02-12',47748,'Customer Connections Services - 1669'),(2524,'2012-02-11 12:25:58',NULL,47032,'Nick Taylor','Gymea','2012-02-12',42357,'Field Services - 1609'),(2525,'2012-02-11 13:42:26',NULL,26320,'Malcolm Rutherford','Ermington','2012-02-12',38242,'Employee Relations & Administration - 2118'),(2526,'2012-02-11 14:10:42',NULL,51469,'Michele Neden','Thirroul','2012-02-12',47311,'Field Services - 1669'),(2527,'2012-02-11 14:12:06',NULL,47465,'Natalie Fox','Belmore','2012-02-12',47311,'Field Services - 1669'),(2528,'2012-02-11 14:17:50',NULL,44710,'Craig Anderson','Loftus','2012-02-12',42357,'Field Services - 1609'),(2529,'2012-02-11 14:20:20',NULL,49336,'Alan Ferguson','Bexley','2012-02-12',47311,'Customer Connections Services - 1669'),(2530,'2012-02-11 14:31:21',NULL,47571,'Jeff Corcoran','Kincumber','2012-02-12',49748,'Central Coast Area - 1667'),(2531,'2012-02-11 13:43:40',1228,32094,'allan giles','Maroubra South','2012-02-12',42357,'overhead/poles'),(2532,'2012-02-11 13:47:24',1229,48604,'Daniel Blomfield','Panania','2012-02-12',42357,'Field Services - 1609'),(2533,'2012-02-11 07:34:44',1230,50672,'Geoff Macpherson','Harbord','2012-02-12',47573,'Customer Connections Services - 1666'),(2534,'2012-02-11 15:29:29',NULL,49121,'Joshua Gribble','Belmont North','2012-02-12',43098,'Contestability - 2507'),(2535,'2012-02-11 17:11:26',NULL,42094,'Gerard Mifsud','Kogarah','2012-02-12',41803,'Payroll Services - 7810'),(2536,'2012-02-11 14:28:36',1231,48357,'Keith Donaldson','Woodberry','2012-02-12',45931,'Area Management - Lower Hunter - 1648'),(2537,'2012-02-12 06:48:02',NULL,53975,'Jake Duncan','Rathmines','2012-02-12',45150,'Training - 3719'),(2538,'2012-02-12 11:39:53',NULL,53975,'Jake Duncan','Rathmines','2012-02-12',45150,'Training - 3719'),(2539,'2012-02-12 14:04:57',NULL,52504,'Mitchell Field','Thornton','2012-02-12',45931,'Training - 3719'),(2540,'2012-02-12 16:54:14',1232,37906,'Warren Elliott','Narellan Vale','2012-02-12',41040,'Field Services - 1621'),(2541,'2012-02-12 16:56:30',1233,37906,'Warren Elliott','Narellan Vale','2012-02-12',41040,'Field Services - 1621'),(2542,'2012-02-13 06:27:11',NULL,31347,'Raymond Keevers','Wentworthville','2012-02-12',33514,'Field Services - 1630'),(2543,'2012-02-13 06:14:14',1234,41004,'michael katsanis','Penshurst','2012-02-12',28598,'dor-1608'),(2544,'2012-02-13 06:28:14',NULL,46364,'Darren Jones','San Remo','2012-02-12',29478,'Field Services - 1629'),(2545,'2012-02-13 06:28:53',NULL,34427,'Clifford Worsfold','Condell Park','2012-02-12',26654,'Field Services - 1617'),(2546,'2012-02-13 06:33:58',NULL,47792,'Gary Pryke','Charmhaven','2012-02-12',39580,'Field Services - 1629'),(2547,'2012-02-13 06:34:18',NULL,48562,'David Oxenbould','Blackheath','2012-02-12',39713,'Field Services - 1631'),(2548,'2012-02-13 06:34:57',NULL,47828,'Richard Redman','Cardiff South','2012-02-12',45921,'Area Management - Lower Hunter - 1661'),(2549,'2012-02-13 06:35:20',NULL,51390,'Charles Morell','Penrith','2012-02-12',26654,'Field Services - 1617'),(2550,'2012-02-13 06:36:41',NULL,51390,'Charles Morell','Penrith','2012-02-12',26654,'Field Services - 1617'),(2551,'2012-02-13 06:37:19',NULL,49683,'Wayne Trindall','Merrylands West','2012-02-12',39580,'Field Services - 1629'),(2552,'2012-02-13 06:24:23',1235,48679,'ross wearn','Little Bay','2012-02-12',28598,'Field Services - 1608'),(2553,'2012-02-13 06:38:58',NULL,39580,'Reuben Stroud','Mount Colah','2012-02-12',29478,'Field Services - 1629'),(2554,'2012-02-13 06:42:59',NULL,46352,'Cameron Martin','Leonay','2012-02-12',37827,'Field Services - 1633'),(2555,'2012-02-13 06:44:25',NULL,46352,'Cameron Martin','Leonay','2012-02-12',37827,'Field Services - 1633'),(2556,'2012-02-13 06:46:14',NULL,46352,'Cameron Martin','Leonay','2012-02-12',37827,'Field Services - 1633'),(2557,'2012-02-06 06:43:25',1236,41406,'Bradley Keep','Blacktown','2012-02-05',28598,'Field Services - 1608'),(2558,'2012-02-06 06:46:12',1237,47943,'Scott Lewis','Engadine','2012-02-05',28598,'Field Services - 1608'),(2559,'2012-02-13 06:50:52',1238,47943,'Scott Lewis','Engadine','2012-02-12',28598,'Field Services - 1608'),(2560,'2012-02-06 06:24:59',1239,50710,'Michael Fisher','Panania','2012-02-05',41040,'Field Services - 1621'),(2561,'2012-02-06 06:26:33',1240,50710,'Michael Fisher','Panania','2012-02-05',41040,'Field Services - 1621'),(2562,'2012-02-13 06:34:42',1241,50710,'Michael Fisher','Panania','2012-02-12',41040,'Field Services - 1621'),(2563,'2012-02-13 06:58:53',NULL,36721,'Noel Baker','Kirrawee','2012-02-12',40055,'Field Services - 1616'),(2564,'2012-02-13 07:00:52',NULL,42509,'Andrew Woolgar','Brookvale','2012-02-12',37827,'Field Services - 1632'),(2565,'2012-02-13 07:02:26',NULL,47976,'Simon Pryor','Engadine','2012-02-12',40055,'Field Services - 1616'),(2566,'2012-02-13 07:04:19',NULL,39307,'William Davison','Heathcote','2012-02-12',40055,'Field Services - 1616'),(2567,'2012-02-13 07:05:08',NULL,39307,'William Davison','Heathcote','2012-02-12',40055,'Field Services - 1616'),(2568,'2012-02-13 07:05:27',NULL,40930,'Gary Skelham','Dundas Valley','2012-02-12',36592,'Field Services - 1632'),(2569,'2012-02-13 07:06:40',NULL,34886,'Brian Mansfield','Berowra Heights','2012-02-12',42357,'Field Services - 1609'),(2570,'2012-02-13 07:06:42',NULL,55660,'Matthew Munday','Belmont','2012-02-12',49448,'Training - 3719'),(2571,'2012-02-13 07:06:59',NULL,55663,'Thomas Thurston','Bateau Bay','2012-02-12',49448,'Training - 3719'),(2572,'2012-02-06 07:24:48',1242,53009,'Robert Whitton','Sutherland','2012-01-29',40055,'Training - 3719'),(2573,'2012-02-06 07:22:37',1243,55615,'matthew harding','Woonona','2012-02-05',40055,'oatley overhead'),(2574,'2012-02-06 07:20:34',1244,55620,'duc anh le','Cabramatta','2012-02-05',40055,'oatley overhead'),(2575,'2012-02-13 07:07:33',NULL,34886,'Brian Mansfield','Berowra Heights','2012-02-12',42357,'Field Services - 1609'),(2576,'2012-02-13 07:07:51',NULL,49177,'Kurt Ware','Ramsgate','2012-02-12',42357,'Field Services - 1609'),(2577,'2012-02-13 07:08:37',NULL,46636,'Donald Myers','Ryde','2012-02-12',39713,'Field Services - 1631'),(2578,'2012-02-13 07:09:01',NULL,53006,'Ashley Watts','Cambridge Park','2012-02-12',33514,'Field Services - 1630'),(2579,'2012-02-13 07:09:39',NULL,51447,'Grant Kerrigan','Cranebrook North','2012-02-12',28598,'Field Services - 1608'),(2580,'2012-02-13 07:09:43',NULL,52597,'Van Nguyen','Hinchinbrook','2012-02-12',37827,'Training - 3719'),(2581,'2012-02-13 07:09:53',NULL,53006,'Ashley Watts','Cambridge Park','2012-02-12',33514,'Field Services - 1630'),(2582,'2012-02-13 07:10:24',NULL,51365,'Jarrod Mckeown','Avoca Beach','2012-02-12',33514,'Training - 3719'),(2583,'2012-02-13 07:10:33',NULL,53006,'Ashley Watts','Cambridge Park','2012-02-12',33514,'Field Services - 1630'),(2584,'2012-02-13 07:10:33',NULL,52597,'Van Nguyen','Hinchinbrook','2012-02-12',37827,'Training - 3719'),(2585,'2012-02-13 07:11:02',NULL,52597,'Van Nguyen','Hinchinbrook','2012-02-12',37827,'Training - 3719'),(2586,'2012-02-13 07:11:14',NULL,53006,'Ashley Watts','Cambridge Park','2012-02-12',33514,'Field Services - 1630'),(2587,'2012-02-13 07:11:54',NULL,53006,'Ashley Watts','Cambridge Park','2012-02-12',33514,'Field Services - 1630'),(2588,'2012-02-13 07:12:33',NULL,50268,'Peter Lam','Birrong','2012-02-12',37827,'Training - 3719'),(2589,'2012-02-13 07:12:45',NULL,53006,'Ashley Watts','Cambridge Park','2012-02-12',33514,'Field Services - 1630'),(2590,'2012-02-13 07:13:09',NULL,48793,'Paul Heaney','Grays Point','2012-02-12',28598,'Field Services - 1608'),(2591,'2012-02-13 07:15:43',NULL,47565,'Dallon Hansen','Gymea Bay','2012-02-12',28598,'Field Services - 1608'),(2592,'2012-02-13 07:04:03',1245,40445,'Brett Garvan','Miranda','2012-02-12',40055,'Field Services - 1616'),(2593,'2012-02-11 15:05:03',1246,42890,'keith georgeson','Ingleside','2012-02-12',37805,'hornsby poles'),(2594,'2012-02-13 07:05:02',1247,43110,'Colin Booth','Manly','2012-02-12',36592,'Field Services - 1635'),(2595,'2012-02-13 07:01:29',1248,44389,'jamie gauci','Arncliffe','2012-02-12',28598,'east subs'),(2596,'2012-02-13 07:02:22',1249,47280,'Todd Hill','Thirroul','2012-02-12',40055,'Field Services - 1616'),(2597,'2012-02-06 14:53:27',1250,48211,'Grant Davis','Bulli','2012-02-05',40055,'Field Services - 1616'),(2598,'2012-02-13 07:10:56',1251,50201,'michael crawford','Leichhardt','2012-02-12',28598,'east subs'),(2599,'2012-02-08 08:03:00',1252,50385,'josh benton','Jannali','2012-02-05',40055,'oatley overhead'),(2600,'2012-02-13 06:54:18',1253,51475,'Bruce Wear','West Ryde','2012-02-12',26654,'1615'),(2601,'2012-02-06 08:01:25',1254,52598,'Thilendran Gounden','Glenmore Park','2012-02-05',26654,'Training - 3719'),(2602,'2012-02-13 06:49:05',1255,52599,'Nicholas Cameron','Macquarie Fields','2012-02-12',41122,'Training - 3719'),(2603,'2012-02-13 07:17:45',NULL,51487,'Angelo Tatsis','Lakemba','2012-02-12',28598,'Field Services - 1608'),(2604,'2012-02-13 07:18:08',NULL,52678,'Abby Edwards','Cronulla','2012-02-12',28598,'Field Services - 1608'),(2605,'2012-02-13 07:21:11',NULL,51487,'Angelo Tatsis','Lakemba','2012-01-15',28598,'Field Services - 1608'),(2606,'2012-02-13 07:22:08',NULL,47977,'Luigi Martinuzzi','Petersham','2012-02-12',49303,'Control & Protection - Sydney - 1831'),(2607,'2012-02-13 07:22:21',NULL,51476,'Corben Panton','North Rocks','2012-02-12',41399,'Transmission Substations - Central - 1716'),(2608,'2012-02-13 07:22:39',NULL,55655,'Blake Blyton','Belmont','2012-02-12',45150,'Training - 3719'),(2609,'2012-02-13 07:22:44',NULL,55659,'Chad Mangan','Cardiff','2012-02-12',49448,'Training - 3719'),(2610,'2012-02-13 07:23:50',NULL,54076,'Matthew O\'Neill','Harris Park','2012-02-12',28598,'Field Services - 1608'),(2611,'2012-02-13 07:26:50',NULL,53958,'Blake Smith','Bensville','2012-02-12',37827,'Training - 3719'),(2612,'2012-02-13 07:17:28',1256,40257,'Mario Guerrera','Willoughby','2012-02-12',36592,'Field Services - 1635'),(2613,'2012-01-17 09:19:31',1257,46636,'Donald Myers','Ryde','2012-01-15',39713,'Field Services - 1631'),(2614,'2012-01-30 10:06:45',1258,46636,'Donald Myers','Ryde','2012-01-29',39713,'Field Services - 1631'),(2615,'2012-02-13 07:16:52',1259,47714,'benjamin levi','Darlington','2012-02-12',40055,'3715'),(2616,'2012-02-13 07:18:53',1260,47714,'benjamin levi','Darlington','2012-02-12',40055,'1615'),(2617,'2012-02-13 07:02:30',1261,53925,'Nicholas Beckman','Matraville','2012-02-12',42357,'Training - 3719'),(2618,'2012-02-13 07:13:07',1262,53929,'Jimmy Cemal','Quakers Hill','2012-02-12',42357,'Training - 3719'),(2619,'2012-02-13 07:05:47',1263,53957,'Steven Sing','Monterey','2012-02-12',42357,'Training - 3719'),(2620,'2012-02-13 07:32:33',NULL,39757,'John Ryan','Collaroy (sydney)','2012-02-12',28598,'Field Services - 1608'),(2621,'2012-02-13 07:36:50',NULL,42112,'Ross Hardy','Ingleburn','2012-02-12',28598,'Field Services - 1608'),(2622,'2012-02-06 07:22:52',1264,35037,'anthony ruane','Maroubra','2012-02-05',42357,'o/h 1609'),(2623,'2012-02-06 07:31:18',1265,35037,'Anthony Ruane','Maroubra','2012-02-05',42357,'Training - 3706'),(2624,'2012-02-13 07:08:53',1266,40547,'Sean Timbs','Kearns','2012-02-12',40055,'Training - 3715'),(2625,'2012-02-13 07:17:57',1267,41620,'Peter Urbano','Arcadia','2012-02-12',36592,'Field Services - 1632'),(2626,'2012-02-13 07:17:25',1268,42470,'Rob Van Der Kley','Normanhurst','2012-02-12',39713,'Field Services - 1631'),(2627,'2012-02-13 07:23:35',1269,46772,'michael brown','Kirrawee','2012-02-12',26654,'homebush inner west'),(2628,'2012-02-13 07:21:23',1270,47274,'Evan Thomas','Newport Beach','2012-02-12',39713,'Field Services - 1631'),(2629,'2012-02-06 15:00:51',1271,48199,'timothy polson','Camden','2012-02-05',42357,'zetland overhead'),(2630,'2012-02-13 07:15:37',1272,48222,'Jakub Sedlak','Mosman','2012-02-12',36592,'Field Services - 1632'),(2631,'2012-02-13 07:17:35',1273,48222,'Jakub Sedlak','Mosman','2012-02-12',36592,'Field Services - 1632'),(2632,'2012-02-13 06:59:34',1274,48386,'Darryl Woods','Spring Farm','2012-02-12',54170,'Field Services - 1623'),(2633,'2012-02-13 07:02:49',1275,49996,'Daniel Van Der Kley','Mona Vale','2012-02-12',39713,'Field Services - 1631'),(2634,'2012-02-13 07:25:27',1276,50191,'Jordan Buie','Brooklyn','2012-02-12',39713,'Field Services - 1631'),(2635,'2012-02-06 08:17:47',1277,50277,'Ashley Part','Padstow Heights','2012-02-05',42357,'Training - 3719'),(2636,'2012-02-13 07:23:34',1278,50322,'Michael Hoban','Terrigal','2012-02-12',39713,'Field Services - 1631'),(2637,'2012-02-13 07:04:33',1279,51410,'adrian buie','Brooklyn','2012-02-12',39713,'north subs'),(2638,'2012-02-13 07:11:58',1280,53009,'Robert Whitton','Sutherland','2012-02-12',40055,'Training - 3719'),(2639,'2012-01-23 07:34:27',1281,53013,'Shannon Phillips','Rozelle','2012-01-22',36592,'Field Services - 1635'),(2640,'2012-01-23 07:45:38',1282,53013,'Shannon Phillips','Rozelle','2012-01-22',36592,'Field Services - 1635'),(2641,'2012-01-31 08:07:51',1283,53925,'Nicholas Beckman','Matraville','2012-01-29',42357,'Training - 3719'),(2642,'2012-01-31 07:59:49',1284,53929,'Jimmy Cemal','Quakers Hill','2012-01-29',42357,'Training - 3719'),(2643,'2012-02-13 07:21:30',1285,53950,'Matthew Muir','Woonona','2012-02-12',40055,'Training - 3719'),(2644,'2012-02-13 07:18:57',1286,55605,'robert bancroft','Albion Park','2012-02-12',40055,'oatley'),(2645,'2012-02-13 07:15:50',1287,55610,'samir chalfa','Leppington','2012-02-12',40055,'oatley overhead'),(2646,'2012-02-06 07:37:35',1288,55611,'aaron cox','Heathcote','2012-02-05',42357,'training - 3706'),(2647,'2012-02-13 07:13:55',1289,55611,'aaron cox','Heathcote','2012-02-12',42357,'Training - 3719'),(2648,'2012-02-13 07:14:11',1290,55615,'matthew harding','Woonona','2012-02-12',40055,'oatley overhead'),(2649,'2012-02-06 07:44:51',1291,55623,'christopher madonis','Miranda','2012-02-05',42357,'training - 3706'),(2650,'2012-02-13 07:20:15',1292,55623,'christopher madonis','Miranda','2012-02-12',42357,'Training - 3719'),(2651,'2012-02-06 07:51:14',1293,55631,'Philip Searle','Miranda','2012-02-05',42357,'Training - 3706'),(2652,'2012-02-13 07:05:26',1294,55631,'Philip Searle','Miranda','2012-02-12',42357,'Training - 3719'),(2653,'2012-02-13 07:39:04',NULL,39548,'Wayne Monk','Ettalong Beach','2012-02-12',41437,'Training - 3717'),(2654,'2012-02-13 07:41:09',NULL,35099,'Peter Bray','Jannali','2012-02-12',40055,'Field Services - 1616'),(2655,'2012-02-13 07:41:58',NULL,35099,'Peter Bray','Jannali','2012-02-12',40055,'Field Services - 1616'),(2656,'2012-02-13 07:44:00',NULL,46972,'Peter De Bernardi','Grasmere','2012-02-12',40055,'Field Services - 1616'),(2657,'2012-02-13 07:24:56',1295,39163,'Stephen Beakey','Narrabeen','2012-02-12',36592,'Field Services - 1635'),(2658,'2012-02-13 07:17:37',1296,47285,'Brendan Verhoeven','Blaxland','2012-02-12',26654,'Field Services - 1617'),(2659,'2012-02-13 07:32:59',1297,49166,'adam herera','Wakeley','2012-02-12',21900,'regents park 1618'),(2660,'2012-02-13 07:33:14',1298,49180,'Ossie Ryan','Hillsdale','2012-02-12',26654,'Field Services - 1617'),(2661,'2012-02-13 07:37:22',1299,49685,'daniel  young','Terrey Hills','2012-02-12',36592,'Field Services - 1635'),(2662,'2012-02-13 07:21:22',1300,51458,'Philip Mackenzie','Seven Hills','2012-02-12',39713,'Field Services - 1631'),(2663,'2012-02-13 07:27:29',1301,53013,'Shannon Phillips','Rozelle','2012-02-12',36592,'Field Services - 1635'),(2664,'2012-02-13 07:28:54',1302,53013,'Shannon Phillips','Rozelle','2012-02-12',36592,'Field Services - 1635'),(2665,'2012-02-13 07:49:14',NULL,42188,'Philip Chandler','Holsworthy','2012-02-12',40055,'Field Services - 1616'),(2666,'2012-02-13 07:56:48',NULL,53472,'Alison Johnson','Blakehurst','2012-02-12',30004,'Field Services - 1612'),(2667,'2012-02-13 07:47:12',1303,40903,'Branko Mitrevski','Hurlstone Park','2012-02-12',54170,'Field Services - 1623'),(2668,'2012-02-13 07:22:47',1304,41138,'Phillip Papatheodosiou','Merrylands','2012-02-12',42357,'Overhead  East'),(2669,'2012-02-13 07:44:04',1305,46969,'Dean Berwick','Wallacia','2012-02-12',54170,'Field Services - 1623'),(2670,'2012-02-13 07:46:42',1306,47902,'Brian Weetman','North Bondi','2012-02-12',42357,'Field Services - 1609'),(2671,'2012-02-13 08:06:50',NULL,40516,'Mark Monsillo','Connells Point','2012-02-12',42357,'Field Services - 1609'),(2672,'2012-02-13 08:07:16',NULL,55630,'Beau Franklin','Adamstown','2012-02-12',45289,'Professional Development - 3801'),(2673,'2012-01-30 13:38:00',1307,47976,'earle pryor','Engadine','2012-01-29',40055,'overhead 1616'),(2674,'2012-01-24 13:39:02',1308,48359,'Patrick Chater','Heathcote','2012-01-22',40055,'Field Services - 3607'),(2675,'2012-02-13 07:42:39',1309,48359,'Patrick Chater','Heathcote','2012-02-12',40055,'Field Services - 3607'),(2676,'2012-01-24 13:43:30',1310,49681,'Aaron Cupples','Newtown','2012-01-22',40055,'Training - 3719'),(2677,'2012-02-13 07:21:17',1311,50219,'Brendan Lees','Marsfield','2012-02-12',39713,'Field Services - 1631'),(2678,'2012-02-02 12:58:18',1312,52453,'Stephen Brown','Gymea','2012-01-15',40055,'Training - 3719'),(2679,'2012-02-02 13:01:09',1313,52453,'Stephen Brown','Gymea','2012-01-29',40055,'Training - 3719'),(2680,'2012-02-13 07:55:09',1314,55587,'Adam Coperp','Woolooware','2012-02-12',54170,'HR '),(2681,'2012-02-13 08:07:34',NULL,40632,'David Cini','Toongabbie','2012-02-12',37805,'Field Services - 1636'),(2682,'2012-02-13 08:09:02',NULL,52711,'David Pegg','Bow Bowing','2012-02-12',28598,'Training - 3719'),(2683,'2012-02-13 08:09:26',NULL,40632,'David Cini','Toongabbie','2012-02-12',37805,'Field Services - 1636'),(2684,'2012-02-13 08:10:54',NULL,22661,'Corry Gadaleta','Gladesville','2012-02-12',39580,'Field Services - 1629'),(2685,'2012-02-13 08:11:46',NULL,55658,'John Gittoes','Maryland','2012-02-12',45921,'Area Management - Lower Hunter - 1662'),(2686,'2012-02-13 08:12:18',NULL,43157,'Tony Wilson','St Clair','2012-02-12',39580,'Field Services - 1629'),(2687,'2012-02-13 08:14:59',NULL,42973,'Joe Giusa','Westmead','2012-02-12',39580,'Field Services - 1629'),(2688,'2012-02-13 08:15:54',NULL,47715,'Anthony Dallaway','Harbord','2012-02-05',33514,'Field Services - 1630'),(2689,'2012-02-13 08:18:10',NULL,47715,'Anthony Dallaway','Harbord','2012-02-12',33514,'Field Services - 1630'),(2690,'2012-02-13 08:46:38',NULL,48616,'Kylie Morton Bright','Northmead','2012-02-12',51532,'Marketing - 9515'),(2691,'2012-02-13 07:50:57',1315,53953,'jean rene','Revesby','2012-02-12',42357,'zetland'),(2692,'2012-02-13 08:57:54',NULL,47899,'Brendin Patterson','Flinders','2012-01-08',46351,'Field Services - 1610'),(2693,'2012-02-13 08:58:53',1316,49100,'Michael Stirling','Sutherland','2012-02-12',38050,'Field Services - 1619'),(2694,'2012-02-13 09:20:02',NULL,48359,'Patrick Chater','Heathcote','2012-01-22',40055,'Field Services - 3607'),(2695,'2012-02-13 09:21:41',NULL,48359,'Patrick Chater','Heathcote','2012-01-22',40055,'Field Services - 3607'),(2696,'2012-02-13 09:26:04',NULL,47976,'Simon Pryor','Engadine','2012-01-29',40055,'Field Services - 1616'),(2697,'2012-02-13 09:28:43',NULL,41042,'Craig Edwards','West Gosford','2012-02-12',37805,'Field Services - 1636'),(2698,'2012-02-13 09:33:46',NULL,46857,'Adam Marks','Noraville','2012-02-12',34882,'Training - 3712'),(2699,'2012-02-13 09:41:31',NULL,44781,'Susan A Walton','Glenwood','2012-02-12',48334,'Sales - 5300'),(2700,'2012-02-13 09:42:05',NULL,44781,'Susan A Walton','Glenwood','2012-02-19',48334,'Sales - 5300'),(2701,'2012-02-13 09:53:06',NULL,47299,'Daniel Pike','Bolton Point','2012-02-05',48392,'Contestability - 2507'),(2702,'2012-02-13 07:27:21',1318,52164,'Glenn Hotchin','Warriewood','2012-02-12',39713,'Field Services - 1631'),(2703,'2012-02-13 07:37:15',1319,54039,'Jon Beuman','Mount Colah','2012-02-12',39713,'Training - 3719'),(2704,'2012-02-13 10:00:48',NULL,45466,'Wayne Mitchell','Buttaba','2012-02-12',41437,'Training - 3717'),(2705,'2012-02-13 10:02:22',NULL,52781,'Andrew Mendes','Stanmore','2012-02-12',28598,'Training - 3719'),(2706,'2012-02-13 10:06:06',NULL,43923,'Mitz Molo','Merrylands','2012-02-12',28598,'Field Services - 1608'),(2707,'2012-02-13 10:10:12',NULL,55467,'Seung Min Lee','Castle Hill','2012-02-12',47263,'Training - 3719'),(2708,'2012-02-13 08:33:28',1320,43368,'Christopher Mcleod','East Gosford','2012-02-12',39713,'Field Services - 1631'),(2709,'2012-02-13 10:07:21',1321,50711,'Greg Uebel','Cronulla South','2012-02-05',38050,'Field Services - 1619'),(2710,'2012-02-13 10:25:03',NULL,46328,'Aaron Wallis','Balcolyn','2012-02-12',34882,'Training - 3712'),(2711,'2012-02-13 10:04:48',1322,47026,'Byron King','Baulkham Hills','2012-02-12',26654,'Field Services - 1617'),(2712,'2012-02-13 10:46:46',NULL,40035,'Mark Cotter','Erskineville','2012-02-12',42357,'Field Services - 1609'),(2713,'2012-02-13 10:54:43',NULL,54059,'Adam Kovacevic','Abbotsbury','2012-02-12',47263,'Training - 3719'),(2714,'2012-02-13 10:57:32',NULL,27482,'Alan Sing','Monterey','2012-02-12',28598,'Field Services - 1608'),(2715,'2012-02-13 11:09:49',NULL,34218,'Barry Bennie','Holsworthy','2012-02-12',42357,'Field Services - 1609'),(2716,'2012-02-13 11:25:23',NULL,48436,'Budi Cahyadi','Ashfield','2012-02-12',44786,'Service Delivery - 5300'),(2717,'2012-02-13 11:37:15',NULL,48436,'Budi Cahyadi','Ashfield','2011-12-25',44786,'Service Delivery - 5300'),(2718,'2012-02-13 11:39:15',NULL,48436,'Budi Cahyadi','Ashfield','2012-01-01',44786,'Service Delivery - 5300'),(2719,'2012-02-13 11:41:17',NULL,48436,'Budi Cahyadi','Ashfield','2012-01-08',44786,'Service Delivery - 5300'),(2720,'2012-02-13 11:43:17',NULL,40174,'Chris Lynch','Zetland','2012-01-08',46955,'Field Services - 1614'),(2721,'2012-02-13 11:43:32',NULL,48436,'Budi Cahyadi','Ashfield','2012-01-15',44786,'Service Delivery - 5300'),(2722,'2012-02-13 11:45:11',NULL,48436,'Budi Cahyadi','Ashfield','2012-01-22',44786,'Service Delivery - 5300'),(2723,'2012-02-13 11:47:02',NULL,48436,'Budi Cahyadi','Ashfield','2012-01-29',44786,'Service Delivery - 5300'),(2724,'2012-02-13 11:49:21',NULL,48436,'Budi Cahyadi','Ashfield','2012-02-05',44786,'Service Delivery - 5300'),(2725,'2012-02-13 11:40:53',1323,49060,'Warwick Chancellor','Calga','2012-02-12',39713,'Field Services - 1631'),(2726,'2012-02-06 09:59:00',1324,49824,'cade watson','Hornsby','2012-02-05',39713,'field services north'),(2727,'2012-02-09 14:01:21',1325,49824,'Cade Watson','Hornsby','2012-02-12',39713,'Field Services - 1631'),(2728,'2012-02-13 11:49:10',1326,55498,'Stephen Tuffin','Berowra','2012-02-12',39713,'Training - 3719'),(2729,'2012-02-13 12:01:10',NULL,41737,'Sam Giftopoulos','Kareela','2012-02-12',28598,'Field Services - 1608'),(2730,'2012-02-13 12:04:19',NULL,46366,'Matthew Thompson','Picnic Point','2012-02-12',41122,'Field Services - 1622'),(2731,'2012-02-13 12:04:52',NULL,46366,'Matthew Thompson','Picnic Point','2012-02-12',41122,'Field Services - 1622'),(2732,'2012-02-13 12:05:45',NULL,46366,'Matthew Thompson','Picnic Point','2012-02-12',41122,'Field Services - 1622'),(2733,'2012-02-13 11:42:59',1327,46885,'Dennis Elder','Campbelltown','2012-02-12',28598,'Field Services - 1608'),(2734,'2012-02-13 11:35:04',1328,47560,'Matthew Kane','Miranda','2012-02-12',28598,'Field Services - 1608'),(2735,'2012-02-13 11:28:03',1329,52700,'Matt Sutton','Cherrybrook','2012-02-12',28598,'field services east'),(2736,'2012-02-13 12:19:28',NULL,42181,'Brad Bishop','Yowie Bay','2012-02-12',46351,'Field Services - 1610'),(2737,'2012-02-13 12:47:39',NULL,44684,'Kerri Mccaw','Seaham','2012-02-12',50738,'Workforce Planning & Management - 4301'),(2738,'2012-02-13 12:53:03',NULL,39371,'Craig Robson','Blaxland East','2012-02-12',34969,'Field Services - 1637'),(2739,'2012-02-13 08:28:39',1330,47706,'Trent Moss','Caringbah','2012-02-12',54170,'Field Services - 1623'),(2740,'2012-02-13 13:17:49',NULL,49595,'Laurie Camilleri','Kyeemagh','2012-02-12',41437,'Training - 3717'),(2741,'2012-02-13 13:33:13',NULL,44924,'Pauline Roberts','Ashton Field','2012-02-12',55783,'Contact Centre - Newcastle - 4301'),(2742,'2012-02-13 13:38:05',NULL,42718,'Tony O\'Brien','Quakers Hill','2012-02-12',43818,'Business Support - 1701'),(2743,'2012-02-13 13:46:43',NULL,34936,'Michael Guerrera','Hornsby Heights','2012-02-12',33514,'Field Services - 1630'),(2744,'2012-02-07 11:00:39',1331,46896,'Luke Powell','Cronulla','2012-02-05',38050,'Field Services - 1619'),(2745,'2012-02-13 13:30:53',1333,52694,'Naomi Lawrie','Barden Ridge','2012-02-12',47263,'Training - 3719'),(2746,'2012-02-13 13:33:45',1334,52694,'Naomi Lawrie','Barden Ridge','2012-02-05',47263,'Training - 3719'),(2747,'2012-02-13 13:27:15',1335,55442,'Adam Bolton','Shellharbour','2012-02-12',47263,'Training - 3719'),(2748,'2012-02-13 13:54:57',NULL,45706,'Gordon Tuxford','Cardiff Heights','2012-02-12',49448,'Training - 3714'),(2749,'2012-02-13 13:42:09',1336,47928,'Lee Taylor','Wollongong','2012-02-12',38050,'field services'),(2750,'2012-02-13 13:46:47',1337,48841,'Michael Frost','Yarrawarrah','2012-02-12',38050,'Field Services - 1619'),(2751,'2012-02-13 14:15:55',NULL,46770,'Clint Mayberry','Illawong','2012-02-12',26654,'Field Services - 1617'),(2752,'2012-02-13 14:39:00',NULL,47041,'Stephen Wheatley','Seaforth','2012-02-12',39580,'Field Services - 1629'),(2753,'2012-02-13 14:41:54',NULL,52501,'Luke Ahrens','Caves Beach (swansea)','2012-02-12',44804,'Training - 3719'),(2754,'2012-02-13 14:44:44',NULL,52507,'Drew Maddison','Beresfield','2012-02-12',44804,'Training - 3719'),(2755,'2012-02-13 14:34:13',1338,52112,'Richard Czado','Collaroy (sydney)','2012-02-12',39713,'Field Services - 1631'),(2756,'2012-02-13 15:07:02',NULL,47940,'Steve Evan','Seven Hills','2012-02-12',37827,'Field Services - 1633'),(2757,'2012-02-13 14:52:46',1339,50287,'Damien Walker','Banksia','2012-02-12',40055,'oatley oh'),(2758,'2012-02-13 14:29:22',1340,52453,'Stephen Brown','Gymea','2012-02-12',43319,'Training - 3719'),(2759,'2012-02-13 14:55:09',1341,52453,'Stephen Brown','Gymea','2012-02-12',43319,'Training - 3719'),(2760,'2012-02-13 12:46:29',1342,48441,'David Schelin','Glenhaven','2012-02-12',39713,'Field Services - 1631'),(2761,'2012-02-13 13:53:04',1343,48560,'kirk metcalfe','Kurrajong Heights','2012-02-12',33514,'Field Services - 1630'),(2762,'2012-02-13 14:42:34',1344,49190,'tom wojtkowiak','Merrylands','2012-02-12',33514,'chatswood oh'),(2763,'2012-02-13 07:49:52',1345,52631,'Bradley Anderson','Waterloo','2012-02-12',33514,'Training - 3719'),(2764,'2012-02-13 15:19:38',NULL,55473,'Hunter Julian Mcgarrigle','Ermington','2012-02-12',47263,'Training - 3719'),(2765,'2012-02-13 15:14:53',1346,38815,'Mark Lintern','Bilgola Plateau','2012-02-12',36592,'Field Services - 1632'),(2766,'2012-02-13 06:50:12',1347,43599,'Thach Tran','Guildford','2012-02-12',42357,'Field Services - 1609'),(2767,'2012-01-30 07:55:06',1348,47022,'Rowan Davis','Engadine','2012-01-29',42357,'Field Services - 1609'),(2768,'2012-02-12 14:53:40',1349,47031,'Rhys Stacpoole','Heathcote','2012-02-05',42357,'Field Services - 1609'),(2769,'2012-02-12 14:55:10',1350,47031,'Rhys Stacpoole','Heathcote','2012-02-12',42357,'Field Services - 1609'),(2770,'2012-02-13 07:22:17',1351,47807,'bruce roberts','Hurstville','2012-02-12',42357,'1609'),(2771,'2012-02-13 15:03:37',1352,47807,'Bruce Roberts','Hurstville','2012-02-05',42357,'Field Services - 1609'),(2772,'2012-02-05 13:37:43',1353,50273,'ben nagy','loftus','2012-02-05',42357,'1609'),(2773,'2012-02-05 13:39:00',1354,50273,'ben nagy','loftus','2012-01-29',42357,'1609'),(2774,'2012-02-13 07:19:55',1355,50273,'ben nagy','Loftus','2012-02-12',42357,'1609'),(2775,'2012-02-13 07:45:10',1356,50273,'ben nagy','loftus','2012-02-12',42357,'1609'),(2776,'2012-02-13 07:48:05',1357,50273,'ben nagy','loftus','2012-02-05',42357,'1609'),(2777,'2012-02-06 08:30:48',1358,50289,'Thomas Weekley','Bonnet Bay','2012-02-05',42357,'Field Services - 1609'),(2778,'2012-02-13 07:42:01',1359,50289,'Thomas Weekley','Bonnet Bay','2012-02-12',42357,'Field Services - 1609'),(2779,'2012-02-02 06:57:45',1360,50708,'Matthew Canellis','Revesby','2012-02-05',43319,'Training - 3719'),(2780,'2012-02-08 12:30:20',1361,50708,'Matthew Canellis','Revesby','2012-02-12',43319,'Training - 3719'),(2781,'2012-02-09 07:21:45',1362,51376,'THANH BUI','St Johns Park','2012-02-05',42357,'1609'),(2782,'2012-02-13 07:08:03',1363,51391,'Keshwant Nagaiya','Lurnea','2012-02-12',43319,'Training - 3719'),(2783,'2012-02-13 07:09:45',1364,51391,'Keshwant Nagaiya','Lurnea','2012-02-12',43319,'Training - 3719'),(2784,'2012-02-08 09:26:15',1365,51395,'JOEL PHILLIPS','Cronulla','2012-02-05',42357,'1609'),(2785,'2012-02-08 21:17:59',1366,51395,'JOEL PHILLIPS','Cronulla South','2012-02-05',42357,'ZETLAND OH'),(2786,'2012-02-13 07:14:21',1367,51395,'JOEL PHILLIPS','Cronulla South','2012-02-12',42357,'1609'),(2787,'2012-02-13 07:17:13',1368,51395,'JOEL PHILLIPS','Cronulla South','2012-02-12',42357,'1609'),(2788,'2012-02-03 14:57:45',1369,52614,'Stephen Lawton','Glenorie','2012-02-05',43319,'Training - 3719'),(2789,'2012-02-09 07:13:05',1370,52614,'Stephen Lawton','Glenorie','2012-02-12',43319,'Training - 3719'),(2790,'2012-02-12 15:03:22',1371,52626,'luke muir','Stanmore','2012-02-05',45738,'1609'),(2791,'2012-02-12 15:08:21',1372,52626,'luke muir','Stanmore','2012-01-29',45738,'1609'),(2792,'2012-02-12 15:10:44',1373,52626,'luke muir','Stanmore','2012-01-22',45738,'1609'),(2793,'2012-02-11 18:38:09',1374,52645,'Deon Apps','Engadine','2012-02-12',42357,'1609'),(2794,'2012-02-12 07:17:56',1375,52645,'Deon Apps','Engadine','2012-02-12',43319,'1609'),(2795,'2012-02-13 15:58:29',NULL,42054,'Paul Wallace','Bondi Beach','2012-02-12',28598,'Field Services - 1608'),(2796,'2012-02-13 16:33:22',NULL,54074,'Paulo Nascimento','Figtree (wollongong)','2012-02-12',47263,'Training - 3716'),(2797,'2012-02-14 05:57:52',NULL,53974,'Andrew J Cameron','Shortland','2012-02-12',45150,'Training - 3719'),(2798,'2012-02-14 06:45:20',NULL,41841,'David Parkinson','Lakehaven','2012-02-12',36592,'Field Services - 1635'),(2799,'2012-02-14 06:53:05',NULL,41841,'David Parkinson','Lakehaven','2012-02-12',36592,'Field Services - 1635'),(2800,'2012-02-14 06:57:47',NULL,53129,'Andrew Frith','Davidson','2012-02-05',33514,'Field Services - 1630'),(2801,'2012-02-14 07:16:01',NULL,47615,'Todd O\'Mahony','Aberglasslyn','2012-02-12',45931,'Area Management - Lower Hunter - 1648'),(2802,'2012-02-14 07:05:18',1376,41457,'richard hanley','Prestons','2012-02-12',40055,'overhead'),(2803,'2012-02-07 07:05:41',1377,50270,'jay miller','Engadine','2012-02-05',40055,'1616'),(2804,'2012-02-14 07:05:53',1378,50270,'Jay Miller','Engadine','2012-02-12',40055,'feild services 1616'),(2805,'2012-02-14 07:19:05',NULL,50735,'Murray Sellers','Metford','2012-02-12',45931,'Area Management - Lower Hunter - 1649'),(2806,'2012-02-14 07:19:37',NULL,51454,'Tevita Leha','Marrickville','2012-02-05',47263,'Training - 3719'),(2807,'2012-02-14 07:21:37',NULL,47906,'Brendan Mcgregor','Warners Bay','2012-02-12',45931,'Area Management - Lower Hunter - 1648'),(2808,'2012-02-14 07:22:19',NULL,51454,'Tevita Leha','Marrickville','2012-02-12',47263,'Training - 3719'),(2809,'2012-02-14 07:23:40',NULL,46968,'Alexander Baldacchino','Baulkham Hills','2012-02-12',39580,'Field Services - 1629'),(2810,'2012-02-14 07:34:53',NULL,47715,'Anthony Dallaway','Harbord','2012-02-05',33514,'Field Services - 1630'),(2811,'2012-02-14 07:36:50',NULL,43689,'Andrew Creswell','Stanhope Gardens','2012-02-12',39713,'Field Services - 1631'),(2812,'2012-02-14 07:37:53',NULL,47715,'Anthony Dallaway','Harbord','2012-02-12',33514,'Field Services - 1630'),(2813,'2012-02-14 07:39:38',NULL,52643,'Luke Furlong','Glebe','2012-02-05',43319,'Training - 3719'),(2814,'2012-02-14 07:40:49',NULL,52643,'Luke Furlong','Glebe','2012-02-12',43319,'Training - 3719'),(2815,'2012-02-14 07:41:11',NULL,53972,'Scott Archbold','eleebana','2012-02-05',45580,'Training - 3719'),(2816,'2012-02-14 07:41:47',NULL,53972,'Scott Archbold','eleebana','2012-02-12',45580,'Training - 3719'),(2817,'2012-02-06 07:56:16',1379,40916,'Steven Hunt','Hilltop (s Highlands)','2012-02-05',40055,'Field Services - 1616'),(2818,'2012-02-06 08:00:19',1380,40916,'Steven Hunt','Hilltop (s Highlands)','2012-02-05',40055,'Field Services - 1616'),(2819,'2012-02-13 18:59:50',1381,49156,'Luke Browne','Paddington','2012-02-12',43319,'Training - 3719'),(2820,'2012-02-14 07:51:46',NULL,52643,'Luke Furlong','Glebe','2012-02-12',43319,'Training - 3719'),(2821,'2012-02-14 07:55:12',NULL,50229,'David Robertson','Sutherland','2012-02-12',38050,'Field Services - 1619'),(2822,'2012-02-14 07:57:31',NULL,50229,'David Robertson','Sutherland','2012-01-15',38050,'Field Services - 1619'),(2823,'2012-02-14 07:59:14',NULL,50229,'David Robertson','Sutherland','2012-01-22',38050,'Field Services - 1619'),(2824,'2012-02-14 07:59:59',NULL,50229,'David Robertson','Sutherland','2012-01-29',38050,'Field Services - 1619'),(2825,'2012-02-14 08:01:23',NULL,50229,'David Robertson','Sutherland','2012-02-05',38050,'Field Services - 1619'),(2826,'2012-02-14 07:59:58',1382,47713,'benjamin levi','Darlington','2012-01-22',40055,'oatley overhead - 1615'),(2827,'2012-02-14 08:01:14',1383,47713,'benjamin levi','Darlington','2012-01-29',40055,'oatley overhead - 1615'),(2828,'2012-02-14 08:02:24',1384,47713,'benjamin levi','Darlington','2012-02-05',40055,'oatley overhead - 1615'),(2829,'2012-02-14 08:03:25',1385,47713,'benjamin levi','Darlington','2012-02-12',40055,'oatley overhead - 1615'),(2830,'2012-02-14 07:50:59',1386,52808,'Alex Phillis','Sylvania','2012-02-05',40055,'oatley 0verhead - 1615'),(2831,'2012-02-14 07:39:02',1387,53946,'Shane Lyons','Menai','2012-01-15',40055,'oatley overhead 1615'),(2832,'2012-02-14 07:40:27',1388,53946,'Shane Lyons','Menai','2012-01-29',40055,'oatley overhead 1615'),(2833,'2012-02-14 07:41:45',1389,53946,'Shane Lyons','Menai','2012-02-05',40055,'oatley overhead 1615'),(2834,'2012-02-14 08:38:08',NULL,45384,'Gary Bailey','Merewether','2012-02-12',43407,'Metering Technology - 4611'),(2835,'2012-02-14 08:38:18',NULL,43336,'Mike Ringland','Baulkham Hills','2012-02-12',45261,'Operating Standards & Accreditation - 6908'),(2836,'2012-02-14 08:40:13',NULL,43336,'Mike Ringland','Baulkham Hills','2012-02-12',45261,'Operating Standards & Accreditation - 6908'),(2837,'2012-02-13 08:02:18',1390,42460,'Freddy Xerri','Narellan Vale','2012-02-12',54170,'Field Services - 1623'),(2838,'2012-02-06 08:02:40',1391,50059,'Rowan Williams','Macquarie Fields','2012-02-05',38050,'Field Services - 1619'),(2839,'2012-02-14 09:14:25',1392,50059,'Rowan Williams','Macquarie Fields','2012-02-12',38050,'Field Services - 1619'),(2840,'2012-02-06 08:08:37',1393,54063,'Antonio Lupo','Peakhurst','2012-02-05',38050,'OATLEY SUBS - 1619'),(2841,'2012-02-14 09:17:39',1394,54063,'Antonio Lupo','Peakhurst','2012-02-12',38050,'1619'),(2842,'2012-02-14 09:48:16',NULL,48359,'Patrick Chater','Heathcote','2012-02-12',40055,'Field Services - 3607'),(2843,'2012-02-14 09:56:25',NULL,53009,'Robert Whitton','Sutherland','2012-02-12',40055,'Field Services - 1609'),(2844,'2012-02-14 09:57:18',NULL,39730,'Michael Hudson','Lisarow','2012-02-12',47571,'Central Coast Area - 1667'),(2845,'2012-02-14 10:19:23',NULL,54054,'Mark Hanratty','Narellan Vale','2012-02-12',42156,'Training - 3719'),(2846,'2012-02-14 07:31:45',1395,48149,'Jonathon Apps','Quakers Hill','2012-02-12',39713,'Field Services - 1631'),(2847,'2012-02-13 07:03:07',1396,47965,'Angelo Pandzic','Berala','2012-02-12',39713,'Field Services - 1631'),(2848,'2012-02-14 10:27:52',1397,48788,'David Sloan','Wentworthville','2012-02-12',39713,'Field Services - 1631'),(2849,'2012-02-14 11:17:15',1398,44072,'Cameron Rix','Elderslie (camden)','2012-02-05',28598,'Field Services - 1608'),(2850,'2012-02-14 11:09:54',1399,52683,'matthew thomson','Llandilo','2012-02-12',28598,'Field Services - 1608'),(2851,'2012-02-14 13:14:09',1400,52634,'David Leung','Blacktown','2012-02-12',26654,'homebush'),(2852,'2012-02-14 08:17:46',1401,53950,'matthew muir','Woonona','2012-01-15',40055,'oatley overhead -1615'),(2853,'2012-02-14 08:18:53',1402,53950,'matthew muir','Woonona','2012-01-22',40055,'oatley overhead -1615'),(2854,'2012-02-14 08:20:15',1403,53950,'matthew muir','Woonona','2012-01-29',40055,'oatley overhead -1615'),(2855,'2012-02-14 08:21:56',1404,53950,'matthew muir','Woonona','2012-02-05',40055,'oatley overhead -1615'),(2856,'2012-02-14 08:22:51',1405,53950,'matthew muir','Woonona','2012-02-12',40055,'oatley overhead -1615'),(2857,'2012-02-14 13:43:20',1406,40257,'Mario Guerrera','Willoughby','2012-02-12',36592,'Field Services - 1635'),(2858,'2012-02-14 13:45:02',1407,40257,'Mario Guerrera','Willoughby','2012-02-12',36592,'Field Services - 1635'),(2859,'2012-02-14 13:54:33',1408,42460,'Freddy Xerri','Narellan Vale','2012-02-12',54170,'Field Services - 1623'),(2860,'2012-02-14 15:06:18',NULL,40996,'Elvis De Carlo','Frenchs Forest East','2012-02-12',36592,'Field Services - 1632'),(2861,'2012-02-13 10:14:41',1409,41072,'Max Del Boccio','Concord West','2012-02-12',33514,'Field Services - 1630'),(2862,'2012-02-13 15:25:00',1410,47900,'Greg Scott','Glossodia','2012-02-12',33514,'Field Services - 1630'),(2863,'2012-02-13 15:22:34',1411,49743,'Benjamin Tatham','Caringbah','2012-02-12',33514,'Training - 3719'),(2864,'2012-02-04 14:29:02',1412,51414,'Ravi Chaudhary','Rooty Hill','2012-02-05',47311,'Customer Connections Services - 1669'),(2865,'2012-02-11 14:08:09',1413,51414,'Ravi Chaudhary','Rooty Hill','2012-02-12',47311,'Customer Connections Services - 1669'),(2866,'2012-02-04 14:31:57',1414,52149,'Minh Hai Tran','West Hoxton','2012-02-05',47311,'Customer Connections Services - 1669'),(2867,'2012-02-13 12:48:32',1415,55622,'R Lombardo','Horningsea Park','2012-02-12',43319,'silverwater learning centre'),(2868,'2012-02-13 12:50:15',1416,55622,'R Lombardo','Horningsea Park','2012-02-12',33514,'field services - 1630'),(2869,'2012-02-13 14:35:11',1417,55627,'Robert Nicholls','Revesby','2012-02-12',43319,'Silverwater Learning Centre 3715'),(2870,'2012-02-13 14:37:59',1418,55627,'Robert Nicholls','Revesby','2012-02-12',33514,'Field Services 1630'),(2871,'2012-02-13 13:18:29',1419,55629,'Edward Ranjan','Minto','2012-02-12',43319,'Silverwater Learning Centre 3715'),(2872,'2012-02-13 13:21:10',1420,55629,'Edward Ranjan','Minto','2012-02-12',33514,'Field Services 1630'),(2873,'2012-02-13 14:40:31',1421,55629,'Edward Ranjan','Minto','2012-02-12',33514,'Field Services 1630'),(2874,'2012-02-13 12:57:22',1422,55632,'alessandro tilocca','Leppington','2012-02-12',43319,'silverwater learning centre'),(2875,'2012-02-13 12:59:58',1423,55632,'alessandro tilocca','Leppington','2012-02-12',33514,'field services 1630'),(2876,'2012-02-14 13:52:06',1424,49747,'S.PHILLIPS','Georges Hall','2012-01-08',33514,'1630'),(2877,'2012-02-14 13:53:15',1425,49747,'S.PHILLIPS','Georges Hall','2012-01-08',33514,'1630'),(2878,'2012-02-14 13:54:42',1426,49747,'S.PHILLIPS','Georges Hall','2012-01-08',33514,'1630'),(2879,'2012-02-14 15:01:25',1427,51380,'Dean Davies','Weston (newcastle)','2012-02-12',45931,'Area Management - Lower Hunter - 1648'),(2880,'2012-02-14 15:35:09',1428,42643,'Robert Medved','Toongabbie','2012-02-12',31584,'Project Services & Alliance Management - 1912'),(2881,'2012-02-06 07:32:48',1429,38949,'Robert Broad','Chifley (sydney)','2012-02-05',28598,'Field Services - 1608'),(2882,'2012-02-14 06:24:38',1430,38949,'Robert Broad','Chifley (sydney)','2012-02-12',28598,'Field Services - 1608'),(2883,'2012-02-14 08:05:34',1431,38949,'Robert Broad','Chifley (sydney)','2012-02-12',28598,'Field Services - 1608'),(2884,'2012-02-14 07:19:37',1432,52166,'Tuan Bui','Fairfield','2012-02-12',39713,'Field Services - 1631'),(2885,'2012-02-14 16:39:50',1433,52117,'Brett Mcandrew','Plumpton','2012-02-12',39713,'Field Services - 1631'),(2886,'2012-02-15 06:49:30',NULL,47965,'Angelo Pandzic','Berala','2012-02-12',39713,'Field Services - 1631'),(2887,'2012-02-14 10:23:45',1434,50225,'Jason Prior','south windsor','2012-02-12',39713,'Field Services - 1631'),(2888,'2012-02-14 10:02:07',1435,52115,'Matthew Powell','Point Clare','2012-02-12',39713,'Field Services - 1631'),(2889,'2012-02-14 10:16:17',1436,54045,'Richie Coombes','Quakers Hill','2012-02-12',39713,'Training - 3719'),(2890,'2012-01-30 14:45:20',1437,54081,'Efrem Reyes','Kellyville','2012-01-29',39713,'Training - 3719'),(2891,'2012-02-15 06:58:04',NULL,52508,'Maverick Quist','Glendale','2012-02-12',45150,'Training - 3719'),(2892,'2012-02-15 07:13:00',NULL,46029,'Scott Bell','Boat Harbour','2012-02-12',45150,'Training - 3714'),(2893,'2012-02-15 07:16:15',NULL,48497,'Richard Azevedo','Kingsgrove','2012-02-12',38050,'Field Services - 1619'),(2894,'2012-02-15 06:49:15',1438,46462,'Michael Loomes','Frenchs Forest','2012-02-12',36592,'Field Services - 1632'),(2895,'2012-02-15 07:18:27',NULL,48494,'Nick Speranza','Northmead','2012-02-12',38050,'Field Services - 1619'),(2896,'2012-02-15 07:30:22',NULL,55470,'Thomas Peter Loiselle','Bowen Mountain','2012-02-12',47263,'Training - 3719'),(2897,'2012-02-06 07:19:13',1439,41241,'Douglas Elton','Mount Kuring-gai','2012-02-05',37827,'DOR 1633'),(2898,'2012-02-14 07:21:32',1440,41241,'Douglas Elton','Mount Kuring-gai','2012-02-12',37827,'DOR 1633'),(2899,'2012-02-15 07:40:02',NULL,54060,'Jai Lapham','Burraneer','2012-02-12',47263,'Training - 3719'),(2900,'2012-02-06 07:08:26',1441,54056,'Benjamin Johnson','Frenchs Forest','2012-02-05',39713,'Training - 3719'),(2901,'2012-02-13 07:21:16',1442,49075,'Likhit Khamphimno','Silverdale','2012-02-12',39713,'Field Services - 1631'),(2902,'2012-02-15 08:37:45',1443,41433,'frank soballa','Seven Hills','2012-02-12',28598,'east subs 1608'),(2903,'2012-02-13 07:09:56',1444,50196,'zachary smith','Aberglasslyn','2012-02-12',45931,'Area Management - Lower Hunter - 1648'),(2904,'2012-02-15 08:47:59',NULL,48567,'Paul Cox','Revesby','2012-02-12',36759,'Field Services - 1665'),(2905,'2012-02-15 09:04:33',NULL,51730,'Michelle Hanson','Kariong','2012-02-12',48392,'Contestability - 2507'),(2906,'2012-02-13 07:52:33',1445,47894,'Simon Cutajar','Revesby','2012-02-12',41040,'Field Services - 1621'),(2907,'2012-02-13 07:54:45',1446,47894,'Simon Cutajar','Revesby','2012-02-12',41040,'Field Services - 1621'),(2908,'2012-02-07 14:32:48',1447,50160,'Matthew','East Maitland','2012-02-05',44804,'Maitland OH Field Services 1660'),(2909,'2012-02-15 09:06:35',1448,50160,'Matthew Butler','East Maitland','2012-02-12',44804,'Area Management - Lower Hunter - 1660'),(2910,'2012-01-18 13:59:02',1449,50170,'Mathew Riding','Hillsborough','2012-01-15',44804,'Area Management - Lower Hunter - 1660'),(2911,'2012-02-14 08:13:46',1450,46303,'Matthew Mackay','Holsworthy','2012-02-12',28598,'Field Services - 1608'),(2912,'2012-02-14 08:06:22',1451,49092,'con panagopoulos','Kingsgrove','2012-02-12',28598,'east subs'),(2913,'2012-02-15 10:59:38',NULL,52505,'Steven Kiley','Mayfield','2012-02-12',45150,'Training - 3719'),(2914,'2012-01-30 07:25:26',1452,41406,'Bradley Keep','Blacktown','2012-01-29',28598,'Field Services - 1608'),(2915,'2012-02-15 11:57:28',1453,41406,'Bradley Keep','Blacktown','2012-02-12',28598,'Field Services - 1608'),(2916,'2012-02-11 12:45:13',1454,48807,'Glenn Ridge','Wyoming (gosford)','2012-02-12',39713,'Field Services - 1631'),(2917,'2012-02-14 07:04:29',1455,48200,'Joshua Porter','Sutherland','2012-02-12',42357,'Field Services - 3719'),(2918,'2012-02-14 07:17:52',1456,50708,'Matthew Canellis','Revesby','2012-02-19',43319,'Training - 3719'),(2919,'2012-02-14 07:11:26',1457,51376,'THANH BUI','St Johns Park','2012-02-12',42357,'1609'),(2920,'2012-02-15 12:54:17',NULL,47529,'Stuart Sweeney','Cardiff South','2012-02-19',43336,'Operating Standards & Accreditation - 6908'),(2921,'2012-02-15 12:55:09',NULL,47529,'Stuart Sweeney','Cardiff South','2012-02-19',43336,'Operating Standards & Accreditation - 6908'),(2922,'2012-02-15 13:34:43',NULL,40802,'Robert Hill','Reedy Creek','2012-02-19',45290,'Metering Operations - 4611'),(2923,'2012-02-15 13:51:47',NULL,40802,'Robert Hill','Reedy Creek','2012-02-12',45290,'Metering Operations - 4611'),(2924,'2012-02-15 13:53:35',NULL,40802,'Robert Hill','Reedy Creek','2012-02-05',45290,'Metering Operations - 4611'),(2925,'2012-02-15 11:20:30',1458,40980,'Charles Vindin','St Ives','2012-02-12',39713,'Field Services - 1631'),(2926,'2012-02-15 14:38:06',NULL,53980,'Mitchell Ronan','Caves Beach (swansea)','2012-02-12',45150,'Training - 3719'),(2927,'2012-02-15 14:38:12',NULL,41858,'Dennis Hogan','Canton Beach','2012-02-12',39580,'Field Services - 1629'),(2928,'2012-02-10 07:19:41',1459,35211,'Michael Williamson','Werrington County','2012-01-29',26654,'Field Services - 1617'),(2929,'2012-02-10 08:45:35',1460,35211,'Michael Williamson','Werrington County','2012-02-05',26654,'Field Services - 1617'),(2930,'2012-02-13 12:03:13',1461,35211,'Michael Williamson','Werrington County','2012-02-12',26654,'Field Services - 1615'),(2931,'2012-02-15 07:42:32',1462,48378,'Gavin Johns','Thornton','2012-02-12',45931,'Area Management - Lower Hunter - 1648'),(2932,'2012-02-15 07:46:14',1463,48378,'Gavin Johns','Thornton','2012-02-05',45931,'Area Management - Lower Hunter - 1648'),(2933,'2012-02-10 09:08:30',1464,53926,'Shayne Bellingham','Emu Heights (penrith)','2012-02-05',26654,'field services 1615'),(2934,'2012-02-15 08:45:00',1465,53926,'Shayne Bellingham','Emu Heights (penrith)','2012-02-12',26654,'field training 1615'),(2935,'2012-02-15 14:52:45',1466,49119,'Rhys Brooker','East Maitland','2012-02-12',45931,'Area Management - Lower Hunter - 1648'),(2936,'2012-02-15 14:22:15',1467,52651,'Dominic Britt','Canterbury','2012-02-12',42357,'Training - 3719'),(2937,'2012-02-15 14:24:39',1468,52651,'Dominic Britt','Canterbury','2012-01-29',42357,'Training - 3719'),(2938,'2012-02-10 09:13:31',1469,53955,'Morgan Ryall','Maroubra Junction','2012-01-29',26654,'field services - 1615'),(2939,'2012-02-15 08:48:27',1470,53955,'Morgan Ryall','Maroubra Junction','2012-02-12',26654,'field training - 1615'),(2940,'2012-02-15 09:36:08',1471,53956,'Thomas Shea','Peakhurst','2012-02-12',26654,'feild services 1615'),(2941,'2012-02-15 08:54:50',1472,53963,'Hai Vuong','Liverpool','2012-02-12',26654,'field training 1516'),(2942,'2012-02-07 09:31:16',1473,55614,'justin field','Camperdown','2012-02-05',26654,'6262'),(2943,'2012-02-07 12:05:05',1474,55619,'Liam Keyte','St Ives','2012-02-05',26654,'Field Services - 1616'),(2944,'2012-02-13 06:47:00',1475,48723,'robert xerri','Narellan Vale','2012-02-12',42357,'DOR'),(2945,'2012-02-13 06:43:22',1476,50855,'Paul Hulse','Eschol Park','2012-02-05',42357,'Field Services - 1609'),(2946,'2012-02-15 14:56:37',1477,51380,'Dean Davies','Weston (newcastle)','2012-02-12',45931,'Area Management - Lower Hunter - 1648'),(2947,'2012-02-15 15:17:34',NULL,47701,'Ben King','Macquarie Park','2012-02-12',33514,'Field Services - 1630'),(2948,'2012-02-15 21:22:28',1478,48604,'Daniel Blomfield','Panania','2012-02-19',42357,'Field Services - 1609'),(2949,'2012-02-16 06:39:08',NULL,53948,'Timothy Matthews','Ermington','2012-02-19',43319,'Training - 3719'),(2950,'2012-02-16 06:40:29',1479,48293,'Brent Mccaan','Redfern','2012-02-12',28598,'Field Services - 1608'),(2951,'2012-02-16 06:57:40',NULL,52593,'Andrew Clark','Kemps Creek','2012-02-12',33514,'Training - 3719'),(2952,'2012-02-16 06:45:31',1480,49696,'Mark Bridge','Revesby','2012-02-19',41040,'Field Services - 1621'),(2953,'2012-02-16 07:00:12',1481,51469,'michele neden','Thirroul','2012-02-19',47311,'field services 1669'),(2954,'2012-02-16 07:04:46',1482,52150,'Simon Pintabona','Pyrmont','2012-02-19',47311,'Customer Connections Services - 1669'),(2955,'2012-02-16 07:10:27',NULL,55482,'Michael T Ryan','Beverly Hills','2012-02-12',28598,'Field Services - 1908'),(2956,'2012-02-16 07:13:59',NULL,54052,'Tully Giles-Cook','Matraville','2012-02-12',47263,'Training - 3719'),(2957,'2012-02-16 07:14:30',NULL,47791,'Glen Meier','Randwick','2012-02-19',46351,'Field Services - 1610'),(2958,'2012-02-16 07:02:54',1483,47827,'Brian Prastin','Tenambit','2012-02-12',45931,'Area Management - Lower Hunter - 1660'),(2959,'2012-02-16 07:23:03',NULL,48408,'Frank Allara','Riverwood','2012-02-19',46351,'Field Services - 1610'),(2960,'2012-02-11 11:24:43',1484,43249,'Lindsay Bolstad','Chester Hill','2012-02-12',36759,'Training - 3715'),(2961,'2012-02-11 11:08:12',1485,47934,'Tim Hill','Greystanes','2012-02-12',36759,'hr'),(2962,'2012-02-10 08:07:47',1486,55601,'Henry Arancibia','Randwick','2012-02-12',36759,'HR'),(2963,'2012-02-11 11:15:46',1487,55601,'Henry Arancibia','Randwick','2012-02-12',36759,'hr'),(2964,'2012-02-10 07:39:34',1488,55602,'christopher arnold','Dee Why','2012-02-12',36759,'hr'),(2965,'2012-02-11 10:56:58',1489,55602,'christopher arnold','Dee Why','2012-02-12',36759,'hr'),(2966,'2012-02-14 13:53:49',1490,55602,'christopher arnold','Dee Why','2012-02-19',36759,'hr'),(2967,'2012-02-10 07:54:57',1491,55604,'jamie baker','Carlton','2012-02-12',36759,'hr'),(2968,'2012-02-11 11:18:13',1492,55604,'jamie baker','Carlton','2012-02-12',36759,'hr'),(2969,'2012-02-10 08:15:49',1493,55606,'dion beattie','Gymea Bay','2012-02-12',36759,'hr'),(2970,'2012-02-11 11:11:53',1494,55606,'dion beatie','Gymea Bay','2012-02-12',36759,'hr'),(2971,'2012-02-14 13:57:45',1495,55606,'dion beatie','Gymea Bay','2012-02-19',36759,'hr'),(2972,'2012-02-13 07:18:50',1496,47676,'Ernesto Ocampo','Dee Why','2012-02-12',39713,'Field Services - 1631'),(2973,'2012-02-16 07:54:55',1497,46362,'Glenn Marlin','Bradbury','2012-02-19',54170,'Homebush underground 1623'),(2974,'2012-02-16 07:57:19',1498,40578,'michael fischer','Alfords Point','2012-02-12',40055,'oatley overhead 1616'),(2975,'2012-02-16 07:43:35',1499,49745,'Kim Ryan','warilla','2012-02-12',40055,'Field Services - 1616'),(2976,'2012-02-13 14:57:24',1500,50275,'anthony o\'sullivan','Bexley','2012-02-12',40055,'oatley overhead 1616'),(2977,'2012-02-13 15:01:25',1501,50603,'josh davison','Heathcote','2012-02-12',40055,'oatley overhead 1616'),(2978,'2012-02-13 15:04:03',1502,50603,'josh davison','Heathcote','2012-02-05',40055,'oatley overhead 1616'),(2979,'2012-02-14 07:49:04',1503,51394,'matthew patrikiou-smith','Cronulla','2012-02-12',40055,'oatley over head'),(2980,'2012-02-16 08:18:21',NULL,35225,'Robert Cox','Five Dock','2012-02-19',46351,'Field Services - 1610'),(2981,'2012-02-16 08:32:44',NULL,43683,'Paul Alexander','Gymea Bay','2012-02-12',34882,'Training - 3712'),(2982,'2012-02-06 07:32:19',1504,48189,'David Lee','Sutherland','2012-02-05',40055,'Field Services - 1616'),(2983,'2012-02-15 07:43:46',1505,48211,'Grant Davis','Bulli','2012-02-12',40055,'Field Services - 1616'),(2984,'2012-02-06 07:35:19',1506,48216,'joel chapman','Bangor','2012-02-05',40055,'1616 oatley'),(2985,'2012-02-15 07:53:28',1507,49681,'Aaron Cupples','Newtown','2012-02-12',40055,'Training - 3719'),(2986,'2012-02-13 09:03:35',1508,51367,'Ben O\'Keefe','Ingleburn','2012-02-12',40055,'oatley overhead-1616'),(2987,'2012-02-16 08:45:09',1509,51456,'mark lester','Botany','2012-02-12',28598,'east subs 1608'),(2988,'2012-02-16 09:21:10',NULL,48436,'Budi Cahyadi','ashfield','2012-02-19',44786,'Service Delivery - 5300'),(2989,'2012-02-16 10:12:39',NULL,52603,'Joshua Davison','Heathcote','2012-02-05',40055,'Training - 3719'),(2990,'2012-02-16 10:29:40',NULL,52603,'Joshua Davison','Heathcote','2012-02-12',40055,'Training - 3719'),(2991,'2012-02-16 10:36:40',NULL,46351,'Kane Kennett','Wyoming (gosford)','2012-02-19',48035,'Field Services - 1610'),(2992,'2012-02-16 11:34:29',NULL,44657,'Mana Pholsena','Green Valley','2012-02-05',49303,'Control & Protection - Sydney - 1831'),(2993,'2012-02-16 11:50:28',NULL,44684,'Kerri Mccaw','Seaham','2012-02-19',50738,'Workforce Planning & Management - 4301'),(2994,'2012-02-16 12:15:59',NULL,27472,'Andrew Milne','Avoca Beach','2012-02-12',41399,'Technical Services - 1716'),(2995,'2012-02-16 12:23:47',NULL,27472,'Andrew Milne','Avoca Beach','2012-02-12',41399,'Technical Services - 1716'),(2996,'2012-02-13 07:09:45',1510,47144,'brian park','Shelly Beach','2012-02-12',37827,'hornsby overhead'),(2997,'2012-02-16 13:31:11',1511,50055,'David Doret','Macquarie Fields','2012-02-12',28598,'Field Services - 1608'),(2998,'2012-02-13 07:13:16',1512,52641,'trent park','Shelly Beach','2012-02-12',37827,'hornsby overhead'),(2999,'2012-02-16 07:07:27',1513,47465,'Natalie Fox','Belmore','2012-02-19',47311,'Field Services - 1669'),(3000,'2012-02-16 15:23:30',NULL,44782,'Mark Miller','Seven Hills','2012-02-19',46748,'Business Services - 4806'),(3001,'2012-02-16 15:41:15',NULL,48318,'Frank Taylor','Gladesville','2012-02-19',42707,'Contact Centre - Sydney - 4302'),(3002,'2012-02-16 15:45:19',NULL,48318,'Frank Taylor','Gladesville','2012-02-19',40904,'Contact Centre - Sydney - 4302'),(3003,'2012-02-16 15:46:07',NULL,24522,'Ronald Full','Hillsdale','2012-01-29',54170,'Field Services - 1623'),(3004,'2012-01-25 14:33:53',1514,48357,'Keith Donaldson','Woodberry','2012-01-22',45931,'Area Management - Lower Hunter - 1648'),(3005,'2012-02-26 00:18:23',NULL,47357,'Aaron Hughes','Sydney','2012-02-19',43880,'Transmission Substations - Newcastle 1730');

--
-- Table structure for table `traveltime_transport_types`
--

CREATE TABLE `traveltime_transport_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `acronym` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `acronym` (`acronym`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `traveltime_transport_types`
--

INSERT INTO `traveltime_transport_types` VALUES (1,'AG Vehicle','AGV'),(2,'Private','PVT'),(3,'Public','PUB'),(4,'Taxi','TAX');

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `service_number` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY (`service_number`,`role_id`),
  KEY `fk_roles_role_id` (`role_id`),
  CONSTRAINT `user_roles_ibfk_1` FOREIGN KEY (`service_number`) REFERENCES `users` (`service_number`) ON DELETE CASCADE,
  CONSTRAINT `user_roles_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `permission_roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_roles`
--

INSERT INTO `user_roles` VALUES (16148,1),(18713,1),(20750,1),(21014,1),(21389,1),(21393,1),(21900,1),(22166,1),(22169,1),(22706,1),(22971,1),(24712,1),(24727,1),(24747,1),(24774,1),(24784,1),(26012,1),(26013,1),(26169,1),(26654,1),(26765,1),(26809,1),(27256,1),(27414,1),(27459,1),(27700,1),(27732,1),(28149,1),(28274,1),(28505,1),(28577,1),(28598,1),(28606,1),(28607,1),(28638,1),(28654,1),(29026,1),(29478,1),(29535,1),(29956,1),(29980,1),(29985,1),(30001,1),(30004,1),(30058,1),(30158,1),(30270,1),(30396,1),(30538,1),(30703,1),(30710,1),(30717,1),(30719,1),(30724,1),(30753,1),(30755,1),(30821,1),(30844,1),(30993,1),(31002,1),(31451,1),(31563,1),(31564,1),(31582,1),(31584,1),(31607,1),(31609,1),(31672,1),(32304,1),(32357,1),(32384,1),(32410,1),(32411,1),(32412,1),(32414,1),(32544,1),(32588,1),(33057,1),(33196,1),(33219,1),(33259,1),(33423,1),(33459,1),(33467,1),(33482,1),(33514,1),(33593,1),(33596,1),(33606,1),(33629,1),(33630,1),(33689,1),(33908,1),(34001,1),(34060,1),(34062,1),(34074,1),(34081,1),(34132,1),(34158,1),(34168,1),(34187,1),(34383,1),(34474,1),(34475,1),(34511,1),(34573,1),(34769,1),(34778,1),(34882,1),(34936,1),(34969,1),(34992,1),(35058,1),(35064,1),(35087,1),(35129,1),(35680,1),(35880,1),(35997,1),(36301,1),(36592,1),(36759,1),(36815,1),(36820,1),(36974,1),(36982,1),(37062,1),(37487,1),(37779,1),(37805,1),(37827,1),(37853,1),(38050,1),(38087,1),(38177,1),(38194,1),(38242,1),(38289,1),(38369,1),(38599,1),(38775,1),(38886,1),(38908,1),(39045,1),(39073,1),(39074,1),(39075,1),(39076,1),(39085,1),(39580,1),(39584,1),(39678,1),(39713,1),(39725,1),(39727,1),(39730,1),(39734,1),(39798,1),(39803,1),(39810,1),(39820,1),(39825,1),(39885,1),(39921,1),(40026,1),(40032,1),(40055,1),(40136,1),(40154,1),(40165,1),(40212,1),(40253,1),(40339,1),(40348,1),(40368,1),(40382,1),(40395,1),(40580,1),(40644,1),(40723,1),(40727,1),(40731,1),(40735,1),(40808,1),(40860,1),(40863,1),(40864,1),(40904,1),(41040,1),(41058,1),(41068,1),(41122,1),(41393,1),(41399,1),(41403,1),(41437,1),(41440,1),(41466,1),(41525,1),(41680,1),(41789,1),(41803,1),(41870,1),(41963,1),(42002,1),(42013,1),(42017,1),(42024,1),(42027,1),(42046,1),(42140,1),(42141,1),(42143,1),(42148,1),(42150,1),(42156,1),(42181,1),(42226,1),(42318,1),(42357,1),(42543,1),(42631,1),(42652,1),(42707,1),(42731,1),(42993,1),(43014,1),(43028,1),(43051,1),(43063,1),(43094,1),(43098,1),(43129,1),(43183,1),(43319,1),(43336,1),(43352,1),(43391,1),(43407,1),(43416,1),(43423,1),(43426,1),(43439,1),(43466,1),(43526,1),(43632,1),(43666,1),(43709,1),(43720,1),(43731,1),(43761,1),(43776,1),(43785,1),(43788,1),(43818,1),(43837,1),(43852,1),(43861,1),(43880,1),(43926,1),(43927,1),(43944,1),(44013,1),(44014,1),(44035,1),(44050,1),(44051,1),(44052,1),(44067,1),(44079,1),(44084,1),(44091,1),(44092,1),(44102,1),(44106,1),(44134,1),(44164,1),(44235,1),(44263,1),(44285,1),(44331,1),(44336,1),(44384,1),(44393,1),(44424,1),(44425,1),(44429,1),(44430,1),(44436,1),(44446,1),(44463,1),(44492,1),(44517,1),(44572,1),(44590,1),(44599,1),(44609,1),(44616,1),(44639,1),(44673,1),(44679,1),(44684,1),(44702,1),(44706,1),(44778,1),(44781,1),(44783,1),(44786,1),(44794,1),(44804,1),(44886,1),(44892,1),(44924,1),(44942,1),(44943,1),(44952,1),(44955,1),(44967,1),(44975,1),(45007,1),(45011,1),(45029,1),(45121,1),(45140,1),(45150,1),(45151,1),(45158,1),(45164,1),(45183,1),(45196,1),(45212,1),(45213,1),(45241,1),(45247,1),(45261,1),(45270,1),(45281,1),(45289,1),(45290,1),(45292,1),(45324,1),(45358,1),(45364,1),(45381,1),(45383,1),(45422,1),(45436,1),(45511,1),(45545,1),(45580,1),(45628,1),(45654,1),(45667,1),(45669,1),(45685,1),(45701,1),(45730,1),(45737,1),(45738,1),(45768,1),(45770,1),(45792,1),(45814,1),(45820,1),(45821,1),(45888,1),(45898,1),(45907,1),(45921,1),(45931,1),(45971,1),(46010,1),(46056,1),(46079,1),(46109,1),(46113,1),(46123,1),(46175,1),(46202,1),(46229,1),(46307,1),(46351,1),(46360,1),(46390,1),(46393,1),(46419,1),(46429,1),(46440,1),(46444,1),(46447,1),(46448,1),(46524,1),(46525,1),(46526,1),(46537,1),(46545,1),(46591,1),(46621,1),(46665,1),(46666,1),(46696,1),(46703,1),(46713,1),(46715,1),(46724,1),(46726,1),(46738,1),(46739,1),(46745,1),(46747,1),(46748,1),(46751,1),(46797,1),(46828,1),(46836,1),(46845,1),(46867,1),(46912,1),(46918,1),(46924,1),(46926,1),(46932,1),(46940,1),(46955,1),(46964,1),(46989,1),(46997,1),(47012,1),(47014,1),(47015,1),(47032,1),(47055,1),(47058,1),(47064,1),(47070,1),(47075,1),(47090,1),(47095,1),(47111,1),(47124,1),(47125,1),(47126,1),(47127,1),(47133,1),(47135,1),(47136,1),(47145,1),(47170,1),(47201,1),(47203,1),(47227,1),(47255,1),(47263,1),(47293,1),(47309,1),(47311,1),(47320,1),(47321,1),(47333,1),(47343,1),(47344,1),(47347,1),(47351,1),(47360,1),(47363,1),(47375,1),(47381,1),(47396,1),(47399,1),(47422,1),(47437,1),(47495,1),(47498,1),(47500,1),(47571,1),(47573,1),(47591,1),(47597,1),(47672,1),(47735,1),(47745,1),(47748,1),(47750,1),(47760,1),(47761,1),(47785,1),(47797,1),(47801,1),(47804,1),(47815,1),(47831,1),(47840,1),(47861,1),(47876,1),(47878,1),(48020,1),(48027,1),(48035,1),(48042,1),(48046,1),(48069,1),(48142,1),(48147,1),(48253,1),(48266,1),(48321,1),(48327,1),(48328,1),(48334,1),(48355,1),(48358,1),(48364,1),(48372,1),(48374,1),(48388,1),(48392,1),(48400,1),(48421,1),(48423,1),(48520,1),(48521,1),(48546,1),(48616,1),(48660,1),(48697,1),(48698,1),(48724,1),(48822,1),(48857,1),(48868,1),(48878,1),(48886,1),(48905,1),(48908,1),(48951,1),(48990,1),(49001,1),(49019,1),(49029,1),(49033,1),(49245,1),(49267,1),(49271,1),(49276,1),(49303,1),(49361,1),(49367,1),(49411,1),(49412,1),(49417,1),(49421,1),(49423,1),(49448,1),(49453,1),(49523,1),(49574,1),(49599,1),(49647,1),(49649,1),(49664,1),(49710,1),(49711,1),(49748,1),(49795,1),(49808,1),(49859,1),(49916,1),(49923,1),(49924,1),(49926,1),(49929,1),(49953,1),(49956,1),(50000,1),(50024,1),(50078,1),(50081,1),(50089,1),(50092,1),(50308,1),(50394,1),(50421,1),(50436,1),(50442,1),(50488,1),(50527,1),(50568,1),(50587,1),(50598,1),(50608,1),(50618,1),(50632,1),(50738,1),(50810,1),(50818,1),(50838,1),(50913,1),(50916,1),(50922,1),(50927,1),(50938,1),(50970,1),(50991,1),(51007,1),(51013,1),(51060,1),(51062,1),(51080,1),(51106,1),(51109,1),(51115,1),(51121,1),(51160,1),(51162,1),(51178,1),(51265,1),(51527,1),(51529,1),(51531,1),(51532,1),(51552,1),(51568,1),(51628,1),(51710,1),(51740,1),(51758,1),(51768,1),(51783,1),(51795,1),(51824,1),(51834,1),(51835,1),(51912,1),(51950,1),(51972,1),(52058,1),(52385,1),(52396,1),(52460,1),(52488,1),(52816,1),(52836,1),(52849,1),(52872,1),(52981,1),(53181,1),(53188,1),(53197,1),(53198,1),(53212,1),(53241,1),(53247,1),(53251,1),(53262,1),(53271,1),(53294,1),(53342,1),(53471,1),(53489,1),(53495,1),(53513,1),(53544,1),(53567,1),(53578,1),(53622,1),(53673,1),(53674,1),(53696,1),(53770,1),(53788,1),(53789,1),(53796,1),(53798,1),(53875,1),(53900,1),(53913,1),(53916,1),(54124,1),(54132,1),(54170,1),(54230,1),(54398,1),(54510,1),(54575,1),(54639,1),(54703,1),(54713,1),(54715,1),(54807,1),(54880,1),(54900,1),(54901,1),(54966,1),(55094,1),(55182,1),(55229,1),(55386,1),(55393,1),(55433,1),(55506,1),(55783,1),(55874,1),(55889,1),(55892,1),(55948,1),(55998,1),(56084,1),(56090,1),(56302,1),(56367,1),(56372,1),(99935,1),(39887,2),(47187,2),(47802,2),(42094,7),(42815,7),(47187,8);


