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 entity base table (cdf_<entity>) is used to store your data for the entity you are migrating. Each record in the entity base table has a field for each attribute that can be migrated to the associated Microsoft CRM entity. This includes all optional Microsoft CRM attributes that, by default, are not on the standard Microsoft CRM forms for the entity.
To make it easier to cleanse your data so that it meets Microsoft CRM requirements, the entity base table includes a string attribute as well as an integer attribute for storing your data for identifier and drop-down list attributes. The integer attribute stores the data that is to be migrated; the string attribute stores the string associated with the integer.
- All <entity>Id attributes are integers, and each has an associated <entity>IdName string attribute.
- All <drop-down list>Code attributes are integers, and each has an associated <drop-down list>CodeName string attribute.
For a list of the attributes in each cdf_<entity> table, see CDF Database Entity Tables.
Each attribute in each entity base table has an associated record in the cdf_EntityAttribute table, which is one of the CDF metadata tables. Only those attributes listed in the cdf_EntityAttribute metadata table are migrated, which means that you can create your own additional columns in the entity base tables for tracking information about cleansing data and removing duplicates.