Tables installed with PPM Standard (Project Portfolio Management)

Tables are added with activation of PPM Standard plugin.

PPM Standard tables

PPM Standard 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 that the project or demand can accrue.
Benefit Breakdown [benefit_plan_breakdown]	Benefit breakdown for the project or demand. These records are rollups of all benefits.
Budget Reference Rates [itfm_fx_rate]	The exchange rates that budgets use.

Project Portfolio Suite tables

Project Portfolio Suite adds the following tables.

Table	Description
Project Stakeholder [pm_m2m_project_stakeholder]	Stores all stakeholders who are associated with one or more projects.
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.
Demand Task [dmn_demand_task]	Stores tasks associated with demands. Extends the planned_task table to support demand-level task tracking and resource allocation.

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]	Defines tables that are excluded from recalculation (start and end dates). For example, the table is used for all sub tables under planned_task to exclude tables from being recalculated. This table allows you to configure the tables from which you would not like to perform the recalculation from.

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
Group Resource Roles group_has_resource_role	Stores the resource roles for the groups with pps_resource_role. The roles in this table are populated from the User Resource Role [user_has_resource_role] table of the users that are part of a group. The table is read-only.
Requested Allocation Daily [requested_allocation_daily]	Stores day-level breakdown for requested allocations. The table is read-only.
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. This table is not enabled by default. To generate daily aggregates and store them in this table, create the com.snc.resource_management.generate_daily_aggregates property and set the value to true.
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 [resource_event]	Stores events that are created for a user.
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 Plan Logs [resource_plan_logs]	Stores errors and warning that might occur during the resource allocation for a resource plan.
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.
User Schedule [user_has_schedule]	Stores the schedule for a user.

Innovation management tables

Innovation Management adds the following tables.

Table	Description
Idea [im_idea_core]	Default table which stores all the information related to the Idea portal. Extends the Task table.
Idea Category [im_category]	Stores the list of static idea categories.
Idea Category Configuration [im_category_config]	Stores idea category definition information such as the table to use, field name, and hierarchy of the idea category. Also stores mapping information between idea categories table and the Idea module.
Idea Categories [im_m2m_idea_category]	Stores mapping information between idea categories and ideas.
Idea Module [im_module]	Configuration for the Idea portal such as module name, module id, and idea table to use. Create a separate table for each Idea module.

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.
Time Card Daily [time_card_daily]	Stores the time logged in a time card on daily basis.

Rate model tables

Rate model add the following tables.

Table	Description
Rate Model [rate_model]	Stores rate model definition.
Rate Model Entity [rate_model_entity]	List of entities from which the attributes can be selected.
Rate Model Entity Attribute [rate_model_entity_attribute]	List of attributes in the entities.
Rate Model Line [rate_model_line]	Stores rate line values.
Rate Model Line Attribute [rate_model_line_attribute]	Stores rate line attributes that are added from the entities.
Rate Line Import Set [imp_rate_model_line]	Stores import sets that you imported into the instance.