Hi Tony,
It does sound like what you need is beyond what is possible with the database activity, and that some custom development to meet your need might be the way to go.
Before that though I would suggest you have a browse through the Moodle plugin database:
and see if there are any existing plugins that would work for you. If not (and assuming you don't have any in-house developement capability) I'd suggest getting in touch with a Totara Partner - they will be able to help with the process of defining your requirements and working out the best way to deliver what you need:
Simon