VBA Picklist Item Missing

Timmus Agersea from Customer Systems Inc shares a tip about a missing picklist item in SalesLogix related to script tasks in Contact Processes (posted in the SalesLogix Business Partner newsgroups). Thanks Timmus.

The Contact Process engine adds history records for each task.  If the type of task is a script, the history record type value is 262159.  This does not exist in the picklist table and is therefore excluded from the history tab (inner join to Picklist).  Rather than change the UI, I decided to fix the data.  Here is the sql to accomplish the same.  Note that 262147 is a ToDo.

INSERT INTO
    PickList
SELECT
    262159 , 'VBA' , 'VBA' , 'VBAVBAVBAVBA' , PickListID ,
    UserID , DefaultIndex
FROM
    PickList
WHERE ID = 262147