How validation logs are stored and purged

Only readings that require validation and are associated with a validation queue item are logged to the validation log database tables; queue items with a validation status of Pass (PV) are automatically logged to the validation log history tables. Only the most recent logs for each meter channel associated with a validation queue item are kept in the following validation log tables:

• ValidationLog

• ValidationLogDetail

As soon as the validation queue items are resolved or new logs replace the old logs, the validation log entries are moved to the following validation log history database tables:

• ValidationLogDetailHistory

• ValidationLogHistory

After logs are moved to the validation log history database tables, the VLHistoryGroup Days to Keep field in the HistoricalPurgeModule database table determines when the log items are purged. This value can be changed by an IEE database administrator in the IEE database.