Hey guys,
I have a somewhat delicate but very challenging task. I need to make an application that updates data from an ERP, because this ERP does not have a platform where employees can do this in the way the company needs. I'll give an example: One of the tables that needs to be updated has 130 fields, but HR wants only some of these fields to be updated, such as Email, Telephone, Cell Phone, Home Address, Name, ID, CPF and other data of the Spouse, ... anyway, of these 130 fields, only a few must be updated. But, they also want this system to be prepared so that, from time to time, they can select the fields they need, like just the employee's address data so that they can update this in the database, at another time, just the training data of these employees or just a photo, etc. Of course this is just an example and of course there are other tables with other information. But the idea is for each sector to select which information they want to make available for users to update or not. So, I would like to have a suggestion from you on how I can make my application so that only a volume of data is available for updating or not according to the needs of the sector. Of course I have some ideas but I would like an idea from someone who already has a lot more experience so that later I don't have to do too much rework, you know.
Grateful,
Ilano.
