Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

Information about decoding the GUID fields that are stored in the UDF fields of the Activity table v2012

  1. Last updated
  2. Save as PDF

We are trying to use the Activities section using three of the configurable fields provided so far.  While the base information is stored in the Activity table, we cannot find details to decode Code1, Code2 and Code3 GUID fields that are stored in the code fields on the Activity table.  This information is not stored in the UDFcode table. Which other tables should be queried to locate this data?

The descriptions of the values are stored in codedetail, where the activitycode GUID is equal to the codedetail.codedetail GUID. In order to get all details , a SQL join query to the codedetails table can be used. Here is an example:

 

select a.description 'Activity', cd.description 'Code1' from activity a with (nolock)

leftouter join codedetail cd with (nolock) on a.code1 = cd.codedetail