Assignment at work

Hi Guys,

I got an interesting assignment yesterday.

We have running log of our main application stored in database within complex db tables (prescription log). Couple of major insurance companies require us to report them our prescription history to use their formulary information. The problem begins with all the different message formats of reporting and all the reports are based on the running log database with certain date range. Running log table has a time stamp field.

Let's think about this. It obviously contains one part "stays as same" and the other part "varies".
Isn't it good challenge for using design pattern?

I don't have any clear idea about this little project but I believe you guys can help me with this.
Any comments and ideas are welcome!

Chester