Gen. Reference: Historic Production Detail Protection
and the 'Keep Production Detail for _ Periods' setting

To support reporting on historic activity throughout a user-specified period of time, Bundle-Track protects certain records against changes or removal from the database:

• Event records logged on dates within the protection timeframe will be protected against deletion, and so will any Production (scanned Tickets or charged Operations) tied to those events.

 
• Any Product, Operation, Lot, and Cut records that are related to protected Production and Events data will, if deleted, be preserved in the database in hidden form for reference in reporting. While they remain hidden, you will not be able to reuse their Code values.
   
• Products will refuse changes Size Set while they are related to protected Production data. (Click here for more detail.)

The length of the historic protection timeframe is specified in the "Keep Production Detail for __ Periods" field in the Pay Groups setup area (under Setup >> Options >> General Setup). During this timeframe, hidden deleted records will be immune to the data purging that occurs when you compress your database. Once those protected hidden records fall beyond the protection period, they will be automatically deleted with the next compression.

While these records remain in the database, it is possible to roll back pay period closings and re-close with full data integrity. If you want to check the limit of your current rollback potential, you may run this query to reveal the dates of the earliest records kept in the tables from which history would be reconstructed:

• select PaySesDefLab As PayGroup, PaySesDefKey, min(EveCur.WrkDat) As EarliestDate
  from EveCur, EmpMas, PaySesDef
  where EveCur.EmpMasKey=EmpMas.EmpMasKey
  and EmpMas.PaySesDefKey=PaySesDef.PaySesDefKey
  group by PaySesDefLab, PaySesDefKey
  order by PaySesDefLab

We welcome your comments at support@bundle-track.com.

If you would like our live assistance, you may hire us at our professional services rate.