The SalesLogix Activity & History tables use a ‘Type’ field to store the type of Activity. If you look at the TYPE field, you’ll see that the values there are numeric values such as ‘262147’. This number represents the type for the given activity or history record. But for someone new to SalesLogix it might be difficult to determine how & where these types are defined.
These “types” are stored as a picklist named “Activity Types”. Take a look at the items in the picklist with the following query:
select p1.id, p1.text, p1.shorttext from picklist p1
left outer join picklist p2 on (p1.picklistid = p2.itemid)
where p2.picklistid = 'PICKLISTLIST' and p2.text = 'Activity Types'
This query will return three columns from the picklist table. The ID, which you will find is the numeric value stored in the TYPE field of the Activity & History tables (such as “262147“), the Text field, which is the text name for the Activity Type (such as “To-Do”, “Phone Call”, etc), and the ShortText, which is the abbreviated text for the activity type (such as “TODO”, “CALL”, etc). The results of the above query will show you the following:
262156 Database Change DBCHANGE 262150 Dialog DIALOG 262153 Document DOC 262154 E-Mail EMAIL 262151 Event Selection ESP 262155 Fax FAX 262157 Form FORM 262163 Literature Request LITREQ 262145 Meeting APPT 262148 Note NOTE 262158 OLE OLE 262161 Page PAGE 262162 Personal Activity PERSONAL 262146 Phone Call CALL 262160 Process PROCESS 262149 Question Q 262152 Report REPORT 262144 Start START 262164 Stop STOP 262147 To-Do TODO
Having these “types” in the picklist table make for an easy join from the activity and history tables to display the type’s associated text with the history or activity items.