text: 
  -----------------START--------------------
  
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (1, 'Absenteesim of door to door garbage collector', 18, 0, 'AODTDGC', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (2, 'Absenteesim of sweepers', NULL, 0, 'AOS', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (3, 'Bio Medical waste/Health hazard waste removal', NULL, 0, 'BMWHHWR', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (4, 'Broken Bin', NULL, 0, 'BRKNB', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (5, 'Building plan sanction', NULL, 0, 'BPS', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (6, 'Burning of garbage', NULL, 0, 'BOG', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (7, 'Change of address in Electoral Roll', 16, 0, 'COAIEB', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (8, 'Complaints regarding  Cleanliness of Toilets in Shopping complex', 18, 0, 'CRCTSC', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (9, 'Complaints regarding  Dispensary ', 18, 0, 'CRD', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (10, 'Complaints regarding Bridges/Flyovers/Subways', 19, 0, 'CRBFS', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (11, 'Complaints regarding Park', NULL, 0, 'CRP', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (12, 'Complaints regarding Play grounds', NULL, 0, 'CRPG', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (13, 'Complaints regarding Schools', 5, 0, 'CRS', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (14, 'Complaints regarding Voter list', 24, 0, 'CRVL', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (15, 'Complaints regarding burial ground', 18, 0, 'CRBG', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (16, 'Complaints regarding community hall', 24, 0, 'CRCH', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (17, 'Complaints regarding public toilets', 18, 0, 'CRPT', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (18, 'Complaints regarding quality of food in Hotels', 18, 0, 'CRQOFIH', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (19, 'Complaints regarding unauthorised restaurants', 18, 0, 'CRUR', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (20, 'Complaints related to issue of all types of license ', 18, 0, '20code', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (21, 'Complaints related to property tax ', 24, 0, 'CRTPT', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (22, 'Covering of Man holes of SWD', NULL, 0, 'COMHOSWD', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (23, 'Damage to the  Electric Pole', 20, 0, 'DTTEP', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (24, 'Death of Stray Animals', 18, 0, 'DOSA', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (25, 'Desilting of Canal', NULL, 0, 'DOC', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (26, 'Desilting of Drain', NULL, 0, 'DOD', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (27, 'Disposal of removed silt on the Road', NULL, 0, 'DORSOTR', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (28, 'Dog menace ', 18, 0, 'DM', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (29, 'Electric Shock due to street light', 20, 0, 'ESDTSL', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (30, 'Encroachment on the public property', NULL, 0, 'EOTPP', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (31, 'Formation of New Road', NULL, 0, 'FNR', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (32, 'Garbage lorry with out Net', NULL, 0, 'GLWON', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (33, 'Illegal draining of sewage to SWD/Open site', NULL, 0, 'IDOSTOS', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (34, 'Illegal slaughtering', 18, 0, 'IS', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (35, 'Improper Sweeping', NULL, 0, 'IMS', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (36, 'Issue of Birth and Death Certificate', 18, 0, 'IOBADC', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (37, 'Mosquito menace ', 18, 0, 'MM', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (38, 'Name Error (Spelling Related)', 16, 0, 'NESR', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (39, 'Name not found in Electoral Roll', 16, 0, 'NNFIER', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (40, 'New Drain Construction', 4, 0, 'NDC', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (63, 'Shifting of garbage bin', NULL, 0, 'SGB', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (64, 'Slaughter House', 18, 0, 'SH', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (65, 'Slow progress of work', NULL, 0, 'SPOW', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (66, 'Spilling of Garbage from lorry', NULL, 0, 'SOGFL', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (67, 'Stagnation of water', NULL, 0, 'SOW', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (69, 'Stray cattle', 18, 0, 'SC', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (70, 'Transfer Station Smell', NULL, 0, 'TSS', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (71, 'Unauthorised / Illegal construction', NULL, 0, 'UAIC', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (72, 'Unauthorised Advt. Boards', NULL, 0, 'UAAB', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (73, 'Unauthorised sale of meat and meat product', 18, 0, 'UASMP', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (74, 'Unauthorised tree Cutting', NULL, 0, 'UATC', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (41, 'New Street light', 20, 0, 'NSL', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (42, 'Non Burning of Street Lights', 20, 0, 'NBOSL', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (43, 'Nuisance by garbage tractors or trucks', NULL, 0, 'NBGTOT', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (44, 'Obstruction of Trees', NULL, 0, 'OOT', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (45, 'Obstruction of water flow', NULL, 0, 'OOWF', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (46, 'Over flowing of garbage bins ', NULL, 0, 'OFOGB', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (47, 'Over head cable Wires running in Hapazard manner', NULL, 0, 'OHCWRIHM', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (48, 'Parking Issue', NULL, 0, 'PI', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (49, 'Poor quality of work', NULL, 0, 'PQOW', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (50, 'Pot hole fill up/Repairs to the damage surface', NULL, 0, 'PHFURTTDS', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (51, 'Provision of garbage bin', NULL, 0, 'POGB', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (52, 'Public Health/Dengue/Malaria/Gastro-enteritis', 18, 0, 'PHDMG', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (53, 'Removal of Debris', NULL, 0, 'ROD', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (54, 'Removal of fallen trees', NULL, 0, 'ROFT', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (55, 'Removal of garbage', NULL, 0, 'ROG', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (56, 'Removal of shops in the footpath', NULL, 0, 'ROSITFP', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (57, 'Repairs to existing footpath', NULL, 0, 'RTEFP', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (58, 'Repairs to the SWD', NULL, 0, 'RTTSWD', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (59, 'Request to provide footpath', NULL, 0, 'RTPFP', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (60, 'Request to relay the Road', NULL, 0, 'RTRR', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (61, 'Road Side Eateries', 18, 0, 'RSE', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (62, 'Shifting of Street light Pole', 20, 0, 'SOSLP', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (68, 'Stray Pigs', 18, 0, 'SP', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (75, 'Unhygienic and improper transport of meat and livestock', 18, 0, 'UHITOMAL', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (76, 'Unsanitary conditions on the road', 18, 0, 'USCOTR', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  INSERT INTO egpgr_complainttype (id, name, department, version, code, isactive, description, createddate, lastmodifieddate, createdby, lastmodifiedby,slahours,hasfinancialimpact) VALUES (77, 'Violation of DCR/Building bye laws', NULL, 0, 'VODCRBL', true, NULL, '2010-01-01 00:00:00', '2015-01-01 00:00:00', 1, 1,24,false);
  
  
  
  SELECT pg_catalog.setval('seq_egpgr_complainttype', 77, true);
  ------------------END---------------------
  
  
  INSERT INTO egpgr_router (id, complainttypeid, "position", bndryid, version, createdby, createddate, lastmodifiedby, lastmodifieddate) VALUES (1, NULL, 2, 1, 0, 1, '2015-08-28', 1, '2015-08-28');
  SELECT pg_catalog.setval('seq_egpgr_router', 1, true);
  