BMC Remedyforce Data Dictionary

The BMC Remedyforce Data Dictionary is a repository of information about the objects in which data is stored and provides details about the fields in each object. For information about the supported field types, see the Salesforce Help.

You can use this data dictionary to understand the objects and fields from which you can export data from BMC Remedyforce to an external tool, such as a reporting application. You can also use this information to plan the import of data from an external tool to BMC Remedyforce.

The following figure provides a sample view of the BMC Remedyforce Data Dictionary.

Download BMC Remedyforce Data Dictionary

To bulk export data from BMC Remedyforce or import data from an external tool, you can use the Data Loader. For information about the Data Loader, see the Salesforce Help. For information about exporting data from fields of the Lookup data type, see Best practice for exporting BMC Remedyforce data

Version 1.0 of the BMC Remedyforce Data Dictionary

Version 1.0 of the BMC Remedyforce Data Dictionary provides information about objects and fields in which data about the following modules is stored:

  • Incidents
  • Service Requests
  • Tasks
  • Problems
  • Change Requests
  • Releases

The data dictionary includes fields of all data types that are displayed out-of-the-box on the forms in the Remedyforce Console. The data dictionary also includes all additional fields of the Lookup data type that are not displayed on the form but are available in the Incidents, Tasks, Problems, Change Requests, and Releases objects. For all other related objects, such as Incident Service Target and Incident CI Link, the data dictionary includes all fields of all data types.


Fields in the Base Element object correspond to attributes of classes in BMC Remedyforce CMDB. For information about these fields, including their data type, see  BMC Remedyforce CMDB Common Data Model Open link .

Using Formula fields

You can use Formula fields when you create workflow criteria or flows criteria. Formula fields, with the tilde (~) character in its label, display the value of the Name field that is associated with the reference object record. The Lookup type fields use the Salesforce ID as values and are not very useful in defining criteria. If you use Formula fields, the data is displayed in a readable format. For example, if the Category Lookup field displays the value as 0x0d458djkdf, the Category~ Formula field displays the value in a readable format as Hardware.

Best practice for exporting BMC Remedyforce data

Fields that are of the Lookup data type reference 18-character Salesforce IDs that are stored in another object. Exporting these fields does not provide any meaningful data. Instead, BMC recommends that you perform one of the following actions:

  • Export the corresponding field of the Formula data type, if it is available.
    For example, the Staff ID field (API Name: BMCServiceDesk__FKUser__c) on the Incidents object is an example of a field of the Lookup data type. Instead of exporting the Staff ID field, you can export the corresponding Formula field, Staff ID~ (API Name: BMCServiceDesk__userId__c).
  • Export another field from the referred object that stores more meaningful data.
    In Step 3: Edit your Query of the Data Loader, edit the query and replace __c in the API name of the appropriate field (date type: Lookup) with __r.fieldName. This action exports data from the field that you specify from the referred object.

    For example, in the following query, BMCServiceDesk__FKCategory__c is replaced with BMCServiceDesk__FKCategory__r.Name:
    Select Name, BMCServiceDesk__FKCategory__r.Name FROM BMCServiceDesk__Incident__c

    The following figure highlights the difference between the data that is exported when you use BMCServiceDesk__FKCategory__c or BMCServiceDesk__FKCategory__r.Name in a query.

Related topics

Configuring dashboards and reports

Creating reports


Was this page helpful? Yes No Submitting... Thank you


  1. Shubhangi Apte

    The BMC Remedyforce documentation team would like to thank Giselle Caruso for working with us on conceptualizing and creating the Data Dictionary.

    This kind of coordination between the BMC Remedyforce writers and customers enables us to enhance the documentation by addressing the use cases that focus on customer needs.

    BMC Remedyforce Documentation Team

    Feb 01, 2016 11:46
  2. Paul Donders
    Seems that the link to "BMC Remedyforce CMDB Common Data Model " is broken
    Oct 03, 2016 07:43
    1. Surabhee Kulkarni

      Hello Paul,

      Thank you for your comment. Could you please try clicking the link again? It opens the following page in a new window:

      Thanks and regards,



      Oct 04, 2016 06:01