Dear Lowell,

this an example from the current scenario:

offer 1:

Tariff_idPrefixDestination rate startdate endDate

1273360042France-Bouygues Mobile0.xxx2010-05-222079-01-01

offer 2:

I got new rate:

Tariff_idPrefixDestination ratestartdate endDate

1273360042France-Bouygues Mobile0.xxx2010-05-222010-06-03

1273360042France-Bouygues Mobile0.yyy2010-06-042079-01-01

offer 3: date 2010-06-15

Code removed from the offer for this destination

Tariff_idPrefixDestination ratestartdate endDate

1273360042France-Bouygues Mobile0.xxx2010-05-222010-06-03

1273360042France-Bouygues Mobile0.yyy2010-06-042010-06-14

Note:

every destination or prefix not exist or changed on the next offer must be ended (even if one letter changed in the destination field)

always the increase rate have a different start date from the decrease

do I have to change my analyses?

Do I need a history table? if yes, and if the enddate is in the future, the current rate will be in history table!

what do you suggest?

it is very complicated right? 🙂