How does Pacific Timesheet's archiving of historical data work?
One of the most important IT tasks performed by Pacific Timesheet's cloud services, particularly to maintaining database performance of large-scale systems, is archiving historical data.
Without archiving, over time, the amounts of data stored in database tables continue to grow, particularly for transaction data such as time or expense entries, and database performance can degrade over time. Pacific Timesheet addresses this issue by moving older data into an archived tables on a regularly scheduled basis and thereby maintains optimal performance of non-archived data.
Pacific Timesheet Archiving Approach
- Each year, Pacific Timesheet systemically archives data older than 5 years for systems with 1,000 or more users, or systems that store a relatively large amount of time and expense entry data.
- Archiving is performed once per year during scheduled maintenance windows.
- Archived data is moved out of database tables into archival tables to maintain high performance non-archived data.
- Archived data can no longer be viewed in timesheets, expense sheets, asset, log or other sheets.
- However, archived data can still be reported on for any reason, e.g. financial or labor audits.
- When you run a report for a time period that has been archived you will be prompted to access the archival data and the report will run as normal.
- If you absolutely need access to individual timesheets that have been previously archived, you can make a special "de-archive" request through your customer relationship manager. The request needs to include a requirement that cannot be met through reporting alone.
Data that will be Archived
- Time entries and timesheets
- Expense entries and expense sheets
- Asset/Log/Other entries and sheets
- Employee balance history entries