Tables
The CData ADO.NET Provider for ServiceNow models ServiceNow data as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures. Live connectivity to these objects means that any changes to your ServiceNow account are immediately available.
The metadata for the tables in ServiceNow is obtained at runtime based on a number of predefined schemas from ServiceNow and your unique ServiceNow account information. The following list is a sample of the tables available in the ServiceNow development environment, which models the core ServiceNow system.
You can use data dictionary tables to obtain details about the tables available in your ServiceNow environment. Data dictionary tables and other system tables are prefixed with system_.
The following data dictionary tables define the structure of the database tables:
- system_db_object: This contains information about each table, one row per table.
- system_dictionary: This defines every table and field in the system.
- system_documentation: This contains the human-readable labels and language information for every field of every table in the database.
CData ADO.NET Provider for ServiceNow Tables
| Name | Description |
| ast_contract | Stores contract records for managed assets, including start dates, vendors, and terms of agreement. |
| ast_license_base | Maintains software license information such as license types, entitlements, and usage limits. |
| change_request | Tracks change requests, including their approval workflows, implementation details, and completion status. |
| cmdb_ci | Stores configuration item (CI) records representing hardware, software, and services managed in the Configuration Management Database (CMDB). |
| cmdb_metric | Captures metrics assessing the accuracy, completeness, and health of configuration items in the Configuration Management Database (CMDB). |
| cmn_building | Stores information about buildings or facilities, including addresses and related location details. |
| cmn_context_help | Holds context-sensitive help content that provides user guidance within ServiceNow applications. |
| cmn_cost_center | Manages cost center records used for tracking budgets, expenses, and departmental spending. |
| cmn_department | Stores departmental information such as department names, hierarchies, and assigned managers. |
| cmn_location | Maintains location records for offices, sites, and branches within the organization. |
| cmn_map_page | Defines pages used for map-based visualizations to display geographical or asset-related data. |
| cmn_notif_device | Stores user notification device details, such as email addresses and mobile endpoints. |
| cmn_notif_device_variable | Defines variables that configure notification device behavior for personalized delivery. |
| cmn_notif_grmember | Manages group membership for notification delivery, defining which users belong to each group. |
| cmn_notif_group | Stores details about notification groups used to send alerts to multiple recipients. |
| cmn_notif_message | Contains notification message templates, including subjects, bodies, and formats. |
| cmn_notif_service_provider | Stores details about external providers used for sending notifications, such as SMS or email gateways. |
| cmn_other_schedule | Maintains non-standard schedules, such as maintenance or on-call availability calendars. |
| cmn_relative_duration | Defines relative duration values used in workflow calculations and Service Level Agreement (SLA) timing. |
| cmn_schedule | Stores schedules that represent business hours, on-call rotations, or maintenance windows. |
| cmn_schedule_blackout | Defines blackout periods when scheduled activities such as maintenance or deployments cannot occur. |
| cmn_schedule_condition | Specifies conditions that determine when certain schedules apply based on context. |
| cmn_schedule_maintenance | Stores planned maintenance schedules for systems and services managed in ServiceNow. |
| cmn_schedule_page | Defines schedule pages that organize related schedules or calendar segments for easier management. |
| cmn_schedule_span | Records specific time spans within schedules, such as working hours, holidays, or exceptions. |
| cmn_timeline_page | Defines timeline pages used to display events or workflows along a visual timeline. |
| cmn_timeline_page_style | Stores style configurations for timeline pages, including color schemes and layout settings. |
| cmn_timeline_sub_item | Maintains sub-items displayed in timeline views, supporting nested visualization of activities. |
| diagrammer_action | Stores diagram actions that define transitions or behaviors within process flow diagrams. |
| expert_panel | Maintains expert panel data, including participant details and assigned review cases. |
| incident | Tracks incidents that document issues, service disruptions, or user-reported problems. |
| item_option_new | Defines configuration options for catalog items, enabling customized orders or service requests. |
| question | Stores survey or catalog questions that collect user input for requests or feedback forms. |
| sc_category | Defines Service Catalog (SC) categories used to group catalog items for easier navigation. |
| sc_cat_item | Stores catalog items offered through the Service Catalog (SC), such as products or services. |
| sla | Defines Service Level Agreements (SLAs) that measure and enforce service delivery commitments. |
| sysauto | Stores scheduled job definitions that automate recurring processes and system tasks. |
| sysauto_script | Contains scripted scheduled jobs that execute automated actions at defined intervals. |
| syslog | Logs system events, errors, and informational messages for auditing and troubleshooting. |
| sysrule | Stores rule definitions that drive automated logic and system behaviors. |
| system_db_object | Stores metadata for database objects, including tables and views in the ServiceNow schema. |
| system_dictionary | Contains dictionary entries that describe fields, attributes, and relationships in the data model. |
| system_documentation | Holds documentation text and help information for ServiceNow fields and tables. |
| system_import_set_row | Records data rows imported via import sets, including staging and transformation details. |
| system_journal_field | Stores journal entries for field-level updates, allowing audit tracking of changes over time. |
| system_script_client | Contains client-side script definitions that control dynamic behavior in the ServiceNow interface. |
| system_ui_policy | Defines user interface (UI) policies that determine field visibility, read-only status, and mandatory settings. |
| system_ui_policy_action | Specifies actions triggered by user interface (UI) policies, such as showing or hiding form elements. |
| system_user | Stores user account details, including credentials, roles, and contact information. |
| task | Tracks generic task records used by multiple ServiceNow applications, including incidents, problems, and changes. |
| v_field_creator | Stores metadata about field creation, including associated tables and data types. |