Category Attribute Snapshot Table - Precisely_EnterWorks - EnterWorks - 11.0

A category attribute snapshot table view is sometimes called a "vertical snapshot table", because instead of the attributes making up the columns of the table, they make up the rows. They are arranged in this manner to allow the category attribute snapshot table view to overcome the database limitation of allowing only 1022 columns, thereby freeing EnterWorks repositories to have an unlimited number of category attributes in the snapshot tables.

A repository's category attribute snapshot table has a row for each record's non-null category attributes, whether the category attribute has been marked as relational or not. If a category attribute is designated as relational and the repository has a category attribute snapshot table, the category attribute will appear in both the main snapshot table and in the category attribute snapshot table.

A category attribute snapshot table view has the same name as the main snapshot table, except that it has a suffix of "_KV". KV stands for "key value pairs". So if a repository is named:

      Product_Staging
    

its category attribute snapshot table view would be named:

      Product_Staging_KV
    

The schema of each row in a category attribute snapshot table is:

• InternalRecordId: This maps to the InternalRecordId of the record in the repository. It can be used to join a category attribute snapshot table row to a row in the main snapshot table.

• KeyName: The name of the category attribute. This will exactly match the attribute's name in the repository, which can be seen by viewing the repository's profile or opening the repository in the Detail Editor.

• KeyRestrictedName: The restricted name of the attribute, as defined in the repository's attribute definition.

• KeyValue: The attribute's value.

• KeySequence: If a display sequence is set for the attributes in the repository, KeySequence will contain the display sequence value.