|
Matillion Data Model for ServiceNow
|
Connection String OptionsBack To Top
- AuthScheme
- URL
- User
- Password
- SSOLoginURL
- SSOProperties
- CredentialsLocation
- InitiateOAuth
- OAuthClientId
- OAuthClientSecret
- OAuthAccessToken
- OAuthSettingsLocation
- CallbackURL
- OAuthGrantType
- OAuthVerifier
- OAuthRefreshToken
- OAuthExpiresIn
- OAuthTokenTimestamp
- SSLServerCert
- FirewallType
- FirewallServer
- FirewallPort
- FirewallUser
- FirewallPassword
- ProxyAutoDetect
- ProxyServer
- ProxyPort
- ProxyAuthScheme
- ProxyUser
- ProxyPassword
- ProxySSLType
- ProxyExceptions
- Logfile
- Verbosity
- LogModules
- MaxLogFileSize
- MaxLogFileCount
- Location
- BrowsableSchemas
- Tables
- Views
- IncludeDatabaseViews
- IncludeSystemTables
- AutoCache
- CacheDriver
- CacheConnection
- CacheLocation
- CacheTolerance
- Offline
- CacheMetadata
- BatchSize
- ConnectionLifeTime
- ConnectOnOpen
- DisplayValue
- ExcludeReferenceLink
- GetColumnsMetadata
- MaxRows
- Other
- Pagesize
- PoolIdleTimeout
- PoolMaxSize
- PoolMinSize
- PoolWaitTime
- PseudoColumns
- Readonly
- RTK
- ShowDescriptions
- SupportEnhancedSQL
- Timeout
- UseConnectionPooling
- UseDisplayTableNames
AuthScheme
Data Type
string
Default Value
"Auto"
Remarks
This property specifies the type of authentication to perform. Possible values are:
- Auto: Lets the driver decide automatically based on the other connection properties you have set.
- Basic: Set this to use BASIC authentication.
- OAuth: Set this to perform OAuth authentication.
By default, AuthScheme is Basic, and if the User and Password properties are set, the driver will attempt basic authentication.
The driver will perform OAuth authentication if AuthScheme is set to OAuth, or OAuthAccessToken property is set.
The following options are available for SSO:
- OKTA: Set to use a single sign on connection with OKTA as the identify provider.
- ADFS: Set to use a single sign on connection with ADFS as the identify provider.
- OneLogin: Set to use a single sign on connection with OneLogin as the identify provider.
- PingFederate: Set to use a single sign on connection with PingFederate as the identity provider.
URL
Data Type
string
Default Value
""
Remarks
Set the base URL of your ServiceNow instance site. For example: https://dev47813.service-now.com/.
User
Data Type
string
Default Value
""
Remarks
Together with Password, this field is used to authenticate against the ServiceNow server.
Password
Data Type
string
Default Value
""
Remarks
The User and Password are together used to authenticate with the server.
SSOLoginURL
Data Type
string
Default Value
""
Remarks
The identity provider's login URL.
SSOProperties
Data Type
string
Default Value
""
Remarks
Additional properties required to connect to the identity provider in a semicolon-separated list. is used in conjunction with the SSOLoginURL.
SSO configuration is discussed further in Establishing a Connection.
CredentialsLocation
Data Type
string
Default Value
"%APPDATA%\\CData\\ServiceNow Data Provider\\CredentialsFile.txt"
Remarks
MFA credentials are short lived and typically expire after an hour. At that point, a different MFAToken must be specified to continue connecting. MFA tokens only work once, so in the case of multi-threaded or multi-process applications, the credentials must be centrally located and shared to avoid problems. When MFAToken is not specified, this property does nothing.
If left unspecified, the default location is "%APPDATA%\\CData\\ServiceNow Data Provider\\CredentialsFile.txt" with %APPDATA% being set to the user's configuration directory:
| Platform | %APPDATA% |
| Windows | The value of the APPDATA environment variable |
| Mac | ~/Library/Application Support |
| Linux | ~/.config |
InitiateOAuth
Data Type
string
Default Value
"OFF"
Remarks
The following options are available:
- OFF: Indicates that the OAuth flow will be handled entirely by the user. An OAuthAccessToken will be required to authenticate.
- 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.
- 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.
OAuthClientId
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.
OAuthClientSecret
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.
OAuthAccessToken
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 user name and password. The access token protects your credentials by keeping them on the server.
OAuthSettingsLocation
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.
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.
If left unspecified, the default location is "%APPDATA%\\CData\\ServiceNow Data Provider\\OAuthSettings.txt" with %APPDATA% being set to the user's configuration directory:
| Platform | %APPDATA% |
| Windows | The value of the APPDATA environment variable |
| Mac | ~/Library/Application Support |
| Linux | ~/.config |
CallbackURL
Data Type
string
Default Value
"http://localhost:33333"
Remarks
During the authentication process, the OAuth authorization server redirects the user to this URL. This value must match the callback URL you specify in your app settings.
OAuthGrantType
Data Type
string
Default Value
"PASSWORD"
Remarks
The grant type for the OAuth flow. The following options are available: CODE,PASSWORD
OAuthVerifier
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 Establishing a Connection 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.
OAuthRefreshToken
Data Type
string
Default Value
""
Remarks
The OAuthRefreshToken property is used to refresh the OAuthAccessToken when using OAuth authentication.
OAuthExpiresIn
Data Type
string
Default Value
""
Remarks
Pair with OAuthTokenTimestamp to determine when the AccessToken will expire.
OAuthTokenTimestamp
Data Type
string
Default Value
""
Remarks
Pair with OAuthExpiresIn to determine when the AccessToken will expire.
SSLServerCert
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 is rejected.
This property can take the following 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 is accepted.
Certificates are validated as trusted by the machine based on the System's trust store. The trust store used is the 'javax.net.ssl.trustStore' value specified for the system. If no value is specified for this property, Java's default trust store is used (for example, JAVA_HOME\lib\security\cacerts).
Use '*' to signify to accept all certificates. Note that this is not recommended due to security concerns.
FirewallType
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.
FirewallServer
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.
FirewallPort
Data Type
int
Default Value
0
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.
FirewallUser
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.
FirewallPassword
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.
ProxyAutoDetect
Data Type
bool
Default Value
false
Remarks
This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.
NOTE: When this property is set to True, the proxy used is determined as follows:
- A search from the JVM properties (http.proxy, https.proxy, socksProxy, etc.) is performed.
- In the case that the JVM properties don't exist, a search from java.home/lib/net.properties is performed.
- In the case that java.net.useSystemProxies is set to True, a search from the SystemProxy is performed.
- In Windows only, an attempt is made to retrieve these properties from the Internet Options in the registry.
To connect to an HTTP proxy, see ProxyServer. For other proxies, such as SOCKS or tunneling, see FirewallType.
ProxyServer
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.
ProxyPort
Data Type
int
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.
ProxyAuthScheme
Data Type
string
Default Value
"BASIC"
Remarks
This value specifies the authentication type to use to authenticate to the HTTP proxy specified by ProxyServer and ProxyPort.
Note that the driver will use the system proxy settings by default, without further configuration needed; if you want to connect to another proxy, you will need to set ProxyAutoDetect to false, in addition to ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.
The authentication type can be one of the following:
- BASIC: The driver performs HTTP BASIC authentication.
- DIGEST: The driver performs HTTP DIGEST authentication.
- NEGOTIATE: The driver retrieves an NTLM or Kerberos token based on the applicable protocol for authentication.
- PROPRIETARY: The driver does not generate an NTLM or Kerberos token. You must supply this token in the Authorization header of the HTTP request.
If you need to use another authentication type, such as SOCKS 5 authentication, see FirewallType.
ProxyUser
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 user name of a user recognized by the HTTP proxy. If you are using Windows or Kerberos authentication, set this property to a user name in one of the following formats:
user@domain domain\user
ProxyPassword
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.
ProxySSLType
Data Type
string
Default Value
"AUTO"
Remarks
This property determines when to use SSL for the connection to an HTTP proxy specified by ProxyServer. This value can be AUTO, ALWAYS, NEVER, or TUNNEL. The applicable values are the following:
| AUTO | Default setting. If the URL is an HTTPS URL, the driver will use the TUNNEL option. If the URL is an HTTP URL, the component will use the NEVER option. |
| ALWAYS | The connection is always SSL enabled. |
| NEVER | The connection is not SSL enabled. |
| TUNNEL | The connection is through a tunneling proxy. The proxy server opens a connection to the remote host and traffic flows back and forth through the proxy. |
ProxyExceptions
Data Type
string
Default Value
""
Remarks
The ProxyServer is used for all addresses, except for addresses defined in this property. Use semicolons to separate entries.
Note that the driver uses the system proxy settings by default, without further configuration needed; if you want to explicitly configure proxy exceptions for this connection, you need to set ProxyAutoDetect = false, and configure ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.
Logfile
Data Type
string
Default Value
""
Remarks
Once this property is set, the driver will populate the log file as it carries out various tasks, such as when authentication is performed or queries are executed. If the specified file doesn't already exist, it will be created.
Connection strings and version information are also logged, though connection properties containing sensitive information are masked automatically.
If a relative filepath is supplied, the location of the log file will be resolved based on the path found in the Location connection property.
For more control over what is written to the log file, you can adjust the Verbosity property.
Log contents are categorized into several modules. You can show/hide individual modules using the LogModules property.
To edit the maximum size of a single logfile before a new one is created, see MaxLogFileSize.
If you would like to place a cap on the number of logfiles generated, use MaxLogFileCount.
Java Logging
Java logging is also supported. To enable Java logging, set Logfile to:
Logfile=JAVALOG://myloggername
As in the above sample, JAVALOG:// is a required prefix to use Java logging, and you will substitute your own Logger.
The supplied Logger's getLogger method is then called, using the supplied value to create the Logger instance. If a logging instance already exists, it will reference the existing instance.
When Java logging is enabled, the Verbosity will now correspond to specific logging levels.
Verbosity
Data Type
string
Default Value
"1"
Remarks
The verbosity level determines the amount of detail that the driver reports to the Logfile. Verbosity levels from 1 to 5 are supported. These are detailed in the Logging page.
LogModules
Data Type
string
Default Value
""
Remarks
Only the modules specified (separated by ';') will be included in the log file. By default all modules are included.
See the Logging page for an overview.
MaxLogFileSize
Data Type
string
Default Value
"100MB"
Remarks
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 100 MB. Values lower than 100 kB will use 100 kB as the value instead.
Adjust the maximum number of logfiles generated with MaxLogFileCount.
MaxLogFileCount
Data Type
int
Default Value
-1
Remarks
When the limit is hit, a new log is created in the same folder with the date and time appended to the end and the oldest log file will be deleted.
The minimum supported value is 2. A value of 0 or a negative value indicates no limit on the count.
Adjust the maximum size of the logfiles generated with MaxLogFileSize.
Location
Data Type
string
Default Value
"%APPDATA%\\CData\\ServiceNow Data Provider\\Schema"
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 folder location can be a relative path from the location of the executable. The Location property is only needed if you want to customize definitions (for example, change a column name, ignore a column, and so on) or extend the data model with new tables, views, or stored procedures.
If left unspecified, the default location is "%APPDATA%\\CData\\ServiceNow Data Provider\\Schema" with %APPDATA% being set to the user's configuration directory:
| Platform | %APPDATA% |
| Windows | The value of the APPDATA environment variable |
| Mac | ~/Library/Application Support |
| Linux | ~/.config |
BrowsableSchemas
Data Type
string
Default Value
""
Remarks
Listing the schemas from databases can be expensive. Providing a list of schemas in the connection string improves the performance.
Tables
Data Type
string
Default Value
""
Remarks
Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the driver.
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. Each table should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space`.
Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.
Views
Data Type
string
Default Value
""
Remarks
Listing the views from some databases can be expensive. Providing a list of views in the connection string improves the performance of the driver.
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. Each view should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space`.
Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.
IncludeDatabaseViews
Data Type
bool
Default Value
false
Remarks
Controls whether to expose the Database Views or not. If 'True', the driver will send several additional metadata calls to get the metadata of the Database Views.
IncludeSystemTables
Data Type
bool
Default Value
true
Remarks
Controls whether to expose the system tables or not. Usually only admin-role users have access to these tables. Setting this property to false will make them to not be listed on metadata calls.
AutoCache
Data Type
bool
Default Value
false
Remarks
When AutoCache = true, 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.
Setting the Caching Database
When AutoCache = true, the driver caches to a simple, file-based cache. You can configure its location or cache to a different database with the following properties:
- CacheLocation: Specifies the path to the file store.
- CacheDriver and CacheConnection: Specifies a driver to a database and the connection string.
See Also
- CacheTolerance: This property controls the tolerance for stale data in the cache.
- CacheMetadata: This property reduces the amount of metadata that crosses the network by persisting table schemas retrieved from the ServiceNow metadata. Metadata then needs to be retrieved only once instead of every connection.
- REPLICATE Statements: When you execute a SELECT statement with AutoCache = true, the driver internally calls the REPLICATE statement. The REPLICATE statement enables incremental updates instead of first dropping the cached table.
- Explicitly Caching Data: This section provides more examples of using AutoCache in Offline mode.
- CACHE Statements: You can use the CACHE statement to persist any SELECT query, as well as manage the cache; for example, refreshing schemas.
CacheDriver
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 want to use to cache data.
Note that you must also add the CacheDriver JAR file 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 file is shipped in the JDK. You can find the JAR file, 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;User=MyUser;Password=MyPassword;Url=https://MyInstance12345.service-now.com/;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;User=MyUser;Password=MyPassword;Url=https://MyInstance12345.service-now.com/;
SQLite
The following 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;User=MyUser;Password=MyPassword;Url=https://MyInstance12345.service-now.com/;
MySQL
The following 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;User=MyUser;Password=MyPassword;Url=https://MyInstance12345.service-now.com/;
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;User=MyUser;Password=MyPassword;Url=https://MyInstance12345.service-now.com/;
Oracle
The following is a JDBC URL for the Oracle Thin Client:
jdbc:servicenow:Cache Driver=oracle.jdbc.OracleDriver;CacheConnection='jdbc:oracle:thin:scott/tiger@localhost:1521:orcldb';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;User=MyUser;Password=MyPassword;Url=https://MyInstance12345.service-now.com/;
NOTE: If using a version of Oracle older than 9i, the cache driver will instead be oracle.jdbc.driver.OracleDriver .
PostgreSQL
The following JDBC URL uses the official PostgreSQL JDBC driver:
jdbc:servicenow:CacheDriver=cdata.jdbc.postgresql.PostgreSQLDriver;CacheConnection='jdbc:postgresql:User=postgres;Password=admin;Database=postgres;Server=localhost;Port=5432;';InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;User=MyUser;Password=MyPassword;Url=https://MyInstance12345.service-now.com/;
CacheConnection
Data Type
string
Default Value
""
Remarks
The cache database is determined based on the CacheDriver and CacheConnection properties. Both properties 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 CacheDriver and CacheConnection. The following 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. The following is the syntax of the JDBC URL:
jdbc:sqlite:dataSource
- Data Source: The path to an SQLite database file. Or, use a value of :memory to cache in memory.
MySQL
The installation includes the CData JDBC Driver for MySQL. The following is an example JDBC URL:
jdbc:mysql:User=root;Password=root;Server=localhost;Port=3306;Database=cache
The following are typical connection properties:
- Server: The IP address or domain name of the server you want to connect to.
- Port: The port that the server is running on.
- User: The user name provided for authentication to the database.
- Password: The password provided for authentication to the database.
- Database: The name of the database.
SQL Server
The JDBC URL for the Microsoft JDBC Driver for SQL Server has the following syntax:
jdbc:sqlserver://[serverName[\instance][:port]][;database=databaseName][;property=value[;property=value] ... ]
For example:
jdbc:sqlserver://localhost\sqlexpress:1433;integratedSecurity=true
The following are typical SQL Server connection properties:
- Server: The name or network address of the computer running SQL Server. To connect to a named instance instead of the default instance, this property can be used to specify the host name and the instance, separated by a backslash.
- Port: The port SQL Server is running on.
- Database: The name of the SQL Server database.
- Integrated Security: Set this option to true to use the current Windows account for authentication. Set this option to false if you are setting the User and Password in the connection.
To use integrated security, you will also need to add sqljdbc_auth.dll to a folder on the Windows system path. This file is located in the auth subfolder of the Microsoft JDBC Driver for SQL Server installation. The bitness of the assembly must match the bitness of your JVM.
- User Id: The user name provided for authentication with SQL Server. This property is only needed if you are not using integrated security.
- Password: The password provided for authentication with SQL Server. This property is only needed if you are not using integrated security.
Oracle
The following 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
The following are typical connection properties:
-
Data Source: The connect descriptor that identifies the Oracle database. This can be a TNS connect descriptor, an Oracle Net Services name that resolves to a connect descriptor, or, after version 11g, an Easy Connect naming (the host name of the Oracle server with an optional port and service name).
- Password: The password provided for authentication with the Oracle database.
- User Id: The user Id provided for authentication with the Oracle database.
PostgreSQL
The following 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
The following are typical connection properties:
- Host: The address of the server hosting the PostgreSQL database.
- Port: The port used to connect to the server hosting the PostgreSQL database.
- Database: The name of the database.
- User name: The user Id provided for authentication with the PostgreSQL database. You can specify this in the JDBC URL with the "user" parameter.
- Password: The password provided for authentication with the PostgreSQL database.
CacheLocation
Data Type
string
Default Value
"%APPDATA%\\CData\\ServiceNow Data Provider"
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 file to the classpath. The JAR file, derby.jar, is shipped in the JDK and located in the db subfolder of the JDK installation.
If left unspecified, the default location is "%APPDATA%\\CData\\ServiceNow Data Provider" with %APPDATA% being set to the user's configuration directory:
| Platform | %APPDATA% |
| Windows | The value of the APPDATA environment variable |
| Mac | ~/Library/Application Support |
| Linux | ~/.config |
See Also
- AutoCache: Set to implicitly create and maintain a cache for later offline use.
- CacheMetadata: Set to persist the ServiceNow catalog in CacheLocation.
CacheTolerance
Data Type
int
Default Value
600
Remarks
The tolerance for stale data in the cache specified in seconds. This only applies when AutoCache is used. The driver checks with the data source for newer records after the tolerance interval has expired. Otherwise, it returns the data directly from the cache.
Offline
Data Type
bool
Default Value
false
Remarks
When Offline = 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.
CacheMetadata
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
- When you are working with volatile metadata: Metadata for a table is only retrieved the first time the connection to the table is made. To pick up new, changed, or deleted columns, you would need to delete and rebuild the metadata cache. Therefore, it is best to rely on the in-memory caching for cases where metadata changes often.
- When you are caching to a database: CacheMetadata can only be used with CacheLocation. If you are caching to another database with the CacheDriver and CacheConnection properties, use AutoCache to cache implicitly. Or, use REPLICATE Statements or CACHE Statements to cache explicitly.
BatchSize
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.
ConnectionLifeTime
Data Type
int
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.
ConnectOnOpen
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).
DisplayValue
Data Type
string
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" due to API limitations.
- TRUE: returns display values for all fields.
- FALSE: returns actual values from the database.
- ALL: returns both actual and display values.
ExcludeReferenceLink
Data Type
bool
Default Value
false
Remarks
Based on this value, the additional information provided for reference fields will be suppressed or not.
GetColumnsMetadata
Data Type
string
Default Value
"OnStart"
Remarks
Available settings are the following:
- OnStart: The driver will execute the metadata calls to discover and cache all columns for every table, prior to executing the first statement.
- OnUse: The driver will execute the table specific metadata calls the first time the table is referenced, provided the metadata for the table is not already cached.
MaxRows
Data Type
int
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.
Other
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=True | Caches only a subset of columns, which you can specify in your query. |
| QueryPassthrough=True | Passes the specified query to the cache database instead of using the SQL parser of the driver. |
Integration and Formatting
| DefaultColumnSize | Sets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000. |
| ConvertDateTimeToGMT | Determines whether to convert date-time values to GMT, instead of the local time of the machine. |
| RecordToFile=filename | Records the underlying socket data transfer to the specified file. |
Pagesize
Data Type
int
Default Value
5000
Remarks
The Pagesize property affects the maximum number of results to return per page from ServiceNow. Setting a higher value may result in better performance at the cost of additional memory allocated per page consumed.
PoolIdleTimeout
Data Type
int
Default Value
60
Remarks
The allowed idle time a connection can remain in the pool until the connection is closed. The default is 60 seconds.
PoolMaxSize
Data Type
int
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.
PoolMinSize
Data Type
int
Default Value
1
Remarks
The minimum number of connections in the pool. The default is 1.
PoolWaitTime
Data Type
int
Default Value
60
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.
PseudoColumns
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; for example, "*=*".
Readonly
Data Type
bool
Default Value
false
Remarks
If this property is set to true, the driver will allow only SELECT queries. INSERT, UPDATE, DELETE, and stored procedure queries will cause an error to be thrown.
RTK
Data Type
string
Default Value
""
Remarks
The RTK property may be used to license a build. See the included licensing file to see how to set this property. The runtime key is only available if you purchased an OEM license.
ShowDescriptions
Data Type
string
Default Value
"NONE"
Remarks
Note: By default, it is set to NONE and the descriptions for the tables and their respective columns are not shown. Extra API calls will be executed if this property is set to a value other than NONE.
Set the value of this property to TableLabels if you want to retrieve the Labels (Display Names) for every table from the sys_db_object API endpoint.
Set the value of this property to ColumnLabels if you want to retrieve the Labels (Display Names) for every column from the sys_documentation API endpoint.
Set the value of this property to TableAndColumnLabels if you want to retrieve the Labels (Display Names) for every table and their respective columns from the sys_db_object and sys_documentation API endpoints.
Set the value of this property to ColumnComments if you want to retrieve the Comments for every column from the sys_dictionary API endpoint.
SupportEnhancedSQL
Data Type
bool
Default Value
true
Remarks
When SupportEnhancedSQL = 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 = 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.
Timeout
Data Type
int
Default Value
60
Remarks
If Timeout = 0, operations do not time out. The operations run until they complete successfully or until they encounter an error condition.
If Timeout expires and the operation is not yet complete, the driver throws an exception.
UseConnectionPooling
Data Type
bool
Default Value
false
Remarks
This property enables connection pooling. The default is false. See Connection Pooling for information on using connection pools.
UseDisplayTableNames
Data Type
bool
Default Value
false
Remarks
By default, the tables are exposed using the Internal Table Names.
If this property is set to true, the provider will expose the tables using the ServiceNow GUI Display Names.
TablesBack To Top
- ast_contract
- ast_license_base
- change_request
- cmdb_ci
- cmdb_metric
- cmn_building
- cmn_context_help
- cmn_cost_center
- cmn_department
- cmn_location
- cmn_map_page
- cmn_notif_device
- cmn_notif_device_variable
- cmn_notif_grmember
- cmn_notif_group
- cmn_notif_message
- cmn_notif_service_provider
- cmn_other_schedule
- cmn_relative_duration
- cmn_schedule
- cmn_schedule_blackout
- cmn_schedule_condition
- cmn_schedule_maintenance
- cmn_schedule_page
- cmn_schedule_span
- cmn_timeline_page
- cmn_timeline_page_style
- cmn_timeline_sub_item
- diagrammer_action
- expert_panel
- item_option_new
- question
- sc_category
- sc_cat_item
- sla
- sysauto
- sysauto_script
- syslog
- sysrule
- system_db_object
- system_dictionary
- system_documentation
- system_import_set_row
- system_script_client
- system_ui_policy
- system_ui_policy_action
- task
- 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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |