Home

sql to bulk remove borrower interest codes from borrower records

Submitted by lcartwright on Thu, 2012-01-26 16:44

Hi
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.

delete BORROWER_GROUPING_LINK
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
Lin

»

bulk removal of interest codes

Submitted by lcartwright on Fri, 2012-01-27 15:11.

I realise now that I probably shouldn't remove any from the grouping table as this contains all the codes configured in Alto. I had originally thought that this table was populated when a code was used by a borrower record. Derr!
So.. is it ok to just remove the relevant rows from the borrower grouping link table.
Lin

»

bulk removal of interest codes

Submitted by lcartwright on Mon, 2012-01-30 14:48.

Hi
I would like to be able to run this delete on 1st Feb. My test runs on MIS confirm the expected number of rows and the correct Interest codes deleted. I've checked the results against some Decisions queries and it all LOOKS ok. I'd feel happier to have a confirmation that deleting these rows will not have an affect on another process or part of the DB.
many thanks
Lin

»