Power BI Connector for ServiceNow

Build 25.0.9454

system_dictionary

Contains dictionary entries that describe fields, attributes, and relationships in the data model.

Columns

Name Type ReadOnly References Description
create_roles String False

Specifies which user roles are authorized to create new records or fields defined in the System Dictionary.

sizeclass String False

Defines the display size classification of the field, typically used for user interface rendering.

array String False

Indicates whether the field supports storing multiple values as an array.

active String False

Determines whether the dictionary entry is active and currently in use within the system.

foreign_database String False

Specifies the external or foreign database connection associated with this field, if applicable.

dependent_on_field String False

Identifies another field that this field's behavior or value depends on.

reference_cascade_rule String False

Defines the cascade rule that controls what happens to related records when a referenced record is deleted.

reference String False

Specifies the target table or record that the field references, creating a relationship between data entities.

choice String False

Indicates whether the field presents predefined selectable choices for users.

default_value String False

Specifies the value automatically assigned to the field when a new record is created.

defaultsort String False

Defines the default sorting order applied to records for this field.

sys_id [KEY] String False

Provides the system identifier (sys_id) for the System Dictionary record.

attributes String False

Contains additional configuration attributes that modify the field's behavior or display properties.

xml_view String False

Determines whether the field is visible or configurable in XML views.

delete_roles String False

Specifies which user roles are permitted to delete records associated with this field.

reference_qual String False

Defines a qualification or filter applied to reference fields to limit selectable records.

reference_key String False

Specifies the key field used to establish the relationship between tables in reference fields.

dynamic_creation_script String False

Contains a script that dynamically generates related records when needed.

max_length String False

Defines the maximum number of characters or data length permitted in this field.

column_label String False

Specifies the display label used for this field in forms and lists.

read_only String False

Indicates whether the field is restricted from being edited by users.

dependent String False

Shows whether the field's value is determined by another field's configuration or selection.

unique String False

Specifies whether the field must contain a unique value across all records.

spell_check String False

Indicates whether spell-check functionality is enabled for text-based fields.

write_roles String False

Lists the user roles permitted to edit or modify the field's value.

audit String False

Determines whether changes to this field are tracked in the system audit logs.

staged String False

Indicates whether changes to this field are staged for approval before implementation.

dynamic_ref_qual String False

Enables dynamic reference qualification using scripts or conditions at runtime.

use_dynamic_default String False

Specifies whether a dynamic script or condition determines the field's default value.

dynamic_default_value String False

Stores the dynamic logic or script that calculates the default field value.

use_dependent_field String False

Indicates whether this field uses another field as a dependency for its value or display.

use_reference_qualifier String False

Specifies whether reference qualifiers are used to filter valid reference options.

reference_qual_condition String False

Defines the conditional logic applied to limit records in reference lookups.

choice_field String False

Identifies the field whose values define selectable options for this field.

dynamic_creation String False

Enables the automatic creation of related records when none exist in the referenced table.

calculation String False

Contains a script or expression used to compute the field's value dynamically.

next_element String False

Indicates the next field or element in a sequence, used in ordered data models.

display String False

Determines whether this field is displayed as the primary value in reference lists or related records.

reference_floats String False

Specifies whether reference data maintains floating-point precision when applicable.

element_reference String False

Identifies another element that this field directly references in the dictionary definition.

mandatory String False

Indicates whether the field must have a value before the record can be saved.

read_roles String False

Lists the user roles authorized to view the field's value.

text_index String False

Specifies whether the field is indexed for full-text search capabilities.

comments String False

Contains comments or notes explaining the purpose or configuration of this dictionary entry.

primary String False

Indicates whether this field serves as a primary key for its table.

element String False

Specifies the name of the element or column represented by this dictionary entry.

widget String False

Defines the type of user interface widget used to display the field's value.

reference_type String False

Specifies the type of reference relationship established by this field.

table_reference String False

Identifies the database table to which this field's definition belongs.

internal_type String False

Indicates the internal data type used by the platform to store the field's value.

virtual String False

Determines whether the field is virtual, meaning its value is derived rather than stored in the database.

sys_policy String False

Specifies the system policy that governs how this field behaves during updates or upgrades.

sys_replace_on_upgrade String False

Indicates whether this dictionary entry is replaced during platform upgrades.

sys_customer_update String False

Shows whether this record has been modified by a customer or remains system-delivered.

sys_scope String False

Identifies the application scope that owns this dictionary entry.

sys_package String False

References the application package that includes this field definition.

sys_updated_on Datetime False

Records the date and time when the dictionary record was last updated.

sys_created_on Datetime False

Records the date and time when the dictionary record was originally created.

sys_name String False

Stores the internal name used to identify the dictionary record within the system.

sys_updated_by String False

Identifies the user who last modified the dictionary record.

sys_created_by String False

Identifies the user who originally created the dictionary record.

sys_class_name String False

Defines the system class of the dictionary record, indicating its functional type.

sys_mod_count String False

Tracks how many times the dictionary record has been modified since creation.

sys_update_name String False

Contains the update name used for version control and change tracking in update sets.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454