Activity Pointer and Activity Type Code in CRM 2011/2013/2015

CRM has lots of different activities

1) Phone Call
2) Task
3) Letter
4) Email
5) Appointment
6) Fax
7) Custom Activities
 
In CRM, all the activities are saved in ActivityPointer table. This way, we can retrieve all activities with one request instead of multiple transactions.
 
Whenever you create an activity record in Microsoft Dynamics CRM, a corresponding activity pointer record is created. This implies that the activity record and the corresponding activity pointer record have the same value for the ActivityId attribute. For example, if you create an Email record, the attribute values of Email.ActivityId and the corresponding ActivityPointer.ActivityId will be the same.
 
We can differentiate the activities by Activity Type Code.

Value	Label
4201	Appointment
4202	Email
4204	Fax
4206	Case Resolution
4207	Letter
4208	Opportunity Close
4209	Order Close
4210	Phone Call
4211	Quote Close
4212	Task
4214	Service Activity
4251	Recurring Appointment
4401	Campaign Response
4402	Campaign Activity
4406	Bulk Operation

Hope this helps.
 
--
Happy CRM'ing
Gopinath