ServiceNow Data Model

Connection String Options

  1. Auto Cache
  2. Cache Connection
  3. Cache Driver
  4. Cache Location
  5. Cache Metadata
  6. Cache Query Result
  7. Connect On Open
  8. Firewall Password
  9. Firewall Port
  10. Firewall Server
  11. Firewall Type
  12. Firewall User
  13. Initiate OAuth
  14. Instance
  15. Location
  16. Logfile
  17. Max Log File Size
  18. OAuth Access Token
  19. OAuth Client Id
  20. OAuth Client Secret
  21. OAuth Refresh Token
  22. OAuth Settings Location
  23. Offline
  24. Other
  25. Password
  26. Proxy Auth Scheme
  27. Proxy Auto Detect
  28. Proxy Password
  29. Proxy Port
  30. Proxy Server
  31. Proxy SSL Type
  32. Proxy User
  33. Pseudo Columns
  34. Query Cache
  35. Readonly
  36. RTK
  37. SSL Server Cert
  38. Support Enhanced SQL
  39. Tables
  40. Timeout
  41. Username
  42. Verbosity
  43. Views

Auto Cache

Data Type

bool

Default Value

false

Remarks

When AutoCache is set, the driver maintains a cache in the background. The driver can update the cache when you execute a SELECT query to the remote ServiceNow data.

This functionality gives you the option to query a persistent, up-to-date cache or execute real-time queries with a failover solution for connectivity loss.

Caching on Every SELECT

 

CacheQueryResult is a way to query ServiceNow in real time while maintaining a cache for offline use. Set CacheQueryResult to update the cache whenever you execute a SELECT statement. When you execute a SELECT statement with AutoCache and CacheQueryResult set, the driver executes the query to the remote data and persists the results; rows that already exist are overwritten. That is, SELECT statements are used to create and refresh the cache, not to query it. Data manipulation commands are executed to the remote data as well.

To query the cached data, set the Offline property. If you need to query the cached data in an online connection, you can append #CACHE to the table name. For example:

SELECT * FROM [incident#CACHE]

 

 

Setting the Caching Database

 

When AutoCache is set, the driver caches to a simple, file-based cache. You can configure its location or cache to a different database with the following properties:

 

 

See Also

 

 

  • Caching: Best Practices: This section provides more examples of using AutoCache with Offline, as well as information on determining a caching strategy.
  • QueryCache: In addition to backup, you can also use a local copy of data as a shortcut that minimizes network transit.

    When this property is set, the driver builds a temporary, in-memory dataset that caches the results of the queries you execute. Result sets for subsequent queries are extracted from this dataset, if possible.

    This property is useful in BI, analytics, and other tools that generate queries for you. In these tools, explicit cache queries with the #CACHE syntax may not be an option.

  • CacheMetadata: This property reduces the amount of metadata that crosses the network by persisting table schemas retrieved from the ServiceNow metadata. Metadata then needs to be retrieved only once instead of every connection.
  • CACHE Statements: You can use the CACHE statement to persist any SELECT query, as well as manage the cache; for example, refreshing schemas.

 

 

 

Cache Connection

Data Type

string

Default Value

""

Remarks

The cache database is determined based on the CacheDriver and CacheConnection properties. You will need at least the following information to connect to one of the caching databases below. To load the caching database's driver, refer to CacheDriver.

The connection string specified in the CacheConnection property is passed directly to the underlying CacheDriver. The documentation for the underlying JDBC driver will have all of the available properties.

 

Derby and Java DB

 

In most caching scenarios, you need to set only the following:

 

For other Java DB configurations, you will need to use CacheDriver and CacheConnection. Below is the Derby JDBC URL syntax:

jdbc:derby:[subsubprotocol:][databaseName][;attribute=value[;attribute=value] ... ]
For example, to cache to an in-memory database, use the following:
jdbc:derby:memory

 

 

SQLite

 

To cache to SQLite, you can use the SQLite JDBC driver. Below is the syntax of the JDBC URL:

jdbc:sqlite:dataSource
  • Data Source: The path to an SQLite database file. Or, use a value of :memory to cache in memory.

 

 

MySQL

 

The installation includes the CData JDBC Driver for MySQL. Below is an example JDBC URL:

jdbc:mysql:User=root;Password=root;Server=localhost;Port=3306;Database=cache
Below are typical connection properties:

 

 

  • Server: The IP address or domain name of the server you want to connect to.
  • Port: The port that the server is running on.
  • User: The username provided for authentication to the database.
  • Password: The password provided for authentication to the database.
  • Database: The name of the database.
SQL Server

 

The JDBC URL for the Microsoft JDBC Driver for SQL Server has the following syntax:

jdbc:sqlserver://[serverName[\instance][:port]][;database=databaseName][;property=value[;property=value] ... ]
For example:
jdbc:sqlserver://localhost\sqlexpress:1433;integratedSecurity=true
Below are typical SQL Server connection properties:
  • Port: The port SQL Server is running on.
  • Server: The name or network address of the computer running SQL Server. To connect to a named instance instead of the default instance, this property can be used to specify the host name and the instance, separated by a backslash.
  • Database: The name of the SQL Server database.
  • Integrated Security: Set this option to true to use Windows authentication. Set this option to false to use forms-based authentication.

    To use integrated security, you will also need to add sqljdbc_auth.dll to a folder on the Windows system path. This file is located in the auth subfolder of the Microsoft JDBC Driver for SQL Server installation. The bitness of the assembly must match the bitness of your JVM.

  • User: The username provided for authentication with SQL Server, if you are using forms authentication.
  • Password: The password provided for authentication with SQL Server, if you are using forms authentication.
Oracle

 

Below is the conventional JDBC URL syntax for the Oracle JDBC Thin driver:

jdbc:oracle:thin:[userId/password]@[//]host[[:port][:sid]]
For example:
jdbc:oracle:thin:scott/tiger@myhost:1521:orcl
Below are typical connection properties:
  • Data Source: The connect descriptor that identifies the Oracle database. This can be a TNS connect descriptor, an Oracle Net Services name that resolves to a connect descriptor, or, after version 11g, an Easy Connect naming (the host name of the Oracle server with an optional port and service name).

  • Password: The password provided for authentication with the Oracle database.
  • User Id: The user Id provided for authentication with the Oracle database.
PostgreSQL

 

Below is the JDBC URL syntax for the official PostgreSQL JDBC driver:

jdbc:postgresql:[//[host[:port]]/]database[[?option=value][[&option=value][&option=value] ... ]]
For example, the following connection string connects to a database on the default host (localhost) and port (5432):
jdbc:postgresql:postgres
Below are typical connection properties:
  • Host: The address of the server hosting the PostgreSQL database.
  • Port: The port used to connect to the server hosting the PostgreSQL database.
  • Database: The name of the database.
  • Username: The user Id provided for authentication with the PostgreSQL database. You can specify this in the JDBC URL with the "user" parameter.
  • Password: The password provided for authentication with the PostgreSQL database.

 

 

Cache Driver

Data Type

string

Default Value

""

Remarks

You can cache to any database that you have a JDBC driver for, including CData JDBC drivers.

The cache database is determined based on the CacheDriver and CacheConnection properties. The CacheDriver is the name of the JDBC driver class that you would like to use to cache data.

Note that you must also add the CacheDriver JAR to the classpath.

The following examples show how to cache to several major databases. Refer to CacheConnection for more information on the JDBC URL syntax and typical connection properties.

Derby and Java DB

 

 

The driver simplifies Java DB configuration. Java DB is the Oracle distribution of Derby. The JAR is shipped in the JDK. You can find the JAR, derby.jar, in the db subfolder of the JDK installation. In most caching scenarios, you need to specify only the following, after adding derby.jar to the classpath.

jdbc:servicenow:CacheLocation='c:/Temp/cachedir';OAuthAccessToken=MyOAuthAccessToken;Instance=MyInstance;
To customize the Java DB JDBC URL, use CacheProvider and CacheConnection. For example, to cache to an in-memory database, use a JDBC URL like the following:
jdbc:servicenow:CacheDriver=org.apache.derby.jdbc.EmbeddedDriver;CacheConnection='jdbc:derby:memory';OAuthAccessToken=MyOAuthAccessToken;Instance=MyInstance;
SQLite

 

Below is a JDBC URL for the SQLite JDBC driver:

jdbc:servicenow:CacheDriver=org.sqlite.JDBC;CacheConnection='jdbc:sqlite:C:/Temp/sqlite.db';OAuthAccessToken=MyOAuthAccessToken;Instance=MyInstance;
MySQL

 

Below is a JDBC URL for the included CData JDBC Driver for MySQL:

jdbc:servicenow:Cache Driver=cdata.jdbc.mysql.MySQLDriver;Cache Connection='jdbc:mysql:Server=localhost;Port=3306;Database=cache;User=root;Password=123456';OAuthAccessToken=MyOAuthAccessToken;Instance=MyInstance;
The CData JDBC Driver for MySQL is located in the lib subfolder of the CData JDBC Driver for ServiceNow 2016 installation directory.
SQL Server

 

The following JDBC URL uses the Microsoft JDBC Driver for SQL Server:

jdbc:servicenow:Cache Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;Cache Connection='jdbc:sqlserver://localhost\sqlexpress:7437;user=sa;password=123456;databaseName=Cache';OAuthAccessToken=MyOAuthAccessToken;Instance=MyInstance;
Oracle

 

Below is a JDBC URL for the Oracle Thin Client:

jdbc:servicenow:Cache Driver=oracle.jdbc.driver.OracleDriver;CacheConnection='jdbc:oracle:thin:scott/tiger@localhost:1521:orcldb';OAuthAccessToken=MyOAuthAccessToken;Instance=MyInstance;
PostgreSQL

 

The following JDBC URL uses the official PostgreSQL JDBC driver:

jdbc:servicenow:CacheDriver=org.postgresql.Driver;CacheConnection='jdbc:postgresql://localhost:5433/postgres?user=postgres&password=admin';OAuthAccessToken=MyOAuthAccessToken;Instance=MyInstance;

 

 

Cache Location

Data Type

string

Default Value

""

Remarks

The CacheLocation is a simple, file-based cache. The driver uses Java DB, Oracle's distribution of the Derby database. To cache to Java DB, you will need to add the Java DB JAR to the classpath. The JAR, derby.jar, is shipped in the JDK and located in the db subfolder of the JDK installation.

CacheLocation defaults to the directory specified by the Location setting.

See Also

 

 

  • AutoCache: Set this to implicitly create and maintain a cache for later offline use.
  • QueryCache: Set this to use a temporary, in-memory cache.
  • CacheMetadata: Set this to persist the ServiceNow catalog in CacheLocation.

 

 

Cache Metadata

Data Type

bool

Default Value

false

Remarks

As you execute queries with this property set, the relevant system tables in the ServiceNow catalog are cached to the file store specified by CacheLocation.

Setting CacheMetadata and CacheLocation will retrieve metadata only once over multiple connections. For example, metadata will be retrieved only when a connection pool is initialized.

When to Use CacheMetadata

 

The driver automatically caches metadata in memory when you open a connection, so within the same connection schema discovery is only expensive on the first query. QueryCache only becomes useful when retrieving the system catalog on every connection open becomes expensive. For example, when you are working with large amounts of metadata or when you have many simultaneous, short-lived connections.

When Not to Use CacheMetadata

 

 

  • When you are working with volatile metadata: To pick up new, changed, or deleted columns, you need to delete and rebuild the metadata cache. In this case, if the default in-memory cache is insufficient, consider a caching solution that will allow you to maintain the cache with CACHE Statements statements. See Caching Data for more information on selecting a caching solution.
  • When you are caching to a database: CacheMetadata can only be used with CacheLocation. If you are caching to another database with the CacheDriver and CacheConnection properties, use AutoCache to cache implicitly. Or, use CACHE Statements to cache explicitly.

 

 

Cache Query Result

Data Type

bool

Default Value

false

Remarks

When CacheQueryResult and AutoCache is set, the entire result of every SELECT query is cached in the cache database. Note that the performance can be significantly impacted when using AutoCache when the ServiceNow API does not support the REPLICATE Statements statement.

 

Connect On Open

Data Type

bool

Default Value

false

Remarks

When set to 'true', a connection will be made to ServiceNow when the connection is opened. This property enables the 'Test Connection' feature available in various database tools.

This feature acts as a NOOP command as it is used to verify a connection can be made to ServiceNow and nothing from this initial connection is maintained.

Setting this property to 'false' may provide performance improvements (depending upon the number of times a connection is opened).

 

Firewall Password

Data Type

string

Default Value

""

Remarks

This property is passed to the proxy specified by FirewallServer and FirewallPort, following the authentication method specified by FirewallType.

 

Firewall Port

Data Type

string

Default Value

""

Remarks

This specifies the TCP port for a proxy allowing traversal of a firewall. Use FirewallServer to specify the name or IP address. Specify the protocol with FirewallType.

 

Firewall Server

Data Type

string

Default Value

""

Remarks

This property specifies the IP address, DNS name, or host name of a proxy allowing traversal of a firewall. The protocol is specified by FirewallType: Use FirewallServer with this property to connect through SOCKS or do tunneling. Use ProxyServer to connect to an HTTP proxy.

Note that the driver uses the system proxy by default. To use a different proxy, set ProxyAutoDetect to false.

 

Firewall Type

Data Type

string

Default Value

"NONE"

Remarks

This property specifies the protocol that the driver will use to tunnel traffic through the FirewallServer proxy. Note that by default the driver connects to the system proxy; to disable this behavior and connect to one of the following proxy types, set ProxyAutoDetect to false.

 

   
Type Default Port Description
TUNNEL 80 When this is set, the driver opens a connection to ServiceNow and traffic flows back and forth through the proxy.
SOCKS4 1080 When this is set, the driver sends data through the SOCKS 4 proxy specified by FirewallServer and FirewallPort and passes the FirewallUser value to the proxy, which determines if the connection request should be granted.
SOCKS5 1080 When this is set, the driver sends data through the SOCKS 5 proxy specified by FirewallServer and FirewallPort. If your proxy requires authentication, set FirewallUser and FirewallPassword to credentials the proxy recognizes.

 

To connect to HTTP proxies, use ProxyServer and ProxyPort. To authenticate to HTTP proxies, use ProxyAuthScheme, ProxyUser, and ProxyPassword.

 

 

Firewall User

Data Type

string

Default Value

""

Remarks

The FirewallUser and FirewallPassword properties are used to authenticate against the proxy specified in FirewallServer and FirewallPort, following the authentication type specified in FirewallType.

 

Initiate OAuth

Data Type

string

Default Value

"OFF"

Remarks

The following options are available:

  1. OFF: Indicates that the OAuth flow will be handled entirely by the user. An OAuthAccessToken will be required to authenticate.
  2. GETANDREFRESH: Indicates that the entire OAuth Flow will be handled by the driver. If no token currently exists, it will be obtained by prompting the user via the browser. If a token exists, it will be refreshed when applicable.
  3. REFRESH: Indicates that the driver will only handle refreshing the OAuthAccessToken. The user will never be prompted by the driver to authenticate via the browser. The user must handle obtaining the OAuthAccessToken and OAuthRefreshToken initially.

 

 

Instance

Data Type

string

Default Value

""

Remarks

The ServiceNow instance to retrieve tables from.

 

Location

Data Type

string

Default Value

""

Remarks

The path to a directory which contains the schema files for the driver (.rsd files for tables and views, .rsb files for stored procedures). The Location property is only needed if you would like to customize definitions (e.g., change a column name, ignore a column, etc.) or extend the data model with new tables, views, or stored procedures.

The schema files used in your application must be deployed with other assemblies. You must also ensure that Location points to the folder that contains the schema files. The folder location can be a relative path from the location of the executable.

 

Logfile

Data Type

string

Default Value

""

Remarks

For more control over what is written to the log file, take a look at Verbosity.

 

Max Log File Size

Data Type

string

Default Value

""

Remarks

A string specifying the maximum size in bytes for a log file (ex: 10MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end. There is no limit by default. Values lower than 100kB will use 100kB as the value instead.

 

OAuth Access Token

Data Type

string

Default Value

""

Remarks

The OAuthAccessToken property is used to connect using OAuth. The OAuthAccessToken is retrieved from the OAuth server as part of the authentication process. It has a server-dependent timeout and can be reused between requests.

The access token is used in place of your username and password. The access token protects your credentials by keeping them on the server.

 

OAuth Client Id

Data Type

string

Default Value

""

Remarks

OAuth requires you to register your application. As part of the registration, you will receive a client Id, sometimes also called a consumer key, and a client secret. You must specify both the OAuthClientId and OAuthClientSecret to connect to an OAuth server.

 

OAuth Client Secret

Data Type

string

Default Value

""

Remarks

OAuth requires you to register your application. As part of the registration you will receive a client Id and a client secret, sometimes also called a consumer secret. You must specify both the OAuthClientId and OAuthClientSecret to connect to an OAuth server.

 

OAuth Refresh Token

Data Type

string

Default Value

""

Remarks

The OAuthRefreshToken property is used to refresh the OAuthAccessToken when using OAuth authentication.

 

OAuth Settings Location

Data Type

string

Default Value

"%APPDATA%\\CData\\ServiceNow Data Provider\\OAuthSettings.txt"

Remarks

When InitiateOAuth is set to GETANDREFRESH or REFRESH, the driver saves OAuth values to a settings file to avoid requiring the user to manually enter OAuth connection properties. The default OAuthSettingsLocation is a settings file located in the %AppData%\CData folder.

This property is useful for connecting to multiple ServiceNow accounts at once: Set OAuthSettingsLocation to a file unique to the connection.

 

Offline

Data Type

bool

Default Value

false

Remarks

When Offline is set to TRUE, all queries execute against the cache as opposed to the live data source. In this mode, certain queries like INSERT, UPDATE, DELETE, and CACHE are not allowed.

 

Other

Data Type

string

Default Value

""

Remarks

The Other property is a semicolon-separated list of name-value pairs used in connection parameters specific to a data source.

Caching Configuration

 

   
CachePartial=True Caches only a subset of columns, which you can specify in your query.
QueryPassthrough=True Passes the specified query to the cache database instead of using the SQL parser of the driver.

 

Integration and Formatting

 

   
SupportAccessLinkedMode In Access' linked mode, it is generally a good idea to always use a cache as most data sources do not support multiple Id queries. However if you want to use the driver in Access but not in linked mode, this property must be set to False to avoid using a cache of a SELECT * query for the given table.
ConvertDateTimeToGMT Whether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filename Records the underlying socket data transfer to the specified file.
ClientCulture This property can be used to specify the format of data (e.g., currency values) that is accepted by the client application. This property can be used when the client application does not support the machine's culture settings. For example, Microsoft Access requires 'en-US'.
Culture This setting can be used to specify culture settings that determine how the driver interprets certain data types that are passed into the driver. For example, setting Culture='de-DE' will output German formats even on an American machine.

 

 

Password

Data Type

string

Default Value

""

Remarks

The password used to authenticate the user.

 

Proxy Auth Scheme

Data Type

string

Default Value

"BASIC"

Remarks

This value specifies the authentication type to use to authenticate to the HTTP proxy specified by ProxyServer and ProxyPort.

Note that the driver will use the system proxy settings by default, without further configuration needed; if you want to connect to another proxy, you will need to set ProxyAutoDetect to false, in addition to ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

The authentication type can be one of the following:

  • BASIC: The driver performs HTTP BASIC authentication.
  • DIGEST: The driver performs HTTP DIGEST authentication.
  • NEGOTIATE: The driver retrieves an NTLM or Kerberos token based on the applicable protocol for authentication.
  • PROPRIETARY: The driver does not generate an NTLM or Kerberos token. You must supply this token in the Authorization header of the HTTP request.
If you need to use another authentication type, such as SOCKS 5 authentication, see FirewallType.

 

 

Proxy Auto Detect

Data Type

bool

Default Value

true

Remarks

By default, the driver uses the system HTTP proxy. Set this to false if you want to connect to another proxy.

To connect to an HTTP proxy, see ProxyServer.

For other proxies, such as SOCKS or tunneling, see FirewallType.

 

Proxy Password

Data Type

string

Default Value

""

Remarks

This property is used to authenticate to an HTTP proxy server that supports NTLM (Windows), Kerberos, or HTTP authentication. To specify the HTTP proxy, you can set ProxyServer and ProxyPort. To specify the authentication type, set ProxyAuthScheme.

If you are using HTTP authentication, additionally set ProxyUser and ProxyPassword to HTTP proxy.

If you are using NTLM authentication, set ProxyUser and ProxyPassword to your Windows password. You may also need these to complete Kerberos authentication.

For SOCKS 5 authentication or tunneling, see FirewallType.

By default, the driver uses the system proxy. If you want to connect to another proxy, set ProxyAutoDetect to false.

 

Proxy Port

Data Type

string

Default Value

"80"

Remarks

The port the HTTP proxy is running on that you want to redirect HTTP traffic through. Specify the HTTP proxy in ProxyServer. For other proxy types, see FirewallType.

 

Proxy Server

Data Type

string

Default Value

""

Remarks

The hostname or IP address of a proxy to route HTTP traffic through. The driver can use the HTTP, Windows (NTLM), or Kerberos authentication types to authenticate to an HTTP proxy.

If you need to connect through a SOCKS proxy or tunnel the connection, see FirewallType.

By default, the driver uses the system proxy. If you need to use another proxy, set ProxyAutoDetect to false.

 

Proxy SSL Type

Data Type

string

Default Value

"AUTO"

Remarks

This property determines when to use SSL for the connection to an HTTP proxy specified by ProxyServer. This value can be AUTO, ALWAYS, NEVER, or TUNNEL. The applicable values are the following:

 

   
AUTO Default setting. If the URL is an HTTPS URL, the driver will use the TUNNEL option. If the URL is an HTTP URL, the component will use the NEVER option.
ALWAYS The connection is always SSL enabled.
NEVER The connection is not SSL enabled.
TUNNEL The connection is through a tunneling proxy: The proxy server opens a connection to the remote host and traffic flows back and forth through the proxy.

 

 

Proxy User

Data Type

string

Default Value

""

Remarks

The ProxyUser and ProxyPassword options are used to connect and authenticate against the HTTP proxy specified in ProxyServer.

You can select one of the available authentication types in ProxyAuthScheme. If you are using HTTP authentication, set this to the username of a user recognized by the HTTP proxy. If you are using Windows or Kerberos authentication, set this property to a username in one of the following formats:

user@domain
domain\user

 

 

Pseudo Columns

Data Type

string

Default Value

""

Remarks

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; i.e., "*=*".

 

Query Cache

Data Type

string

Default Value

""

Remarks

The QueryCache property allows you to cache the results of a query in memory and use them until the cache expires. The cache expires after the seconds specified in this property. The in-memory query cache is shared across connections, so it can help with performance even if more than one connection is being used.

How QueryCache Works

 

The cache manager for QueryCache will not only use the cache for exactly the same query, but also use the cache for queries that represent a subset of data in the cached query. For example, in the following queries, the cache created while executing Query A will be used to obtain the results for both Query B and Query C.

SELECT * FROM Account; // Query A
SELECT * FROM Account WHERE Name LIKE '%John'; // Query B
SELECT sys_id, Name FROM Account LIMIT 10; // Query C

 

 

When to Use QueryCache

 

Setting the QueryCache property can improve performance in the following scenarios:

  • When you need to execute the same or similar queries from multiple connections: With this property set, all connections share the same temporary cache instead of each executing a query to ServiceNow. This can be useful in connection pooling.

  •  

    When you need to query cached data with generated queries: Data access wizards and dashboard designers generate an underlying SQL query, which you may have a limited ability to modify. Typically, to pass through SQL to query a cache, you need to set Offline. Offline queries may be unacceptable if your BI and analytics need to reflect changes to the data in real time. But, slow networks or servers can result in reports with unacceptable lag.

    QueryCache enables you to execute standard SQL against a local cache while remaining online to periodically refresh the cache.

    Note that Offline and QueryCache do not provide an ad-hoc way to select a cached table or a remote table after opening a connection; the properties allow access to only one or the other. The #CACHE SQL syntax enables you to explicitly select a cached table, without going offline. Refer to Caching Explicitly for more information.

When Not to Use QueryCache

 

 

  • When you need the most efficient queries possible: By default, the driver offloads as much processing as possible to the server. This results in the least amount of data crossing the network. ; even if a query is not supported and needs some in-memory processing, the driver still leverages the API's capabilities. QueryCache is only desirable when the default functionality is not possible or when there are overriding constraints; for example, even API-optimized queries can be expensive against a slow server.

 

 

Readonly

Data Type

bool

Default Value

false

Remarks

If this property is set to true, the driver will allow only SELECT queries. INSERT, UPDATE, DELETE, and stored procedure queries will cause an error to be thrown.

 

RTK

Data Type

string

Default Value

""

Remarks

The RTK property may be used to license a build. Please see the included licensing file to see how to set this property. The runtime key is only available if you purchased an OEM license.

 

SSL Server Cert

Data Type

string

Default Value

""

Remarks

If using a TLS/SSL connection, this property can be used to specify the TLS/SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine will be rejected.

This property can take the forms:

 

   
Description Example
A full PEM Certificate (example shortened for brevity) -----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
A path to a local file containing the certificate C:\cert.cer
The public key (example shortened for brevity) -----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
The MD5 Thumbprint (hex values can also be either space or colon separated) ecadbdda5a1529c58a1e9e09828d70e4
The SHA1 Thumbprint (hex values can also be either space or colon separated) 34a929226ae0819f2ec14b4a3d904f801cbb150d

 

If not specified, any certificate trusted by the machine will be accepted. Use '*' to signify to accept all certificates (not recommended for security concerns).

 

Support Enhanced SQL

Data Type

bool

Default Value

true

Remarks

Use QueryCache to cache memory for a given time in seconds or to disable in-memory caching.

Use QueryCache to cache in memory for a given time in seconds or to disable in-memory caching.

 

Tables

Data Type

string

Default Value

""

Remarks

Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the driver.

 

Timeout

Data Type

string

Default Value

"60"

Remarks

If the Timeout property is set to 0, operations do not time out: They run until they complete successfully or encounter an error condition.

If Timeout expires and the operation is not yet complete, the driver throws an exception.

 

Username

Data Type

string

Default Value

""

Remarks

Together with Password, this field is used to authenticate to ServiceNow.

 

 

Verbosity

Data Type

string

Default Value

"1"

Remarks

The verbosity level determines the amount of detail that the driver reports to the Logfile. Verbosity levels from 1 to 5 are supported. These are described below:

 

   
1 Setting Verbosity to 1 will log the query, the number of rows returned by it, the start of execution and the time taken, and any errors.
2 Setting Verbosity to 2 will log everything included in Verbosity 1, cache queries, and HTTP headers.
3 Setting Verbosity to 3 will additionally log the body of the HTTP requests.
4 Setting Verbosity to 4 will additionally log transport-level communication with the data source. This includes SSL negotiation.
5 Setting Verbosity to 5 will additionally log communication with the data source and additional details that may be helpful in troubleshooting problems. This includes interface commands.

The Verbosity should not be set to greater than 1 for normal operation. Substantial amounts of data can be logged at higher verbosities, which can delay execution times.

 

Views

Data Type

string

Default Value

""

Remarks

Listing the Views from some databases can be expensive. Providing a list of Views in the connection string improves the performance of the driver.




 

Tables

  1. ast_contract
  2. ast_license_base
  3. change_request
  4. cmdb_ci
  5. cmdb_metric
  6. cmn_building
  7. cmn_context_help
  8. cmn_cost_center
  9. cmn_department
  10. cmn_location
  11. cmn_map_page
  12. cmn_notif_device
  13. cmn_notif_device_variable
  14. cmn_notif_grmember
  15. cmn_notif_group
  16. cmn_notif_message
  17. cmn_notif_service_provider
  18. cmn_other_schedule
  19. cmn_relative_duration
  20. cmn_schedule
  21. cmn_schedule_blackout
  22. cmn_schedule_condition
  23. cmn_schedule_maintenance
  24. cmn_schedule_page
  25. cmn_schedule_span
  26. cmn_timeline_page
  27. cmn_timeline_page_style
  28. cmn_timeline_sub_item
  29. diagrammer_action
  30. expert_panel
  31. item_option_new
  32. question
  33. sc_category
  34. sc_cat_item
  35. sla
  36. sysauto
  37. sysauto_script
  38. syslog
  39. sysrule
  40. system_db_object
  41. system_dictionary
  42. system_documentation
  43. system_import_set_row
  44. system_script_client
  45. system_ui_policy
  46. system_ui_policy_action
  47. task
  48. v_field_creator

ast_contract

The ServiceNow table ast_contract.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
vendor String False  

The vendor column for the table ast_contract.

renewable String False  

The renewable column for the table ast_contract.

tax_rate String False  

The tax_rate column for the table ast_contract.

contract_model String False  

The contract_model column for the table ast_contract.

state String False  

The state column for the table ast_contract.

sys_class_name String False  

The sys_class_name column for the table ast_contract.

ends Datetime False  

The ends column for the table ast_contract.

total_cost String False  

The total_cost column for the table ast_contract.

contract_administrator String False  

The contract_administrator column for the table ast_contract.

cost_center String False  

The cost_center column for the table ast_contract.

expiration String False  

The expiration column for the table ast_contract.

description String False  

The description column for the table ast_contract.

cost_adjustment_type String False  

The cost_adjustment_type column for the table ast_contract.

payment_schedule String False  

The payment_schedule column for the table ast_contract.

renewal_options String False  

The renewal_options column for the table ast_contract.

license_type String False  

The license_type column for the table ast_contract.

vendor_account String False  

The vendor_account column for the table ast_contract.

cost_adjustment_percentage String False  

The cost_adjustment_percentage column for the table ast_contract.

payment_amount String False  

The payment_amount column for the table ast_contract.

renewal_end_date Datetime False  

The renewal_end_date column for the table ast_contract.

process String False  

The process column for the table ast_contract.

ratecard String False  

The ratecard column for the table ast_contract.

cost_per_unit String False  

The cost_per_unit column for the table ast_contract.

monthly_cost String False  

The monthly_cost column for the table ast_contract.

sys_mod_count String False  

The sys_mod_count column for the table ast_contract.

commitment String False  

The commitment column for the table ast_contract.

sys_created_by String False  

The sys_created_by column for the table ast_contract.

approval_history String False  

The approval_history column for the table ast_contract.

sys_updated_by String False  

The sys_updated_by column for the table ast_contract.

number String False  

The number column for the table ast_contract.

active String False  

The active column for the table ast_contract.

sales_tax String False  

The sales_tax column for the table ast_contract.

renewal_contact String False  

The renewal_contact column for the table ast_contract.

license_quantity_entitled String False  

The license_quantity_entitled column for the table ast_contract.

starts Datetime False  

The starts column for the table ast_contract.

sub_total_cost String False  

The sub_total_cost column for the table ast_contract.

location String False  

The location column for the table ast_contract.

po_number String False  

The po_number column for the table ast_contract.

sys_domain String False  

The sys_domain column for the table ast_contract.

short_description String False  

The short_description column for the table ast_contract.

cost_adjustment_reason String False  

The cost_adjustment_reason column for the table ast_contract.

tax_cost String False  

The tax_cost column for the table ast_contract.

invoice_payment_terms String False  

The invoice_payment_terms column for the table ast_contract.

terms_and_conditions String False  

The terms_and_conditions column for the table ast_contract.

vendor_contract String False  

The vendor_contract column for the table ast_contract.

cost_adjustment String False  

The cost_adjustment column for the table ast_contract.

tax_exempt String False  

The tax_exempt column for the table ast_contract.

renewal_date Datetime False  

The renewal_date column for the table ast_contract.

substate String False  

The substate column for the table ast_contract.

approver String False  

The approver column for the table ast_contract.

lifetime_cost String False  

The lifetime_cost column for the table ast_contract.

yearly_cost String False  

The yearly_cost column for the table ast_contract.

sys_created_on Datetime False  

The sys_created_on column for the table ast_contract.

discount String False  

The discount column for the table ast_contract.

sys_updated_on Datetime False  

The sys_updated_on column for the table ast_contract.

application_model String False  

The application_model column for the table ast_contract.

sys_id [KEY] String False  

The sys_id column for the table ast_contract.

sys_domain_path String False  

The sys_domain_path column for the table ast_contract.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

ast_license_base

The ServiceNow table ast_license_base.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
number String False  

The number column for the table ast_license_base.

vendor_account String False  

The vendor_account column for the table ast_license_base.

license_count String False  

The license_count column for the table ast_license_base.

option String False  

The option column for the table ast_license_base.

sys_created_on Datetime False  

The sys_created_on column for the table ast_license_base.

vendor String False  

The vendor column for the table ast_license_base.

license_key String False  

The license_key column for the table ast_license_base.

upgraded_from String False  

The upgraded_from column for the table ast_license_base.

sys_updated_on Datetime False  

The sys_updated_on column for the table ast_license_base.

sys_class_name String False  

The sys_class_name column for the table ast_license_base.

short_description String False  

The short_description column for the table ast_license_base.

license_cost String False  

The license_cost column for the table ast_license_base.

sys_id [KEY] String False  

The sys_id column for the table ast_license_base.

invoice_number String False  

The invoice_number column for the table ast_license_base.

location String False  

The location column for the table ast_license_base.

percent_used String False  

The percent_used column for the table ast_license_base.

vendor_contract String False  

The vendor_contract column for the table ast_license_base.

install_count String False  

The install_count column for the table ast_license_base.

manual String False  

The manual column for the table ast_license_base.

sys_created_by String False  

The sys_created_by column for the table ast_license_base.

department String False  

The department column for the table ast_license_base.

description String False  

The description column for the table ast_license_base.

maintenance_cost String False  

The maintenance_cost column for the table ast_license_base.

sys_updated_by String False  

The sys_updated_by column for the table ast_license_base.

parent String False  

The parent column for the table ast_license_base.

purchased Datetime False  

The purchased column for the table ast_license_base.

total_cost String False  

The total_cost column for the table ast_license_base.

compliance_level String False  

The compliance_level column for the table ast_license_base.

po_number String False  

The po_number column for the table ast_license_base.

license_available String False  

The license_available column for the table ast_license_base.

discoverable_key String False  

The discoverable_key column for the table ast_license_base.

sys_mod_count String False  

The sys_mod_count column for the table ast_license_base.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

change_request

The ServiceNow table change_request.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
outside_maintenance_schedule String False  

The outside_maintenance_schedule column for the table change_request.

on_hold_reason String False  

The on_hold_reason column for the table change_request.

start_date Datetime False  

The start_date column for the table change_request.

cab_date Datetime False  

The cab_date column for the table change_request.

close_code String False  

The close_code column for the table change_request.

requested_by String False  

The requested_by column for the table change_request.

backout_plan String False  

The backout_plan column for the table change_request.

change_plan String False  

The change_plan column for the table change_request.

implementation_plan String False  

The implementation_plan column for the table change_request.

sys_id [KEY] String False  

The sys_id column for the table change_request.

phase String False  

The phase column for the table change_request.

review_status String False  

The review_status column for the table change_request.

conflict_status String False  

The conflict_status column for the table change_request.

phase_state String False  

The phase_state column for the table change_request.

production_system String False  

The production_system column for the table change_request.

type String False  

The type column for the table change_request.

on_hold String False  

The on_hold column for the table change_request.

end_date Datetime False  

The end_date column for the table change_request.

requested_by_date Datetime False  

The requested_by_date column for the table change_request.

risk_impact_analysis String False  

The risk_impact_analysis column for the table change_request.

test_plan String False  

The test_plan column for the table change_request.

justification String False  

The justification column for the table change_request.

scope String False  

The scope column for the table change_request.

review_comments String False  

The review_comments column for the table change_request.

std_change_producer_version String False  

The std_change_producer_version column for the table change_request.

category String False  

The category column for the table change_request.

review_date Datetime False  

The review_date column for the table change_request.

conflict_last_run Datetime False  

The conflict_last_run column for the table change_request.

risk String False  

The risk column for the table change_request.

reason String False  

The reason column for the table change_request.

cab_recommendation String False  

The cab_recommendation column for the table change_request.

delivery_task String False  

The delivery_task column for the table change_request.

upon_approval String False  

The upon_approval column for the table change_request.

work_start Datetime False  

The work_start column for the table change_request.

delivery_plan String False  

The delivery_plan column for the table change_request.

rejection_goto String False  

The rejection_goto column for the table change_request.

work_end Datetime False  

The work_end column for the table change_request.

upon_reject String False  

The upon_reject column for the table change_request.

business_service String False  

The business_service column for the table change_request.

sys_domain String False  

The sys_domain column for the table change_request.

sys_created_on Datetime False  

The sys_created_on column for the table change_request.

sys_updated_on Datetime False  

The sys_updated_on column for the table change_request.

expected_start Datetime False  

The expected_start column for the table change_request.

variables String False  

The variables column for the table change_request.

number String False  

The number column for the table change_request.

comments String False  

The comments column for the table change_request.

urgency String False  

The urgency column for the table change_request.

opened_at Datetime False  

The opened_at column for the table change_request.

watch_list String False  

The watch_list column for the table change_request.

sla_due Datetime False  

The sla_due column for the table change_request.

active String False  

The active column for the table change_request.

state String False  

The state column for the table change_request.

work_notes String False  

The work_notes column for the table change_request.

closed_by String False  

The closed_by column for the table change_request.

follow_up Datetime False  

The follow_up column for the table change_request.

work_notes_list String False  

The work_notes_list column for the table change_request.

cmdb_ci String False  

The cmdb_ci column for the table change_request.

approval_history String False  

The approval_history column for the table change_request.

business_duration Datetime False  

The business_duration column for the table change_request.

location String False  

The location column for the table change_request.

user_input String False  

The user_input column for the table change_request.

assigned_to String False  

The assigned_to column for the table change_request.

escalation String False  

The escalation column for the table change_request.

time_worked String False  

The time_worked column for the table change_request.

additional_assignee_list String False  

The additional_assignee_list column for the table change_request.

correlation_id String False  

The correlation_id column for the table change_request.

comments_and_work_notes String False  

The comments_and_work_notes column for the table change_request.

order String False  

The order column for the table change_request.

made_sla String False  

The made_sla column for the table change_request.

sys_mod_count String False  

The sys_mod_count column for the table change_request.

sys_created_by String False  

The sys_created_by column for the table change_request.

sys_updated_by String False  

The sys_updated_by column for the table change_request.

sys_domain_path String False  

The sys_domain_path column for the table change_request.

sys_class_name String False  

The sys_class_name column for the table change_request.

parent String False  

The parent column for the table change_request.

priority String False  

The priority column for the table change_request.

close_notes String False  

The close_notes column for the table change_request.

reassignment_count String False  

The reassignment_count column for the table change_request.

due_date Datetime False  

The due_date column for the table change_request.

short_description String False  

The short_description column for the table change_request.

company String False  

The company column for the table change_request.

approval_set Datetime False  

The approval_set column for the table change_request.

opened_by String False  

The opened_by column for the table change_request.

contact_type String False  

The contact_type column for the table change_request.

assignment_group String False  

The assignment_group column for the table change_request.

approval String False  

The approval column for the table change_request.

calendar_duration Datetime False  

The calendar_duration column for the table change_request.

knowledge String False  

The knowledge column for the table change_request.

correlation_display String False  

The correlation_display column for the table change_request.

wf_activity String False  

The wf_activity column for the table change_request.

description String False  

The description column for the table change_request.

impact String False  

The impact column for the table change_request.

closed_at Datetime False  

The closed_at column for the table change_request.

group_list String False  

The group_list column for the table change_request.

activity_due Datetime False  

The activity_due column for the table change_request.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmdb_ci

The ServiceNow table cmdb_ci.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
name String False  

The name column for the table cmdb_ci.

serial_number String False  

The serial_number column for the table cmdb_ci.

delivery_date Datetime False  

The delivery_date column for the table cmdb_ci.

lease_id String False  

The lease_id column for the table cmdb_ci.

checked_out Datetime False  

The checked_out column for the table cmdb_ci.

sys_domain_path String False  

The sys_domain_path column for the table cmdb_ci.

sys_created_by String False  

The sys_created_by column for the table cmdb_ci.

purchase_date Datetime False  

The purchase_date column for the table cmdb_ci.

location String False  

The location column for the table cmdb_ci.

cost_cc String False  

The cost_cc column for the table cmdb_ci.

managed_by String False  

The managed_by column for the table cmdb_ci.

sys_updated_by String False  

The sys_updated_by column for the table cmdb_ci.

assignment_group String False  

The assignment_group column for the table cmdb_ci.

model_id String False  

The model_id column for the table cmdb_ci.

gl_account String False  

The gl_account column for the table cmdb_ci.

supported_by String False  

The supported_by column for the table cmdb_ci.

unverified String False  

The unverified column for the table cmdb_ci.

company String False  

The company column for the table cmdb_ci.

manufacturer String False  

The manufacturer column for the table cmdb_ci.

po_number String False  

The po_number column for the table cmdb_ci.

due_in String False  

The due_in column for the table cmdb_ci.

asset String False  

The asset column for the table cmdb_ci.

sys_mod_count String False  

The sys_mod_count column for the table cmdb_ci.

asset_tag String False  

The asset_tag column for the table cmdb_ci.

sys_class_name String False  

The sys_class_name column for the table cmdb_ci.

order_date Datetime False  

The order_date column for the table cmdb_ci.

department String False  

The department column for the table cmdb_ci.

checked_in Datetime False  

The checked_in column for the table cmdb_ci.

sys_domain String False  

The sys_domain column for the table cmdb_ci.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmdb_ci.

install_status String False  

The install_status column for the table cmdb_ci.

justification String False  

The justification column for the table cmdb_ci.

cost String False  

The cost column for the table cmdb_ci.

owned_by String False  

The owned_by column for the table cmdb_ci.

assigned Datetime False  

The assigned column for the table cmdb_ci.

vendor String False  

The vendor column for the table cmdb_ci.

invoice_number String False  

The invoice_number column for the table cmdb_ci.

support_group String False  

The support_group column for the table cmdb_ci.

skip_sync String False  

The skip_sync column for the table cmdb_ci.

assigned_to String False  

The assigned_to column for the table cmdb_ci.

install_date Datetime False  

The install_date column for the table cmdb_ci.

warranty_expiration Datetime False  

The warranty_expiration column for the table cmdb_ci.

due Datetime False  

The due column for the table cmdb_ci.

cost_center String False  

The cost_center column for the table cmdb_ci.

sys_created_on Datetime False  

The sys_created_on column for the table cmdb_ci.

short_description String False  

The short_description column for the table cmdb_ci.

attributes String False  

The attributes column for the table cmdb_ci.

fault_count String False  

The fault_count column for the table cmdb_ci.

change_control String False  

The change_control column for the table cmdb_ci.

fqdn String False  

The fqdn column for the table cmdb_ci.

subcategory String False  

The subcategory column for the table cmdb_ci.

last_discovered Datetime False  

The last_discovered column for the table cmdb_ci.

correlation_id String False  

The correlation_id column for the table cmdb_ci.

discovery_source String False  

The discovery_source column for the table cmdb_ci.

mac_address String False  

The mac_address column for the table cmdb_ci.

maintenance_schedule String False  

The maintenance_schedule column for the table cmdb_ci.

model_number String False  

The model_number column for the table cmdb_ci.

monitor String False  

The monitor column for the table cmdb_ci.

sys_id [KEY] String False  

The sys_id column for the table cmdb_ci.

operational_status String False  

The operational_status column for the table cmdb_ci.

start_date Datetime False  

The start_date column for the table cmdb_ci.

dns_domain String False  

The dns_domain column for the table cmdb_ci.

category String False  

The category column for the table cmdb_ci.

first_discovered Datetime False  

The first_discovered column for the table cmdb_ci.

can_print String False  

The can_print column for the table cmdb_ci.

comments String False  

The comments column for the table cmdb_ci.

ip_address String False  

The ip_address column for the table cmdb_ci.

schedule String False  

The schedule column for the table cmdb_ci.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmdb_metric

The ServiceNow table cmdb_metric.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
sys_updated_by String False  

The sys_updated_by column for the table cmdb_metric.

snc_mi String False  

The snc_mi column for the table cmdb_metric.

sys_mod_count String False  

The sys_mod_count column for the table cmdb_metric.

sys_created_by String False  

The sys_created_by column for the table cmdb_metric.

sys_id [KEY] String False  

The sys_id column for the table cmdb_metric.

sys_class_name String False  

The sys_class_name column for the table cmdb_metric.

sys_created_on Datetime False  

The sys_created_on column for the table cmdb_metric.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmdb_metric.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_building

The ServiceNow table cmn_building.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
sys_mod_count String False  

The sys_mod_count column for the table cmn_building.

location String False  

The location column for the table cmn_building.

sys_updated_by String False  

The sys_updated_by column for the table cmn_building.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_building.

floors String False  

The floors column for the table cmn_building.

notes String False  

The notes column for the table cmn_building.

sys_created_by String False  

The sys_created_by column for the table cmn_building.

name String False  

The name column for the table cmn_building.

contact String False  

The contact column for the table cmn_building.

sys_id [KEY] String False  

The sys_id column for the table cmn_building.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_building.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_context_help

The ServiceNow table cmn_context_help.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
document String False  

The document column for the table cmn_context_help.

plugin_id String False  

The plugin_id column for the table cmn_context_help.

language String False  

The language column for the table cmn_context_help.

type String False  

The type column for the table cmn_context_help.

servicenow String False  

The servicenow column for the table cmn_context_help.

url String False  

The url column for the table cmn_context_help.

active String False  

The active column for the table cmn_context_help.

sys_id [KEY] String False  

The sys_id column for the table cmn_context_help.

use_plugin_base_url String False  

The use_plugin_base_url column for the table cmn_context_help.

sys_policy String False  

The sys_policy column for the table cmn_context_help.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table cmn_context_help.

sys_customer_update String False  

The sys_customer_update column for the table cmn_context_help.

sys_scope String False  

The sys_scope column for the table cmn_context_help.

sys_package String False  

The sys_package column for the table cmn_context_help.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_context_help.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_context_help.

sys_name String False  

The sys_name column for the table cmn_context_help.

sys_updated_by String False  

The sys_updated_by column for the table cmn_context_help.

sys_created_by String False  

The sys_created_by column for the table cmn_context_help.

sys_class_name String False  

The sys_class_name column for the table cmn_context_help.

sys_mod_count String False  

The sys_mod_count column for the table cmn_context_help.

sys_update_name String False  

The sys_update_name column for the table cmn_context_help.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_cost_center

The ServiceNow table cmn_cost_center.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
sys_created_by String False  

The sys_created_by column for the table cmn_cost_center.

parent String False  

The parent column for the table cmn_cost_center.

valid_to Datetime False  

The valid_to column for the table cmn_cost_center.

sys_id [KEY] String False  

The sys_id column for the table cmn_cost_center.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_cost_center.

name String False  

The name column for the table cmn_cost_center.

manager String False  

The manager column for the table cmn_cost_center.

location String False  

The location column for the table cmn_cost_center.

sys_updated_by String False  

The sys_updated_by column for the table cmn_cost_center.

sys_mod_count String False  

The sys_mod_count column for the table cmn_cost_center.

code String False  

The code column for the table cmn_cost_center.

account_number String False  

The account_number column for the table cmn_cost_center.

valid_from Datetime False  

The valid_from column for the table cmn_cost_center.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_cost_center.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_department

The ServiceNow table cmn_department.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
cost_center String False  

The cost_center column for the table cmn_department.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_department.

dept_head String False  

The dept_head column for the table cmn_department.

primary_contact String False  

The primary_contact column for the table cmn_department.

head_count String False  

The head_count column for the table cmn_department.

sys_created_by String False  

The sys_created_by column for the table cmn_department.

name String False  

The name column for the table cmn_department.

id String False  

The id column for the table cmn_department.

description String False  

The description column for the table cmn_department.

sys_id [KEY] String False  

The sys_id column for the table cmn_department.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_department.

sys_mod_count String False  

The sys_mod_count column for the table cmn_department.

company String False  

The company column for the table cmn_department.

parent String False  

The parent column for the table cmn_department.

sys_updated_by String False  

The sys_updated_by column for the table cmn_department.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_location

The ServiceNow table cmn_location.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
parent String False  

The parent column for the table cmn_location.

lat_long_error String False  

The lat_long_error column for the table cmn_location.

state String False  

The state column for the table cmn_location.

sys_created_by String False  

The sys_created_by column for the table cmn_location.

fax_phone String False  

The fax_phone column for the table cmn_location.

phone_territory String False  

The phone_territory column for the table cmn_location.

contact String False  

The contact column for the table cmn_location.

full_name String False  

The full_name column for the table cmn_location.

name String False  

The name column for the table cmn_location.

sys_id [KEY] String False  

The sys_id column for the table cmn_location.

zip String False  

The zip column for the table cmn_location.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_location.

country String False  

The country column for the table cmn_location.

sys_mod_count String False  

The sys_mod_count column for the table cmn_location.

stock_room String False  

The stock_room column for the table cmn_location.

latitude String False  

The latitude column for the table cmn_location.

street String False  

The street column for the table cmn_location.

sys_updated_by String False  

The sys_updated_by column for the table cmn_location.

time_zone String False  

The time_zone column for the table cmn_location.

city String False  

The city column for the table cmn_location.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_location.

phone String False  

The phone column for the table cmn_location.

company String False  

The company column for the table cmn_location.

longitude String False  

The longitude column for the table cmn_location.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_map_page

The ServiceNow table cmn_map_page.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
name String False  

The name column for the table cmn_map_page.

center_latitude String False  

The center_latitude column for the table cmn_map_page.

script String False  

The script column for the table cmn_map_page.

type_selection String False  

The type_selection column for the table cmn_map_page.

show_device_location String False  

The show_device_location column for the table cmn_map_page.

controls_size String False  

The controls_size column for the table cmn_map_page.

initial_zoom String False  

The initial_zoom column for the table cmn_map_page.

center_address String False  

The center_address column for the table cmn_map_page.

overview String False  

The overview column for the table cmn_map_page.

sys_id [KEY] String False  

The sys_id column for the table cmn_map_page.

type String False  

The type column for the table cmn_map_page.

refresh_on_zoom String False  

The refresh_on_zoom column for the table cmn_map_page.

suffix String False  

The suffix column for the table cmn_map_page.

center_longitude String False  

The center_longitude column for the table cmn_map_page.

sys_policy String False  

The sys_policy column for the table cmn_map_page.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table cmn_map_page.

sys_customer_update String False  

The sys_customer_update column for the table cmn_map_page.

sys_scope String False  

The sys_scope column for the table cmn_map_page.

sys_package String False  

The sys_package column for the table cmn_map_page.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_map_page.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_map_page.

sys_name String False  

The sys_name column for the table cmn_map_page.

sys_updated_by String False  

The sys_updated_by column for the table cmn_map_page.

sys_created_by String False  

The sys_created_by column for the table cmn_map_page.

sys_class_name String False  

The sys_class_name column for the table cmn_map_page.

sys_mod_count String False  

The sys_mod_count column for the table cmn_map_page.

sys_update_name String False  

The sys_update_name column for the table cmn_map_page.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_notif_device

The ServiceNow table cmn_notif_device.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
email_address String False  

The email_address column for the table cmn_notif_device.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_notif_device.

primary_email String False  

The primary_email column for the table cmn_notif_device.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_notif_device.

name String False  

The name column for the table cmn_notif_device.

sys_id [KEY] String False  

The sys_id column for the table cmn_notif_device.

user String False  

The user column for the table cmn_notif_device.

type String False  

The type column for the table cmn_notif_device.

push_app String False  

The push_app column for the table cmn_notif_device.

phone_number String False  

The phone_number column for the table cmn_notif_device.

sys_created_by String False  

The sys_created_by column for the table cmn_notif_device.

active String False  

The active column for the table cmn_notif_device.

sys_updated_by String False  

The sys_updated_by column for the table cmn_notif_device.

order String False  

The order column for the table cmn_notif_device.

service_provider String False  

The service_provider column for the table cmn_notif_device.

schedule String False  

The schedule column for the table cmn_notif_device.

sys_mod_count String False  

The sys_mod_count column for the table cmn_notif_device.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_notif_device_variable

The ServiceNow table cmn_notif_device_variable.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
name String False  

The name column for the table cmn_notif_device_variable.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_notif_device_variable.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_notif_device_variable.

sys_id [KEY] String False  

The sys_id column for the table cmn_notif_device_variable.

device String False  

The device column for the table cmn_notif_device_variable.

sys_mod_count String False  

The sys_mod_count column for the table cmn_notif_device_variable.

sys_created_by String False  

The sys_created_by column for the table cmn_notif_device_variable.

sys_updated_by String False  

The sys_updated_by column for the table cmn_notif_device_variable.

value String False  

The value column for the table cmn_notif_device_variable.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_notif_grmember

The ServiceNow table cmn_notif_grmember.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
sys_id [KEY] String False  

The sys_id column for the table cmn_notif_grmember.

group String False  

The group column for the table cmn_notif_grmember.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_notif_grmember.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_notif_grmember.

user String False  

The user column for the table cmn_notif_grmember.

sys_mod_count String False  

The sys_mod_count column for the table cmn_notif_grmember.

sys_created_by String False  

The sys_created_by column for the table cmn_notif_grmember.

sys_updated_by String False  

The sys_updated_by column for the table cmn_notif_grmember.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_notif_group

The ServiceNow table cmn_notif_group.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
name String False  

The name column for the table cmn_notif_group.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_notif_group.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_notif_group.

sys_id [KEY] String False  

The sys_id column for the table cmn_notif_group.

sys_mod_count String False  

The sys_mod_count column for the table cmn_notif_group.

sys_created_by String False  

The sys_created_by column for the table cmn_notif_group.

sys_updated_by String False  

The sys_updated_by column for the table cmn_notif_group.

group String False  

The group column for the table cmn_notif_group.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_notif_message

The ServiceNow table cmn_notif_message.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
name String False  

The name column for the table cmn_notif_message.

schedule String False  

The schedule column for the table cmn_notif_message.

sys_updated_by String False  

The sys_updated_by column for the table cmn_notif_message.

device String False  

The device column for the table cmn_notif_message.

send_sms String False  

The send_sms column for the table cmn_notif_message.

condition String False  

The condition column for the table cmn_notif_message.

group String False  

The group column for the table cmn_notif_message.

sys_mod_count String False  

The sys_mod_count column for the table cmn_notif_message.

notification String False  

The notification column for the table cmn_notif_message.

location String False  

The location column for the table cmn_notif_message.

sys_created_by String False  

The sys_created_by column for the table cmn_notif_message.

advanced String False  

The advanced column for the table cmn_notif_message.

sys_id [KEY] String False  

The sys_id column for the table cmn_notif_message.

notification_filter String False  

The notification_filter column for the table cmn_notif_message.

send_email String False  

The send_email column for the table cmn_notif_message.

cost_center String False  

The cost_center column for the table cmn_notif_message.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_notif_message.

user String False  

The user column for the table cmn_notif_message.

configuration_item String False  

The configuration_item column for the table cmn_notif_message.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_notif_message.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_notif_service_provider

The ServiceNow table cmn_notif_service_provider.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
type String False  

The type column for the table cmn_notif_service_provider.

im_provider String False  

The im_provider column for the table cmn_notif_service_provider.

use_custom_script String False  

The use_custom_script column for the table cmn_notif_service_provider.

construction_script String False  

The construction_script column for the table cmn_notif_service_provider.

email_prefix String False  

The email_prefix column for the table cmn_notif_service_provider.

name String False  

The name column for the table cmn_notif_service_provider.

script String False  

The script column for the table cmn_notif_service_provider.

active String False  

The active column for the table cmn_notif_service_provider.

use_construction_script String False  

The use_construction_script column for the table cmn_notif_service_provider.

email_suffix String False  

The email_suffix column for the table cmn_notif_service_provider.

sys_id [KEY] String False  

The sys_id column for the table cmn_notif_service_provider.

sys_policy String False  

The sys_policy column for the table cmn_notif_service_provider.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table cmn_notif_service_provider.

sys_customer_update String False  

The sys_customer_update column for the table cmn_notif_service_provider.

sys_scope String False  

The sys_scope column for the table cmn_notif_service_provider.

sys_package String False  

The sys_package column for the table cmn_notif_service_provider.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_notif_service_provider.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_notif_service_provider.

sys_name String False  

The sys_name column for the table cmn_notif_service_provider.

sys_updated_by String False  

The sys_updated_by column for the table cmn_notif_service_provider.

sys_created_by String False  

The sys_created_by column for the table cmn_notif_service_provider.

sys_class_name String False  

The sys_class_name column for the table cmn_notif_service_provider.

sys_mod_count String False  

The sys_mod_count column for the table cmn_notif_service_provider.

sys_update_name String False  

The sys_update_name column for the table cmn_notif_service_provider.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_other_schedule

The ServiceNow table cmn_other_schedule.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
sys_created_by String False  

The sys_created_by column for the table cmn_other_schedule.

sys_updated_by String False  

The sys_updated_by column for the table cmn_other_schedule.

type String False  

The type column for the table cmn_other_schedule.

child_schedule String False  

The child_schedule column for the table cmn_other_schedule.

sys_mod_count String False  

The sys_mod_count column for the table cmn_other_schedule.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_other_schedule.

sys_id [KEY] String False  

The sys_id column for the table cmn_other_schedule.

time_zone String False  

The time_zone column for the table cmn_other_schedule.

schedule String False  

The schedule column for the table cmn_other_schedule.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_other_schedule.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_relative_duration

The ServiceNow table cmn_relative_duration.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
name String False  

The name column for the table cmn_relative_duration.

active String False  

The active column for the table cmn_relative_duration.

sys_id [KEY] String False  

The sys_id column for the table cmn_relative_duration.

script String False  

The script column for the table cmn_relative_duration.

sys_policy String False  

The sys_policy column for the table cmn_relative_duration.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table cmn_relative_duration.

sys_customer_update String False  

The sys_customer_update column for the table cmn_relative_duration.

sys_scope String False  

The sys_scope column for the table cmn_relative_duration.

sys_package String False  

The sys_package column for the table cmn_relative_duration.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_relative_duration.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_relative_duration.

sys_name String False  

The sys_name column for the table cmn_relative_duration.

sys_updated_by String False  

The sys_updated_by column for the table cmn_relative_duration.

sys_created_by String False  

The sys_created_by column for the table cmn_relative_duration.

sys_class_name String False  

The sys_class_name column for the table cmn_relative_duration.

sys_mod_count String False  

The sys_mod_count column for the table cmn_relative_duration.

sys_update_name String False  

The sys_update_name column for the table cmn_relative_duration.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_schedule

The ServiceNow table cmn_schedule.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
parent String False  

The parent column for the table cmn_schedule.

document_key String False  

The document_key column for the table cmn_schedule.

type String False  

The type column for the table cmn_schedule.

description String False  

The description column for the table cmn_schedule.

read_only String False  

The read_only column for the table cmn_schedule.

sys_id [KEY] String False  

The sys_id column for the table cmn_schedule.

document String False  

The document column for the table cmn_schedule.

time_zone String False  

The time_zone column for the table cmn_schedule.

name String False  

The name column for the table cmn_schedule.

sys_policy String False  

The sys_policy column for the table cmn_schedule.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table cmn_schedule.

sys_customer_update String False  

The sys_customer_update column for the table cmn_schedule.

sys_scope String False  

The sys_scope column for the table cmn_schedule.

sys_package String False  

The sys_package column for the table cmn_schedule.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_schedule.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_schedule.

sys_name String False  

The sys_name column for the table cmn_schedule.

sys_updated_by String False  

The sys_updated_by column for the table cmn_schedule.

sys_created_by String False  

The sys_created_by column for the table cmn_schedule.

sys_class_name String False  

The sys_class_name column for the table cmn_schedule.

sys_mod_count String False  

The sys_mod_count column for the table cmn_schedule.

sys_update_name String False  

The sys_update_name column for the table cmn_schedule.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_schedule_blackout

The ServiceNow table cmn_schedule_blackout.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
sys_id [KEY] String False  

The sys_id column for the table cmn_schedule_blackout.

condition String False  

The condition column for the table cmn_schedule_blackout.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_schedule_condition

The ServiceNow table cmn_schedule_condition.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
parent String False  

The parent column for the table cmn_schedule_condition.

document_key String False  

The document_key column for the table cmn_schedule_condition.

type String False  

The type column for the table cmn_schedule_condition.

description String False  

The description column for the table cmn_schedule_condition.

read_only String False  

The read_only column for the table cmn_schedule_condition.

document String False  

The document column for the table cmn_schedule_condition.

time_zone String False  

The time_zone column for the table cmn_schedule_condition.

name String False  

The name column for the table cmn_schedule_condition.

sys_id [KEY] String False  

The sys_id column for the table cmn_schedule_condition.

condition String False  

The condition column for the table cmn_schedule_condition.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_schedule_maintenance

The ServiceNow table cmn_schedule_maintenance.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
condition String False  

The condition column for the table cmn_schedule_maintenance.

sys_id [KEY] String False  

The sys_id column for the table cmn_schedule_maintenance.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_schedule_page

The ServiceNow table cmn_schedule_page.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
init_function String False  

The init_function column for the table cmn_schedule_page.

client_script String False  

The client_script column for the table cmn_schedule_page.

description String False  

The description column for the table cmn_schedule_page.

name String False  

The name column for the table cmn_schedule_page.

sys_id [KEY] String False  

The sys_id column for the table cmn_schedule_page.

header_html String False  

The header_html column for the table cmn_schedule_page.

view_type String False  

The view_type column for the table cmn_schedule_page.

type String False  

The type column for the table cmn_schedule_page.

server_script String False  

The server_script column for the table cmn_schedule_page.

sys_policy String False  

The sys_policy column for the table cmn_schedule_page.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table cmn_schedule_page.

sys_customer_update String False  

The sys_customer_update column for the table cmn_schedule_page.

sys_scope String False  

The sys_scope column for the table cmn_schedule_page.

sys_package String False  

The sys_package column for the table cmn_schedule_page.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_schedule_page.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_schedule_page.

sys_name String False  

The sys_name column for the table cmn_schedule_page.

sys_updated_by String False  

The sys_updated_by column for the table cmn_schedule_page.

sys_created_by String False  

The sys_created_by column for the table cmn_schedule_page.

sys_class_name String False  

The sys_class_name column for the table cmn_schedule_page.

sys_mod_count String False  

The sys_mod_count column for the table cmn_schedule_page.

sys_update_name String False  

The sys_update_name column for the table cmn_schedule_page.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_schedule_span

The ServiceNow table cmn_schedule_span.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
start_date_time String False  

The start_date_time column for the table cmn_schedule_span.

yearly_type String False  

The yearly_type column for the table cmn_schedule_span.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_schedule_span.

show_as String False  

The show_as column for the table cmn_schedule_span.

days_of_week String False  

The days_of_week column for the table cmn_schedule_span.

sys_id [KEY] String False  

The sys_id column for the table cmn_schedule_span.

notes String False  

The notes column for the table cmn_schedule_span.

repeat_type String False  

The repeat_type column for the table cmn_schedule_span.

parent String False  

The parent column for the table cmn_schedule_span.

schedule String False  

The schedule column for the table cmn_schedule_span.

all_day String False  

The all_day column for the table cmn_schedule_span.

float_week String False  

The float_week column for the table cmn_schedule_span.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_schedule_span.

type String False  

The type column for the table cmn_schedule_span.

monthly_type String False  

The monthly_type column for the table cmn_schedule_span.

sys_updated_by String False  

The sys_updated_by column for the table cmn_schedule_span.

sys_class_name String False  

The sys_class_name column for the table cmn_schedule_span.

repeat_count String False  

The repeat_count column for the table cmn_schedule_span.

override_start_date String False  

The override_start_date column for the table cmn_schedule_span.

name String False  

The name column for the table cmn_schedule_span.

repeat_until String False  

The repeat_until column for the table cmn_schedule_span.

float_day String False  

The float_day column for the table cmn_schedule_span.

sys_mod_count String False  

The sys_mod_count column for the table cmn_schedule_span.

end_date_time String False  

The end_date_time column for the table cmn_schedule_span.

month String False  

The month column for the table cmn_schedule_span.

sys_created_by String False  

The sys_created_by column for the table cmn_schedule_span.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_timeline_page

The ServiceNow table cmn_timeline_page.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
show_span_text String False  

The show_span_text column for the table cmn_timeline_page.

allow_dragging String False  

The allow_dragging column for the table cmn_timeline_page.

name String False  

The name column for the table cmn_timeline_page.

auto_refresh String False  

The auto_refresh column for the table cmn_timeline_page.

perform_custom_sort String False  

The perform_custom_sort column for the table cmn_timeline_page.

show_summary_pane String False  

The show_summary_pane column for the table cmn_timeline_page.

condition String False  

The condition column for the table cmn_timeline_page.

sys_id [KEY] String False  

The sys_id column for the table cmn_timeline_page.

end_date_field String False  

The end_date_field column for the table cmn_timeline_page.

show_tooltips String False  

The show_tooltips column for the table cmn_timeline_page.

allow_drag_right String False  

The allow_drag_right column for the table cmn_timeline_page.

suffix String False  

The suffix column for the table cmn_timeline_page.

css_span_color String False  

The css_span_color column for the table cmn_timeline_page.

sort_by_order String False  

The sort_by_order column for the table cmn_timeline_page.

show_left_pane String False  

The show_left_pane column for the table cmn_timeline_page.

sort_by String False  

The sort_by column for the table cmn_timeline_page.

show_grid_lines String False  

The show_grid_lines column for the table cmn_timeline_page.

tooltip_label String False  

The tooltip_label column for the table cmn_timeline_page.

range_calculator String False  

The range_calculator column for the table cmn_timeline_page.

start_date_field String False  

The start_date_field column for the table cmn_timeline_page.

labels String False  

The labels column for the table cmn_timeline_page.

allow_drag_left String False  

The allow_drag_left column for the table cmn_timeline_page.

sys_policy String False  

The sys_policy column for the table cmn_timeline_page.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table cmn_timeline_page.

sys_customer_update String False  

The sys_customer_update column for the table cmn_timeline_page.

sys_scope String False  

The sys_scope column for the table cmn_timeline_page.

sys_package String False  

The sys_package column for the table cmn_timeline_page.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_timeline_page.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_timeline_page.

sys_name String False  

The sys_name column for the table cmn_timeline_page.

sys_updated_by String False  

The sys_updated_by column for the table cmn_timeline_page.

sys_created_by String False  

The sys_created_by column for the table cmn_timeline_page.

sys_class_name String False  

The sys_class_name column for the table cmn_timeline_page.

sys_mod_count String False  

The sys_mod_count column for the table cmn_timeline_page.

sys_update_name String False  

The sys_update_name column for the table cmn_timeline_page.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_timeline_page_style

The ServiceNow table cmn_timeline_page_style.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
label_color String False  

The label_color column for the table cmn_timeline_page_style.

condition String False  

The condition column for the table cmn_timeline_page_style.

order String False  

The order column for the table cmn_timeline_page_style.

span_color String False  

The span_color column for the table cmn_timeline_page_style.

timeline_page String False  

The timeline_page column for the table cmn_timeline_page_style.

sys_id [KEY] String False  

The sys_id column for the table cmn_timeline_page_style.

label_decoration String False  

The label_decoration column for the table cmn_timeline_page_style.

sys_policy String False  

The sys_policy column for the table cmn_timeline_page_style.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table cmn_timeline_page_style.

sys_customer_update String False  

The sys_customer_update column for the table cmn_timeline_page_style.

sys_scope String False  

The sys_scope column for the table cmn_timeline_page_style.

sys_package String False  

The sys_package column for the table cmn_timeline_page_style.

sys_updated_on Datetime False  

The sys_updated_on column for the table cmn_timeline_page_style.

sys_created_on Datetime False  

The sys_created_on column for the table cmn_timeline_page_style.

sys_name String False  

The sys_name column for the table cmn_timeline_page_style.

sys_updated_by String False  

The sys_updated_by column for the table cmn_timeline_page_style.

sys_created_by String False  

The sys_created_by column for the table cmn_timeline_page_style.

sys_class_name String False  

The sys_class_name column for the table cmn_timeline_page_style.

sys_mod_count String False  

The sys_mod_count column for the table cmn_timeline_page_style.

sys_update_name String False  

The sys_update_name column for the table cmn_timeline_page_style.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

cmn_timeline_sub_item

The ServiceNow table cmn_timeline_sub_item.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
show_span_text String False  

The show_span_text column for the table cmn_timeline_sub_item.

allow_dragging String False  

The allow_dragging column for the table cmn_timeline_sub_item.

name String False  

The name column for the table cmn_timeline_sub_item.

auto_refresh String False  

The auto_refresh column for the table cmn_timeline_sub_item.

perform_custom_sort String False  

The perform_custom_sort column for the table cmn_timeline_sub_item.

show_summary_pane String False  

The show_summary_pane column for the table cmn_timeline_sub_item.

condition String False  

The condition column for the table cmn_timeline_sub_item.

end_date_field String False  

The end_date_field column for the table cmn_timeline_sub_item.

show_tooltips String False  

The show_tooltips column for the table cmn_timeline_sub_item.

allow_drag_right String False  

The allow_drag_right column for the table cmn_timeline_sub_item.

suffix String False  

The suffix column for the table cmn_timeline_sub_item.

css_span_color String False  

The css_span_color column for the table cmn_timeline_sub_item.

sort_by_order String False  

The sort_by_order column for the table cmn_timeline_sub_item.

show_left_pane String False  

The show_left_pane column for the table cmn_timeline_sub_item.

sort_by String False  

The sort_by column for the table cmn_timeline_sub_item.

show_grid_lines String False  

The show_grid_lines column for the table cmn_timeline_sub_item.

tooltip_label String False  

The tooltip_label column for the table cmn_timeline_sub_item.

range_calculator String False  

The range_calculator column for the table cmn_timeline_sub_item.

start_date_field String False  

The start_date_field column for the table cmn_timeline_sub_item.

labels String False  

The labels column for the table cmn_timeline_sub_item.

allow_drag_left String False  

The allow_drag_left column for the table cmn_timeline_sub_item.

parent String False  

The parent column for the table cmn_timeline_sub_item.

restriction String False  

The restriction column for the table cmn_timeline_sub_item.

sys_id [KEY] String False  

The sys_id column for the table cmn_timeline_sub_item.

parent_col String False  

The parent_col column for the table cmn_timeline_sub_item.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

diagrammer_action

The ServiceNow table diagrammer_action.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
name String False  

The name column for the table diagrammer_action.

active String False  

The active column for the table diagrammer_action.

script String False  

The script column for the table diagrammer_action.

icon String False  

The icon column for the table diagrammer_action.

sys_id [KEY] String False  

The sys_id column for the table diagrammer_action.

order String False  

The order column for the table diagrammer_action.

condition String False  

The condition column for the table diagrammer_action.

type String False  

The type column for the table diagrammer_action.

sys_policy String False  

The sys_policy column for the table diagrammer_action.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table diagrammer_action.

sys_customer_update String False  

The sys_customer_update column for the table diagrammer_action.

sys_scope String False  

The sys_scope column for the table diagrammer_action.

sys_package String False  

The sys_package column for the table diagrammer_action.

sys_updated_on Datetime False  

The sys_updated_on column for the table diagrammer_action.

sys_created_on Datetime False  

The sys_created_on column for the table diagrammer_action.

sys_name String False  

The sys_name column for the table diagrammer_action.

sys_updated_by String False  

The sys_updated_by column for the table diagrammer_action.

sys_created_by String False  

The sys_created_by column for the table diagrammer_action.

sys_class_name String False  

The sys_class_name column for the table diagrammer_action.

sys_mod_count String False  

The sys_mod_count column for the table diagrammer_action.

sys_update_name String False  

The sys_update_name column for the table diagrammer_action.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

expert_panel

The ServiceNow table expert_panel.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
description String False  

The description column for the table expert_panel.

expert String False  

The expert column for the table expert_panel.

name String False  

The name column for the table expert_panel.

order String False  

The order column for the table expert_panel.

previous_message String False  

The previous_message column for the table expert_panel.

title String False  

The title column for the table expert_panel.

banner_step String False  

The banner_step column for the table expert_panel.

sys_id [KEY] String False  

The sys_id column for the table expert_panel.

complete_message String False  

The complete_message column for the table expert_panel.

next_message String False  

The next_message column for the table expert_panel.

sys_policy String False  

The sys_policy column for the table expert_panel.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table expert_panel.

sys_customer_update String False  

The sys_customer_update column for the table expert_panel.

sys_scope String False  

The sys_scope column for the table expert_panel.

sys_package String False  

The sys_package column for the table expert_panel.

sys_updated_on Datetime False  

The sys_updated_on column for the table expert_panel.

sys_created_on Datetime False  

The sys_created_on column for the table expert_panel.

sys_name String False  

The sys_name column for the table expert_panel.

sys_updated_by String False  

The sys_updated_by column for the table expert_panel.

sys_created_by String False  

The sys_created_by column for the table expert_panel.

sys_class_name String False  

The sys_class_name column for the table expert_panel.

sys_mod_count String False  

The sys_mod_count column for the table expert_panel.

sys_update_name String False  

The sys_update_name column for the table expert_panel.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

item_option_new

The ServiceNow table item_option_new.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
cat_item String False  

The cat_item column for the table item_option_new.

description String False  

The description column for the table item_option_new.

category String False  

The category column for the table item_option_new.

visible_bundle String False  

The visible_bundle column for the table item_option_new.

visible_guide String False  

The visible_guide column for the table item_option_new.

global String False  

The global column for the table item_option_new.

variable_set String False  

The variable_set column for the table item_option_new.

delivery_plan String False  

The delivery_plan column for the table item_option_new.

visibility String False  

The visibility column for the table item_option_new.

visible_standalone String False  

The visible_standalone column for the table item_option_new.

visible_summary String False  

The visible_summary column for the table item_option_new.

sys_id [KEY] String False  

The sys_id column for the table item_option_new.

dynamic_ref_qual String False  

The dynamic_ref_qual column for the table item_option_new.

dynamic_default_value String False  

The dynamic_default_value column for the table item_option_new.

use_reference_qualifier String False  

The use_reference_qualifier column for the table item_option_new.

pricing_implications String False  

The pricing_implications column for the table item_option_new.

variable_name String False  

The variable_name column for the table item_option_new.

lookup_label String False  

The lookup_label column for the table item_option_new.

mandatory String False  

The mandatory column for the table item_option_new.

mask_use_encryption String False  

The mask_use_encryption column for the table item_option_new.

default_html_value String False  

The default_html_value column for the table item_option_new.

choice_direction String False  

The choice_direction column for the table item_option_new.

lookup_price String False  

The lookup_price column for the table item_option_new.

use_dynamic_default String False  

The use_dynamic_default column for the table item_option_new.

layout String False  

The layout column for the table item_option_new.

mask_use_confirmation String False  

The mask_use_confirmation column for the table item_option_new.

ui_page String False  

The ui_page column for the table item_option_new.

active String False  

The active column for the table item_option_new.

field String False  

The field column for the table item_option_new.

lookup_value String False  

The lookup_value column for the table item_option_new.

help_text String False  

The help_text column for the table item_option_new.

record_producer_table String False  

The record_producer_table column for the table item_option_new.

price_if_checked String False  

The price_if_checked column for the table item_option_new.

scale_min String False  

The scale_min column for the table item_option_new.

reference_qual String False  

The reference_qual column for the table item_option_new.

show_help String False  

The show_help column for the table item_option_new.

delete_roles String False  

The delete_roles column for the table item_option_new.

map_to_field String False  

The map_to_field column for the table item_option_new.

name String False  

The name column for the table item_option_new.

rec_price_if_checked String False  

The rec_price_if_checked column for the table item_option_new.

macro String False  

The macro column for the table item_option_new.

reference_qual_condition String False  

The reference_qual_condition column for the table item_option_new.

attributes String False  

The attributes column for the table item_option_new.

question_text String False  

The question_text column for the table item_option_new.

scale_max String False  

The scale_max column for the table item_option_new.

choice_field String False  

The choice_field column for the table item_option_new.

display_title String False  

The display_title column for the table item_option_new.

read_roles String False  

The read_roles column for the table item_option_new.

create_roles String False  

The create_roles column for the table item_option_new.

tooltip String False  

The tooltip column for the table item_option_new.

record String False  

The record column for the table item_option_new.

type String False  

The type column for the table item_option_new.

default_value String False  

The default_value column for the table item_option_new.

order String False  

The order column for the table item_option_new.

rec_lookup_price String False  

The rec_lookup_price column for the table item_option_new.

include_none String False  

The include_none column for the table item_option_new.

lookup_unique String False  

The lookup_unique column for the table item_option_new.

write_roles String False  

The write_roles column for the table item_option_new.

help_tag String False  

The help_tag column for the table item_option_new.

do_not_select_first String False  

The do_not_select_first column for the table item_option_new.

summary_macro String False  

The summary_macro column for the table item_option_new.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

question

The ServiceNow table question.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
dynamic_ref_qual String False  

The dynamic_ref_qual column for the table question.

dynamic_default_value String False  

The dynamic_default_value column for the table question.

sys_id [KEY] String False  

The sys_id column for the table question.

use_reference_qualifier String False  

The use_reference_qualifier column for the table question.

pricing_implications String False  

The pricing_implications column for the table question.

variable_name String False  

The variable_name column for the table question.

lookup_label String False  

The lookup_label column for the table question.

mandatory String False  

The mandatory column for the table question.

mask_use_encryption String False  

The mask_use_encryption column for the table question.

default_html_value String False  

The default_html_value column for the table question.

choice_direction String False  

The choice_direction column for the table question.

lookup_price String False  

The lookup_price column for the table question.

use_dynamic_default String False  

The use_dynamic_default column for the table question.

layout String False  

The layout column for the table question.

mask_use_confirmation String False  

The mask_use_confirmation column for the table question.

ui_page String False  

The ui_page column for the table question.

active String False  

The active column for the table question.

field String False  

The field column for the table question.

lookup_value String False  

The lookup_value column for the table question.

help_text String False  

The help_text column for the table question.

record_producer_table String False  

The record_producer_table column for the table question.

price_if_checked String False  

The price_if_checked column for the table question.

scale_min String False  

The scale_min column for the table question.

reference_qual String False  

The reference_qual column for the table question.

show_help String False  

The show_help column for the table question.

delete_roles String False  

The delete_roles column for the table question.

map_to_field String False  

The map_to_field column for the table question.

name String False  

The name column for the table question.

rec_price_if_checked String False  

The rec_price_if_checked column for the table question.

macro String False  

The macro column for the table question.

reference_qual_condition String False  

The reference_qual_condition column for the table question.

attributes String False  

The attributes column for the table question.

question_text String False  

The question_text column for the table question.

scale_max String False  

The scale_max column for the table question.

choice_field String False  

The choice_field column for the table question.

display_title String False  

The display_title column for the table question.

read_roles String False  

The read_roles column for the table question.

create_roles String False  

The create_roles column for the table question.

tooltip String False  

The tooltip column for the table question.

record String False  

The record column for the table question.

type String False  

The type column for the table question.

default_value String False  

The default_value column for the table question.

order String False  

The order column for the table question.

rec_lookup_price String False  

The rec_lookup_price column for the table question.

include_none String False  

The include_none column for the table question.

lookup_unique String False  

The lookup_unique column for the table question.

write_roles String False  

The write_roles column for the table question.

help_tag String False  

The help_tag column for the table question.

do_not_select_first String False  

The do_not_select_first column for the table question.

summary_macro String False  

The summary_macro column for the table question.

sys_policy String False  

The sys_policy column for the table question.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table question.

sys_customer_update String False  

The sys_customer_update column for the table question.

sys_scope String False  

The sys_scope column for the table question.

sys_package String False  

The sys_package column for the table question.

sys_updated_on Datetime False  

The sys_updated_on column for the table question.

sys_created_on Datetime False  

The sys_created_on column for the table question.

sys_name String False  

The sys_name column for the table question.

sys_updated_by String False  

The sys_updated_by column for the table question.

sys_created_by String False  

The sys_created_by column for the table question.

sys_class_name String False  

The sys_class_name column for the table question.

sys_mod_count String False  

The sys_mod_count column for the table question.

sys_update_name String False  

The sys_update_name column for the table question.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

sc_category

The ServiceNow table sc_category.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
show_in_cms String False  

The show_in_cms column for the table sc_category.

header_icon String False  

The header_icon column for the table sc_category.

module String False  

The module column for the table sc_category.

roles String False  

The roles column for the table sc_category.

mobile_subcategory_render_type String False  

The mobile_subcategory_render_type column for the table sc_category.

mobile_picture String False  

The mobile_picture column for the table sc_category.

order String False  

The order column for the table sc_category.

description String False  

The description column for the table sc_category.

image String False  

The image column for the table sc_category.

parent String False  

The parent column for the table sc_category.

icon String False  

The icon column for the table sc_category.

homepage_renderer String False  

The homepage_renderer column for the table sc_category.

active String False  

The active column for the table sc_category.

mobile_hide_description String False  

The mobile_hide_description column for the table sc_category.

homepage_image String False  

The homepage_image column for the table sc_category.

entitlement_script String False  

The entitlement_script column for the table sc_category.

sys_id [KEY] String False  

The sys_id column for the table sc_category.

title String False  

The title column for the table sc_category.

sc_catalog String False  

The sc_catalog column for the table sc_category.

location String False  

The location column for the table sc_category.

sys_policy String False  

The sys_policy column for the table sc_category.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table sc_category.

sys_customer_update String False  

The sys_customer_update column for the table sc_category.

sys_scope String False  

The sys_scope column for the table sc_category.

sys_package String False  

The sys_package column for the table sc_category.

sys_updated_on Datetime False  

The sys_updated_on column for the table sc_category.

sys_created_on Datetime False  

The sys_created_on column for the table sc_category.

sys_name String False  

The sys_name column for the table sc_category.

sys_updated_by String False  

The sys_updated_by column for the table sc_category.

sys_created_by String False  

The sys_created_by column for the table sc_category.

sys_class_name String False  

The sys_class_name column for the table sc_category.

sys_mod_count String False  

The sys_mod_count column for the table sc_category.

sys_update_name String False  

The sys_update_name column for the table sc_category.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

sc_cat_item

The ServiceNow table sc_cat_item.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
category String False  

The category column for the table sc_cat_item.

model String False  

The model column for the table sc_cat_item.

mobile_picture_type String False  

The mobile_picture_type column for the table sc_cat_item.

no_search String False  

The no_search column for the table sc_cat_item.

billable String False  

The billable column for the table sc_cat_item.

group String False  

The group column for the table sc_cat_item.

picture String False  

The picture column for the table sc_cat_item.

no_order_now String False  

The no_order_now column for the table sc_cat_item.

price String False  

The price column for the table sc_cat_item.

meta String False  

The meta column for the table sc_cat_item.

roles String False  

The roles column for the table sc_cat_item.

start_closed String False  

The start_closed column for the table sc_cat_item.

short_description String False  

The short_description column for the table sc_cat_item.

template String False  

The template column for the table sc_cat_item.

icon String False  

The icon column for the table sc_cat_item.

use_sc_layout String False  

The use_sc_layout column for the table sc_cat_item.

omit_price String False  

The omit_price column for the table sc_cat_item.

vendor String False  

The vendor column for the table sc_cat_item.

list_price String False  

The list_price column for the table sc_cat_item.

visible_standalone String False  

The visible_standalone column for the table sc_cat_item.

recurring_frequency String False  

The recurring_frequency column for the table sc_cat_item.

entitlement_script String False  

The entitlement_script column for the table sc_cat_item.

cost String False  

The cost column for the table sc_cat_item.

workflow String False  

The workflow column for the table sc_cat_item.

custom_cart String False  

The custom_cart column for the table sc_cat_item.

sc_ic_item_staging String False  

The sc_ic_item_staging column for the table sc_cat_item.

image String False  

The image column for the table sc_cat_item.

delivery_time Datetime False  

The delivery_time column for the table sc_cat_item.

mobile_picture String False  

The mobile_picture column for the table sc_cat_item.

no_order String False  

The no_order column for the table sc_cat_item.

ignore_price String False  

The ignore_price column for the table sc_cat_item.

location String False  

The location column for the table sc_cat_item.

delivery_plan String False  

The delivery_plan column for the table sc_cat_item.

no_proceed_checkout String False  

The no_proceed_checkout column for the table sc_cat_item.

name String False  

The name column for the table sc_cat_item.

description String False  

The description column for the table sc_cat_item.

active String False  

The active column for the table sc_cat_item.

order String False  

The order column for the table sc_cat_item.

sc_catalogs String False  

The sc_catalogs column for the table sc_cat_item.

type String False  

The type column for the table sc_cat_item.

mobile_hide_price String False  

The mobile_hide_price column for the table sc_cat_item.

no_cart String False  

The no_cart column for the table sc_cat_item.

visible_guide String False  

The visible_guide column for the table sc_cat_item.

ordered_item_link String False  

The ordered_item_link column for the table sc_cat_item.

visible_bundle String False  

The visible_bundle column for the table sc_cat_item.

recurring_price String False  

The recurring_price column for the table sc_cat_item.

sys_id [KEY] String False  

The sys_id column for the table sc_cat_item.

delivery_plan_script String False  

The delivery_plan_script column for the table sc_cat_item.

preview String False  

The preview column for the table sc_cat_item.

sc_ic_version String False  

The sc_ic_version column for the table sc_cat_item.

no_quantity String False  

The no_quantity column for the table sc_cat_item.

availability String False  

The availability column for the table sc_cat_item.

sys_policy String False  

The sys_policy column for the table sc_cat_item.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table sc_cat_item.

sys_customer_update String False  

The sys_customer_update column for the table sc_cat_item.

sys_scope String False  

The sys_scope column for the table sc_cat_item.

sys_package String False  

The sys_package column for the table sc_cat_item.

sys_updated_on Datetime False  

The sys_updated_on column for the table sc_cat_item.

sys_created_on Datetime False  

The sys_created_on column for the table sc_cat_item.

sys_name String False  

The sys_name column for the table sc_cat_item.

sys_updated_by String False  

The sys_updated_by column for the table sc_cat_item.

sys_created_by String False  

The sys_created_by column for the table sc_cat_item.

sys_class_name String False  

The sys_class_name column for the table sc_cat_item.

sys_mod_count String False  

The sys_mod_count column for the table sc_cat_item.

sys_update_name String False  

The sys_update_name column for the table sc_cat_item.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

sla

The ServiceNow table sla.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
sys_mod_count String False  

The sys_mod_count column for the table sla.

sys_created_by String False  

The sys_created_by column for the table sla.

sys_updated_by String False  

The sys_updated_by column for the table sla.

ends Datetime False  

The ends column for the table sla.

department String False  

The department column for the table sla.

business_lead String False  

The business_lead column for the table sla.

change_procedures String False  

The change_procedures column for the table sla.

notes String False  

The notes column for the table sla.

contract String False  

The contract column for the table sla.

users String False  

The users column for the table sla.

service_goals String False  

The service_goals column for the table sla.

name String False  

The name column for the table sla.

transaction_load String False  

The transaction_load column for the table sla.

security_notes String False  

The security_notes column for the table sla.

consultant_user String False  

The consultant_user column for the table sla.

number String False  

The number column for the table sla.

avail_pct String False  

The avail_pct column for the table sla.

functional_area String False  

The functional_area column for the table sla.

accountable_user String False  

The accountable_user column for the table sla.

signatures String False  

The signatures column for the table sla.

sys_created_on Datetime False  

The sys_created_on column for the table sla.

sys_updated_on Datetime False  

The sys_updated_on column for the table sla.

begins Datetime False  

The begins column for the table sla.

short_description String False  

The short_description column for the table sla.

maintenance String False  

The maintenance column for the table sla.

reponsibilities String False  

The reponsibilities column for the table sla.

description String False  

The description column for the table sla.

calendar String False  

The calendar column for the table sla.

next_review Datetime False  

The next_review column for the table sla.

informed_user String False  

The informed_user column for the table sla.

sys_class_name String False  

The sys_class_name column for the table sla.

response_time String False  

The response_time column for the table sla.

disaster_recovery String False  

The disaster_recovery column for the table sla.

responsible_user String False  

The responsible_user column for the table sla.

sys_id [KEY] String False  

The sys_id column for the table sla.

active String False  

The active column for the table sla.

business_unit String False  

The business_unit column for the table sla.

technical_lead String False  

The technical_lead column for the table sla.

incident_procedures String False  

The incident_procedures column for the table sla.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

sysauto

The ServiceNow table sysauto.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
condition String False  

The condition column for the table sysauto.

run_start Datetime False  

The run_start column for the table sysauto.

active String False  

The active column for the table sysauto.

run_time Datetime False  

The run_time column for the table sysauto.

run_dayofweek String False  

The run_dayofweek column for the table sysauto.

run_as_tz String False  

The run_as_tz column for the table sysauto.

upgrade_safe String False  

The upgrade_safe column for the table sysauto.

conditional String False  

The conditional column for the table sysauto.

run_period Datetime False  

The run_period column for the table sysauto.

name String False  

The name column for the table sysauto.

run_dayofmonth String False  

The run_dayofmonth column for the table sysauto.

run_type String False  

The run_type column for the table sysauto.

run_as String False  

The run_as column for the table sysauto.

sys_id [KEY] String False  

The sys_id column for the table sysauto.

sys_policy String False  

The sys_policy column for the table sysauto.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table sysauto.

sys_customer_update String False  

The sys_customer_update column for the table sysauto.

sys_scope String False  

The sys_scope column for the table sysauto.

sys_package String False  

The sys_package column for the table sysauto.

sys_updated_on Datetime False  

The sys_updated_on column for the table sysauto.

sys_created_on Datetime False  

The sys_created_on column for the table sysauto.

sys_name String False  

The sys_name column for the table sysauto.

sys_updated_by String False  

The sys_updated_by column for the table sysauto.

sys_created_by String False  

The sys_created_by column for the table sysauto.

sys_class_name String False  

The sys_class_name column for the table sysauto.

sys_mod_count String False  

The sys_mod_count column for the table sysauto.

sys_update_name String False  

The sys_update_name column for the table sysauto.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

sysauto_script

The ServiceNow table sysauto_script.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
condition String False  

The condition column for the table sysauto_script.

run_start Datetime False  

The run_start column for the table sysauto_script.

active String False  

The active column for the table sysauto_script.

run_time Datetime False  

The run_time column for the table sysauto_script.

run_dayofweek String False  

The run_dayofweek column for the table sysauto_script.

run_as_tz String False  

The run_as_tz column for the table sysauto_script.

upgrade_safe String False  

The upgrade_safe column for the table sysauto_script.

conditional String False  

The conditional column for the table sysauto_script.

run_period Datetime False  

The run_period column for the table sysauto_script.

name String False  

The name column for the table sysauto_script.

run_dayofmonth String False  

The run_dayofmonth column for the table sysauto_script.

run_type String False  

The run_type column for the table sysauto_script.

run_as String False  

The run_as column for the table sysauto_script.

sys_id [KEY] String False  

The sys_id column for the table sysauto_script.

script String False  

The script column for the table sysauto_script.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

syslog

The ServiceNow table syslog.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
level String False  

The level column for the table syslog.

sys_class_name String False  

The sys_class_name column for the table syslog.

sys_id [KEY] String False  

The sys_id column for the table syslog.

source String False  

The source column for the table syslog.

sys_created_by String False  

The sys_created_by column for the table syslog.

sys_created_on Datetime False  

The sys_created_on column for the table syslog.

message String False  

The message column for the table syslog.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

sysrule

The ServiceNow table sysrule.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
sys_overrides String False  

The sys_overrides column for the table sysrule.

order String False  

The order column for the table sysrule.

name String False  

The name column for the table sysrule.

sys_id [KEY] String False  

The sys_id column for the table sysrule.

sys_domain_path String False  

The sys_domain_path column for the table sysrule.

sys_domain String False  

The sys_domain column for the table sysrule.

description String False  

The description column for the table sysrule.

sys_policy String False  

The sys_policy column for the table sysrule.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table sysrule.

sys_customer_update String False  

The sys_customer_update column for the table sysrule.

sys_scope String False  

The sys_scope column for the table sysrule.

sys_package String False  

The sys_package column for the table sysrule.

sys_updated_on Datetime False  

The sys_updated_on column for the table sysrule.

sys_created_on Datetime False  

The sys_created_on column for the table sysrule.

sys_name String False  

The sys_name column for the table sysrule.

sys_updated_by String False  

The sys_updated_by column for the table sysrule.

sys_created_by String False  

The sys_created_by column for the table sysrule.

sys_class_name String False  

The sys_class_name column for the table sysrule.

sys_mod_count String False  

The sys_mod_count column for the table sysrule.

sys_update_name String False  

The sys_update_name column for the table sysrule.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

system_db_object

The ServiceNow table system_db_object.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
is_extendable String False  

The is_extendable column for the table system_db_object.

client_scripts_access String False  

The client_scripts_access column for the table system_db_object.

delete_access String False  

The delete_access column for the table system_db_object.

live_feed_enabled String False  

The live_feed_enabled column for the table system_db_object.

actions_access String False  

The actions_access column for the table system_db_object.

update_access String False  

The update_access column for the table system_db_object.

number_ref String False  

The number_ref column for the table system_db_object.

provider_class String False  

The provider_class column for the table system_db_object.

sys_id [KEY] String False  

The sys_id column for the table system_db_object.

create_access String False  

The create_access column for the table system_db_object.

label String False  

The label column for the table system_db_object.

super_class String False  

The super_class column for the table system_db_object.

access String False  

The access column for the table system_db_object.

alter_access String False  

The alter_access column for the table system_db_object.

user_role String False  

The user_role column for the table system_db_object.

create_access_controls String False  

The create_access_controls column for the table system_db_object.

extension_model String False  

The extension_model column for the table system_db_object.

name String False  

The name column for the table system_db_object.

configuration_access String False  

The configuration_access column for the table system_db_object.

ws_access String False  

The ws_access column for the table system_db_object.

read_access String False  

The read_access column for the table system_db_object.

sys_policy String False  

The sys_policy column for the table system_db_object.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table system_db_object.

sys_customer_update String False  

The sys_customer_update column for the table system_db_object.

sys_scope String False  

The sys_scope column for the table system_db_object.

sys_package String False  

The sys_package column for the table system_db_object.

sys_updated_on Datetime False  

The sys_updated_on column for the table system_db_object.

sys_created_on Datetime False  

The sys_created_on column for the table system_db_object.

sys_name String False  

The sys_name column for the table system_db_object.

sys_updated_by String False  

The sys_updated_by column for the table system_db_object.

sys_created_by String False  

The sys_created_by column for the table system_db_object.

sys_class_name String False  

The sys_class_name column for the table system_db_object.

sys_mod_count String False  

The sys_mod_count column for the table system_db_object.

sys_update_name String False  

The sys_update_name column for the table system_db_object.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

system_dictionary

The ServiceNow table system_dictionary.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
create_roles String False  

The create_roles column for the table system_dictionary.

sizeclass String False  

The sizeclass column for the table system_dictionary.

array String False  

The array column for the table system_dictionary.

active String False  

The active column for the table system_dictionary.

foreign_database String False  

The foreign_database column for the table system_dictionary.

dependent_on_field String False  

The dependent_on_field column for the table system_dictionary.

reference_cascade_rule String False  

The reference_cascade_rule column for the table system_dictionary.

reference String False  

The reference column for the table system_dictionary.

choice String False  

The choice column for the table system_dictionary.

default_value String False  

The default_value column for the table system_dictionary.

defaultsort String False  

The defaultsort column for the table system_dictionary.

sys_id [KEY] String False  

The sys_id column for the table system_dictionary.

attributes String False  

The attributes column for the table system_dictionary.

xml_view String False  

The xml_view column for the table system_dictionary.

delete_roles String False  

The delete_roles column for the table system_dictionary.

reference_qual String False  

The reference_qual column for the table system_dictionary.

reference_key String False  

The reference_key column for the table system_dictionary.

dynamic_creation_script String False  

The dynamic_creation_script column for the table system_dictionary.

max_length String False  

The max_length column for the table system_dictionary.

column_label String False  

The column_label column for the table system_dictionary.

read_only String False  

The read_only column for the table system_dictionary.

dependent String False  

The dependent column for the table system_dictionary.

unique String False  

The unique column for the table system_dictionary.

spell_check String False  

The spell_check column for the table system_dictionary.

write_roles String False  

The write_roles column for the table system_dictionary.

audit String False  

The audit column for the table system_dictionary.

staged String False  

The staged column for the table system_dictionary.

dynamic_ref_qual String False  

The dynamic_ref_qual column for the table system_dictionary.

use_dynamic_default String False  

The use_dynamic_default column for the table system_dictionary.

dynamic_default_value String False  

The dynamic_default_value column for the table system_dictionary.

use_dependent_field String False  

The use_dependent_field column for the table system_dictionary.

use_reference_qualifier String False  

The use_reference_qualifier column for the table system_dictionary.

reference_qual_condition String False  

The reference_qual_condition column for the table system_dictionary.

choice_field String False  

The choice_field column for the table system_dictionary.

dynamic_creation String False  

The dynamic_creation column for the table system_dictionary.

calculation String False  

The calculation column for the table system_dictionary.

next_element String False  

The next_element column for the table system_dictionary.

display String False  

The display column for the table system_dictionary.

reference_floats String False  

The reference_floats column for the table system_dictionary.

element_reference String False  

The element_reference column for the table system_dictionary.

mandatory String False  

The mandatory column for the table system_dictionary.

read_roles String False  

The read_roles column for the table system_dictionary.

text_index String False  

The text_index column for the table system_dictionary.

comments String False  

The comments column for the table system_dictionary.

primary String False  

The primary column for the table system_dictionary.

element String False  

The element column for the table system_dictionary.

widget String False  

The widget column for the table system_dictionary.

reference_type String False  

The reference_type column for the table system_dictionary.

table_reference String False  

The table_reference column for the table system_dictionary.

internal_type String False  

The internal_type column for the table system_dictionary.

virtual String False  

The virtual column for the table system_dictionary.

sys_policy String False  

The sys_policy column for the table system_dictionary.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table system_dictionary.

sys_customer_update String False  

The sys_customer_update column for the table system_dictionary.

sys_scope String False  

The sys_scope column for the table system_dictionary.

sys_package String False  

The sys_package column for the table system_dictionary.

sys_updated_on Datetime False  

The sys_updated_on column for the table system_dictionary.

sys_created_on Datetime False  

The sys_created_on column for the table system_dictionary.

sys_name String False  

The sys_name column for the table system_dictionary.

sys_updated_by String False  

The sys_updated_by column for the table system_dictionary.

sys_created_by String False  

The sys_created_by column for the table system_dictionary.

sys_class_name String False  

The sys_class_name column for the table system_dictionary.

sys_mod_count String False  

The sys_mod_count column for the table system_dictionary.

sys_update_name String False  

The sys_update_name column for the table system_dictionary.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

system_documentation

The ServiceNow table system_documentation.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
label String False  

The label column for the table system_documentation.

url String False  

The url column for the table system_documentation.

help String False  

The help column for the table system_documentation.

language String False  

The language column for the table system_documentation.

sys_id [KEY] String False  

The sys_id column for the table system_documentation.

hint String False  

The hint column for the table system_documentation.

element String False  

The element column for the table system_documentation.

plural String False  

The plural column for the table system_documentation.

url_target String False  

The url_target column for the table system_documentation.

sys_policy String False  

The sys_policy column for the table system_documentation.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table system_documentation.

sys_customer_update String False  

The sys_customer_update column for the table system_documentation.

sys_scope String False  

The sys_scope column for the table system_documentation.

sys_package String False  

The sys_package column for the table system_documentation.

sys_updated_on Datetime False  

The sys_updated_on column for the table system_documentation.

sys_created_on Datetime False  

The sys_created_on column for the table system_documentation.

sys_name String False  

The sys_name column for the table system_documentation.

sys_updated_by String False  

The sys_updated_by column for the table system_documentation.

sys_created_by String False  

The sys_created_by column for the table system_documentation.

sys_class_name String False  

The sys_class_name column for the table system_documentation.

sys_mod_count String False  

The sys_mod_count column for the table system_documentation.

sys_update_name String False  

The sys_update_name column for the table system_documentation.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

system_import_set_row

The ServiceNow table system_import_set_row.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
sys_import_state String False  

The sys_import_state column for the table system_import_set_row.

sys_id [KEY] String False  

The sys_id column for the table system_import_set_row.

sys_import_set String False  

The sys_import_set column for the table system_import_set_row.

template_import_log String False  

The template_import_log column for the table system_import_set_row.

sys_row_error String False  

The sys_row_error column for the table system_import_set_row.

sys_created_on Datetime False  

The sys_created_on column for the table system_import_set_row.

sys_updated_on Datetime False  

The sys_updated_on column for the table system_import_set_row.

sys_import_row String False  

The sys_import_row column for the table system_import_set_row.

import_set_run String False  

The import_set_run column for the table system_import_set_row.

sys_class_name String False  

The sys_class_name column for the table system_import_set_row.

sys_transform_map String False  

The sys_transform_map column for the table system_import_set_row.

sys_mod_count String False  

The sys_mod_count column for the table system_import_set_row.

sys_target_sys_id String False  

The sys_target_sys_id column for the table system_import_set_row.

sys_created_by String False  

The sys_created_by column for the table system_import_set_row.

sys_import_state_comment String False  

The sys_import_state_comment column for the table system_import_set_row.

sys_updated_by String False  

The sys_updated_by column for the table system_import_set_row.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

system_script_client

The ServiceNow table system_script_client.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
sys_policy String False  

The sys_policy column for the table system_script_client.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table system_script_client.

sys_customer_update String False  

The sys_customer_update column for the table system_script_client.

sys_scope String False  

The sys_scope column for the table system_script_client.

sys_package String False  

The sys_package column for the table system_script_client.

sys_updated_on Datetime False  

The sys_updated_on column for the table system_script_client.

sys_created_on Datetime False  

The sys_created_on column for the table system_script_client.

sys_name String False  

The sys_name column for the table system_script_client.

sys_updated_by String False  

The sys_updated_by column for the table system_script_client.

sys_created_by String False  

The sys_created_by column for the table system_script_client.

sys_class_name String False  

The sys_class_name column for the table system_script_client.

sys_mod_count String False  

The sys_mod_count column for the table system_script_client.

sys_update_name String False  

The sys_update_name column for the table system_script_client.

sys_domain String False  

The sys_domain column for the table system_script_client.

global String False  

The global column for the table system_script_client.

condition String False  

The condition column for the table system_script_client.

description String False  

The description column for the table system_script_client.

sys_overrides String False  

The sys_overrides column for the table system_script_client.

field String False  

The field column for the table system_script_client.

applies_extended String False  

The applies_extended column for the table system_script_client.

sys_domain_path String False  

The sys_domain_path column for the table system_script_client.

type String False  

The type column for the table system_script_client.

messages String False  

The messages column for the table system_script_client.

sys_id [KEY] String False  

The sys_id column for the table system_script_client.

active String False  

The active column for the table system_script_client.

view String False  

The view column for the table system_script_client.

order String False  

The order column for the table system_script_client.

script String False  

The script column for the table system_script_client.

name String False  

The name column for the table system_script_client.

ui_type String False  

The ui_type column for the table system_script_client.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

system_ui_policy

The ServiceNow table system_ui_policy.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
sys_policy String False  

The sys_policy column for the table system_ui_policy.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table system_ui_policy.

sys_customer_update String False  

The sys_customer_update column for the table system_ui_policy.

sys_scope String False  

The sys_scope column for the table system_ui_policy.

sys_package String False  

The sys_package column for the table system_ui_policy.

sys_updated_on Datetime False  

The sys_updated_on column for the table system_ui_policy.

sys_created_on Datetime False  

The sys_created_on column for the table system_ui_policy.

sys_name String False  

The sys_name column for the table system_ui_policy.

sys_updated_by String False  

The sys_updated_by column for the table system_ui_policy.

sys_created_by String False  

The sys_created_by column for the table system_ui_policy.

sys_class_name String False  

The sys_class_name column for the table system_ui_policy.

sys_mod_count String False  

The sys_mod_count column for the table system_ui_policy.

sys_update_name String False  

The sys_update_name column for the table system_ui_policy.

inherit String False  

The inherit column for the table system_ui_policy.

model_id String False  

The model_id column for the table system_ui_policy.

sys_id [KEY] String False  

The sys_id column for the table system_ui_policy.

reverse_if_false String False  

The reverse_if_false column for the table system_ui_policy.

script_false String False  

The script_false column for the table system_ui_policy.

set_values String False  

The set_values column for the table system_ui_policy.

active String False  

The active column for the table system_ui_policy.

short_description String False  

The short_description column for the table system_ui_policy.

run_scripts String False  

The run_scripts column for the table system_ui_policy.

sys_domain_path String False  

The sys_domain_path column for the table system_ui_policy.

ui_type String False  

The ui_type column for the table system_ui_policy.

order String False  

The order column for the table system_ui_policy.

sys_domain String False  

The sys_domain column for the table system_ui_policy.

description String False  

The description column for the table system_ui_policy.

view String False  

The view column for the table system_ui_policy.

conditions String False  

The conditions column for the table system_ui_policy.

on_load String False  

The on_load column for the table system_ui_policy.

script_true String False  

The script_true column for the table system_ui_policy.

sys_overrides String False  

The sys_overrides column for the table system_ui_policy.

global String False  

The global column for the table system_ui_policy.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

system_ui_policy_action

The ServiceNow table system_ui_policy_action.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
sys_policy String False  

The sys_policy column for the table system_ui_policy_action.

sys_replace_on_upgrade String False  

The sys_replace_on_upgrade column for the table system_ui_policy_action.

sys_customer_update String False  

The sys_customer_update column for the table system_ui_policy_action.

sys_scope String False  

The sys_scope column for the table system_ui_policy_action.

sys_package String False  

The sys_package column for the table system_ui_policy_action.

sys_updated_on Datetime False  

The sys_updated_on column for the table system_ui_policy_action.

sys_created_on Datetime False  

The sys_created_on column for the table system_ui_policy_action.

sys_name String False  

The sys_name column for the table system_ui_policy_action.

sys_updated_by String False  

The sys_updated_by column for the table system_ui_policy_action.

sys_created_by String False  

The sys_created_by column for the table system_ui_policy_action.

sys_class_name String False  

The sys_class_name column for the table system_ui_policy_action.

sys_mod_count String False  

The sys_mod_count column for the table system_ui_policy_action.

sys_update_name String False  

The sys_update_name column for the table system_ui_policy_action.

visible String False  

The visible column for the table system_ui_policy_action.

ui_policy String False  

The ui_policy column for the table system_ui_policy_action.

mandatory String False  

The mandatory column for the table system_ui_policy_action.

disabled String False  

The disabled column for the table system_ui_policy_action.

sys_id [KEY] String False  

The sys_id column for the table system_ui_policy_action.

field String False  

The field column for the table system_ui_policy_action.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

task

The ServiceNow table task.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
delivery_task String False  

The delivery_task column for the table task.

upon_approval String False  

The upon_approval column for the table task.

work_start Datetime False  

The work_start column for the table task.

delivery_plan String False  

The delivery_plan column for the table task.

rejection_goto String False  

The rejection_goto column for the table task.

work_end Datetime False  

The work_end column for the table task.

upon_reject String False  

The upon_reject column for the table task.

business_service String False  

The business_service column for the table task.

sys_id [KEY] String False  

The sys_id column for the table task.

sys_domain String False  

The sys_domain column for the table task.

sys_created_on Datetime False  

The sys_created_on column for the table task.

sys_updated_on Datetime False  

The sys_updated_on column for the table task.

expected_start Datetime False  

The expected_start column for the table task.

variables String False  

The variables column for the table task.

number String False  

The number column for the table task.

comments String False  

The comments column for the table task.

urgency String False  

The urgency column for the table task.

opened_at Datetime False  

The opened_at column for the table task.

watch_list String False  

The watch_list column for the table task.

sla_due Datetime False  

The sla_due column for the table task.

active String False  

The active column for the table task.

state String False  

The state column for the table task.

work_notes String False  

The work_notes column for the table task.

closed_by String False  

The closed_by column for the table task.

follow_up Datetime False  

The follow_up column for the table task.

work_notes_list String False  

The work_notes_list column for the table task.

cmdb_ci String False  

The cmdb_ci column for the table task.

approval_history String False  

The approval_history column for the table task.

business_duration Datetime False  

The business_duration column for the table task.

location String False  

The location column for the table task.

user_input String False  

The user_input column for the table task.

assigned_to String False  

The assigned_to column for the table task.

escalation String False  

The escalation column for the table task.

time_worked String False  

The time_worked column for the table task.

additional_assignee_list String False  

The additional_assignee_list column for the table task.

correlation_id String False  

The correlation_id column for the table task.

comments_and_work_notes String False  

The comments_and_work_notes column for the table task.

order String False  

The order column for the table task.

made_sla String False  

The made_sla column for the table task.

sys_mod_count String False  

The sys_mod_count column for the table task.

sys_created_by String False  

The sys_created_by column for the table task.

sys_updated_by String False  

The sys_updated_by column for the table task.

sys_domain_path String False  

The sys_domain_path column for the table task.

sys_class_name String False  

The sys_class_name column for the table task.

parent String False  

The parent column for the table task.

priority String False  

The priority column for the table task.

close_notes String False  

The close_notes column for the table task.

reassignment_count String False  

The reassignment_count column for the table task.

due_date Datetime False  

The due_date column for the table task.

short_description String False  

The short_description column for the table task.

company String False  

The company column for the table task.

approval_set Datetime False  

The approval_set column for the table task.

opened_by String False  

The opened_by column for the table task.

contact_type String False  

The contact_type column for the table task.

assignment_group String False  

The assignment_group column for the table task.

approval String False  

The approval column for the table task.

calendar_duration Datetime False  

The calendar_duration column for the table task.

knowledge String False  

The knowledge column for the table task.

correlation_display String False  

The correlation_display column for the table task.

wf_activity String False  

The wf_activity column for the table task.

description String False  

The description column for the table task.

impact String False  

The impact column for the table task.

closed_at Datetime False  

The closed_at column for the table task.

group_list String False  

The group_list column for the table task.

activity_due Datetime False  

The activity_due column for the table task.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.

 

 

 

v_field_creator

The ServiceNow table v_field_creator.

 

Columns

 

 

 

   
Name Type ReadOnly References Description
label String False  

The label column for the table v_field_creator.

sys_created_by String False  

The sys_created_by column for the table v_field_creator.

sys_class_name String False  

The sys_class_name column for the table v_field_creator.

sys_updated_by String False  

The sys_updated_by column for the table v_field_creator.

table_creator String False  

The table_creator column for the table v_field_creator.

length String False  

The length column for the table v_field_creator.

sys_mod_count String False  

The sys_mod_count column for the table v_field_creator.

name String False  

The name column for the table v_field_creator.

sys_updated_on Datetime False  

The sys_updated_on column for the table v_field_creator.

sys_id [KEY] String False  

The sys_id column for the table v_field_creator.

type String False  

The type column for the table v_field_creator.

sys_created_on Datetime False  

The sys_created_on column for the table v_field_creator.

 

Pseudo-Columns

 

 

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

 

 

   
Name Type Description
rows@next String

This is used to page through multiple pages of results and should not be set manually.