insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (1, 100, 'Purchase', '4', PARSEDATETIME('09/01/2013 00:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', PARSEDATETIME('03/03/2013 22:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 1294.37);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (2, 1000, 'Task 1', PARSEDATETIME('16/12/2012 20:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('09/01/2013 00:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 100, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (3, 1001, 'Task 2', PARSEDATETIME('28/12/2012 03:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('09/01/2013 00:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 100, PARSEDATETIME('04/02/2013 16:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 640.37, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (4, 1002, 'Task 3', PARSEDATETIME('03/02/2013 06:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('04/02/2013 16:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 100, PARSEDATETIME('03/03/2013 22:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 654.00, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (5, 99, 'New Hire', '3', PARSEDATETIME('03/01/2013 13:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', null, '1', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (6, 990, 'Task 1', PARSEDATETIME('19/12/2012 18:48', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/01/2013 13:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 99, PARSEDATETIME('28/01/2013 05:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 592.57, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (7, 991, 'Task 2', PARSEDATETIME('25/01/2013 06:55', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('28/01/2013 05:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 99, PARSEDATETIME('20/02/2013 14:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 560.23, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (8, 992, 'Task 3', PARSEDATETIME('23/01/2013 01:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Angel C.', 99, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (9, 993, 'Task 4', PARSEDATETIME('04/02/2013 14:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Laia P.', 99, null, null, 'Created');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (10, 98, 'Purchase', '1', PARSEDATETIME('14/01/2013 18:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', null, '2', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (11, 980, 'Task 1', PARSEDATETIME('07/01/2013 10:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Fred G.', 98, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (12, 981, 'Task 2', PARSEDATETIME('24/12/2012 12:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('14/01/2013 18:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 98, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (13, 982, 'Task 3', PARSEDATETIME('21/12/2012 00:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('14/01/2013 18:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 98, null, null, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (14, 97, 'Purchase', '2', PARSEDATETIME('21/01/2013 19:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', null, '1', 1294.37);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (15, 970, 'Task 1', PARSEDATETIME('28/12/2012 05:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Frank T.', 97, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (16, 971, 'Task 2', PARSEDATETIME('03/01/2013 13:21', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Frank T.', 97, PARSEDATETIME('04/02/2013 16:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 640.37, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (17, 972, 'Task 3', PARSEDATETIME('31/01/2013 06:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('04/02/2013 16:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', 97, null, 654.00, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (18, 96, 'Sales', '2', PARSEDATETIME('08/01/2013 15:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', null, '3', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (19, 960, 'Task 1', PARSEDATETIME('10/12/2012 07:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 15:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 96, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (20, 961, 'Task 2', PARSEDATETIME('04/01/2013 07:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 15:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 96, PARSEDATETIME('01/02/2013 23:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 583.78, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (21, 962, 'Task 3', PARSEDATETIME('31/01/2013 06:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('01/02/2013 23:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 96, PARSEDATETIME('04/02/2013 15:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 64.40, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (22, 963, 'Task 4a', PARSEDATETIME('31/01/2013 04:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Paco P.', 96, null, null, 'Created');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (23, 95, 'Sales', '3', PARSEDATETIME('24/12/2012 15:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', PARSEDATETIME('18/01/2013 18:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 602.17);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (24, 950, 'Task 1', PARSEDATETIME('08/12/2012 20:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Angel C.', 95, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (25, 951, 'Task 2', PARSEDATETIME('10/12/2012 08:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 15:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 95, null, null, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (26, 952, 'Task 3', PARSEDATETIME('28/11/2012 03:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 15:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 95, null, null, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (27, 953, 'Task 4', PARSEDATETIME('17/12/2012 12:43', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 15:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 95, PARSEDATETIME('18/01/2013 18:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 602.17, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (28, 94, 'Leave Management', '3', PARSEDATETIME('12/01/2013 19:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', PARSEDATETIME('31/03/2013 09:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 1861.27);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (29, 940, 'Task 1', PARSEDATETIME('09/01/2013 03:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 19:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 94, PARSEDATETIME('30/01/2013 18:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 430.73, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (30, 941, 'Task 2', PARSEDATETIME('13/01/2013 01:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('30/01/2013 18:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 94, PARSEDATETIME('27/02/2013 21:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 675.42, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (31, 942, 'Task 3', PARSEDATETIME('03/02/2013 00:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('27/02/2013 21:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 94, PARSEDATETIME('08/03/2013 02:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 196.52, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (32, 943, 'Task 4', PARSEDATETIME('21/02/2013 00:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/03/2013 02:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 94, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (33, 944, 'Task 5', PARSEDATETIME('16/02/2013 12:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/03/2013 02:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 94, PARSEDATETIME('31/03/2013 09:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 558.60, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (34, 93, 'Sales', '4', PARSEDATETIME('28/12/2012 10:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', null, '3', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (35, 930, 'Task 1', PARSEDATETIME('15/12/2012 14:20', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('28/12/2012 10:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 93, PARSEDATETIME('29/12/2012 02:43', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 16.52, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (36, 931, 'Task 2', PARSEDATETIME('20/12/2012 02:23', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('29/12/2012 02:43', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 93, PARSEDATETIME('03/01/2013 20:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 137.30, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (37, 932, 'Task 3', PARSEDATETIME('08/12/2012 10:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/01/2013 20:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 93, PARSEDATETIME('05/01/2013 11:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 39.13, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (38, 933, 'Task 4a', PARSEDATETIME('08/12/2012 16:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('05/01/2013 11:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 93, null, null, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (39, 92, 'Sales', '2', PARSEDATETIME('18/01/2013 18:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', PARSEDATETIME('19/03/2013 21:55', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 1443.85);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (40, 920, 'Task 1', PARSEDATETIME('13/01/2013 21:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('18/01/2013 18:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 92, PARSEDATETIME('10/02/2013 12:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 546.12, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (41, 921, 'Task 2', PARSEDATETIME('14/01/2013 09:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Miguel K.', 92, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (42, 922, 'Task 4', PARSEDATETIME('02/02/2013 09:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('10/02/2013 12:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 92, PARSEDATETIME('05/03/2013 01:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 541.03, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (43, 923, 'Task 5', PARSEDATETIME('04/03/2013 05:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('05/03/2013 01:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 92, PARSEDATETIME('19/03/2013 21:55', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 356.70, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (44, 91, 'Sales', '0', PARSEDATETIME('16/01/2013 17:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', PARSEDATETIME('07/05/2013 03:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '3', 2648.67);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (45, 910, 'Task 1', PARSEDATETIME('11/01/2013 23:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('16/01/2013 17:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 91, PARSEDATETIME('26/01/2013 04:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 226.98, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (46, 911, 'Task 2', PARSEDATETIME('13/01/2013 08:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('26/01/2013 04:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 91, PARSEDATETIME('06/02/2013 19:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 279.37, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (47, 912, 'Task 3', PARSEDATETIME('22/01/2013 01:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/02/2013 19:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 91, PARSEDATETIME('07/03/2013 20:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 696.23, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (48, 913, 'Task 4a', PARSEDATETIME('18/02/2013 23:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/03/2013 20:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 91, PARSEDATETIME('04/04/2013 14:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 665.58, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (49, 914, 'Task 4b', PARSEDATETIME('18/03/2013 17:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('04/04/2013 14:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', 91, null, null, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (50, 915, 'Task 4c', PARSEDATETIME('10/03/2013 14:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('04/04/2013 14:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 91, PARSEDATETIME('18/04/2013 08:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 329.70, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (51, 916, 'Task 5', PARSEDATETIME('27/03/2013 09:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('18/04/2013 08:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 91, PARSEDATETIME('20/04/2013 20:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 60.17, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (52, 917, 'Task 6', PARSEDATETIME('13/04/2013 06:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('20/04/2013 20:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 91, PARSEDATETIME('29/04/2013 11:39', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 207.18, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (53, 918, 'Task 7', PARSEDATETIME('15/04/2013 03:19', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('29/04/2013 11:39', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 91, PARSEDATETIME('07/05/2013 03:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 183.45, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (54, 90, 'Leave Management', '0', PARSEDATETIME('21/01/2013 12:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', null, '1', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (55, 900, 'Task 1', PARSEDATETIME('02/01/2013 10:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Andrea M.', 90, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (56, 901, 'Task 2', PARSEDATETIME('04/01/2013 01:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('21/01/2013 12:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 90, PARSEDATETIME('04/02/2013 05:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 329.43, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (57, 902, 'Task 3', PARSEDATETIME('13/01/2013 18:50', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('04/02/2013 05:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 90, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (58, 903, 'Task 4', PARSEDATETIME('06/01/2013 21:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('04/02/2013 05:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 90, null, null, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (59, 89, 'New Hire', '1', PARSEDATETIME('15/01/2013 19:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', PARSEDATETIME('22/03/2013 01:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 1566.10);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (60, 890, 'Task 1', PARSEDATETIME('29/12/2012 18:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('15/01/2013 19:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 89, PARSEDATETIME('03/02/2013 17:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 453.23, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (61, 891, 'Task 2a', PARSEDATETIME('03/02/2013 15:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 17:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 89, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (62, 892, 'Task 2b', PARSEDATETIME('20/01/2013 09:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 17:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 89, null, null, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (63, 893, 'Task 3', PARSEDATETIME('15/01/2013 15:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 17:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 89, PARSEDATETIME('26/02/2013 14:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 549.77, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (64, 894, 'Task 4', PARSEDATETIME('06/02/2013 18:39', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('26/02/2013 14:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 89, PARSEDATETIME('28/02/2013 23:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 56.67, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (65, 895, 'Task 5', PARSEDATETIME('13/02/2013 18:20', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('28/02/2013 23:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 89, PARSEDATETIME('22/03/2013 01:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 506.43, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (66, 88, 'Leave Management', '2', PARSEDATETIME('07/01/2013 19:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', PARSEDATETIME('02/02/2013 05:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 609.23);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (67, 880, 'Task 1', PARSEDATETIME('10/12/2012 04:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 19:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 88, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (68, 881, 'Task 2', PARSEDATETIME('13/12/2012 04:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 19:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 88, null, 329.43, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (69, 882, 'Task 3', PARSEDATETIME('25/12/2012 18:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 19:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 88, null, null, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (70, 883, 'Task 4', PARSEDATETIME('29/12/2012 03:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 19:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 88, PARSEDATETIME('02/02/2013 05:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 609.23, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (71, 87, 'Sales', '1', PARSEDATETIME('21/01/2013 07:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', null, '1', 602.17);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (72, 870, 'Task 1', PARSEDATETIME('30/12/2012 21:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Andrea M.', 87, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (73, 871, 'Task 2', PARSEDATETIME('09/01/2013 01:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Fred G.', 87, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (74, 872, 'Task 3', PARSEDATETIME('01/01/2013 08:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Antonio N.', 87, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (75, 873, 'Task 4', PARSEDATETIME('09/01/2013 12:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('21/01/2013 07:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 87, PARSEDATETIME('07/02/2013 20:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 421.48, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (76, 874, 'Task 5', PARSEDATETIME('10/01/2013 11:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/02/2013 20:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 87, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (77, 875, 'Task 6', PARSEDATETIME('02/02/2013 01:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/02/2013 20:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 87, PARSEDATETIME('28/02/2013 00:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 483.68, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (78, 876, 'Task 7', PARSEDATETIME('08/02/2013 07:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('28/02/2013 00:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 87, null, null, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (79, 86, 'Travel Management', '0', PARSEDATETIME('24/12/2012 12:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', PARSEDATETIME('14/02/2013 09:23', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 1245.22);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (80, 860, 'Task 1', PARSEDATETIME('01/12/2012 18:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 12:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 86, PARSEDATETIME('26/12/2012 02:48', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 38.63, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (81, 861, 'Task 2', PARSEDATETIME('14/12/2012 01:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('26/12/2012 02:48', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 86, PARSEDATETIME('22/01/2013 22:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 668.15, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (82, 862, 'Task 3', PARSEDATETIME('17/01/2013 10:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('22/01/2013 22:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 86, PARSEDATETIME('14/02/2013 09:23', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 538.43, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (83, 85, 'Leave Management', '1', PARSEDATETIME('29/12/2012 22:40', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', null, '1', 609.23);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (84, 850, 'Task 1', PARSEDATETIME('27/12/2012 08:23', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('29/12/2012 22:40', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 85, PARSEDATETIME('16/01/2013 01:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 411.32, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (85, 851, 'Task 2', PARSEDATETIME('29/12/2012 22:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('16/01/2013 01:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 85, null, 329.43, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (86, 852, 'Task 3', PARSEDATETIME('12/01/2013 13:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('16/01/2013 01:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 85, null, null, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (87, 84, 'Expenses', '2', PARSEDATETIME('12/01/2013 03:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', null, '1', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (88, 840, 'Task 1', PARSEDATETIME('20/12/2012 07:20', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 03:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 84, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (89, 841, 'Task 2', PARSEDATETIME('30/12/2012 12:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Laia P.', 84, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (90, 842, 'Task 3', PARSEDATETIME('27/12/2012 06:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 03:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 84, null, null, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (91, 83, 'Sales', '1', PARSEDATETIME('01/01/2013 01:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', null, '1', 602.17);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (92, 830, 'Task 1', PARSEDATETIME('23/12/2012 03:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('01/01/2013 01:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 83, PARSEDATETIME('10/01/2013 14:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 229.18, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (93, 831, 'Task 2', PARSEDATETIME('28/12/2012 15:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Antonio N.', 83, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (94, 832, 'Task 3', PARSEDATETIME('05/01/2013 12:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('10/01/2013 14:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 83, null, null, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (95, 82, 'New Hire', '1', PARSEDATETIME('27/12/2012 21:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', null, '1', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (96, 820, 'Task 1', PARSEDATETIME('26/12/2012 10:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('27/12/2012 21:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 82, PARSEDATETIME('23/01/2013 06:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 632.82, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (97, 821, 'Task 2', PARSEDATETIME('09/01/2013 19:55', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('23/01/2013 06:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 82, PARSEDATETIME('12/02/2013 08:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 482.65, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (98, 822, 'Task 3', PARSEDATETIME('04/02/2013 09:40', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/02/2013 08:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 82, PARSEDATETIME('06/03/2013 13:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 533.00, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (99, 823, 'Task 4', PARSEDATETIME('23/02/2013 03:50', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/03/2013 13:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 82, PARSEDATETIME('20/03/2013 18:08', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 340.20, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (100, 824, 'Task 5', PARSEDATETIME('21/02/2013 08:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Andrea M.', 82, null, null, 'Created');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (101, 81, 'Sales', '0', PARSEDATETIME('07/01/2013 01:20', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', PARSEDATETIME('18/02/2013 22:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 1028.67);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (102, 810, 'Task 1', PARSEDATETIME('20/12/2012 18:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 01:20', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 81, null, 546.12, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (103, 811, 'Task 2', PARSEDATETIME('31/12/2012 23:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 01:20', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 81, PARSEDATETIME('31/01/2013 02:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 577.25, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (104, 812, 'Task 4', PARSEDATETIME('16/01/2013 07:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('31/01/2013 02:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 81, null, 541.03, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (105, 813, 'Task 5', PARSEDATETIME('10/01/2013 21:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('31/01/2013 02:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 81, PARSEDATETIME('08/02/2013 12:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 201.95, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (106, 814, 'Task 6', PARSEDATETIME('21/01/2013 07:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/02/2013 12:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 81, PARSEDATETIME('18/02/2013 22:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 249.47, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (107, 80, 'Leave Management', '1', PARSEDATETIME('11/01/2013 17:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', PARSEDATETIME('21/01/2013 14:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 236.62);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (108, 800, 'Task 1', PARSEDATETIME('27/12/2012 14:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('11/01/2013 17:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 80, null, 411.32, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (109, 801, 'Task 2', PARSEDATETIME('01/01/2013 12:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Maria A.', 80, null, 329.43, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (110, 802, 'Task 3', PARSEDATETIME('03/01/2013 17:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('11/01/2013 17:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 80, PARSEDATETIME('21/01/2013 14:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 236.62, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (111, 79, 'Sales', '3', PARSEDATETIME('14/01/2013 22:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', null, '2', 1028.67);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (112, 790, 'Task 1', PARSEDATETIME('18/12/2012 22:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('14/01/2013 22:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', 79, PARSEDATETIME('23/01/2013 07:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 200.83, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (113, 791, 'Task 2', PARSEDATETIME('15/01/2013 14:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('23/01/2013 07:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 79, null, 577.25, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (114, 792, 'Task 4', PARSEDATETIME('20/01/2013 23:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('23/01/2013 07:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 79, null, 541.03, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (115, 793, 'Task 5', PARSEDATETIME('23/01/2013 08:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('23/01/2013 07:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 79, PARSEDATETIME('26/01/2013 18:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 83.45, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (116, 794, 'Task 6', PARSEDATETIME('24/01/2013 15:20', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('26/01/2013 18:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 79, PARSEDATETIME('23/02/2013 20:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 674.10, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (117, 795, 'Task 7', PARSEDATETIME('18/02/2013 21:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('23/02/2013 20:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 79, null, null, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (118, 78, 'Sales', '0', PARSEDATETIME('12/01/2013 10:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', PARSEDATETIME('07/02/2013 14:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 627.97);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (119, 780, 'Task 1', PARSEDATETIME('01/01/2013 07:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Frank T.', 78, PARSEDATETIME('23/01/2013 07:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 200.83, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (120, 781, 'Task 2', PARSEDATETIME('02/01/2013 19:22', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('23/01/2013 07:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 78, null, 577.25, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (121, 782, 'Task 4', PARSEDATETIME('01/01/2013 03:20', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Peter S.', 78, null, 541.03, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (122, 783, 'Task 5', PARSEDATETIME('02/01/2013 11:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('23/01/2013 07:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 78, PARSEDATETIME('05/02/2013 19:55', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 324.52, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (123, 784, 'Task 6', PARSEDATETIME('19/01/2013 12:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('05/02/2013 19:55', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 78, PARSEDATETIME('07/02/2013 14:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 42.35, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (124, 77, 'Sales', '2', PARSEDATETIME('07/01/2013 02:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', PARSEDATETIME('15/02/2013 13:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 947.42);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (125, 770, 'Task 1', PARSEDATETIME('07/01/2013 05:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 02:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', 77, PARSEDATETIME('12/01/2013 08:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 125.50, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (126, 771, 'Task 2', PARSEDATETIME('08/01/2013 09:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 08:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 77, PARSEDATETIME('08/02/2013 21:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 661.47, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (127, 772, 'Task 3', PARSEDATETIME('18/01/2013 10:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/02/2013 21:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 77, PARSEDATETIME('15/02/2013 13:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 160.45, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (128, 76, 'Sales', '1', PARSEDATETIME('24/12/2012 01:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', null, '1', 947.42);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (129, 760, 'Task 1', PARSEDATETIME('05/12/2012 12:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 01:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 76, null, 125.50, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (130, 761, 'Task 2', PARSEDATETIME('14/12/2012 00:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 01:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 76, PARSEDATETIME('20/01/2013 09:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 656.62, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (131, 762, 'Task 3', PARSEDATETIME('11/01/2013 06:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('20/01/2013 09:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 76, PARSEDATETIME('03/02/2013 07:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 334.12, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (132, 763, 'Task 4', PARSEDATETIME('27/01/2013 07:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 07:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 76, null, 421.48, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (133, 764, 'Task 5', PARSEDATETIME('06/01/2013 10:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Juan L.', 76, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (134, 765, 'Task 6', PARSEDATETIME('10/01/2013 04:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 07:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 76, PARSEDATETIME('17/02/2013 15:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 343.70, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (135, 766, 'Task 7', PARSEDATETIME('15/02/2013 12:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('17/02/2013 15:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 76, null, null, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (136, 75, 'Leave Management', '0', PARSEDATETIME('15/01/2013 14:39', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', null, '3', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (137, 750, 'Task 1', PARSEDATETIME('09/01/2013 22:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('15/01/2013 14:39', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 75, PARSEDATETIME('07/02/2013 22:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 559.60, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (138, 751, 'Task 2', PARSEDATETIME('23/01/2013 20:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/02/2013 22:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 75, null, null, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (139, 752, 'Task 3a', PARSEDATETIME('27/01/2013 19:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/02/2013 22:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 75, null, null, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (140, 74, 'Purchase', '0', PARSEDATETIME('29/12/2012 05:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', PARSEDATETIME('20/03/2013 20:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 1959.50);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (141, 740, 'Task 1', PARSEDATETIME('26/12/2012 16:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('29/12/2012 05:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 74, PARSEDATETIME('26/01/2013 08:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 675.60, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (142, 741, 'Task 2', PARSEDATETIME('02/01/2013 00:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('26/01/2013 08:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 74, PARSEDATETIME('28/01/2013 09:50', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 49.23, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (143, 742, 'Task 3', PARSEDATETIME('23/01/2013 07:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('28/01/2013 09:50', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 74, PARSEDATETIME('25/02/2013 10:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 672.43, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (144, 743, 'Task 4', PARSEDATETIME('13/02/2013 21:22', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('25/02/2013 10:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 74, PARSEDATETIME('20/03/2013 20:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 562.23, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (145, 73, 'Leave Management', '0', PARSEDATETIME('02/01/2013 23:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', PARSEDATETIME('08/02/2013 22:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 887.20);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (146, 730, 'Task 1', PARSEDATETIME('19/12/2012 03:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('02/01/2013 23:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 73, PARSEDATETIME('24/01/2013 23:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 528.82, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (147, 731, 'Task 2', PARSEDATETIME('28/12/2012 08:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/01/2013 23:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 73, null, 675.42, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (148, 732, 'Task 3', PARSEDATETIME('26/12/2012 18:22', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/01/2013 23:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 73, PARSEDATETIME('08/02/2013 22:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 358.38, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (149, 72, 'Sales', '2', PARSEDATETIME('29/12/2012 21:20', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', null, '3', 2648.67);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (150, 720, 'Task 1', PARSEDATETIME('03/12/2012 13:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('29/12/2012 21:20', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 72, PARSEDATETIME('30/12/2012 02:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 4.87, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (151, 721, 'Task 2', PARSEDATETIME('14/12/2012 21:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('30/12/2012 02:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 72, PARSEDATETIME('04/01/2013 17:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 135.22, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (152, 722, 'Task 3', PARSEDATETIME('31/12/2012 18:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('04/01/2013 17:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 72, null, 696.23, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (153, 71, 'Travel Management', '1', PARSEDATETIME('02/01/2013 06:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', null, '1', 1245.22);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (154, 710, 'Task 1', PARSEDATETIME('19/12/2012 11:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('02/01/2013 06:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 71, PARSEDATETIME('29/01/2013 09:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 651.65, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (155, 711, 'Task 2', PARSEDATETIME('05/01/2013 18:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Fred G.', 71, PARSEDATETIME('22/01/2013 22:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 668.15, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (156, 712, 'Task 3', PARSEDATETIME('27/12/2012 08:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('22/01/2013 22:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 71, null, 538.43, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (157, 70, 'Sales', '3', PARSEDATETIME('15/01/2013 16:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', null, '1', 947.42);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (158, 700, 'Task 1', PARSEDATETIME('13/01/2013 10:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('15/01/2013 16:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 70, null, 125.50, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (159, 701, 'Task 2', PARSEDATETIME('10/01/2013 06:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('15/01/2013 16:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 70, null, 656.62, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (160, 702, 'Task 3', PARSEDATETIME('08/01/2013 12:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('15/01/2013 16:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 70, null, 334.12, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (161, 69, 'Sales', '3', PARSEDATETIME('12/01/2013 14:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', PARSEDATETIME('05/02/2013 12:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 573.55);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (162, 690, 'Task 1', PARSEDATETIME('22/12/2012 12:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 14:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 69, null, 200.83, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (163, 691, 'Task 2', PARSEDATETIME('10/01/2013 02:22', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 14:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 69, PARSEDATETIME('14/01/2013 11:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 44.33, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (164, 692, 'Task 4', PARSEDATETIME('27/12/2012 18:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('14/01/2013 11:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 69, PARSEDATETIME('05/02/2013 12:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 529.22, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (165, 68, 'Expenses', '0', PARSEDATETIME('01/01/2013 13:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', PARSEDATETIME('31/01/2013 14:08', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 720.68);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (166, 680, 'Task 1', PARSEDATETIME('16/12/2012 13:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('01/01/2013 13:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 68, PARSEDATETIME('12/01/2013 08:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 259.48, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (167, 681, 'Task 2', PARSEDATETIME('21/12/2012 05:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 08:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 68, PARSEDATETIME('20/01/2013 14:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 198.02, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (168, 682, 'Task 3', PARSEDATETIME('06/01/2013 05:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('20/01/2013 14:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 68, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (169, 683, 'Task 4', PARSEDATETIME('24/12/2012 13:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('20/01/2013 14:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', 68, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (170, 684, 'Task 5', PARSEDATETIME('17/01/2013 23:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('20/01/2013 14:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 68, PARSEDATETIME('31/01/2013 14:08', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 263.18, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (171, 67, 'Leave Management', '1', PARSEDATETIME('09/01/2013 10:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', null, '1', 236.62);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (172, 670, 'Task 1', PARSEDATETIME('28/12/2012 00:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('09/01/2013 10:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 67, PARSEDATETIME('17/01/2013 18:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 199.70, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (173, 671, 'Task 2', PARSEDATETIME('27/12/2012 07:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Andrea M.', 67, null, 329.43, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (174, 672, 'Task 3', PARSEDATETIME('15/01/2013 06:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('17/01/2013 18:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 67, PARSEDATETIME('13/02/2013 15:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 644.72, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (175, 673, 'Task 4', PARSEDATETIME('31/01/2013 20:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('13/02/2013 15:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 67, null, 609.23, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (176, 66, 'New Hire', '1', PARSEDATETIME('04/01/2013 17:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', null, '1', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (177, 660, 'Task 1', PARSEDATETIME('19/12/2012 18:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('04/01/2013 17:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 66, PARSEDATETIME('10/01/2013 12:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 138.93, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (178, 661, 'Task 2', PARSEDATETIME('19/12/2012 18:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('10/01/2013 12:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 66, null, 482.65, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (179, 662, 'Task 3', PARSEDATETIME('09/01/2013 03:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Carlos F.', 66, PARSEDATETIME('06/03/2013 13:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 533.00, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (180, 663, 'Task 4', PARSEDATETIME('14/02/2013 00:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/03/2013 13:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 66, null, 340.20, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (181, 664, 'Task 5', PARSEDATETIME('17/02/2013 12:54', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Laia P.', 66, null, null, 'Created');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (182, 65, 'New Hire', '2', PARSEDATETIME('19/01/2013 04:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', PARSEDATETIME('26/03/2013 18:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 1598.90);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (183, 650, 'Task 1', PARSEDATETIME('01/01/2013 10:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('19/01/2013 04:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 65, null, 138.93, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (184, 651, 'Task 2', PARSEDATETIME('15/01/2013 23:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('19/01/2013 04:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', 65, PARSEDATETIME('31/01/2013 05:19', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 289.25, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (185, 652, 'Task 3', PARSEDATETIME('11/01/2013 18:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Angel C.', 65, PARSEDATETIME('06/03/2013 13:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 533.00, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (186, 653, 'Task 4', PARSEDATETIME('20/02/2013 05:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/03/2013 13:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 65, PARSEDATETIME('26/03/2013 18:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 485.03, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (187, 64, 'New Hire', '3', PARSEDATETIME('12/01/2013 21:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', PARSEDATETIME('21/01/2013 11:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 205.48);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (188, 640, 'Task 1', PARSEDATETIME('28/12/2012 05:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 21:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 64, null, 453.23, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (189, 641, 'Task 2a', PARSEDATETIME('22/12/2012 09:08', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 21:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 64, PARSEDATETIME('20/01/2013 10:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 180.60, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (190, 642, 'Task 2b', PARSEDATETIME('27/12/2012 20:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('20/01/2013 10:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 64, PARSEDATETIME('21/01/2013 11:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 24.88, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (191, 63, 'Expenses', '0', PARSEDATETIME('20/01/2013 08:21', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', PARSEDATETIME('30/01/2013 23:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 255.42);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (192, 630, 'Task 1', PARSEDATETIME('20/01/2013 00:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Paco P.', 63, PARSEDATETIME('12/01/2013 08:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 259.48, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (193, 631, 'Task 2', PARSEDATETIME('06/01/2013 22:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 08:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 63, null, 198.02, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (194, 632, 'Task 3', PARSEDATETIME('28/12/2012 14:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 08:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 63, PARSEDATETIME('30/01/2013 23:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 446.83, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (195, 62, 'Purchase', '2', PARSEDATETIME('05/01/2013 11:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', null, '2', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (196, 620, 'Task 1', PARSEDATETIME('12/12/2012 22:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('05/01/2013 11:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 62, null, null, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (197, 621, 'Task 2', PARSEDATETIME('17/12/2012 15:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('05/01/2013 11:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 62, null, null, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (198, 622, 'Task 3', PARSEDATETIME('08/12/2012 17:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('05/01/2013 11:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 62, null, null, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (199, 61, 'Expenses', '1', PARSEDATETIME('12/01/2013 16:39', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', PARSEDATETIME('05/03/2013 01:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 1232.82);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (200, 610, 'Task 1', PARSEDATETIME('20/12/2012 10:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 16:39', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 61, PARSEDATETIME('21/01/2013 16:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 215.85, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (201, 611, 'Task 2', PARSEDATETIME('15/01/2013 11:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('21/01/2013 16:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 61, null, 198.02, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (202, 612, 'Task 3', PARSEDATETIME('03/01/2013 21:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('21/01/2013 16:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 61, null, 446.83, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (203, 613, 'Task 4', PARSEDATETIME('09/01/2013 03:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('21/01/2013 16:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 61, PARSEDATETIME('09/02/2013 23:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 462.92, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (204, 614, 'Task 5', PARSEDATETIME('18/01/2013 22:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('09/02/2013 23:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 61, PARSEDATETIME('27/02/2013 20:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 429.45, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (205, 615, 'Task 6', PARSEDATETIME('08/02/2013 21:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('27/02/2013 20:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 61, PARSEDATETIME('05/03/2013 01:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 124.60, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (206, 60, 'Travel Management', '1', PARSEDATETIME('15/01/2013 20:22', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', PARSEDATETIME('13/02/2013 12:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 688.18);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (207, 600, 'Task 1', PARSEDATETIME('21/12/2012 00:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('15/01/2013 20:22', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 60, null, 651.65, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (208, 601, 'Task 2', PARSEDATETIME('11/01/2013 09:48', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Gemma S.', 60, PARSEDATETIME('22/01/2013 22:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 668.15, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (209, 602, 'Task 3', PARSEDATETIME('31/12/2012 01:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('22/01/2013 22:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 60, PARSEDATETIME('31/01/2013 00:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 193.52, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (210, 603, 'Task 4', PARSEDATETIME('10/01/2013 04:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Gemma S.', 60, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (211, 604, 'Task 5', PARSEDATETIME('20/01/2013 06:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('31/01/2013 00:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 60, PARSEDATETIME('13/02/2013 12:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 324.08, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (212, 59, 'New Hire', '0', PARSEDATETIME('15/01/2013 15:43', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', null, '1', 1598.90);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (213, 590, 'Task 1', PARSEDATETIME('02/01/2013 12:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('15/01/2013 15:43', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 59, PARSEDATETIME('02/02/2013 02:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 419.10, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (214, 591, 'Task 2', PARSEDATETIME('19/01/2013 18:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('02/02/2013 02:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 59, null, 289.25, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (215, 592, 'Task 3', PARSEDATETIME('15/01/2013 12:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('02/02/2013 02:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 59, null, 533.00, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (216, 58, 'Leave Management', '2', PARSEDATETIME('11/01/2013 20:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', PARSEDATETIME('02/02/2013 10:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 517.82);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (217, 580, 'Task 1', PARSEDATETIME('21/12/2012 19:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('11/01/2013 20:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 58, null, 199.70, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (218, 581, 'Task 2', PARSEDATETIME('27/12/2012 06:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('11/01/2013 20:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 58, PARSEDATETIME('24/01/2013 13:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 304.67, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (219, 582, 'Task 3', PARSEDATETIME('06/01/2013 01:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/01/2013 13:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 58, PARSEDATETIME('02/02/2013 10:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 213.15, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (220, 57, 'Leave Management', '4', PARSEDATETIME('13/01/2013 01:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', null, '2', 887.20);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (221, 570, 'Task 1', PARSEDATETIME('11/01/2013 12:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Antonio N.', 57, PARSEDATETIME('24/01/2013 23:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 528.82, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (222, 571, 'Task 2', PARSEDATETIME('05/01/2013 19:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/01/2013 23:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 57, null, 675.42, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (223, 572, 'Task 3', PARSEDATETIME('04/01/2013 07:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/01/2013 23:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 57, null, 358.38, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (224, 56, 'Leave Management', '3', PARSEDATETIME('24/12/2012 12:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', PARSEDATETIME('25/12/2012 15:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 27.67);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (225, 560, 'Task 1', PARSEDATETIME('14/12/2012 04:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 12:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 56, null, 528.82, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (226, 561, 'Task 2', PARSEDATETIME('13/12/2012 21:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 12:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 56, null, 675.42, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (227, 562, 'Task 3', PARSEDATETIME('26/11/2012 18:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 12:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 56, PARSEDATETIME('25/12/2012 15:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 27.67, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (228, 55, 'IT support issue', '1', PARSEDATETIME('03/01/2013 06:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', PARSEDATETIME('30/01/2013 02:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 644.20);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (229, 550, 'Task 1', PARSEDATETIME('24/12/2012 12:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/01/2013 06:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 55, PARSEDATETIME('20/01/2013 02:21', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 403.58, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (230, 551, 'Task 2', PARSEDATETIME('24/12/2012 20:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('20/01/2013 02:21', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 55, null, null, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (231, 552, 'Task 3', PARSEDATETIME('24/12/2012 00:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Maria A.', 55, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (232, 553, 'Task 4', PARSEDATETIME('10/01/2013 14:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('20/01/2013 02:21', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 55, PARSEDATETIME('22/01/2013 16:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 62.62, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (233, 554, 'Task 5', PARSEDATETIME('31/12/2012 03:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('22/01/2013 16:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 55, PARSEDATETIME('26/01/2013 17:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 96.03, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (234, 555, 'Task 6', PARSEDATETIME('09/01/2013 22:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('26/01/2013 17:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 55, PARSEDATETIME('28/01/2013 00:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 31.27, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (235, 556, 'Task 7', PARSEDATETIME('25/01/2013 15:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('28/01/2013 00:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 55, null, null, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (236, 557, 'Task 8', PARSEDATETIME('24/01/2013 17:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('28/01/2013 00:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 55, PARSEDATETIME('30/01/2013 02:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 50.70, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (237, 54, 'Purchase', '1', PARSEDATETIME('07/01/2013 23:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', null, '2', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (238, 540, 'Task 1', PARSEDATETIME('05/01/2013 02:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Fred G.', 54, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (239, 541, 'Task 2', PARSEDATETIME('17/12/2012 00:43', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 23:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 54, PARSEDATETIME('24/01/2013 00:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 384.72, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (240, 542, 'Task 3', PARSEDATETIME('15/01/2013 06:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/01/2013 00:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 54, PARSEDATETIME('28/01/2013 08:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 103.35, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (241, 543, 'Task 4', PARSEDATETIME('09/01/2013 06:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('28/01/2013 08:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 54, null, null, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (242, 53, 'IT support issue', '1', PARSEDATETIME('11/01/2013 17:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', null, '1', 644.20);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (243, 530, 'Task 1', PARSEDATETIME('24/12/2012 12:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Antonio N.', 53, PARSEDATETIME('20/01/2013 02:21', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 403.58, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (244, 531, 'Task 2', PARSEDATETIME('15/01/2013 15:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('20/01/2013 02:21', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 53, PARSEDATETIME('22/01/2013 02:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 47.92, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (245, 532, 'Task 3', PARSEDATETIME('14/01/2013 07:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('22/01/2013 02:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 53, null, null, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (246, 52, 'Sales', '0', PARSEDATETIME('26/12/2012 01:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', null, '2', 573.55);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (247, 520, 'Task 1', PARSEDATETIME('19/12/2012 08:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('26/12/2012 01:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 52, null, 200.83, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (248, 521, 'Task 2', PARSEDATETIME('04/12/2012 16:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Juan L.', 52, PARSEDATETIME('14/01/2013 11:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 44.33, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (249, 522, 'Task 4', PARSEDATETIME('11/01/2013 12:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('14/01/2013 11:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', 52, PARSEDATETIME('05/02/2013 08:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 525.53, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (250, 523, 'Task 5', PARSEDATETIME('12/01/2013 01:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('05/02/2013 08:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 52, PARSEDATETIME('08/02/2013 01:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 64.47, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (251, 524, 'Task 6', PARSEDATETIME('23/01/2013 19:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/02/2013 01:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 52, PARSEDATETIME('03/03/2013 07:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 558.22, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (252, 525, 'Task 7', PARSEDATETIME('02/02/2013 00:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/03/2013 07:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 52, null, null, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (253, 51, 'Lead Management', '1', PARSEDATETIME('17/01/2013 08:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', null, '1', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (254, 510, 'Task 1', PARSEDATETIME('09/01/2013 00:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('17/01/2013 08:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 51, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (255, 511, 'Task 2', PARSEDATETIME('01/01/2013 17:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Frank T.', 51, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (256, 512, 'Task 3', PARSEDATETIME('28/12/2012 08:40', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Andrea M.', 51, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (257, 513, 'Task 4', PARSEDATETIME('04/01/2013 21:19', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('17/01/2013 08:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 51, PARSEDATETIME('24/01/2013 20:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 179.85, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (258, 514, 'Task 5', PARSEDATETIME('19/01/2013 16:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/01/2013 20:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', 51, null, null, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (259, 50, 'Purchase', '4', PARSEDATETIME('24/12/2012 02:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', null, '2', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (260, 500, 'Task 1', PARSEDATETIME('18/12/2012 20:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 02:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 50, PARSEDATETIME('25/12/2012 04:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 25.97, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (261, 501, 'Task 2', PARSEDATETIME('04/12/2012 03:19', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Peter S.', 50, PARSEDATETIME('24/01/2013 00:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 384.72, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (262, 502, 'Task 3', PARSEDATETIME('30/12/2012 03:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/01/2013 00:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 50, PARSEDATETIME('27/01/2013 09:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 80.73, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (263, 503, 'Task 4', PARSEDATETIME('04/01/2013 16:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('27/01/2013 09:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 50, null, null, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (264, 49, 'IT support issue', '0', PARSEDATETIME('25/12/2012 13:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', PARSEDATETIME('01/02/2013 16:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 915.30);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (265, 490, 'Task 1', PARSEDATETIME('04/12/2012 02:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('25/12/2012 13:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 49, PARSEDATETIME('15/01/2013 20:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 511.82, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (266, 491, 'Task 2', PARSEDATETIME('25/12/2012 23:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Angel C.', 49, PARSEDATETIME('22/01/2013 02:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 47.92, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (267, 492, 'Task 3', PARSEDATETIME('05/01/2013 06:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('22/01/2013 02:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 49, PARSEDATETIME('30/01/2013 02:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 192.35, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (268, 493, 'Task 4', PARSEDATETIME('29/01/2013 02:23', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('30/01/2013 02:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 49, PARSEDATETIME('01/02/2013 16:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 61.80, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (269, 48, 'Leave Management', '0', PARSEDATETIME('09/01/2013 00:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', null, '3', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (270, 480, 'Task 1', PARSEDATETIME('03/01/2013 02:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('09/01/2013 00:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 48, PARSEDATETIME('22/01/2013 18:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 330.12, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (271, 481, 'Task 2', PARSEDATETIME('06/01/2013 23:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Frank T.', 48, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (272, 482, 'Task 3a', PARSEDATETIME('19/01/2013 05:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Marc V.', 48, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (273, 483, 'Task 3b', PARSEDATETIME('19/01/2013 09:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('22/01/2013 18:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 48, null, null, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (274, 47, 'Purchase', '1', PARSEDATETIME('10/01/2013 15:39', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', PARSEDATETIME('23/01/2013 16:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 312.43);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (275, 470, 'Task 1', PARSEDATETIME('01/01/2013 13:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('10/01/2013 15:39', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 47, null, 25.97, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (276, 471, 'Task 2', PARSEDATETIME('08/01/2013 20:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('10/01/2013 15:39', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 47, PARSEDATETIME('13/01/2013 09:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 65.90, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (277, 472, 'Task 3', PARSEDATETIME('18/12/2012 00:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('13/01/2013 09:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 47, PARSEDATETIME('23/01/2013 16:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 246.53, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (278, 46, 'Sales', '0', PARSEDATETIME('02/01/2013 19:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', PARSEDATETIME('12/01/2013 10:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 231.23);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (279, 460, 'Task 1', PARSEDATETIME('17/12/2012 07:23', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('02/01/2013 19:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 46, null, 125.50, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (280, 461, 'Task 2', PARSEDATETIME('16/12/2012 09:48', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('02/01/2013 19:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 46, null, 656.62, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (281, 462, 'Task 3', PARSEDATETIME('01/01/2013 10:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('02/01/2013 19:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 46, PARSEDATETIME('08/01/2013 12:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 136.92, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (282, 463, 'Task 4', PARSEDATETIME('05/01/2013 18:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 12:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 46, null, 421.48, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (283, 464, 'Task 5', PARSEDATETIME('23/12/2012 18:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 12:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 46, PARSEDATETIME('12/01/2013 10:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 94.32, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (284, 45, 'Travel Management', '4', PARSEDATETIME('04/01/2013 23:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', null, '1', 688.18);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (285, 450, 'Task 1', PARSEDATETIME('28/12/2012 07:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('04/01/2013 23:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 45, null, 651.65, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (286, 451, 'Task 2', PARSEDATETIME('28/12/2012 14:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('04/01/2013 23:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 45, null, 668.15, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (287, 452, 'Task 3', PARSEDATETIME('15/12/2012 07:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('04/01/2013 23:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 45, PARSEDATETIME('27/01/2013 21:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 550.05, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (288, 453, 'Task 4', PARSEDATETIME('08/01/2013 05:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Irina P.', 45, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (289, 454, 'Task 5', PARSEDATETIME('07/01/2013 00:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('27/01/2013 21:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 45, null, 324.08, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (290, 44, 'New Hire', '1', PARSEDATETIME('24/12/2012 08:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', null, '2', 205.48);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (291, 440, 'Task 1', PARSEDATETIME('13/12/2012 22:39', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 08:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 44, PARSEDATETIME('20/01/2013 21:22', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 660.62, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (292, 441, 'Task 2a', PARSEDATETIME('23/12/2012 05:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('20/01/2013 21:22', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 44, null, 180.60, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (293, 442, 'Task 2b', PARSEDATETIME('10/01/2013 09:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Marc V.', 44, PARSEDATETIME('21/01/2013 11:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 24.88, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (294, 443, 'Task 3', PARSEDATETIME('06/01/2013 08:48', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('21/01/2013 11:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 44, PARSEDATETIME('02/02/2013 10:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 287.70, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (295, 444, 'Task 4', PARSEDATETIME('11/01/2013 12:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('02/02/2013 10:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 44, null, 56.67, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (296, 43, 'Sales', '2', PARSEDATETIME('02/01/2013 14:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', null, '1', 231.23);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (297, 430, 'Task 1', PARSEDATETIME('10/12/2012 17:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Miguel K.', 43, null, 125.50, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (298, 431, 'Task 2', PARSEDATETIME('02/01/2013 09:54', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('02/01/2013 14:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 43, null, 656.62, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (299, 432, 'Task 3', PARSEDATETIME('11/12/2012 06:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('02/01/2013 14:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 43, null, 136.92, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (300, 433, 'Task 4', PARSEDATETIME('11/12/2012 20:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('02/01/2013 14:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 43, null, 421.48, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (301, 42, 'Leave Management', '0', PARSEDATETIME('28/12/2012 00:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', null, '1', 517.82);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (302, 420, 'Task 1', PARSEDATETIME('10/12/2012 23:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('28/12/2012 00:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 42, null, 199.70, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (303, 421, 'Task 2', PARSEDATETIME('12/12/2012 01:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('28/12/2012 00:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 42, PARSEDATETIME('08/01/2013 08:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 271.65, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (304, 422, 'Task 3', PARSEDATETIME('24/12/2012 04:08', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 08:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 42, null, 213.15, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (305, 423, 'Task 4', PARSEDATETIME('27/12/2012 15:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Irina P.', 42, null, 609.23, 'Created');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (306, 41, 'Leave Management', '1', PARSEDATETIME('05/01/2013 04:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', null, '1', 517.82);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (307, 410, 'Task 1', PARSEDATETIME('27/12/2012 22:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('05/01/2013 04:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 41, null, 199.70, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (308, 411, 'Task 2', PARSEDATETIME('13/12/2012 09:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Andrea M.', 41, PARSEDATETIME('08/01/2013 08:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 271.65, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (309, 412, 'Task 3', PARSEDATETIME('30/12/2012 05:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 08:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', 41, null, 213.15, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (310, 40, 'Travel Management', '3', PARSEDATETIME('20/01/2013 23:55', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', null, '1', 688.18);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (311, 400, 'Task 1', PARSEDATETIME('03/01/2013 01:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('20/01/2013 23:55', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 40, PARSEDATETIME('10/02/2013 14:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 494.82, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (312, 401, 'Task 2', PARSEDATETIME('20/01/2013 00:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('10/02/2013 14:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 40, PARSEDATETIME('12/02/2013 13:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 47.25, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (313, 402, 'Task 3', PARSEDATETIME('25/01/2013 00:54', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Marc V.', 40, PARSEDATETIME('27/01/2013 21:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 550.05, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (314, 403, 'Task 4', PARSEDATETIME('07/01/2013 07:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('27/01/2013 21:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 40, PARSEDATETIME('03/02/2013 16:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 162.93, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (315, 404, 'Task 5', PARSEDATETIME('12/01/2013 11:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 16:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 40, null, 324.08, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (316, 405, 'Task 6', PARSEDATETIME('02/02/2013 23:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 16:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 40, PARSEDATETIME('04/02/2013 12:54', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 20.73, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (317, 406, 'Task 7', PARSEDATETIME('01/02/2013 10:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Angel C.', 40, null, null, 'Created');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (318, 39, 'Purchase', '1', PARSEDATETIME('05/01/2013 19:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', PARSEDATETIME('03/02/2013 04:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 680.88);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (319, 390, 'Task 1', PARSEDATETIME('24/12/2012 18:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('05/01/2013 19:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 39, PARSEDATETIME('12/01/2013 19:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 167.62, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (320, 391, 'Task 2', PARSEDATETIME('11/01/2013 05:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 19:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 39, PARSEDATETIME('16/01/2013 19:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 95.83, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (321, 392, 'Task 3', PARSEDATETIME('31/12/2012 17:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('16/01/2013 19:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 39, PARSEDATETIME('03/02/2013 04:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 417.43, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (322, 38, 'Leave Management', '0', PARSEDATETIME('03/01/2013 09:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', PARSEDATETIME('30/01/2013 06:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 645.57);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (323, 380, 'Task 1', PARSEDATETIME('21/12/2012 23:54', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/01/2013 09:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 38, null, 199.70, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (324, 381, 'Task 2', PARSEDATETIME('26/12/2012 22:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Gemma S.', 38, PARSEDATETIME('08/01/2013 08:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 271.65, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (325, 382, 'Task 3', PARSEDATETIME('19/12/2012 11:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 08:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 38, PARSEDATETIME('30/01/2013 06:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 526.67, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (326, 37, 'Sales', '4', PARSEDATETIME('08/01/2013 17:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', PARSEDATETIME('03/03/2013 07:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 1286.12);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (327, 370, 'Task 1', PARSEDATETIME('31/12/2012 19:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 17:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 37, null, 200.83, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (328, 371, 'Task 2', PARSEDATETIME('28/12/2012 08:23', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 17:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 37, PARSEDATETIME('26/01/2013 21:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 436.30, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (329, 372, 'Task 4', PARSEDATETIME('15/01/2013 02:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('26/01/2013 21:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 37, PARSEDATETIME('02/02/2013 12:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 158.58, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (330, 373, 'Task 5', PARSEDATETIME('10/01/2013 11:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('02/02/2013 12:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 37, PARSEDATETIME('06/02/2013 21:55', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 105.85, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (331, 374, 'Task 6', PARSEDATETIME('11/01/2013 00:43', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Paco P.', 37, PARSEDATETIME('03/03/2013 07:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 558.22, 'Created');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (332, 36, 'Lead Management', '2', PARSEDATETIME('03/01/2013 17:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', null, '1', null);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (333, 360, 'Task 1', PARSEDATETIME('13/12/2012 04:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/01/2013 17:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 36, null, null, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (334, 361, 'Task 2', PARSEDATETIME('15/12/2012 19:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/01/2013 17:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 36, PARSEDATETIME('31/01/2013 23:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 678.18, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (335, 362, 'Task 3', PARSEDATETIME('20/01/2013 17:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('31/01/2013 23:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 36, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (336, 363, 'Task 4', PARSEDATETIME('05/01/2013 18:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('31/01/2013 23:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 36, null, 179.85, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (337, 35, 'Sales', '4', PARSEDATETIME('24/12/2012 23:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', null, '3', 2648.67);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (338, 350, 'Task 1', PARSEDATETIME('11/12/2012 08:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 23:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 35, null, 4.87, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (339, 351, 'Task 2', PARSEDATETIME('15/12/2012 15:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 23:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 35, null, 135.22, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (340, 352, 'Task 3', PARSEDATETIME('10/12/2012 08:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Paco P.', 35, null, 696.23, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (341, 353, 'Task 4a', PARSEDATETIME('19/12/2012 23:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 23:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 35, null, 665.58, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (342, 354, 'Task 4b', PARSEDATETIME('05/12/2012 11:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 23:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 35, PARSEDATETIME('18/01/2013 21:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 598.43, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (343, 355, 'Task 4c', PARSEDATETIME('02/01/2013 11:54', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('18/01/2013 21:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 35, null, 329.70, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (344, 356, 'Task 5', PARSEDATETIME('15/01/2013 23:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Gemma S.', 35, PARSEDATETIME('20/04/2013 20:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 60.17, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (345, 357, 'Task 6', PARSEDATETIME('29/03/2013 22:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('20/04/2013 20:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 35, PARSEDATETIME('24/04/2013 09:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 84.53, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (346, 358, 'Task 7', PARSEDATETIME('10/04/2013 19:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/04/2013 09:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 35, PARSEDATETIME('07/05/2013 13:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 316.42, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (347, 359, 'Task 8', PARSEDATETIME('26/04/2013 02:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/05/2013 13:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 35, null, null, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (348, 34, 'Sales', '3', PARSEDATETIME('26/12/2012 14:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', null, '2', 1286.12);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (349, 340, 'Task 1', PARSEDATETIME('09/12/2012 08:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('26/12/2012 14:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 34, PARSEDATETIME('12/01/2013 06:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 400.28, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (350, 341, 'Task 2', PARSEDATETIME('09/01/2013 13:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 06:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 34, null, 436.30, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (351, 342, 'Task 4', PARSEDATETIME('21/12/2012 22:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 06:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 34, null, 158.58, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (352, 343, 'Task 5', PARSEDATETIME('05/01/2013 03:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 06:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 34, PARSEDATETIME('05/02/2013 03:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 572.92, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (353, 344, 'Task 6', PARSEDATETIME('26/01/2013 23:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('05/02/2013 03:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 34, null, 558.22, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (354, 33, 'Leave Management', '0', PARSEDATETIME('31/12/2012 04:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', null, '1', 645.57);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (355, 330, 'Task 1', PARSEDATETIME('26/12/2012 11:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Carlos F.', 33, null, 199.70, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (356, 331, 'Task 2', PARSEDATETIME('14/12/2012 17:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('31/12/2012 04:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 33, PARSEDATETIME('06/01/2013 04:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 143.93, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (357, 332, 'Task 3', PARSEDATETIME('05/01/2013 20:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/01/2013 04:29', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 33, PARSEDATETIME('07/01/2013 15:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 35.37, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (358, 333, 'Task 4', PARSEDATETIME('17/12/2012 13:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Irina P.', 33, null, 609.23, 'Created');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (359, 32, 'Leave Management', '1', PARSEDATETIME('05/01/2013 05:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', PARSEDATETIME('16/01/2013 00:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 258.50);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (360, 320, 'Task 1', PARSEDATETIME('02/01/2013 15:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('05/01/2013 05:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 32, null, 528.82, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (361, 321, 'Task 2', PARSEDATETIME('24/12/2012 13:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('05/01/2013 05:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 32, PARSEDATETIME('10/01/2013 15:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 129.57, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (362, 322, 'Task 3', PARSEDATETIME('31/12/2012 21:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('10/01/2013 15:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 32, PARSEDATETIME('16/01/2013 00:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 128.93, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (363, 31, 'Leave Management', '4', PARSEDATETIME('11/01/2013 15:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', PARSEDATETIME('25/02/2013 12:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 1077.35);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (364, 310, 'Task 1', PARSEDATETIME('23/12/2012 16:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('11/01/2013 15:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 31, PARSEDATETIME('29/01/2013 06:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 423.03, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (365, 311, 'Task 2', PARSEDATETIME('20/01/2013 21:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('29/01/2013 06:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 31, PARSEDATETIME('09/02/2013 19:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 276.62, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (366, 312, 'Task 3', PARSEDATETIME('22/01/2013 19:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('09/02/2013 19:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 31, PARSEDATETIME('25/02/2013 12:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 377.70, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (367, 30, 'New Hire', '3', PARSEDATETIME('13/01/2013 06:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', PARSEDATETIME('14/02/2013 05:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 767.43);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (368, 300, 'Task 1', PARSEDATETIME('26/12/2012 16:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('13/01/2013 06:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 30, PARSEDATETIME('03/02/2013 13:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 511.45, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (369, 301, 'Task 2', PARSEDATETIME('24/01/2013 21:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 13:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 30, null, 289.25, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (370, 302, 'Task 3', PARSEDATETIME('09/01/2013 18:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 13:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 30, PARSEDATETIME('14/02/2013 05:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 255.98, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (371, 29, 'Leave Management', '0', PARSEDATETIME('01/01/2013 02:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', PARSEDATETIME('25/02/2013 20:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 1338.38);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (372, 290, 'Task 1', PARSEDATETIME('03/12/2012 08:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('01/01/2013 02:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 29, PARSEDATETIME('14/01/2013 18:22', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 327.77, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (373, 291, 'Task 2', PARSEDATETIME('29/12/2012 13:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('14/01/2013 18:22', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 29, PARSEDATETIME('03/02/2013 12:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 473.70, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (374, 292, 'Task 3', PARSEDATETIME('22/01/2013 20:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 12:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 29, null, 128.93, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (375, 293, 'Task 4', PARSEDATETIME('28/01/2013 23:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 12:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 29, PARSEDATETIME('25/02/2013 20:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 536.92, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (376, 28, 'Leave Management', '1', PARSEDATETIME('12/01/2013 09:54', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', null, '1', 1077.35);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (377, 280, 'Task 1', PARSEDATETIME('06/01/2013 01:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/01/2013 09:54', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 28, PARSEDATETIME('06/02/2013 13:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 603.62, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (378, 281, 'Task 2', PARSEDATETIME('03/02/2013 13:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/02/2013 13:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 28, PARSEDATETIME('14/02/2013 06:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 185.03, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (379, 282, 'Task 3', PARSEDATETIME('11/02/2013 11:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('14/02/2013 06:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 28, null, 377.70, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (380, 27, 'Sales', '2', PARSEDATETIME('20/01/2013 09:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', PARSEDATETIME('11/04/2013 19:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 1953.40);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (381, 270, 'Task 1', PARSEDATETIME('17/01/2013 01:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('20/01/2013 09:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 27, PARSEDATETIME('03/02/2013 06:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 333.68, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (382, 271, 'Task 2', PARSEDATETIME('26/01/2013 18:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Frank T.', 27, null, 436.30, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (383, 272, 'Task 4', PARSEDATETIME('11/01/2013 15:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 06:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 27, PARSEDATETIME('24/02/2013 07:19', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 504.35, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (384, 273, 'Task 5', PARSEDATETIME('05/02/2013 02:23', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/02/2013 07:19', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 27, PARSEDATETIME('25/03/2013 21:23', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 710.07, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (385, 274, 'Task 6', PARSEDATETIME('01/03/2013 04:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('25/03/2013 21:23', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 27, PARSEDATETIME('11/04/2013 19:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 405.30, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (386, 26, 'New Hire', '4', PARSEDATETIME('06/01/2013 03:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', PARSEDATETIME('18/02/2013 09:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 1038.23);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (387, 260, 'Task 1', PARSEDATETIME('06/01/2013 21:23', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/01/2013 03:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 26, PARSEDATETIME('26/01/2013 16:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 493.67, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (388, 261, 'Task 2a', PARSEDATETIME('15/01/2013 17:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('26/01/2013 16:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 26, null, 180.60, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (389, 262, 'Task 2b', PARSEDATETIME('20/01/2013 10:21', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('26/01/2013 16:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 26, PARSEDATETIME('18/02/2013 09:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 544.57, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (390, 25, 'New Hire', '1', PARSEDATETIME('28/12/2012 10:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', null, '1', 767.43);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (391, 250, 'Task 1', PARSEDATETIME('11/12/2012 20:48', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('28/12/2012 10:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 25, PARSEDATETIME('08/01/2013 00:23', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 253.42, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (392, 251, 'Task 2', PARSEDATETIME('22/12/2012 16:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 00:23', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 25, PARSEDATETIME('14/01/2013 05:50', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 149.45, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (393, 252, 'Task 3', PARSEDATETIME('27/12/2012 05:08', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('14/01/2013 05:50', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 25, null, 255.98, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (394, 24, 'Lead Management', '1', PARSEDATETIME('08/01/2013 20:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', PARSEDATETIME('16/02/2013 22:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 937.78);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (395, 240, 'Task 1', PARSEDATETIME('30/12/2012 07:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 20:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 24, null, null, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (396, 241, 'Task 2', PARSEDATETIME('07/01/2013 14:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 20:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 24, null, 678.18, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (397, 242, 'Task 3', PARSEDATETIME('11/12/2012 20:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Fred G.', 24, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (398, 243, 'Task 4', PARSEDATETIME('05/01/2013 19:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 20:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 24, PARSEDATETIME('27/01/2013 00:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 436.65, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (399, 244, 'Task 5', PARSEDATETIME('04/01/2013 13:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('27/01/2013 00:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 24, PARSEDATETIME('04/02/2013 12:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 203.65, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (400, 245, 'Task 6', PARSEDATETIME('06/01/2013 08:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Andrea M.', 24, null, null, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (401, 246, 'Task 7', PARSEDATETIME('02/02/2013 21:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('04/02/2013 12:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 24, PARSEDATETIME('16/02/2013 22:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 297.48, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (402, 23, 'Sales', '2', PARSEDATETIME('01/01/2013 19:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', PARSEDATETIME('17/04/2013 00:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 2524.18);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (403, 230, 'Task 1', PARSEDATETIME('16/12/2012 04:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Irina P.', 23, PARSEDATETIME('03/02/2013 06:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 333.68, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (404, 231, 'Task 2', PARSEDATETIME('09/01/2013 13:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 06:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 23, PARSEDATETIME('04/03/2013 17:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 706.07, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (405, 232, 'Task 4', PARSEDATETIME('07/02/2013 16:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('04/03/2013 17:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 23, PARSEDATETIME('20/03/2013 23:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 390.53, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (406, 233, 'Task 5', PARSEDATETIME('27/02/2013 10:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('20/03/2013 23:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 23, PARSEDATETIME('17/04/2013 00:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 648.20, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (407, 22, 'Lead Management', '3', PARSEDATETIME('16/01/2013 20:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', PARSEDATETIME('05/03/2013 20:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 1152.17);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (408, 220, 'Task 1', PARSEDATETIME('23/12/2012 02:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('16/01/2013 20:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 22, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (409, 221, 'Task 2', PARSEDATETIME('16/01/2013 00:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('16/01/2013 20:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', 22, PARSEDATETIME('03/02/2013 02:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 414.23, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (410, 222, 'Task 3', PARSEDATETIME('18/01/2013 20:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 02:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 22, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (411, 223, 'Task 4', PARSEDATETIME('14/01/2013 03:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Paco P.', 22, PARSEDATETIME('27/01/2013 00:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 436.65, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (412, 224, 'Task 5', PARSEDATETIME('06/01/2013 05:19', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('27/01/2013 00:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 22, PARSEDATETIME('15/02/2013 20:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 475.72, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (413, 225, 'Task 6', PARSEDATETIME('13/02/2013 01:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('15/02/2013 20:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 22, PARSEDATETIME('05/03/2013 20:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 431.85, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (414, 21, 'Purchase', '0', PARSEDATETIME('05/01/2013 03:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', PARSEDATETIME('23/01/2013 16:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 444.32);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (415, 210, 'Task 1', PARSEDATETIME('12/12/2012 09:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('05/01/2013 03:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 21, PARSEDATETIME('30/01/2013 17:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 614.05, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (416, 211, 'Task 2', PARSEDATETIME('18/01/2013 04:50', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('30/01/2013 17:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', 21, PARSEDATETIME('28/02/2013 04:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 682.68, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (417, 212, 'Task 3', PARSEDATETIME('21/02/2013 05:43', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Gemma S.', 21, PARSEDATETIME('23/01/2013 16:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 246.53, 'Created');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (418, 20, 'Sales', '2', PARSEDATETIME('06/01/2013 02:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', PARSEDATETIME('07/05/2013 13:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '3', 2913.63);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (419, 200, 'Task 1', PARSEDATETIME('02/01/2013 19:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/01/2013 02:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 20, null, 4.87, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (420, 201, 'Task 2', PARSEDATETIME('01/01/2013 00:05', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/01/2013 02:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 20, null, 135.22, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (421, 202, 'Task 3', PARSEDATETIME('31/12/2012 23:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/01/2013 02:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 20, null, 696.23, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (422, 203, 'Task 4a', PARSEDATETIME('06/01/2013 13:54', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/01/2013 02:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', 20, PARSEDATETIME('30/01/2013 10:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 584.15, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (423, 204, 'Task 4b', PARSEDATETIME('26/01/2013 13:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('30/01/2013 10:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 20, PARSEDATETIME('25/02/2013 05:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 618.08, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (424, 205, 'Task 4c', PARSEDATETIME('19/02/2013 09:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('25/02/2013 05:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 20, PARSEDATETIME('26/03/2013 07:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 698.25, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (425, 206, 'Task 5', PARSEDATETIME('22/03/2013 21:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('26/03/2013 07:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 20, PARSEDATETIME('01/04/2013 06:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 141.73, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (426, 207, 'Task 6', PARSEDATETIME('18/03/2013 18:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Paco P.', 20, PARSEDATETIME('24/04/2013 09:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 84.53, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (427, 208, 'Task 7', PARSEDATETIME('03/04/2013 22:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Gemma S.', 20, PARSEDATETIME('07/05/2013 13:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 316.42, 'Created');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (428, 19, 'Sales', '0', PARSEDATETIME('24/12/2012 04:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', PARSEDATETIME('20/03/2013 23:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 2083.17);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (429, 190, 'Task 1', PARSEDATETIME('27/11/2012 13:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 04:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 19, PARSEDATETIME('06/01/2013 06:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 314.45, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (430, 191, 'Task 2', PARSEDATETIME('25/12/2012 15:40', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/01/2013 06:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 19, PARSEDATETIME('03/02/2013 12:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 677.70, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (431, 192, 'Task 4', PARSEDATETIME('14/01/2013 12:09', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Gemma S.', 19, PARSEDATETIME('20/03/2013 23:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 390.53, 'Created');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (432, 18, 'Leave Management', '3', PARSEDATETIME('10/01/2013 12:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', PARSEDATETIME('25/02/2013 20:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 1112.35);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (433, 180, 'Task 1', PARSEDATETIME('19/12/2012 08:50', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('10/01/2013 12:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 18, PARSEDATETIME('07/02/2013 15:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 674.90, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (434, 181, 'Task 2', PARSEDATETIME('09/01/2013 08:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Irina P.', 18, PARSEDATETIME('03/02/2013 12:04', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 473.70, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (435, 182, 'Task 3', PARSEDATETIME('06/01/2013 11:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Carlos F.', 18, null, 128.93, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (436, 183, 'Task 4', PARSEDATETIME('27/01/2013 22:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Gemma S.', 18, PARSEDATETIME('25/02/2013 20:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 536.92, 'Created');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (437, 17, 'Leave Management', '4', PARSEDATETIME('06/01/2013 07:55', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', null, '1', 1077.35);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (438, 170, 'Task 1', PARSEDATETIME('21/12/2012 07:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/01/2013 07:55', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 17, PARSEDATETIME('15/01/2013 01:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 209.53, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (439, 171, 'Task 2', PARSEDATETIME('03/01/2013 12:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('15/01/2013 01:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 17, PARSEDATETIME('24/01/2013 09:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 223.80, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (440, 172, 'Task 3', PARSEDATETIME('22/01/2013 09:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/01/2013 09:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 17, null, 377.70, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (441, 16, 'Sales', '1', PARSEDATETIME('07/01/2013 01:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', PARSEDATETIME('23/03/2013 14:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 1812.70);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (442, 160, 'Task 1', PARSEDATETIME('23/12/2012 00:39', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 01:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 16, PARSEDATETIME('01/02/2013 12:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 610.42, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (443, 161, 'Task 2', PARSEDATETIME('15/01/2013 16:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('01/02/2013 12:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 16, PARSEDATETIME('02/03/2013 12:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 696.72, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (444, 162, 'Task 3', PARSEDATETIME('17/02/2013 11:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('02/03/2013 12:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 16, PARSEDATETIME('23/03/2013 14:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 505.57, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (445, 15, 'Purchase', '4', PARSEDATETIME('24/12/2012 05:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', PARSEDATETIME('26/01/2013 17:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 803.68);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (446, 150, 'Task 1', PARSEDATETIME('24/12/2012 06:14', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/12/2012 05:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 15, PARSEDATETIME('22/01/2013 15:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 705.52, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (447, 151, 'Task 2', PARSEDATETIME('02/01/2013 08:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Juan L.', 15, PARSEDATETIME('16/01/2013 19:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 95.83, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (448, 152, 'Task 3', PARSEDATETIME('05/01/2013 17:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('16/01/2013 19:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 15, null, 417.43, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (449, 153, 'Task 4', PARSEDATETIME('16/01/2013 09:30', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('16/01/2013 19:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 15, PARSEDATETIME('26/01/2013 17:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 238.17, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (450, 14, 'Travel Management', '1', PARSEDATETIME('21/01/2013 20:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', PARSEDATETIME('02/03/2013 02:20', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 941.73);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (451, 140, 'Task 1', PARSEDATETIME('28/12/2012 18:57', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Andrea M.', 14, PARSEDATETIME('10/02/2013 14:44', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 494.82, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (452, 141, 'Task 2', PARSEDATETIME('12/01/2013 19:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Miguel K.', 14, PARSEDATETIME('12/02/2013 13:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 47.25, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (453, 142, 'Task 3', PARSEDATETIME('12/02/2013 20:43', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('12/02/2013 13:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 14, PARSEDATETIME('02/03/2013 02:20', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 420.35, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (454, 13, 'Sales', '4', PARSEDATETIME('07/01/2013 10:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', null, '3', 2913.63);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (455, 130, 'Task 1', PARSEDATETIME('07/01/2013 08:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 10:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 13, null, 4.87, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (456, 131, 'Task 2', PARSEDATETIME('03/01/2013 01:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 10:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 13, PARSEDATETIME('29/01/2013 09:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 527.57, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (457, 132, 'Task 3', PARSEDATETIME('03/01/2013 10:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('29/01/2013 09:36', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 13, PARSEDATETIME('26/02/2013 18:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 681.17, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (458, 133, 'Task 4a', PARSEDATETIME('29/01/2013 07:45', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('26/02/2013 18:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 13, PARSEDATETIME('11/03/2013 08:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 301.80, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (459, 134, 'Task 4b', PARSEDATETIME('27/02/2013 13:46', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('11/03/2013 08:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 13, null, 618.08, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (460, 12, 'Leave Management', '4', PARSEDATETIME('17/01/2013 09:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', PARSEDATETIME('23/02/2013 04:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 883.13);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (461, 120, 'Task 1', PARSEDATETIME('09/01/2013 17:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Marc V.', 12, PARSEDATETIME('15/01/2013 01:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 209.53, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (462, 121, 'Task 2', PARSEDATETIME('24/12/2012 00:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('15/01/2013 01:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 12, PARSEDATETIME('27/01/2013 08:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 294.67, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (463, 122, 'Task 3', PARSEDATETIME('09/01/2013 21:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('27/01/2013 08:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 12, PARSEDATETIME('23/02/2013 04:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 644.13, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (464, 11, 'Sales', '1', PARSEDATETIME('08/01/2013 10:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', null, '3', 2913.63);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (465, 110, 'Task 1', PARSEDATETIME('26/12/2012 15:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 10:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Carlos F.', 11, null, 4.87, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (466, 111, 'Task 2', PARSEDATETIME('05/01/2013 01:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 10:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 11, null, 527.57, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (467, 112, 'Task 3', PARSEDATETIME('24/12/2012 01:26', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('08/01/2013 10:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 11, PARSEDATETIME('12/01/2013 15:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 101.35, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (468, 113, 'Task 4a', PARSEDATETIME('25/12/2012 11:40', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Peter S.', 11, PARSEDATETIME('11/03/2013 08:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 301.80, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (469, 114, 'Task 4b', PARSEDATETIME('05/03/2013 18:08', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Antonio N.', 11, null, 618.08, 'Created');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (470, 10, 'Lead Management', '3', PARSEDATETIME('28/12/2012 10:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', PARSEDATETIME('09/02/2013 11:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 1033.87);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (471, 100, 'Task 1', PARSEDATETIME('13/12/2012 01:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('28/12/2012 10:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 10, PARSEDATETIME('24/01/2013 06:52', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 644.75, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (472, 101, 'Task 2', PARSEDATETIME('04/01/2013 08:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Maria A.', 10, PARSEDATETIME('03/02/2013 02:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 414.23, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (473, 102, 'Task 3', PARSEDATETIME('26/01/2013 04:50', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 02:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 10, null, null, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (474, 103, 'Task 4', PARSEDATETIME('14/01/2013 19:48', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 02:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 10, PARSEDATETIME('09/02/2013 11:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 153.47, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (475, 9, 'Lead Management', '2', PARSEDATETIME('06/01/2013 05:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', PARSEDATETIME('30/03/2013 16:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 2003.22);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (476, 90, 'Task 1', PARSEDATETIME('17/12/2012 12:02', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/01/2013 05:15', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 9, PARSEDATETIME('18/01/2013 21:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 304.28, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (477, 91, 'Task 2', PARSEDATETIME('25/12/2012 16:20', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('18/01/2013 21:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 9, PARSEDATETIME('16/02/2013 10:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 685.35, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (478, 92, 'Task 3', PARSEDATETIME('28/01/2013 06:42', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('16/02/2013 10:53', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 9, PARSEDATETIME('10/03/2013 04:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 521.67, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (479, 93, 'Task 4', PARSEDATETIME('04/03/2013 05:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('10/03/2013 04:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 9, PARSEDATETIME('30/03/2013 16:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 491.92, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (480, 8, 'Purchase', '0', PARSEDATETIME('03/01/2013 14:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', null, '2', 444.32);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (481, 80, 'Task 1', PARSEDATETIME('05/12/2012 18:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/01/2013 14:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Paco P.', 8, PARSEDATETIME('23/01/2013 15:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 480.77, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (482, 81, 'Task 2', PARSEDATETIME('10/01/2013 08:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('23/01/2013 15:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', 8, PARSEDATETIME('15/02/2013 16:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 553.35, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (483, 82, 'Task 3', PARSEDATETIME('06/02/2013 14:40', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('15/02/2013 16:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 8, PARSEDATETIME('16/03/2013 06:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 685.23, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (484, 83, 'Task 4', PARSEDATETIME('18/02/2013 16:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('16/03/2013 06:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 8, null, null, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (485, 84, 'Task 5', PARSEDATETIME('19/02/2013 20:27', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('16/03/2013 06:12', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 8, null, null, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (486, 7, 'Sales', '4', PARSEDATETIME('07/01/2013 10:54', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', PARSEDATETIME('13/03/2013 04:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '2', 1553.78);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (487, 70, 'Task 1', PARSEDATETIME('01/01/2013 06:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 10:54', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 7, PARSEDATETIME('18/01/2013 01:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 254.65, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (488, 71, 'Task 2', PARSEDATETIME('18/01/2013 16:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('18/01/2013 01:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Gemma S.', 7, PARSEDATETIME('03/02/2013 05:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 388.03, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (489, 72, 'Task 4', PARSEDATETIME('27/01/2013 13:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/02/2013 05:35', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Irina P.', 7, PARSEDATETIME('15/02/2013 18:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 300.52, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (490, 73, 'Task 5', PARSEDATETIME('19/01/2013 00:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('15/02/2013 18:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Fred G.', 7, null, 648.20, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (491, 74, 'Task 6', PARSEDATETIME('06/02/2013 11:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('15/02/2013 18:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 7, null, 405.30, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (492, 75, 'Task 7', PARSEDATETIME('04/02/2013 00:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('15/02/2013 18:06', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 7, PARSEDATETIME('13/03/2013 04:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 610.58, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (493, 6, 'Leave Management', '1', PARSEDATETIME('07/01/2013 22:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', PARSEDATETIME('18/01/2013 15:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 256.87);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (494, 60, 'Task 1', PARSEDATETIME('25/12/2012 22:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 22:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Marc V.', 6, null, 209.53, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (495, 61, 'Task 2', PARSEDATETIME('22/12/2012 11:11', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 22:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 6, null, 294.67, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (496, 62, 'Task 3', PARSEDATETIME('25/12/2012 07:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 22:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 6, PARSEDATETIME('18/01/2013 15:24', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 256.87, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (497, 5, 'Leave Management', '1', PARSEDATETIME('30/12/2012 03:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', PARSEDATETIME('21/02/2013 21:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 1289.53);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (498, 50, 'Task 1', PARSEDATETIME('05/12/2012 19:38', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('30/12/2012 03:56', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 5, PARSEDATETIME('25/01/2013 05:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 625.33, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (499, 51, 'Task 2', PARSEDATETIME('05/01/2013 18:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Antonio N.', 5, null, 294.67, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (500, 52, 'Task 3', PARSEDATETIME('18/01/2013 15:34', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('25/01/2013 05:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 5, PARSEDATETIME('21/02/2013 21:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 664.20, 'Completed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (501, 4, 'Purchase', '2', PARSEDATETIME('07/01/2013 03:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', null, '1', 803.68);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (502, 40, 'Task 1', PARSEDATETIME('02/01/2013 18:37', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 03:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Frank T.', 4, null, 705.52, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (503, 41, 'Task 2', PARSEDATETIME('30/12/2012 13:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('07/01/2013 03:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 4, PARSEDATETIME('18/01/2013 15:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 276.52, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (504, 42, 'Task 3', PARSEDATETIME('11/01/2013 13:41', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('18/01/2013 15:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Maria A.', 4, null, 417.43, 'Started');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (505, 43, 'Task 4', PARSEDATETIME('15/01/2013 19:47', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('18/01/2013 15:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Juan L.', 4, null, 238.17, 'Started');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (506, 3, 'Travel Management', '4', PARSEDATETIME('01/01/2013 15:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', PARSEDATETIME('03/02/2013 16:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 793.05);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (507, 30, 'Task 1', PARSEDATETIME('24/12/2012 18:39', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('01/01/2013 15:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 3, null, 494.82, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (508, 31, 'Task 2', PARSEDATETIME('22/12/2012 01:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('01/01/2013 15:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 3, PARSEDATETIME('21/01/2013 07:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 472.10, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (509, 32, 'Task 3', PARSEDATETIME('18/01/2013 14:48', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('21/01/2013 07:13', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Angel C.', 3, PARSEDATETIME('03/02/2013 21:23', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 326.17, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (510, 33, 'Task 4', PARSEDATETIME('16/01/2013 14:00', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Frank T.', 3, PARSEDATETIME('03/02/2013 16:10', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 162.93, 'Created');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (511, 2, 'Lead Management', '2', PARSEDATETIME('13/01/2013 18:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', null, '1', 2003.22);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (512, 20, 'Task 1', PARSEDATETIME('03/01/2013 05:59', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('13/01/2013 18:01', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Antonio N.', 2, PARSEDATETIME('06/02/2013 06:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 564.52, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (513, 21, 'Task 2', PARSEDATETIME('20/01/2013 06:18', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('06/02/2013 06:32', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Andrea M.', 2, PARSEDATETIME('24/02/2013 18:21', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 443.82, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (514, 22, 'Task 3', PARSEDATETIME('13/02/2013 19:51', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('24/02/2013 18:21', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 2, null, 521.67, 'Claimed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (515, 23, 'Task 4', PARSEDATETIME('16/02/2013 13:17', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Peter S.', 2, PARSEDATETIME('30/03/2013 16:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 491.92, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (516, 24, 'Task 5', PARSEDATETIME('19/03/2013 21:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('30/03/2013 16:28', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Laia P.', 2, null, 475.72, 'Claimed');
insert into processinstancelog(pk,processinstanceid,processname,status,start_date,user_identity,end_date,processversion,duration) values (517, 1, 'Expenses', '3', PARSEDATETIME('30/12/2012 18:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', PARSEDATETIME('11/02/2013 15:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), '1', 1028.90);
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (518, 10, 'Task 1', PARSEDATETIME('21/12/2012 14:49', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('30/12/2012 18:31', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 1, PARSEDATETIME('03/01/2013 21:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 99.03, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (519, 11, 'Task 2', PARSEDATETIME('21/12/2012 18:07', 'd/MM/yyyy HH:mm', 'en', 'GMT'), null, 'Fred G.', 1, null, 198.02, 'Created');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (520, 12, 'Task 3', PARSEDATETIME('15/12/2012 15:16', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('03/01/2013 21:33', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Miguel K.', 1, PARSEDATETIME('25/01/2013 04:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 510.50, 'Completed');
insert into bamtasksummary(pk,taskid,taskname,createddate,startdate,userid,processinstanceid,enddate,duration,status) values (521, 13, 'Task 4', PARSEDATETIME('10/01/2013 14:58', 'd/MM/yyyy HH:mm', 'en', 'GMT'), PARSEDATETIME('25/01/2013 04:03', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 'Peter S.', 1, PARSEDATETIME('11/02/2013 15:25', 'd/MM/yyyy HH:mm', 'en', 'GMT'), 419.37, 'Completed');
