Share this page

# PFM_BUSINESS_GOALS

This table stores portfolio business goals information.

In this topic:

## Foreign keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
PFM_BUSINESS_GOALS | BG_ID | BG_ID
PFM_KPIS | KPI_ID | KPI_ID
PFM_PORTFOLIOS | PORTFOLIO_ID | PORTFOLIO_ID

## Column descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
BG_ID | NOT NULL | NUMBER | System-generated identifier
BG_NAME | NOT NULL | VARCHAR2 (255) | Business goal name
BG_DESCRIPTION | NULLABLE | VARCHAR2 (4000) | Business goal description
BG_IS_OPTIMIZE_GOAL | NULLABLE | VARCHAR2 (1) | Y: Optimized business goal N: Targeted business goal
BG_STATUS | NOT NULL | VARCHAR2 (20) | Status of business goal NOTSTART ONTRACK ATRISK ACHIEVED MISSED ABANDONED
BG_TARGET_DATE | NULLABLE | DATE | Target date of the targeted business goal
BG_TARGET_VALUE | NULLABLE | NUMBER | Target value of the targeted business goal.
BG_RANK | NULLABLE | NUMBER | Rank of business goal
PORTFOLIO_ID | NOT NULL | NUMBER | Related portfolio ID of business goal
KPI_ID | NOT NULL | NUMBER | Related KPI ID of business goal
CREATED_ BY | NOT NULL | NUMBER | Identifier for the user who created the record
CREATION_ DATE | NOT NULL | DATE | Date when the record was created
LAST_ UPDATE_ DATE | NOT NULL | DATE | Date when the record was last updated
LAST_ UPDATED_ BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
VERSION | NOT NULL | NUMBER | Version
BG_START_DATE | NULLABLE | DATE | Start date of business goal
BG_OWNER_ID | NULLABLE | NUMBER | Owner ID of business goal
STRATEGIC_THEME_ID | NULLABLE | NUMBER | Related strategic theme ID of business goal
PORTFOLIO_TYPE_ID | NULLABLE | NUMBER | If the business goal is created by a portfolio type, the portfolio type ID is stored in this column.
PARENT_ID | NULLABLE | NUMBER | The ID of the business goal's parent.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
PFM_BUSINESS_GOALS_N1 | NONUNIQUE | 1 | PORTFOLIO_ID
PFM_BUSINESS_GOALS_N2 | NONUNIQUE | 1 | KPI_ID
PFM_BUSINESS_GOALS_PK | UNIQUE | 1 | BG_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
PFM_BUSINESS_GOALS_S | BG_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: