We have a forms application which allows the user to enter the data pertaining to a given benificiary to obtain the services related to his place of residence. The service can be either to grant the beneficiary a new apartment or renovate his existing house/apartment among other options. As there is a large number of applications, a points system is used to give each application a grade or mark and the applications with the highest marks are processed. This mark is calculated for each application by pressing a button on the form for each application individually.
The need now is to be able to perform a bulk update and recalculate the mark for all applications in one pass.
I am thinking of writing a procedure to calculate the mark for all the applications in one pass, but I am wondering what to consider in such an approach given that the forms application reads data from many tables in addition to the data provided on the form to calculate the mark and determine whether a given benificiary is eligible for the service or not?