--Delete/Update rfrIftaExchange and rfrIftaBaseSurcharge for 3Q2010
DELETE FROM rfrIftaExchange WHERE fdtmFromDate = {ts '2010-07-01 00:00:00.000'} AND fdtmToDate = {ts '2010-09-30 00:00:00.000'};
DELETE FROM rfrIftaBaseSurcharge WHERE fdtmPeriod = {ts '2010-09-30 00:00:00.000'};
INSERT INTO rfrIFTAExchange(fstrIfta,fdtmfromDate,fdtmToDate,fdblCanRate,fdblUSRate,fblnActive) VALUES ('IFTA',{ts '2010-07-01 00:00:00.000'},{ts '2010-09-30 00:00:00.000'},0.9807,1.0197,1)

--Insert new rates in to rfrIftaBaseSurcharge
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AB','G',0.09,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'BC','G',0.1895,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MB','G',0.115,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NB','G',0.107,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NL' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NL','G',0.165,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NF' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NF','G',0.165,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NS','G',0.155,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ON','G',0.147,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PE','G',0.158,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'QC','G',0.162,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SK','G',0.15,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AL','G',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AZ','G',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AR','G',0.0579,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CA','G',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CO','G',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CT','G',0.0674,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'DE','G',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'FL','G',0.0796,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'GA','G',0.0412,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ID','G',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IL','G',0.0843,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IN','G',0.0485,0.0297,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IA','G',0.0566,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KS','G',0.0646,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KY','G',0.066,0.0116,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'LA','G',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ME','G',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MD','G',0.0633,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MA','G',0.0566,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MI','G',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MN','G',0.0741,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MS','G',0.0485,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MO','G',0.0458,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MT','G',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NE','G',0.073,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NV','G',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NH','G',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NJ','G',0.0391,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NM','G',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NY','G',0.1086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NC','G',0.086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ND','G',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OH','G',0.0755,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OK','G',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OR','G',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PA','G',0.084,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'RI','G',0.0862,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SC','G',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SD','G',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TN','G',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TX','G',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'UT','G',0.066,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VT','G',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VA','G',0.0471,0.0094,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WA','G',0.1011,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WV','G',0.0868,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WI','G',0.0886,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WY','G',0.0377,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AB','D',0.09,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'BC','D',0.2011,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MB','D',0.115,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NB','D',0.169,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NL' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NL','D',0.165,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NF' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NF','D',0.165,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NS','D',0.154,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ON','D',0.143,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PE','D',0.201,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'QC','D',0.172,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SK','D',0.15,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AL','D',0.0512,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AZ','D',0.0701,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AR','D',0.0606,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CA','D',0.1004,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CO','D',0.0553,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CT','D',0.1067,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'DE','D',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'FL','D',0.0853,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'GA','D',0.0425,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ID','D',0.0674,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IL','D',0.0943,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IN','D',0.0431,0.0297,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IA','D',0.0606,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KS','D',0.0701,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KY','D',0.0579,0.0274,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'LA','D',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ME','D',0.0827,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MD','D',0.0654,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MA','D',0.0566,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MI','D',0.0819,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MN','D',0.0741,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MS','D',0.0485,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MO','D',0.0458,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MT','D',0.0747,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NE','D',0.073,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NV','D',0.0727,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NH','D',0.0485,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NJ','D',0.0471,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NM','D',0.0566,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NY','D',0.1038,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NC','D',0.086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ND','D',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OH','D',0.0755,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OK','D',0.035,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OR','D',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PA','D',0.1027,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'RI','D',0.0862,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SC','D',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SD','D',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TN','D',0.0458,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TX','D',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'UT','D',0.066,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VT','D',0.0781,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VA','D',0.0471,0.0094,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WA','D',0.1011,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WV','D',0.0868,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WI','D',0.0886,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WY','D',0.0377,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AB','A',0.09,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'BC','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MB','A',0.115,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NB','A',0.107,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NL' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NL','A',0,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NF' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NF','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NS','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ON','A',0.147,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PE','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'QC','A',0.162,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SK','A',0.15,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AL','A',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AZ','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AR','A',0.0579,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CA','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CO','A',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CT','A',0.0674,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'DE','A',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'FL','A',0.0796,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'GA','A',0.0412,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ID','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IL','A',0.0843,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IN','A',0.0485,0.0297,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IA','A',0.0512,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KS','A',0.0646,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KY','A',0.066,0.0116,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'LA','A',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ME','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MD','A',0.0633,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MA','A',0.0566,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MI','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MN','A',0.0741,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MS','A',0.0485,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MO','A',0.0458,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MT','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NE','A',0.073,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NV','A',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NH','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NJ','A',0.0391,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NM','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NY','A',0.1086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NC','A',0.086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ND','A',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OH','A',0.0755,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OK','A',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OR','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PA','A',0.084,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'RI','A',0.0862,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SC','A',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SD','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TN','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TX','A',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'UT','A',0.066,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VT','A',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VA','A',0.0471,0.0094,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WA','A',0.1011,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WV','A',0.0868,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WI','A',0.0886,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WY','A',0.0377,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AB','P',0.065,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'BC','P',0.0308,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MB','P',0.03,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NB','P',0.067,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NL' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NL','P',0.07,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NF' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NF','P',0.07,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NS','P',0.07,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ON','P',0.043,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PE','P',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'QC','P',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SK','P',0.09,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AL','P',0.0512,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AZ','P',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AR','P',0.0445,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CA','P',0.0162,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CO','P',0.0553,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CT','P',0.0701,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'DE','P',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'FL','P',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'GA','P',0.0345,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ID','P',0.0487,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IL','P',0.0806,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IN','P',0.0431,0.0297,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IA','P',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KS','P',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KY','P',0.066,0.0116,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'LA','P',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ME','P',0.0579,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MD','P',0.0633,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MA','P',0.0704,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MI','P',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MN','P',0.0556,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MS','P',0.0458,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MO','P',0.0458,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MT','P',0.014,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NE','P',0.073,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NV','P',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NH','P',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NJ','P',0.0249,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NM','P',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NY','P',0.0646,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NC','P',0.086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ND','P',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OH','P',0.0755,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OK','P',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OR','P',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PA','P',0.0614,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'RI','P',0.0862,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SC','P',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SD','P',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TN','P',0.0377,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TX','P',0.0404,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'UT','P',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VT','P',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VA','P',0.0471,0.0094,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WA','P',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WV','P',0.0868,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WI','P',0.0609,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WY','P',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AB','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'BC','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MB','L',0.115,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NB','L',0.169,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NL' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NL','L',0,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NF' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NF','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NS','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ON','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PE','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'QC','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SK','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AL','L',0.0512,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AZ','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AR','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CA','L',0.0162,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CO','L',0.0553,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CT','L',0.0701,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'DE','L',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'FL','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'GA','L',0.041,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ID','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IL','L',0.0806,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IN','L',0.0431,0.0297,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IA','L',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KS','L',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KY','L',0.0579,0.0274,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'LA','L',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ME','L',0.0471,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MD','L',0.0633,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MA','L',0.0704,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MI','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MN','L',0.0445,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MS','L',0.0485,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MO','L',0.0458,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MT','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NE','L',0.073,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NV','L',0.0727,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NH','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NJ','L',0.0249,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NM','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NY','L',0.1086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NC','L',0.086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ND','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OH','L',0.0755,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OK','L',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OR','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PA','L',0.049,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'RI','L',0.0862,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SC','L',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SD','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TN','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TX','L',0.0404,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'UT','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VT','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VA','L',0.0471,0.0094,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WA','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WV','L',0.0868,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WI','L',0.0666,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WY','L',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AB','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'BC','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MB','C',0.115,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NB','C',0.169,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NL' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NL','C',0,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NF' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NF','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NS','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ON','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PE','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'QC','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SK','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AL','C',0.0512,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AZ','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AR','C',0.0135,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CA','C',0.0189,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CO','C',0.0553,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CT','C',0.0701,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'DE','C',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'FL','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'GA','C',0.041,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ID','C',0.053,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IL','C',0.0806,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IN','C',0.0431,0.0297,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IA','C',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KS','C',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KY','C',0.0579,0.0274,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'LA','C',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ME','C',0.0643,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MD','C',0.0633,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MA','C',0.0704,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MI','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MN','C',0.0741,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MS','C',0.0485,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MO','C',0.0458,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MT','C',0.0189,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NE','C',0.073,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NV','C',0.0566,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NH','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NJ','C',0.0249,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NM','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NY','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NC','C',0.086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ND','C',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OH','C',0.0755,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OK','C',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OR','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PA','C',0.0213,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'RI','C',0.0862,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SC','C',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SD','C',0.0269,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TN','C',0.035,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TX','C',0.0404,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'UT','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VT','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VA','C',0.0471,0.0094,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WA','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WV','C',0.0868,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WI','C',0.0666,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WY','C',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AB','E',0.09,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'BC','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MB','E',0.09,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NB','E',0.169,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NL' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NL','E',0,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NF' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NF','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NS','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ON','E',0.147,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PE','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'QC','E',0.172,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SK','E',0.15,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AL','E',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AZ','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AR','E',0.0579,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CA','E',0.0243,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CO','E',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CT','E',0.0674,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'DE','E',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'FL','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'GA','E',0.041,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ID','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IL','E',0.0843,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IN','E',0.0431,0.0297,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IA','E',0.0512,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KS','E',0.0646,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KY','E',0.066,0.0116,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'LA','E',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ME','E',0.0525,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MD','E',0.0633,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MA','E',0.0566,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MI','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MN','E',0.0741,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MS','E',0.0485,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MO','E',0.0458,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MT','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NE','E',0.073,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NV','E',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NH','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NJ','E',0.0391,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NM','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NY','E',0.1086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NC','E',0.086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ND','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OH','E',0.0755,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OK','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OR','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PA','E',0.0561,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'RI','E',0.0862,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SC','E',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SD','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TN','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TX','E',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'UT','E',0.066,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VT','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VA','E',0.0471,0.0094,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WA','E',0.1011,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WV','E',0.0868,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WI','E',0.0886,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WY','E',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AB','M',0.09,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'BC','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MB','M',0.115,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NB','M',0.169,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NL' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NL','M',0,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NF' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NF','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NS','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ON','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PE','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'QC','M',0.162,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SK','M',0.15,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AL','M',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AZ','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AR','M',0.0579,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CA','M',0.0243,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CO','M',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CT','M',0.0674,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'DE','M',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'FL','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'GA','M',0.041,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ID','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IL','M',0.0843,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IN','M',0.0431,0.0297,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IA','M',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KS','M',0.0701,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KY','M',0.066,0.0116,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'LA','M',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ME','M',0.0391,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MD','M',0.0633,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MA','M',0.0566,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MI','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MN','M',0.0741,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MS','M',0.0485,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MO','M',0.0458,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MT','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NE','M',0.073,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NV','M',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NH','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NJ','M',0.0391,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NM','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NY','M',0.1086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NC','M',0.086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ND','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OH','M',0.0755,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OK','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OR','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PA','M',0.0415,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'RI','M',0.0862,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SC','M',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SD','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TN','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TX','M',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'UT','M',0.066,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VT','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VA','M',0.0471,0.0094,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WA','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WV','M',0.0868,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WI','M',0.0886,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WY','M',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AB','J',0.09,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'BC','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MB','J',0.09,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NB','J',0.107,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NL' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NL','J',0,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NF' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NF','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NS','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ON','J',0.147,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PE','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'QC','J',0.172,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SK','J',0.15,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AL','J',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AZ','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AR','J',0.0579,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CA','J',0.0243,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CO','J',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CT','J',0.0674,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'DE','J',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'FL','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'GA','J',0.0412,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ID','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IL','J',0.0843,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IN','J',0.0485,0.0297,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IA','J',0.0512,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KS','J',0.0458,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KY','J',0.066,0.0116,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'LA','J',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ME','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MD','J',0.0633,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MA','J',0.0566,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MI','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MN','J',0.0526,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MS','J',0.0485,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MO','J',0.0458,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MT','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NE','J',0.073,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NV','J',0.062,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NH','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NJ','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NM','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NY','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NC','J',0.086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ND','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OH','J',0.0755,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OK','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OR','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PA','J',0.059,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'RI','J',0.0862,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SC','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SD','J',0.0269,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TN','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TX','J',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'UT','J',0.066,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VT','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VA','J',0.0471,0.0094,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WA','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WV','J',0.0868,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WI','J',0.0886,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WY','J',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AB','K',0.09,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'BC','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MB','K',0.115,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NB','K',0.169,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NL' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NL','K',0,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NF' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NF','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NS','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ON','K',0.147,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PE','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'QC','K',0.162,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SK','K',0.15,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AL','K',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AZ','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AR','K',0.0579,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CA','K',0.0243,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CO','K',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CT','K',0.0674,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'DE','K',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'FL','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'GA','K',0.041,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ID','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IL','K',0.0843,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IN','K',0.0485,0.0297,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IA','K',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KS','K',0.0646,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KY','K',0.066,0.0116,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'LA','K',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ME','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MD','K',0.0633,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MA','K',0.0566,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MI','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MN','K',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MS','K',0.0485,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MO','K',0.0458,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MT','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NE','K',0.073,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NV','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NH','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NJ','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NM','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NY','K',0.1086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NC','K',0.086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ND','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OH','K',0.0755,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OK','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OR','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PA','K',0.0479,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'RI','K',0.0862,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SC','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SD','K',0.0269,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TN','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TX','K',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'UT','K',0.066,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VT','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VA','K',0.0471,0.0094,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WA','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WV','K',0.0868,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WI','K',0.0886,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WY','K',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AB','H',0.09,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'BC','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MB','H',0.115,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NB','H',0.169,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NL' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NL','H',0,0,1);
IF EXISTS (SELECT * FROM rfrIFTAJurisdiction WHERE fstrJurisdiction = 'NF' and fblnActive = 1) INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NF','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NS','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ON','H',0.147,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PE','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'QC','H',0.172,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SK','H',0.15,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AL','H',0.0431,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AZ','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'AR','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CA','H',0.1004,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CO','H',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'CT','H',0.0674,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'DE','H',0.0592,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'FL','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'GA','H',0.041,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ID','H',0.0674,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IL','H',0.0843,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IN','H',0.0485,0.0297,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'IA','H',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KS','H',0.0701,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'KY','H',0.0579,0.0274,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'LA','H',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ME','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MD','H',0.0654,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MA','H',0.0566,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MI','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MN','H',0.0741,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MS','H',0.0485,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MO','H',0.0458,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'MT','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NE','H',0.073,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NV','H',0.0512,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NH','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NJ','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NM','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NY','H',0.1086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'NC','H',0.086,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'ND','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OH','H',0.0755,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OK','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'OR','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'PA','H',0.1027,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'RI','H',0.0862,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SC','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'SD','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TN','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'TX','H',0.0538,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'UT','H',0.066,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VT','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'VA','H',0.0471,0.0094,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WA','H',0,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WV','H',0.0868,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WI','H',0.0886,0,1);
INSERT INTO rfrIftaBaseSurcharge (fdtmPeriod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurcharge,fblnActive) VALUES ({ts '2010-09-30 00:00:00.000'},'WY','H',0,0,1);