Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The cdf_EntityAttribute table stores the name, label, type, and size of each attribute and the associated entity of the attribute. It also specifies whether the attribute is used to define relationships between entities, whether it is a drop-down list (picklist), whether it is a custom attribute in Microsoft CRM, whether it should be migrated, and its migration status.
Do not change the cdf_EntityAttribute table directly. Instead, use the stored procedures provided as part of the Microsoft CRM Data Migration Framework to modify values in the table. Using the stored procedures helps protect you from making changes that will cause your migration to fail. For more information about the stored procedures, see Appendix A, "CDF Database Stored Procedures," in the Microsoft Business Solutions CRM Data Migration Framework Guide.
The following table shows the attributes in the cdf_EntityAttribute table.
| cdf_EntityAttribute table attribute | Description of attribute |
| EntityId | The identifier for the entity with which this attribute is associated. The identifier is based on the unique EntityId value for the entity from the cdf_EntityMigrationInfo table. Serves as the primary key for the table along with AttributeName. |
| AttributeName | The name of the attribute. |
| AttributeLabel | The label of the attribute. |
| AttributeType | The type of attribute. |
| AttributeSize | The size of the attribute. This size is determined by the size of the attribute in Microsoft CRM, so Do not change the values in this attribute. |
| SourceAttributeName | Name of the attribute in the source database. |
| IsRelationship | Indicates whether this attribute is a relationship. This information is used by the CDF Migration Tool. Do not change the values in this attribute. |
| IsPicklist | Indicates whether this attribute is a drop-down list (picklist). |
| IsCRMCustom | Indicates that this is a custom attribute created in Microsoft CRM. |
| ValidForCreate | Provides data required for the CDF Migration Tool. Do not change the values in this attribute. |
| ValidForUpdate | Provides data required for the CDF Migration Tool. Do not change the values in this attribute. |
| IsCorrelation | Indicates that this attribute is used by the CDF Migration Tool to correlate data. Do not change the values in this attribute. |
| MigrationCode | Specifies whether this attribute should be migrated. By default, all attributes other than the primary key for each table have a MigrationCode of 1, which means they will be migrated. If you don't want a specific attribute to be migrated, use the p_cdf_SetAttributeMigration stored procedure to change the value for that attribute to 0.
However, be careful if you change the value of MigrationCode to 0. If you change the value for a required attribute to 0, no records in the entity will be migrated. If you change the value to 0 for an attribute that is used to maintain a dependency with another table, the 0 will be ignored and the data required for the relationship will be migrated. Note The primary key for each entity table must have a MigrationCode of 0. Do not change this value. The data for the primary key itself will be migrated if you set the MigrationCode for the entity in the cdf_EntityMigrationInfo table to 1. |