Record Statistics

Each record in Collect! stores unique statistical information about the record itself, such as when it was created, who last modified it.

Record Statistics

The history portion of this form has been moved to our optional Dashboard Module.

To view the Record Statistics for any record in your database, simply Right click in a gray area of the current form and select STATISTICS from the side menu that is displayed.

You must be signed in with user level 10 or 99 to view a record's statistics.

Name

This is the name of the type of record you are viewing. Examples are debtor, client, transaction.

DBIX

This is an internal Collect! database reference number. Collect! has five databases, collect, user, rates, impex and report. So you may see a DBIX of 0, 1, 2, 3 or 4. Most often, you will see DBIX 1 which is the number of the collect database where most of your data is stored.

Rec. ID

This is a unique number indicating the type of record. For instance, the Debtor record is number "1" and the Client record is number "0".

UID

This is the unique record identifier in Collect!. Every single item in the database has its own UID. There should never be duplicate UIDs.

Tag

This is the number of this particular record in it's type of record. For instance, you might have 100 Clients. Each one would have a unique tag or "count". The first would be Tag 1 and the last would be Tag 100.

Date

Date created and date modified. These dates are updated as needed internally by Collect! when a record is created and then whenever it is modified.

Time

Time created and time modified. These time are updated as needed internally by Collect! when a record is created and then whenever it is modified.

By

Created By Operator and Modified By Operator. These IDs are updated as needed internally by Collect! when a record is created and then whenever it is modified.

Record Created

The entries next to this label reflect the Date and Time that this particular record was created. The Operator ID of the user who created the record is also displayed. This entry is created only once, when the record is first created. It is sound evidence for when the record was actually created and who created it.

Record Modified

The entries next to this label reflect the last Date and Time that this particular record was modified. The Operator ID of the user who last modified the record is also displayed. This entry is updated whenever the record is modified in any way. It is sound evidence for when the record was last modified and who modified it.

If you need to track modifications prior to the last one, you can enable change logging. Then you can view the history of all modifications made after the logging began.

OK

Select this button to close the Record Statistics form and return to the previous form.

Summary

The Record Statistics form enables you to keep track of changes to any record in your database. This is very useful if you have several data entry personnel. You can view any modifications and even restore field data to a old data if you have change logging enabled.

If you need to restore a deleted record, you can restore directly through the Change History Settings.