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.

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.
Requested Allocation

[requested_allocation]

Allocations for resource plans.
Resource Event

[resource_event]

All resource events for users.
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.

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 Update
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.