Effects of Data Model Changes on Existing Records and Snapshot Tables

The table below details the effects on existing record attribute values and snapshot tables when the data model is changed.

Type of Edit to Profile	Effects on Repository Attributes and the Snapshot Table
Change an attribute’s data type.	Existing repository attribute values will not be changed. If the attribute is in the snapshot table (is defined as relational), the snapshot table will be automatically rebuilt with the new datatype.
Make an attribute repeatable.	Existing repository attribute values will not be changed. Subsequent edits to existing repository records treat the attribute as repeatable, and if new values are added, the attribute value will contain multiple values separated by the designated delimiter. The snapshot table’s column data type for that attribute will be set to VARCHAR(MAX) regardless of the original data type (and size if VARCHAR) of the attribute. The snapshot table will be automatically rebuilt and the repeatable attribute’s Snapshot column will contain the record attribute’s set of values, separated by the designated delimiter.
Add or remove an attribute in the snapshot table.	Existing repository attribute values will not be changed. A column will be added or removed from the snapshot table. If added, the column will be populated from the repository’s attribute values. If deleted, the column is simply removed.
Add a default value to a profile attribute.	The repository attribute values in existing repositories will not be changed. In order for a repository’s attribute default value to change, it must be changed manually in the attribute definition for that repository. Repositories created after the profile attribute’s default value has changed will copy the profile attribute’s default value to their repository attribute’s default value. The snapshot table will not be automatically rebuilt.
Delete a code from a code set.	Attribute values in existing records will not be changed. When the repository is next validated, any attribute values containing the deleted code will be flagged as invalid. The snapshot table will not be automatically rebuilt.
Change a code in a code set.	Affected records in repositories and snapshot tables that use the code set will be updated.