`

Matillion ETL Data Model for ServiceNow
Version - 18.0.6886

Note: Data models are true for the latest version of Matillion ETL. If you are on an older version or using a component from an old job, your experience may differ.




Connection String OptionsBack To Top

  1. Auto Cache
  2. Batch Size
  3. Cache Connection
  4. Cache Driver
  5. Cache Location
  6. Cache Metadata
  7. Cache Query Result
  8. Cache Tolerance
  9. Connection Life Time
  10. Connect On Open
  11. Firewall Password
  12. Firewall Port
  13. Firewall Server
  14. Firewall Type
  15. Firewall User
  16. Initiate OAuth
  17. Instance
  18. Location
  19. Logfile
  20. Max Log File Size
  21. Max Rows
  22. OAuth Access Token
  23. OAuth Client Id
  24. OAuth Client Secret
  25. OAuth Refresh Token
  26. OAuth Settings Location
  27. OAuth Verifier
  28. Offline
  29. Other
  30. Page Size
  31. Password
  32. Pool Idle Timeout
  33. Pool Max Size
  34. Pool Min Size
  35. Pool Wait Time
  36. Proxy Auth Scheme
  37. Proxy Auto Detect
  38. Proxy Exceptions
  39. Proxy Password
  40. Proxy Port
  41. Proxy Server
  42. Proxy SSL Type
  43. Proxy User
  44. Pseudo Columns
  45. Readonly
  46. RTK
  47. SSL Server Cert
  48. Support Enhanced SQL
  49. Tables
  50. Timeout
  51. Use Connection Pooling
  52. Use Display Values
  53. Username
  54. Verbosity
  55. Views



Auto Cache

Automatically caches the results of SELECT queries into a cache database specified by either CacheLocation or both of CacheConnection and CacheProvider . Configured with CacheQueryResult .
Data Type

bool

Default Value

false

Remarks

When AutoCache is set, the driver automatically maintains a cache of your table's data in the database of your choice. By default, the driver incrementally updates the cache, retrieving only changes since the last SELECT query was run if the length of time since the last run has exceeded the CacheTolerance. After the cache is updated, the query is executed against the cached data. With CacheQueryResult additionally set, the driver updates the cache when you execute a SELECT query and returns the live results from the ServiceNow data.

Explicitly Caching SELECT Results

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 caches 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





Batch Size

The maximum size of each batch operation to submit.
Data Type

int

Default Value

0

Remarks

When BatchSize is set to a value greater than 0, the batch operation will split the entire batch into separate batches of size BatchSize. The split batches will then be submitted to the server individually. This is useful when the server has limitations on the size of the request that can be submitted.

Setting BatchSize to 0 will submit the entire batch as specified.





Cache Connection

The connection string for the cache database. Always used in conjunction with CacheProvider . Setting both properties will override the value set for CacheLocation for caching data.
Data Type

string

Default Value

""

Remarks

The cache database is determined based on the CacheDriver and CacheConnection properties. Both properies are required to use the cache database. Examples of common cache database settings can be found below. For more information on setting the caching database's driver, refer to CacheDriver.

The connection string specified in the CacheConnection property is passed directly to the underlying CacheDriver. Consult the documentation for the specific JDBC driver for more information on the available properties. Make sure to include the JDBC driver in your application's classpath.

Derby and Java DB

The driver simplifies caching to Derby, only requiring you to set the CacheLocation property to make a basic connection.

Alternatively, you can configure the connection to Derby manually using CacheProvider 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

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:

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:
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:
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:





Cache Driver

The database driver to be used to cache data.
Data Type

string

Default Value

""

Remarks

You can cache to any database for which you have a JDBC driver, 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 Derby 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';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;Username=MyUser;Password=MyPassword;Instance=MyInstance;
To customize the Derby JDBC URL, use CacheDriver 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';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;Username=MyUser;Password=MyPassword;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';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;Username=MyUser;Password=MyPassword;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';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;Username=MyUser;Password=MyPassword;Instance=MyInstance;
  
The CData JDBC Driver for MySQL is located in the lib subfolder of the CData JDBC Driver for ServiceNow 2018 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';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;Username=MyUser;Password=MyPassword;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';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;Username=MyUser;Password=MyPassword;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';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;Username=MyUser;Password=MyPassword;Instance=MyInstance;





Cache Location

Specifies the path to the cache when caching to a file.
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





Cache Metadata

Whether or not to cache the table metadata to a file store.
Data Type

bool

Default Value

false

Remarks

As you execute queries with this property set, table metadata in the ServiceNow catalog are cached to the file store specified by CacheLocation if set or the user's home directory otherwise. A table's metadata will be retrieved only once, when the table is queried for the first time.

When to Use CacheMetadata

The driver automatically persists metadata in memory for up to two hours when you first discover the metadata for a table or view and therefore, CacheMetadata is generally not required. CacheMetadata becomes useful when metadata operations are expensive such as when you are working with large amounts of metadata or when you have many short-lived connections.

When Not to Use CacheMetadata





Cache Query Result

With AutoCache set, caches each row read from a SELECT query's results. Without this, the provider will attempt to fully replicate the table before executing the actual query against the replication database.
Data Type

bool

Default Value

false

Remarks

When CacheQueryResult and AutoCache are set, the rows returned from a SELECT query are cached in the cache database. The driver handles caching in a streaming fashion with each row being processed into the cache database from the original result set as you read the row from the returned ResultSet object. This ensures that the live data is not queried twice. Note that any rows you do not read from the returned ResultSet will not be updated in the cache.





Cache Tolerance

The tolerance for stale data in the cache specified in seconds when using AutoCache .
Data Type

string

Default Value

"600"

Remarks

The tolerance for stale data in the cache specified in seconds. This only applies when AutoCache is used. The driver will check with the data source for newer records after the tolerance interval has expired. Otherwise it will return the data directly from the cache.





Connection Life Time

The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed.
Data Type

string

Default Value

"0"

Remarks

The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed. The default is 0 which indicates there is no limit to the connection lifetime.





Connect On Open

Species whether to connect to the ServiceNow when the connection is opened.
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

A password used to authenticate to a proxy-based firewall.
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

The TCP port for a proxy-based firewall.
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

The name or IP address of a proxy-based firewall.
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

The protocol used by a proxy-based firewall.
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

The user name to use to authenticate with a proxy-based firewall.
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 method specified in FirewallType.





Initiate OAuth

Set this property to initiate the process to obtain or refresh the OAuth access token when you connect.
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

The ServiceNow instance to retrieve tables from.
Data Type

string

Default Value

""

Remarks

Set just the sub-domain part of your instance url. I.e if your instance url looks like this 'https://dev47813.service-now.com/', you must set this property to Instance=dev47813.





Location

A path to the directory that contains the schema files defining tables, views, and stored procedures.
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 are deployed alongside the driver 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

A path to the log file.
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

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.
Data Type

string

Default Value

"100MB"

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. The default limit is 100MB. Values lower than 100kB will use 100kB as the value instead.





Max Rows

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
Data Type

string

Default Value

"-1"

Remarks

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.





OAuth Access Token

The access token for connecting using OAuth.
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

The client Id assigned when you register your application with an OAuth authorization server.
Data Type

string

Default Value

""

Remarks

As part of registering an OAuth application, you will receive the OAuthClientId value, sometimes also called a consumer key, and a client secret, the OAuthClientSecret.





OAuth Client Secret

The client secret assigned when you register your application with an OAuth authorization server.
Data Type

string

Default Value

""

Remarks

As part of registering an OAuth application, you will receive the OAuthClientId, also called a consumer key. You will also receive a client secret, also called a consumer secret. Set the client secret in the OAuthClientSecret property.





OAuth Refresh Token

The OAuth refresh token for the corresponding OAuth access token.
Data Type

string

Default Value

""

Remarks

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





OAuth Settings Location

The location of the settings file where OAuth values are saved when InitiateOAuth is set to GETANDREFRESH or REFRESH. Alternatively, this can be held in memory by specifying a value starting with memory://.
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 avoid requiring the user to manually enter OAuth connection properties and allowing the credentials to be shared across connections or processes. The default OAuthSettingsLocation is a settings file located in the %AppData%\CData folder. Alternatively to specifying a file path, memory storage can be used instead. Memory locations are specified by using a value starting with 'memory://' followed by a unique identifier for that set of credentials (ex: memory://user1). The identifier can be anything you choose but should be unique to the user. Unlike with the file based storage, you must manually store the credentials when closing the connection with memory storage to be able to set them in the connection when the process is started again. The OAuth property values can be retrieved with a query to the sys_connection_props system table. If there are multiple connections using the same credentials, the properties should be read from the last connection to be closed.





OAuth Verifier

The verifier code returned from the OAuth authorization URL.
Data Type

string

Default Value

""

Remarks

The verifier code returned from the OAuth authorization URL. This can be used on systems where a browser cannot be launched such as headless systems.

Authentication on Headless Machines

See the Getting Started section to obtain the OAuthVerifier value.

Set OAuthSettingsLocation along with OAuthVerifier. When you connect, the driver exchanges the OAuthVerifier for the OAuth authentication tokens and saves them, encrypted, to the specified file. Set InitiateOAuth to GETANDREFRESH automate the exchange.

Once the OAuth settings file has been generated, you can remove OAuthVerifier from the connection properties and connect with OAuthSettingsLocation set.

To automatically refresh the OAuth token values, set OAuthSettingsLocation and additionally set InitiateOAuth to REFRESH.





Offline

Use offline mode to get the data from the cache instead of the live source.
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

Hidden properties needed only in specific use cases.
Data Type

string

Default Value

""

Remarks

The properties listed below are available for specific use cases. Normal driver use cases and functionality should not require these properties.

Specify multiple properties in a semicolon-separated list.

Caching Configuration

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

Integration and Formatting

DefaultColumnSizeSets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000.
ConvertDateTimeToGMTWhether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filenameRecords the underlying socket data transfer to the specified file.





Page Size

The page size for the pagination.
Data Type

string

Default Value

"10000"

Remarks

The page size for the pagination.





Password

The password used to authenticate the user.
Data Type

string

Default Value

""

Remarks

The password used to authenticate the user.





Pool Idle Timeout

The allowed idle time for a connection before it is closed.
Data Type

string

Default Value

""

Remarks

The allowed idle time a connection can remain in the pool until the connection is closed. The default is 60 seconds.





Pool Max Size

The maximum connections in the pool.
Data Type

string

Default Value

"100"

Remarks

The maximum connections in the pool. The default is 100. To disable this property, set the property value to 0 or less.





Pool Min Size

The minimum number of connections in the pool.
Data Type

string

Default Value

"1"

Remarks

The minimum number of connections in the pool. The default is 1.





Pool Wait Time

The max seconds to wait for an available connection.
Data Type

string

Default Value

""

Remarks

The max seconds to wait for a connection to become available. If a new connection request is waiting for an available connection and exceeds this time, an error is thrown. By default, new requests wait forever for an available connection.





Proxy Auth Scheme

The authentication type to use to authenticate to the ProxyServer proxy.
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:

If you need to use another authentication type, such as SOCKS 5 authentication, see FirewallType.





Proxy Auto Detect

This indicates whether to use the system proxy settings or not. Set ProxyAutoDetect to FALSE to use custom proxy settings. This takes precedence over other proxy settings.
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 Exceptions

A semicolon separated list of hosts or IPs that will be exempt from connecting through the ProxyServer .
Data Type

string

Default Value

""

Remarks

The ProxyServer will be used for all addresses, except for addresses defined in this property. Use semicolons to separate entries.

Note that the driver will use the system proxy settings by default, without further configuration needed; if you want to explicitly configure proxy exceptions for this connection, you will need to set ProxyAutoDetect to false, and configure ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.





Proxy Password

A password to be used to authenticate to the ProxyServer proxy.
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

The TCP port the ProxyServer proxy is running on.
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

The hostname or IP address of a proxy to route HTTP traffic through.
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

The SSL type to use when connecting to the ProxyServer proxy.
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:

AUTODefault 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.
ALWAYSThe connection is always SSL enabled.
NEVERThe connection is not SSL enabled.
TUNNELThe 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

A user name to be used to authenticate to the ProxyServer proxy.
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

Indicates whether or not to include pseudo columns as columns to the table.
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., "*=*".





Readonly

You can use this property to enforce read-only access to ServiceNow from the provider.
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

The runtime key used for licensing.
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

The certificate to be accepted from the server when connecting using TLS/SSL.
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

Enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.
Data Type

bool

Default Value

true

Remarks

When SupportEnhancedSQL is set to true, the driver offloads as much of the SELECT statement processing as possible to ServiceNow and then processes the rest of the query in memory. In this way the driver can execute unsupported predicates, joins, and aggregation.

When SupportEnhancedSQL is set to false, the driver limits SQL execution to what is supported by the ServiceNow API.

Execution of Predicates

The driver determines which of the clauses are supported by the data source and then pushes them to the source to get the smallest superset of rows that would satisfy the query. It then filters the rest of the rows locally. The filter operation is streamed, which enables the driver to filter effectively for even very large datasets.

Execution of Joins

The driver uses various techniques to join in memory. The driver trades off memory utilization against the requirement of reading the same table more than once.

Execution of Aggregates

The driver retrieves all rows necessary to process the aggregation in memory.





Tables

Restrict the tables reported to a subset of the available tables. For example: Tables=TableA,TableB,TableC.
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.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the tables you want in a comma-separated list. For example: Tables=TableA,TableB,TableC





Timeout

The value in seconds until the timeout error is thrown, canceling the operation.
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.





Use Connection Pooling

Enables connection pooling.
Data Type

bool

Default Value

false

Remarks

Enables connection pooling. The default is false. See Connection Pooling for information on using connection pools.





Use Display Values

Based on this value, the provider retrieves the display value or the actual value from the database.
Data Type

bool

Default Value

false

Remarks

Note: If you decide to set this connection property to "true", then all the returned fields will be of type "String", because it is a limitation of the API.





Username

The user account used to authenticate to ServiceNow.
Data Type

string

Default Value

""

Remarks

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





Verbosity

The verbosity level that determines the amount of detail included in the log file.
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:

1Setting 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.
2Setting Verbosity to 2 will log everything included in Verbosity 1, cache queries, and additional information about the request, if applicable, such as HTTP headers.
3Setting Verbosity to 3 will additionally log the body of the request and the response.
4Setting Verbosity to 4 will additionally log transport-level communication with the data source. This includes SSL negotiation.
5Setting 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

Restrict the views reported to a subset of the available tables. For example: Views=ViewsA,ViewsB,ViewsC.
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.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the views you want in a comma-separated list. For example: For example: Views=ViewsA,ViewsB,ViewsC





TablesBack To Top

  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.