Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close

Tables installed with Project Portfolio Suite with Financials

Tables installed with Project Portfolio Suite with Financials

Project Portfolio Suite with Financials tables

Project Portfolio Suite with Financials adds the following tables.
Table Description
Cost Plan

[cost_plan]

Cost plan for the resources required for the project.
Cost Plan Breakdown

[cost_plan_breakdown]

Cost breakdown of resources based on project, program, or portfolio. These records are rollups of all costs. Project task cost plans are not rolled up to the project.
Cost Type Definition

[resource_type_definition]

Definitions of cost types, which specify either an operating expense or capital expense, and can link accounts in the General Ledger [itfm_gl_accounts] table. The General Ledger table is installed with the Financial Management application.
Project Funding

[project_funding]

Project or demand target and budget expense values for both capital and operating expenses. The records in this table are for a single fiscal year.
Benefit Plan

[benefit_plan]

Benefit plan for the potential benefits which can be accrued by the project or demand.
Benefit Breakdown

[benefit_plan_breakdown]

Benefit breakdown for the project or demand. These records are rollups of all benefits.

Project Portfolio Suite tables

Project Portfolio Suite adds the following tables.
Table Description
Project Time Card Exception

[project_timecard_exception]

Stores time card information such as Week starts on, User, Project, and State of the time cards.
Project Time Category

[project_time_category]

Stores project sub-categories created for time cards.
Time Sheet Exception

[time_sheet_exception]

Stores time sheet information such as Week starts on, User, and State of the time sheets.

Demand management tables

Demand management adds the following tables.
Table Description
Demand

[dmn_demand]

Stores all demands.
Decision

[dmn_decision]

Stores all decisions.
Stakeholder Register

[dmn_stakeholder_register]

Stores all stakeholders.
Requirement

[dmn_requirement]

Stores all requirements.
Demand Stakeholder

[dmn_m2m_demand_stakeholder]

Stores all stakeholders who are associated with one or more demands.
Demand Stage Config

[dmn_stage_config]

Stores the images displayed in the demand stage pop-up window.
Idea

[idea]

Stores all ideas.

Project management tables

Project management adds the following tables.
Table Description
Goal

[goal]

Project goals.
Issue

[issue]

Project issues.
Personalize Workbench

[workbench_config_user]

Configuration settings for each user that utilizes the workbench.
Portfolio

[pm_portfolio]

Portfolios.
Portfolio Project

[pm_portfolio_project]

Portfolio projects.
Portfolio Project Goal

[pm_portfolio_goal]

Portfolio project goals.
Portfolio Project Issue

[pm_portfolio_issue]

Portfolio project issues.
Portfolio Project Relationships

[pm_m2m_portfolio_project]

All relationships between a portfolio and each project in the portfolio.
Portfolio Project Risk

[pm_portfolio_risk]

Portfolio project risks.
Project

[pm_project]

All projects.
Project Task

[pm_project_task]

All tasks used in projects.
Project Task Link

[pm_project_task_link]

All records for linked changes (installed with the v3 plugin).
Project Template

[project_template]

Project templates.
Project Template Configuration

[project_template_config]

Configuration settings for project templates.
Project Template Task

[project_template_task]

Tasks in project templates.
Risk

[risk]

Project risks.
Project Change Request

[project_change_request]

Project change requests.
Status Report

[project_status]

Project status reports.
Teamspace

[pm_app_config]

All teamspaces, which refer to the tables that are created for the teamspaces. See Installed with teamspaces for a list of teamspace tables.
Planned task Relationship

[planned_task_rel_planned_task]

Predecessor and successor tasks in a dependent relationship, including task lag values.
Baseline

[planned_task_baseline]

All baselines.
Baseline Item

[planned_task_baseline_item]

All tasks that are part of baselines.
Task Relationship

[task_rel_task]

Predecessor and successor tasks in a dependent relationship.
Planned task Recalculation Exclusions

[planned_task_recalculation_exclusions]

Tables to be excluded during recalculation in planning console.

Program management tables

Program management adds the following tables.
Table Description
Program Task

[pm_program_task]

All the tasks in program
Program

[pm_program]

All programs

Resource management tables

Resource management adds the following tables.
Table Description
Resource Allocation

[resource_allocation]

Allocations for resources.
Resource Allocation Daily

[resource_allocation_daily]

On a day-to-day basis, stores the events that are created through a resource plan. Also stores:
  • User created calendar events as records.
  • Actual hours that a user has spent on a task, project, or any other type of activity, such as meeting or admin work.
Resource Aggregate Daily

[resource_aggregate_daily]

On a day-to-day basis, stores aggregated values, such as capacity, allocated hours in a project, confirmed hours in a project, non-project time, actual hours, and availability of every user.
Resource Aggregate Weekly

[resource_aggregate_weekly]

On a weekly basis, stores aggregated values, such as capacity, allocated hours in a project, confirmed hours in a project, non-project time, actual hours, and availability of every user. The values in the table are asynchronously updated on every insert/update/delete to the Resource Allocation Daily [resource_allocation_daily] table.
Resource Aggregate Monthly

[resource_aggregate_monthly]

On a monthly basis, stores aggregated values, such as capacity, allocated hours in a project, confirmed hours in a project, non-project time, actual hours, and availability of every user. The values in the table are asynchronously updated on every insert/update/delete to the Resource Allocation Daily [resource_allocation_daily] table.
Requested Allocation

[requested_allocation]

Allocations for resource plans.
Resource Event Color

[resource_event_color]

The colors that the application displays for each event type.
Resource Plan

[resource_plan]

All resource plans. These columns were added for Helsinki: top_task, program, portfolio.
Resource Report

[resource_report]

Resource reports that you can generate and save.
Resource Report Chart

[resource_report_chart]

This table is not used.
Resource Report Daily

[resource_report_daily]

Daily resource reports that you can generate and save.
Resource Report Export

[resource_report_export]

Saves JPG and PNG exports of resource management reports.
Resource Report Monthly

[resource_report_monthly]

Monthly resource reports that you can generate and save.
Resource Role

[resource_role]

Stores project specific roles.
User Resource Role

[user_has_resource_role]

Stores the resource roles for a user.
User Calendar Event

[user_calendar_event]

Stores events that are created in the calendar of a user.

Test management tables

Test management adds the following tables.
Table Description
Test Case

[tm_test_case]

Stores the test cases.
Test Case Instance

[tm_test_case_instance]

Extends the Planned Task table.
Test Suite

[tm_test_suite]

Stores the test suites.
Test Environment

[tm_test_environment]

Stores the test environments.
Test

[tm_test]

Stores the tests
Test Instance

[tm_test_instance]

Stores the tests under a test plan.
Test Plan

[tm_test_plan]

Stores the test plans. Extends the Planned Task table.
Test Case Defects

[m2m_tm_test_case_instance_defect]

Stores the test case defects that are recorded for failed tests.

Agile development tables

Agile development adds the following tables.
Table Description
Agile development tables
Application Model

[cmdb_application_product_model]

Represents whole product whose releases are being managed.
Release Product

[m2m_product_release]

Represents all managed products.
Story Dependencies

[m2m_story_dependencies]

Represents all related stories (prerequisite and dependent) to an existing story.
Scrum task

[rm_scrum_task]

Represents a discrete amount of work for a story carried out during a sprint.
Release team member

[scrum_pp_release_team_member]

Represents the list of users who are part of a release.
Sprint team member

[scrum_pp_sprint_team_member]

Represents the list of users who are part of a sprint.
Team

[scrum_pp_team]

Represents who completes scrum tasks and stories during releases and sprints.
Team name

[scrum_pp_team_name]

Represents the name of the scrum team.
Theme

[scrum_theme]

Represents either a tangible product (such as a trading application) or an abstract goal (such as performance tuning).
SDLC Scrum tables
Scrum release

[rm_release_scrum]

Represents individual versions (releases) of the product. Each release contains a list of sprints with a time range in which the stories in those sprints must be completed.
Sprint

[rm_sprint]

Stores sprints, which are the backlog items to be addressed together during a given time period.
Epic

[rm_epic]

Represents related stories or requirements that you have not yet transformed into stories.
Story

[rm_story]

Represents self-contained pieces of work that can be completed within a sprint.
Software Development Life Cycle (SDLC) tables
Defect

[rm_defect]

Represents a deviation from the expected behavior of a product.
Documentation Task

[rm_doc]

Represents documentation tasks for the product.
Enhancement

[rm_enhancement]

Represents an improvement to an existing product.
SDLC release

[rm_release_sdlc]

Represents individual versions of the product.
Testing Task

[rm_test]

Represents testing tasks for the product.

Time card management tables

Time card management adds the following tables.
Table Description
Time Card

[time_card]

Stores time logged by the user against a category such as a task, meeting, or training.
Time Sheet

[time_sheet]

Groups all time cards for the user for a week.
Time Sheet Policy

time_sheet_policy

Stores all time sheet policies.