What is the purpose of the HISTORY_ITEM table? 

Version 1

    Details

    What is the purpose of the HISTORY_ITEM table? 


    Resolution

    [INFORMATION]
    The HISTORY_ITEM stores the recently viewed items (via the RECID) per User and GoldMine area where recently items are available




    - Columns of table HISTORY_ITEM:
    USERID - User name
    FRECID - reference to the original data in the reference table via the recid
    TYPE_CODE - reference table code

    TYPE_CODE information:
    1 = Contacts -> CONTACT1; HISTORY_ITEM->FRECID = CONTACT1->RECID
    2 = Opportunities -> OPMGR; HISTORY_ITEM->FRECID = OPMGR->RECID
    3 = Projects -> OPMGR; HISTORY_ITEM->FRECID = OPMGR->RECID
    4 = E-Mail - MAILBOX (Email Center does not have a recently viewed list within GoldMine as the recently viewed pane shows instead the Email Folders)
    5 = Campaigns -> OPMGR; HISTORY_ITEM->FRECID = OPMGR->RECID
    6 = Cases -> CASES; HISTORY_ITEM->FRECID = CASES->RECID
    7 = Knowledge Base (formerly known as InfoCenter) -> INFOMINE; HISTORY_ITEM->FRECID = INFOMINE->RECID
    VIEW_DATE - when the viewed item was viewed (determines the order in the recently viewed item list)
    RECID - unique record identifier for the entry
    8 = Pending Activities - CAL (Pending Activities can be reviewed on a Contact record's Pending tab >> in this case the recently viewed pane shows the recently viewed contacts, in the Graphical Calendar >> in this case the recently viewed pane shows the Microsoft monthly calendar(s) or the Activity List >> in this case the recently viewed pane shows the Activity List tree)
    9 = Completed Activities - CONTHIST (Completed Activities can be reviewed on a Contact record's History tab >>  in this case the recently viewed pane shows the recently viewed  contacts, in the Graphical Calendar >> in this case the recently viewed  pane shows the Microsoft monthly calendar(s) or the Activity List >> in  this case the recently viewed pane shows the Activity List tree)
    10 = Additional Contacts - CONTSUPP (Additional Contacts can be reviewed on a Contact record's Additional Contacts tab >>  in this case the recently viewed pane shows the recently viewed primary  contacts)

    - HISTORY_ITEM table is part of the Contact Set tables, which means the recently viewed items are different per contact set database

    Additional information:
    - The amount of possible  records per user in the HISTORY_ITEM table is defined by the HISTORY  table CNT field of the user. From the GUI available via Tools >>  Options >> System >> Recent Items  shown setting (see also Knowledge Article #13290)