[dev] Audit trailing in Hermes

[Vinay Kumar]

Hello all,

The DCAA(Defense Contract Audit Agency) guidelines insists that if  
electronic systems are used, then all the actions(add/edit/delete)  
carried out in the timesheet system  should  be tracked, so that in  
future the complete log can be produced.

Basically there are two approaches to keep the changes. One solution  
is to create a new table to keep all the changes. The second method is  
to use the existing table with some additional fields.

I would prefer the second approach, because the edit/delete operations  
  on a timeslice row is probably minimal. The basic ideas is to add a  
new timeslice entry, whenever a timeslice is edited. Store the ID of  
the original timeslice  as timeslice_parentid in the new entry. Also  
mark the new timeslice as NOT EDITED  using another field.

The following are the suggested changes:
1. Tweak the updateTime() function.


Regards
Vinay Kumar
Programmer Analyst
Ejyothi Services/Ascella Technologies.