Delete from RF_IFTAEXCHANGE WHERE tdmuser = '21' AND tdmslice = 0 AND fdtmFromDate = '1-Jul-1998' AND fdtmToDate = '30-Sep-1998'; insert into RF_IFTAEXCHANGE(tdmUser,tdmSlice,fstrDescription,fdtmfromDate,fdtmToDate,fdblCanRate,fdblUSRate,fblnActive) values ('21',0,'IFTA','1-Jul-1998','30-Sep-1998',0.6784,1.4740,1); Delete from RF_IFTABaseSurcharge where fdtmPeriod = '9/30/1998' ; insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AB','G',0.2311,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AB','D',0.2311,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AB','EG',0.2196,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AB','P',0.1669,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AB','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','BC','G',0.2825,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','BC','D',0.2953,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','BC','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','BC','P',0.0514,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','BC','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MB','G',0.2953,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MB','D',0.2799,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MB','EG',0.2311,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MB','P',0.1464,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MB','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NB','G',0.2748,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NB','D',0.3518,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NB','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NB','P',0.172,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NB','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NF','G',0.4237,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NF','D',0.4237,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NF','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NF','P',0.1797,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NF','N',0.4237,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NS','G',0.3467,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NS','D',0.3954,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NS','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NS','P',0.1797,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NS','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ON','G',0.3775,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ON','D',0.3672,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ON','EG',0.3775,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ON','P',0.1104,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ON','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','PE','G',0.3338,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','PE','D',0.3467,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','PE','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','PE','P',0.3338,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','PE','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','QC','G',0.3903,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','QC','D',0.416,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','QC','EG',0.3903,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','QC','P',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','QC','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SK','G',0.3852,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SK','D',0.3852,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SK','EG',0.3852,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SK','P',0.2311,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SK','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AL','G',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AL','D',0.17,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AL','EG',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AL','P',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AL','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AZ','G',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AZ','D',0.27,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AZ','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AZ','P',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AZ','N',0,0,1); update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'AZ' and fstrFuelType = 'G'; update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'AZ' and fstrFuelType = 'D'; update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'AZ' and fstrFuelType = 'EG'; update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'AZ' and fstrFuelType = 'P'; update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'AZ' and fstrFuelType = 'N'; insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AR','G',0.185,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AR','D',0.185,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AR','EG',0.185,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AR','P',0.165,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','AR','N',0.05,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CA','G',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CA','D',0.263,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CA','EG',0.09,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CA','P',0.06,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CA','N',0.07,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CO','G',0.22,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CO','D',0.205,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CO','EG',0.22,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CO','P',0.205,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CO','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CT','G',0.32,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CT','D',0.18,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CT','EG',0.31,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CT','P',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','CT','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','DE','G',0.23,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','DE','D',0.22,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','DE','EG',0.23,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','DE','P',0.22,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','DE','N',0.22,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','FL','G',0.1507,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','FL','D',0.2707,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','FL','EG',0.1507,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','FL','P',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','FL','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','GA','G',0.1009,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','GA','D',0.1009,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','GA','EG',0.1009,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','GA','P',0.1009,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','GA','N',0.1009,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ID','G',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ID','D',0.25,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ID','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ID','P',0.181,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ID','N',0.197,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IL','G',0.246,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IL','D',0.274,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IL','EG',0.246,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IL','P',0.251,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IL','N',0.243,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IN','G',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IN','D',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IN','EG',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IN','P',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IN','N',0.16,0,1); update rf_IFTABaseSurcharge set fcurSurCharge = 0.11 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'IN' and fstrFuelType = 'G'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.11 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'IN' and fstrFuelType = 'D'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.11 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'IN' and fstrFuelType = 'EG'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.11 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'IN' and fstrFuelType = 'P'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.11 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'IN' and fstrFuelType = 'N'; insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IA','G',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IA','D',0.225,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IA','EG',0.19,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IA','P',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','IA','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','KS','G',0.18,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','KS','D',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','KS','EG',0.18,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','KS','P',0.17,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','KS','N',0.17,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','KY','G',0.15,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','KY','D',0.12,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','KY','EG',0.15,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','KY','P',0.15,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','KY','N',0.12,0,1); update rf_IFTABaseSurcharge set fcurSurCharge = 0.022 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'KY' and fstrFuelType = 'G'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.052 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'KY' and fstrFuelType = 'D'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.022 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'KY' and fstrFuelType = 'EG'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.022 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'KY' and fstrFuelType = 'P'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.052 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'KY' and fstrFuelType = 'N'; insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','LA','G',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','LA','D',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','LA','EG',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','LA','P',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','LA','N',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ME','G',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ME','D',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ME','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ME','P',0.18,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ME','N',0.18,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MD','G',0.235,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MD','D',0.2425,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MD','EG',0.235,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MD','P',0.235,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MD','N',0.235,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MA','G',0.21,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MA','D',0.21,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MA','EG',0.21,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MA','P',0.089,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MA','N',0.089,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MI','G',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MI','D',0.09,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MI','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MI','P',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MI','N',0,0,1); update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'MI' and fstrFuelType = 'G'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.12 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'MI' and fstrFuelType = 'D'; update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'MI' and fstrFuelType = 'EG'; update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'MI' and fstrFuelType = 'P'; update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'MI' and fstrFuelType = 'N'; insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MN','G',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MN','D',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MN','EG',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MN','P',0.15,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MN','N',0.12,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MS','G',0.18,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MS','D',0.18,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MS','EG',0.18,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MS','P',0.17,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MS','N',0.18,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MO','G',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MO','D',0.17,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MO','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MO','P',0.17,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MO','N',0.17,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MT','G',0.27,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MT','D',0.2775,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MT','EG',0.27,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MT','P',0.0518,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','MT','N',0.07,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NE','G',0.235,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NE','D',0.235,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NE','EG',0.235,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NE','P',0.235,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NE','N',0.235,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NV','G',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NV','D',0.27,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NV','EG',0.19,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NV','P',0.22,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NV','N',0.21,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NH','G',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NH','D',0.18,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NH','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NH','P',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NH','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NJ','G',0.145,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NJ','D',0.175,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NJ','EG',0.145,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NJ','P',0.0925,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NJ','N',0.0925,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NM','G',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NM','D',0.18,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NM','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NM','P',0.06,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NM','N',0.06,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NY','G',0.293,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NY','D',0.2915,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NY','EG',0.293,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NY','P',0.147,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NY','N',0.293,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NC','G',0.216,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NC','D',0.216,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NC','EG',0.216,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NC','P',0.216,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','NC','N',0.216,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ND','G',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ND','D',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ND','EG',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ND','P',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','ND','N',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OH','G',0.22,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OH','D',0.22,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OH','EG',0.22,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OH','P',0.22,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OH','N',0.22,0,1); update rf_IFTABaseSurcharge set fcurSurCharge = 0.03 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'OH' and fstrFuelType = 'G'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.03 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'OH' and fstrFuelType = 'D'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.03 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'OH' and fstrFuelType = 'EG'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.03 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'OH' and fstrFuelType = 'P'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.03 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'OH' and fstrFuelType = 'N'; insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OK','G',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OK','D',0.13,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OK','EG',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OK','P',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OK','N',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OR','G',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OR','D',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OR','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OR','P',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','OR','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','PA','G',0.259,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','PA','D',0.308,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','PA','EG',0.259,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','PA','P',0.259,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','PA','N',0.259,0,1); update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'PA' and fstrFuelType = 'G'; update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'PA' and fstrFuelType = 'D'; update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'PA' and fstrFuelType = 'EG'; update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'PA' and fstrFuelType = 'P'; update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'PA' and fstrFuelType = 'N'; insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','RI','G',0.28,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','RI','D',0.28,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','RI','EG',0.28,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','RI','P',0.28,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','RI','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SC','G',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SC','D',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SC','EG',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SC','P',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SC','N',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SD','G',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SD','D',0.21,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SD','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SD','P',0.19,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','SD','N',0.09,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','TN','G',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','TN','D',0.17,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','TN','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','TN','P',0.14,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','TN','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','TX','G',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','TX','D',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','TX','EG',0.2,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','TX','P',0.15,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','TX','N',0.15,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','UT','G',0.245,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','UT','D',0.245,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','UT','EG',0.245,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','UT','P',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','UT','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','VT','G',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','VT','D',0.17,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','VT','EG',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','VT','P',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','VT','N',0,0,1); update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'VT' and fstrFuelType = 'G'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.09 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'VT' and fstrFuelType = 'D'; update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'VT' and fstrFuelType = 'EG'; update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'VT' and fstrFuelType = 'P'; update rf_IFTABaseSurcharge set fcurSurCharge = 0 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'VT' and fstrFuelType = 'N'; insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','VA','G',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','VA','D',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','VA','EG',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','VA','P',0.16,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','VA','N',0.16,0,1); update rf_IFTABaseSurcharge set fcurSurCharge = 0.035 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'VA' and fstrFuelType = 'G'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.035 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'VA' and fstrFuelType = 'D'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.035 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'VA' and fstrFuelType = 'EG'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.035 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'VA' and fstrFuelType = 'P'; update rf_IFTABaseSurcharge set fcurSurCharge = 0.035 where tdmuser = 21 and tdmslice = 0 and fdtmPeriod = '9/30/1998' and fstrJurisdiction = 'VA' and fstrFuelType = 'N'; insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WA','G',0.23,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WA','D',0.23,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WA','EG',0.23,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WA','P',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WA','N',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WV','G',0.2535,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WV','D',0.2535,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WV','EG',0.2535,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WV','P',0.2535,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WV','N',0.2535,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WI','G',0.284,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WI','D',0.284,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WI','EG',0.284,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WI','P',0.186,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WI','N',0.203,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WY','G',0.13,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WY','D',0.13,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WY','EG',0.13,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WY','P',0,0,1); insert into RF_IFTABaseSurcharge(tdmUser,tdmSlice,fdtmperiod,fstrJurisdiction,fstrFuelType,fcurBase,fcurSurCharge,fblnActive)values ('21','0','9/30/1998','WY','N',0,0,1);