locked
What is StatusCode Field in ActivityPointerBase pointer table? RRS feed

  • Question

  • Hi All,

    I need to know what is the StatusCode field in ActivityPointerBase table?

    Does master table mapping is available in CRM database?

    Please help me as i'm new to CRM.

    Thank you in advance.

    Dhaval Panchal

    Wednesday, October 17, 2012 12:52 PM

Answers

  • The StateCode and StatusCode show if the Activity has the State of Open/Closed and the Status of in Progress, Completed, Canceled, etc...

    If you are digging into the tables - these queries would help you match up the values to their friendly on screen names

    SELECT * 
    FROM   stringmap 
    WHERE  objecttypecode = 4212 
           AND attributename = 'statecode' 
    
    SELECT * 
    FROM   stringmap 
    WHERE  objecttypecode = 4212 
           AND attributename = 'statuscode' 

    You can get the list of objecttypecodes with this query

    SELECT * 
    FROM   entityview 
    ORDER  BY objecttypecode 

    Microsoft Dynamics CRM 2011 Entity Relationship Diagrams


    Jason Lattimer


    Wednesday, October 17, 2012 1:05 PM
    Moderator