simon.crick (9/25/2013)

---

Gary Varga (9/25/2013)

---

simon.crick (9/25/2013)

---

...This is 100% truthfull, and I do not like the suggestions that I am lying.

I for one am not suggesting that you are lying but how can any system, regardless of complexity, not require enhancing to comply with new regulation that was not on the statute books (if in UK - may be another term if in a different country) at the time of development?

I find that an amazing feat!!!

Eager to learn so please share.

It is a client database and commission tracking system. It is used to keep track of the pensions, investments and other financial products held by approx 1000 clients, as well as automatically track commission payments from the financial institutions (e.g. pension providers) to the advisor and from the advisor to the agents that introduced the clients. Many new types of financial products have emerged over the last 20 years, but the database schema has been generic enough to cope.

To satisfy the regulations that you mention, I believe the advisor has to keep scanned copies of policy documents and authorisation instructions, etc, but these are not stored in the client database.

As I mentioned earlier, there were several off-the-shelf packages available at the time, but they were all way to complicated and did not have the flexibility to cope with future changes.

The system we created was much simpler and much more flexible. It satisfied the requirements without imposing any unnecessary constraints, and it has stood the test of time.

Simon