BMC Remedyforce Data Dictionary
This topic provides details about the BMC Remedyforce Data Dictionary, which is a repository of information about the objects and fields in which data is stored.
Download the BMC Remedyforce Data Dictionary
For information about the objects and fields that are included in the BMC Remedyforce Data Dictionary, see Version 1.0.
Purpose
You can use this data dictionary to perform the following actions:
- Review the objects and fields from which you can export data from BMC Remedyforce to an external tool, such as a reporting application.
- 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.
Version 1.0
Version 1.0 of the BMC Remedyforce Data Dictionary describes the objects and fields that store data about the following modules:
- Incidents
- Service Requests
- Tasks
- Problems
- Change Requests
- Releases
The BMC Remedyforce Data Dictionary contains a tab for each module. In Version 1.0, each tab includes the following details:
- All objects that store information about the module, such as Incidents, IncidentServiceTarget and Incident CI Link.
- Fields of all data types that are displayed out-of-the-box on the forms in the Remedyforce Console.
- 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.
- All fields of all data types for all other related objects, such as IncidentServiceTarget and Incident CI Link.
For information about the supported field types, see Salesforce Help.
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.
Exporting Lookup data type fields
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 (see the following figure).
To export Lookup data type fields, BMC recommends that you perform one of the actions listed in the following table: