PFM_BUSINESS_GOALS

This table stores portfolio business goals information.

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

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