System Auxiliary Tables

The following system auxiliary tables are provided by the Create Database Wizard. Each table contains fields required by the system as well as optional fields you can use as provided, move to the Hidden fields section, or delete.

Note: The system auxiliary tables are added to the Global Application, which can be pulled into the repository. You can then open the Global Application in SBM Composer and modify the system auxiliary tables, or add a Dependency to the Global Application in process apps that use the system auxiliary tables. For details, refer to the SBM Composer Guide.

Companies: This table can be used to store information about the companies with which you interact.
Contacts: This table can be used to store information about individuals with which your company interacts.
Problems: This table stores problem records that can be associated with a primary item, published to the Knowledge Base for either public or internal viewing, or both.
Resolutions: This table stores resolution records that can be associated with a problem contained in the Problems table and published to the Knowledge Base for either public or internal viewing, associated with a primary item, or both.

The following System auxiliary tables are provided for translating the SBM User Workspace into one or more languages or for modifying provided labels in the SBM User Workspace:

Languages: This tables stores language records that enable you to associate strings with a specific language, which is associated with a locale. This table is used in conjunction with the Strings and String IDs tables to enable users to view SBM User Workspace labels and error messages in the language associated with the locale specified in their user profile, if such strings exist.
Strings: This table stores string records that can be used to modify or translate SBM User Workspace elements, such as labels, button names, and error messages, into one or more languages.
String IDs: String IDs table: String identifiers contain the root string information for the SBM User Workspace and should not be modified.
CAUTION:
For best results, limit privileges to the Languages, Strings, and String IDs tables to users who will translate your system into another language or are responsible for modifying existing strings. For example, you might grant privileges to these tables to a translator from a globalization vendor or to a managed administrator who is authorized to modify string names.

The following system auxiliary tables are provided for the SBM Connect for SharePoint^®. These tables track the SharePoint servers and their relationship to SBM projects.

SharePoint Servers – This table is used to store information on available SharePoint servers.
SharePoint Project Servers – This table stores information on the relationships between specific SBM projects and their related SharePoint sites.

For details on modifying the system auxiliary tables, refer to the SBM Composer Guide.

For information on the SBM Connect for SharePoint^®, refer to Integration Guide for SharePoint.