cdf_Incident Table

Data in the cdf_Incident 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_Incident 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 Incident 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	IncidentId	int (PK)	Required
	StateCode1	int (state)		0 (Active) 1 (Resolved) 2 (Canceled)	0
	ParentIncidentId	int	Relationship
General tab
Owner	OwningUser	int	Required, Relationship
	OwningUserName2	nvarchar (255)
Status Reason	StatusCode1	int (status)		1 (In Progress) 2 (On Hold) 3 (Waiting for Details) 4 (Researching)	For StateCode 0, 1
				5 (Problem Solved)	For StateCode 1, 5
				6 (Canceled)	For StateCode 2, 6
Customer	ContactId	int	Required3 , Relationship
	ContactIdName2	nvarchar (160)
	AccountId	int	Required3 , Relationship
	AccountIdName2	nvarchar (160)
Title	Title	nvarchar (200)	Relationship
Subject	SubjectId	int	Relationship
	SubjectIdName2	nvarchar (500)
Description	Description	ntext
Details tab
Contract	ContractId	int
Contract Line	ContractDetailId	int
Product	ProductId	int
	ProductIdName2	nvarchar (100)
Serial Number	ProductSerialNumber	nvarchar (100)
Follow Up By	FollowupBy4	datetime
Service Level	PriorityCode	int (picklist)
	PriorityCodeName2	nvarchar (200) (picklist)		Gold Silver Bronze	Null
Case Origin	CaseOriginCode	int (picklist)
	CaseOriginCodeName2	nvarchar (200) (picklist)		Phone E-mail Web	Null
Priority	ContractServiceLevelCode	int (picklist)
	ContractServiceLevelCodeName2	nvarchar (200) (picklist)		High Normal Low	Normal
Satisfaction	CustomerSatisfactionCode	int (picklist)
	CustomerSatisfactionCodeName2	nvarchar (200) (picklist)		Very Satisfied Satisfied Neutral Dissatisfied Very Dissatisfied	Null
Case Type	CaseTypeCode	int (picklist)
	CaseTypeCodeName2	nvarchar (200) (picklist)		Question Problem Request	Null
Not on tab by default
	ActualServiceUnits	int
	BilledServiceUnits	int
Case No.	TicketNumber	nvarchar (100)
	IncidentStageCode	int (picklist)
	IncidentStageCodeName2	nvarchar (200) (picklist)		Default Value	Default Value
	IsDecrementing	bit		0 (False) 1 (True)	1
	ResponsibleContactId	int	Relationship
	ResponsibleContactIdName2	nvarchar (160)
	SeverityCode	int (picklist)
	SeverityCodeName2	nvarchar (200) (picklist)		Default Value	Default Value
Not migrated
	CreatedBy
	CreatedOn
	DeletionStateCode
	ModifiedBy
	ModifiedOn
	VersionNumber
	CustomerId
	CustomerIdType
	OwnerId
	OwnerIdType
	OwningTeam
	SecurityDescriptor

¹ See StateCode and StatusCode Values.

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

³ Either ContactId or AccountId is required.

⁴ Values for all attributes of type datetime must be in 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), for example, 2003-09-05. If a time is included, it is migrated as the Greenwich Mean Time (GMT) time.

© 2005 Microsoft Corporation. All rights reserved.