Main Snapshot Table - Precisely_EnterWorks - EnterWorks - 11.0

Each repository can have only one main snapshot table. It consists of all the attributes in the repository that are designated as "relational". An index can be created for each of the attributes in the snapshot table. The main snapshot table has the same name as the repository.

Each of the snapshot table's columns are labeled with the restricted name of their corresponding attribute. The restricted name of an attribute is a human-friendly name that makes the attribute easier for a user to identify.

The first few columns in a snapshot table are system bookkeeping columns. They are:

• InternalRecordId: The ID of the repository record.

• Created: The date the repository record was created.

• Last_Updated: The last time the repository record was updated for any reason, including validation.

• Data_Last_Updated: The last date any attribute in the repository record was updated.

• Snapshot_Last_Updated: The last time the snapshot record was updated. This may not match the Data_Last_Updated value if one of the repository record's attributes that is NOT in the snapshot table was changed or if the snapshot table has been regenerated.

The attribute columns follow the system columns and are arranged alphabetically.