There is no trace back to who is modifying the status of a request. We need to be able to track this so when there is a change we can point to who made it. Possible solutions are
-
In the SedmDB script add a logging function for all request. This will at least show all changes and when they were made, but not who made the change.
-
Add a modification table in the database. Works the same as above but each change is marked in the table.
-
All the above
There is no trace back to who is modifying the status of a request. We need to be able to track this so when there is a change we can point to who made it. Possible solutions are
In the SedmDB script add a logging function for all request. This will at least show all changes and when they were made, but not who made the change.
Add a modification table in the database. Works the same as above but each change is marked in the table.
All the above