This site is a read-only archive of the previous TDN. If you wish to contribute to any discussions, please visit the above link.
sql to bulk remove borrower interest codes from borrower records
I have been asked if it is possible to remove all the borrower interest codes currently in use by borrowers. Bradford only use the interest codes to allow us to use Decisions to report on the take-up of Bookstart Schemes. They are starting a new scheme and want to make a clean start.
I have tested on one borrower on MIS and if I delete the rows from the BORROWER_GROUPING_LINK table for SUB_TYPE 5 this will do it.
2> where BORROWER_ID = 125898
3> and SUB_TYPE = 5
But should I also delete the SUB_TYPE 5 rows from GROUPING?
Also am I missing something else?
Is this dangerous?
Thanks for any advice