Hi was looking the best way, on how to update a Master table with a Validation Check.
I do no want to update the records directly into the master table.
-
I need a process of writing to a Temp table first, before entering data into Master table, with a validation process.
-
Some kind of alert to a supervisor, via an email or notification, within a
team to review Temp table record created. -
Validation checks of records created in Temp Table, then supervisor validates record,
maybe in table view of loaded record. -
Once Validation checks completed, Master table record updated, from the current record on temp Table.
5.Probably need track and trace of who did what, maybe username and time against record creation or acknowledgement from supervisor.