Please use docs.servicenow.com for the latest documentation.

This site is for reference purposes only and may not be accurate for the latest ServiceNow version

Data Dictionary Tables

From Wiki Archive
Jump to: navigation, search
Note
Note: This article applies to Fuji. For more current information, see Data Dictionary Tables at http://docs.servicenow.com

The ServiceNow Wiki is no longer being updated. Please refer to http://docs.servicenow.com for the latest product documentation.

Overview

These tables provide data dictionary, data modeling, and entity relationship information:

Dictionary Entries

The Dictionary Entries [sys_dictionary] table, also called the System Dictionary, defines every table and field in the system. It contains information about a field's data type, character limit, default value, dependency, and other attributes.

Access the system dictionary in one of these ways:

  • To see the system dictionary list view, navigate to System Definition > Dictionary.
  • To view particular dictionary definition, right-click the list header, form header, or field label, and select Configure Dictionary (Personalize Dictionary in versions prior to Fuji).

To learn more, see System Dictionary.

The following image shows a filtered list of dictionary entries for the Incident table and the Task table, which it extends.

DictionaryIncTask.png

Field Labels

The Field Labels [sys_documentation] table, also called the Language File, contains information about the labels and hints for each table and column in the system.

Access the language file in one of these ways:

  • To see the list view, navigate to System Definition > Language File.
  • To see the field label for a particular field, right-click the field label on the form.

For more information on the language file, see Relabeling a Table or Field.

The following image shows the language file filtered to display only labels on the Incident table.

Fieldlabels.png

Tables

The Tables [sys_db_object] table contains a record for each table in the database (Calgary release).

Access the Tables list by navigating to System Definition > Tables. Administrators can create a custom table, add or modify columns in a searchable and sortable embedded list, and define the auto-number format. To learn more, see Creating a Custom Table.

The following image shows a list of the tables that extend the Task table.

Tables.png