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

PFM_KPIS

KPI_ID

PFM_PORTFOLIOS

PORTFOLIO_ID

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.

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

Sequence Name	Sequence Type
PFM_BUSINESS_GOALS_S	BG_ID