Table Administration And Data Management

As a time card approver, you can view and approve or reject a submitted time card.

View, approve, or reject time sheet or time cards for your user, for the given week, in a single step.

As a time card administrator, you can assign a time sheet policy to a user.

As an admin, you can configure a scheduled job to generate time cards automatically for project tasks assigned to time card users.

You can roll back the database actions of a script executed using the Scripts-Background module.

The Assignment rules module allows you to automatically set a value in the assigned_to and assignment_group fields when a set of conditions occurs.

During the import of XML records, the system attempts to match some reference field display values to a local sys_id value.

A Planned Task Baseline is a record of the start and end times of the planned task at a particular moment in time.

Join tables into a single view and then create a report based on that view.

A database view defines table joins for reporting purposes.

Access details related to tables, columns, and field labels in your instance.

Data lookup rules offer a generic way to change any field value, not just assignment fields.

The instance can automatically assign a task to a user or group based on pre-defined conditions by using data lookup rules and assignment rules.

Administrators can delete custom tables that are no longer needed. For example, delete a table from an application that is under development because the business requirements change.

Dictionary attributes alter the behavior of the table or field that the dictionary record describes. Administrators can add or modify dictionary attributes.

Dictionary overrides provide the ability to define a field on an extended table differently from the field on the parent table.

When the property glide.export.debug is true, the instance logs export processing including database query time and the time taken to write data to the file.

Migrate data from one instance to another by exporting and importing XML files.

Export data from the ServiceNow AI Platform in a variety of formats.

Exporting currency fields to Excel applies Account formatting and can be configured to convert all values to US dollars or to export values in the user's session currency.

The platform provides a default upper limit for data exports.

When the cost management feature is enabled, time cards can be used to manage the cost of labor in the Cost Management application.

By default, tasks can be related to each other using a parent/child relationship, such as a Problem with a group of child Incidents or a Catalog Request with a group of child Catalog Tasks.

The Mark as Solution button is added to the KB popup view and displayed when you search the knowledge base from a task record.

The Planned Task [planned_task] form provides standard fields for tracking duration and effort.

To convert fields that are displayed in milliseconds (such as 'Resolution Time' on the Incident table) to a duration format (Months/Days/Hours/Seconds), populate the attribute field on the dictionary with: format=glide_duration.

The Planned Task plugin provides a Planned Task [planned_task] table that extends the Task [task] table.

Scripts, assignment rules, business rules, workflows, escalations, and engines all take effect in relation to a database operation, such as insert or update. In many cases, the order of these events is important.

The time card retrieves time accrued on a project or spent working on any record in the Task table from the Time worked field.

View table relationships in a visual manner using the schema map.

Restrict or specify a field that you want returned by the joined table.

Specify the number of records to return for a database view when the view is used in a script.

View a list of all tables in columns in your instance from the system dictionary.

A table is a collection of records in the database. Each record corresponds to a row in a table, and each field on a record corresponds to a column on that table.

The Tasks [task] table is one of the core tables provided with the base system.

Table flattening stores a hierarchy of related tables as one table in a relational database.

Time cards are used to record the time worked on a task by a task assignee.

ServiceNow performs conjunction (AND) statements before disjunction (OR) statements in a query.

The schema map shows the selected table in yellow, typically centered, and all tables related to that table, typically shown at the sides.

An alternative to creating data lookup or assignment rules is to create one or more workflow tasks that assign a task record as part of a workflow.

Configure connection and credential aliases to authenticate an integration between your ServiceNow instance and Google Drive.

Register the Google Drive application in your ServiceNow instance to enable OAuth authorization for exporting table records directly to Google Sheets.

You can copy time cards from an existing time sheet, which copies all the time cards (for project and non-project tasks) from a selected time sheet.

Create a function field that displays the results of a database function, such as a mathematical operation, field length computation, or day of the week calculation.

Build a record hierarchy between records in the same table.

As a time card administrator, you can create a time sheet policy to define the requirements for time card users to record their time worked. The time card approvers must review and process time sheets under the applicable time sheet policy.

As a time card user, you can create a time sheet to group all your time cards for the given week and submit them in a single step.

After you create time cards in Time Sheet Portal, log time in the time cards.

You can create rate types using the Rate Types feature.

Custom tables enable you to expand the functionality of the ServiceNow AI Platform and create custom applications.

Reference topics provide details on exporting data.

Simplify and build more efficient queries by leveraging hierarchical relationships in the condition builder.

Default values are used for column headers and column values, unless overridden by query parameters, Export Set fields, or system properties.

You can recover a deleted record and all related changes. The recovery must be done within seven days of the record being deleted.

Add a function field to the output of a database view to see function results.

Enhance the display of a database view by adding a function field to the output to display function results.

Domain separation is supported in Time Card. Domain separation enables you to separate data, processes, and administrative tasks into logical groupings called domains. You can control several aspects of this separation, including which users can see and access data.

Remove a custom index by dropping it from a table.

This example shows the proper settings when using left-joins to add tables to a database view.

Applications use tables and records to manage data and processes, such as Incident, Problem, and CMDB. Tables can extend other tables, creating parent tables and child tables.

Export a record to PDF or XML.

Export a list of records to a variety of file formats.

Export data from a source instance to an XML file.

Different field types are affected differently by export controls.

After you have successfully exported data from the source instance to XML, import the XML file directly to the target instance.

Control whether a field is read only and whether it can be changed by a client script and server-side APIs.

Use query parameters to export the display value or raw value of fields and the field label or field name for headers.

A baseline instance contains certain assignment rules.

Certain views are included in the base system with the Database Views and Database Views for Service Management plugins.

The Dictionary Entry form was redesigned to provide an Advanced view and additional fields. You might need to configure the form to see all fields.

When you create a new custom table, several fields appear in the Table Columns embedded list. For all tables, required system fields are added automatically. You cannot delete or modify these fields.

The Planned Task table has these fields.

The Task table is a base class that provides fields for the core ITSM applications such as Incident, Problem, and Change Management. All applications that extend the Task table share these fields in common.

Journal fields work together to create a log of changes and comments as tasks are worked on.

Several business rules and one script include determines the dynamic calculation of crucial Planned Task fields.

When the plugin is activated, the Task Relationships application is available with certain modules.

Some many-to-many relationships are defined by default.

After defining task relationships, you can use UI Actions to define the task relationship when a new task is being created from an old task.

Control the ability to edit read-only fields by configuring read-only options.

The Reminder [reminder] table provides a way to auto-generate reminders for a task.

Use the Rollback Contexts module to roll back patch upgrades and plugin activations.

Change the default expiration period for different types of rollback context records.

With rollback contexts, you can roll back certain actions such as a patch upgrade, plugin activation, and background script executions, and you can recover record deletions and all related changes.

As a time card administrator, you can set a time sheet policy as the default policy. The default policy is a global time sheet policy which applies to all the users who are not assigned to any other time sheet policy.

Set up the OAuth application on the Google Sheets API so that you can authenticate requests from your ServiceNow instance to access Google Sheets.

Integrate your ServiceNow instance and Google Cloud Console so that you can export table records directly to the cloud-based Google Sheets in Google Drive. With this integration, you can view, share, and work on data outside the platform by using spreadsheets.

Learn about the role storage aliases play in data manipulation and field creation in the ServiceNow AI Platform.

As a time card user, once a time card for the week is updated with the time worked, you can submit the time card individually.

As a user manager, you can log time and submit the time sheet of your resources.

Once the time sheet is updated with time worked, you can submit the time sheet for the week to submit all the time cards for the week together.

Once you update the time sheet with time worked for a given week, submit it for approval.

Use system properties to export the display value or raw value of fields and the field label or field name for headers.

Administrators can activate the Time Card Management plugin (com.snc.time_card). The plugin also activates the Performance Analytics - Content Pack - Project Portfolio Suite Dashboards plugin (com.snc.pa.time_card). However, you need a Performance Analytics license to use the dashboards.

Specify the table to join to the database view.

Automatically assign a record according to one or more conditions in an assignment rule. Assignment rules are designed to run at the time you open a record.

If the number of records to be exported exceeds the actual export limit, you may want to break the export into smaller increments that do not place a significant performance load on the platform.

Dynamically export data from a script or web service by calling a URL export from any programming language.

You can configure the planned task fields to roll up the field values in the parent entity.

Create the database view.

Create a bi-directional relationship between two tables, so that the related records are visible from both tables in a related list.

Customize the Planned Task Interceptor to control what type of planned task record users can create and what choices they see when creating new planned tasks.

Administrators and application developers can create custom tables to store application data. After you create a table, you can also modify field types and field labels.

You can create time cards to log time against the work you have done.

Build indexes to access the data held in your tables more easily.

Automatically assign a record using Data Lookup and Record Matching.

Use a dictionary override to allow a field in a child table to have a different value or behavior than the same field in a parent table. For example, a dictionary override changes the default value of the priority field from 4 in the parent table to 5 in the Incident table.

Create type codes that define the relationship between parent and child tasks.

Define the Task Relationships Allowed from the Task Relationship Type record.

If you no longer need a custom table, you can delete it after you delete all the records in the table.

You may decide to delete all the records on a table without deleting the table itself. For example, the administrator may want to delete all incidents on a test instance without deleting the incident table itself.

Dynamically export data from a script or web service by building a URL query.

Generate a schema map to view different parts of the database schema.

Modify dictionary entries by configuring a field on a form or from the Dictionary module.

The list view of the Reference Lookup defines the fields displayed in the Task Relations field and editing interface.

The Task Hierarchy tool available for Planned Task displays the relationship between parent and child planned tasks.

Sometimes, two different tables may have fields of the same name that are both important (such as two tables with a sys_updated_on field). For clarity, relabel one of the fields.

The Many to Many Task Relations plugin (com.snc.task_relations) is included with several plugins. You can request activation of the plugin by itself.

You can recover deleted records that are in audited tables.

Determine the extension model used by a table.

Verify that the database view works correctly.

Enable one or more child tables to share fields and records with a parent table. Administrators and application developers can only extend tables during table creation.

You can create relationships between tables by extending tables, referencing records in another table, creating many-to-many relationships, and joining tables in a database view.

ServiceNow provides options for managing your data on the ServiceNow AI Platform.

The Task table structure provides a framework to organize and store task-related data, and includes extensive customization options.

Test read-only behavior on a non-production instance before updating Read only option field values on your production instance.

The Time Card Management feature enables time card users such as task assignees to report and track their time for the assigned tasks.

Time sheet policies contain the policies to which a time sheet, or a time card must adhere.

A time sheet groups all the time cards for a user for the given week.

Administrators can modify the database structure using table administration tools.

Time Sheet Portal categorizes and displays all your assigned tasks in a single view for a given week. The portal enables you to record time spent on tasks on a day-to-day basis and submit the time sheet in a single action.