cdf_Activity Table

Data in the cdf_Activity table must meet the migration criteria specified in Data Requirements for Migration. The following table shows all of the attributes in Microsoft CRM that can be migrated from the cdf_Activity table and the respective attribute names and types in the CDF database. The table also shows whether the attribute is required and whether it is used to create a relationship with other entities. For drop-down lists and Boolean attributes, the table shows the valid values and the default value in Microsoft CRM. The last rows of the table list the Microsoft CRM Activity attributes that cannot be migrated using the Microsoft CRM Data Migration Framework.

Microsoft CRM tab name and attribute label	CDF attribute name	CDF type	Required or Relationship in CDF	Valid Microsoft CRM values	Default Microsoft CRM value
Not on tab	ActivityId	int (PK)	Required
	StateCode1	int (state)		0 (Open) 1 (Completed) 2 (Canceled)	0
	ParentActivityId	int	Relationship
	ActivityTypeCode	int (picklist)	Required
	ActivityTypeCodeName2	nvarchar (200) (picklist)		Task (134) Fax (136) Phone Call (137) E-mail (138) Letter (141) Appointment (142) Resolution (140)
All Activity tabs
Subject	Subject	nvarchar (200)
Body	Description5	ntext
Regarding	ObjectId	int	Relationship
	ObjectName2	nvarchar (500)
	ObjectTypeCode3	int (picklist)
	ObjectTypeCodeName3	nvarchar (200) (picklist)		Account (1) Contact (2) Lead (4) Opportunity (3) Quote (1084) Order (1088) Invoice (1090) Case (112) Contract (1010)8
Owner	OwningUser	int	Required, Relationship
	OwningUserName2	nvarchar (255)
Duration	ScheduledDurationMinutes (for open activities) ActualDurationMinutes (for closed activities)4, 6	int		1 minute 5 minutes 15 minutes 30 minutes 45 minutes 1 hour 1.5 hours 2 hours 3 hours 3.5 hours 4 hours 4.5 hours 5 hours 5.5 hours 6 hours 6.5 hours 7 hours 7.5 hours 8 hours 1 day 2 days 3 days	30 minutes
Due	ScheduledStart (for open activities) ActualStart (for closed activities)4	datetime
Priority	PriorityCode	int (picklist)
	PriorityCodeName2	nvarchar (150) (picklist)		High Normal Low	Normal
Category	Category	nvarchar (250)
Sub-Category	SubCategory	nvarchar (250)
Letter activity
Sender	Associated cdf_ActivityParty record with ParticipationTypeMask=1	int
Recipient	Associated cdf_ActivityParty record with ParticipationTypeMask=2	int
Address	Location	nvarchar (200)
Direction	DirectionCode3	int (picklist)	Required	0 1	0
	DirectionCodeName2	nvarchar (150) (picklist)		Outgoing (0) Incoming (1)	Outgoing
Fax activity
Sender	Associated cdf_ActivityParty record with ParticipationTypeMask=1	int
Recipient	Associated cdf_ActivityParty record with ParticipationTypeMask=2	int
Fax Number	Location	nvarchar (200)
Direction	DirectionCode3	int (picklist)	Required	0 1	0
	DirectionCodeName2	nvarchar (200) (picklist)		Outgoing (0) Incoming (1)	Outgoing
Phone Call activity
Call Initiator	Associated cdf_ActivityParty record with ParticipationTypeMask=1	int
Call Recipient	Associated cdf_ActivityParty record with ParticipationTypeMask=2	int
Phone Number	Location	nvarchar (200)
Direction	DirectionCode3	int (picklist)	Required	0 1	0
	DirectionCodeName2	nvarchar (200) (picklist)		Outgoing (0) Incoming (1)	Outgoing
E-mail activity
From	Associated cdf_ActivityParty record with ParticipationTypeMask=1	int	Relationship
To	Associated cdf_ActivityParty record with ParticipationTypeMask=2	int	Relationship
Cc	Associated cdf_ActivityParty record with ParticipationTypeMask=3	int	Relationship
Bcc	Associated cdf_ActivityParty record with ParticipationTypeMask=4	int	Relationship
Direction	DirectionCode3	int (picklist)	Required	0 1
	DirectionCodeName2	nvarchar (200) (picklist)		Outgoing (0) Incoming (1)	Outgoing
Appointment activity
Organizer	Associated cdf_ActivityParty record with ParticipationTypeMask=7	int	Relationship
Attendees	Associated cdf_ActivityParty record with ParticipationTypeMask=5	int	Relationship
Location	Location	nvarchar (200)
Start Time	ScheduledStart (for open appointments) ActualStart (for closed appointments) 4, 7	datetime
End Time	ScheduledEnd (for open appointments) ActualEnd (for closed appointments) 4, 7	datetime
All day event	AllDayEvent	bit		0 (False) 1 (True)
Not migrated
	Sender9
	ToRecipients9
	CompetitorId
	CompetitorIdName
	MimeType
	ReadReceiptRequested
	PercentComplete
	DeliveryReceiptRequested
	Billed
	Misc1
	Misc2
	Misc3
	NumberOfPages
	ActualRevenue
	TimeSpent
	StatusCode1
	IsPrivate
	CreatedBy
	CreatedOn
	DeletionStateCode
	ModifiedBy
	ModifiedOn
	OwnerId
	OwnerIdType
	OwningTeam
	SecurityDescriptor
	VersionNumber

¹ See StateCode and StatusCode Values.

² The field is used only in the CDF database; it is not migrated.

³ These drop-down lists (picklists) are not in the cdf_StringMapCrm table; you must cleanse the data in these attributes manually.

⁴ The value of ActualDurationMinutes must equal ActualEnd - ActualStart, or the record does not migrate.

⁵ The value of Description can include plain text or HTML, but it should not contain MIME headers.

⁶ These values are set in a user interface control rather than stored in a drop-down list (picklist) in Microsoft CRM. You can use any values, or you can cleanse your data to match the lists in the user interface control.

⁷ Values for all attributes of the type datetime must be in the Coordinated Universal Time (UTC) format CCYY-MM-DD, where CC is the century (00-99), YY is the year (00-99), MM is the month (01-12), and DD is the day of month (01-31). An example is 2003-09-05. If a time is included, it is migrated as the Greenwich Mean Time (GMT).

⁸ Because Contracts are not included in the Data Migration Framework, activities related to contracts will not be migrated.

⁹ The Sender and ToRecipients data is not migrated. You can use this data to determine the appropriate cdf_ActivityParty records to create.

© 2005 Microsoft Corporation. All rights reserved.