A local research company is requesting to have a web application front end built for an oracle database that stores budgeting information for the finance department. The finance department currently accomplishes this task using a series of convoluted excel spreadsheets, which are cumbersome. In addition to storing data, the application must also help in calculating which accounts doctors shall be paid from which are associated to the clinical research they are performing. This logic is crucial because there may be multiple sources of funding for one research study. There are also maximum amounts of payments that may be made to a doctor or researcher depending on the amount of salary they receive in addition to any personal practice salary the individual will receive. Lastly, as requested by the client, there is a requirement to import current data from existing spreadsheets into the database to reduce data entry man hours. It is of utmost importance that the data be secure through the implementation of a user membership role and log in system.
As of today, several forms for creating, updating and reviewing records were properly linked to the site and the form to create a new member were modified to include multi-table records. Most of the back end programming has been updated to include this information but it still needs additional records and validation. In addition to this the site needs a multi-table grid view of existing records in a form that can update multiple fields at once.
Project Student: Joe Cooney
