PM_PROGRAM_BUSINESS_OBJECTIVES

This is an internal table, it defines one to many relationship between program to business objective

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KPMO_BUSINESS_OBJECTIVES_NLS

BUSINESS_OBJECTIVE_ID

BUSINESS_OBJECTIVE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PROGRAM_ID

NOT NULL

NUMBER

System-generated identifier

BUSINESS_OBJECTIVE_ID

NULLABLE

NUMBER

ID of the business objective

BUSINESS_OBJECTIVE_SEQ

NOT NULL

NUMBER

internal value which identifies position of the business objective in the list of business objectives in the program

Indexes

Index Name

Index Type

Sequence

Column Name

PM_PROGRAM_BUSINESS_OBJ_N1

NONUNIQUE

1

BUSINESS_OBJECTIVE_ID

SYS_C005201552

UNIQUE

1

PROGRAM_ID

SYS_C005201552

UNIQUE

2

BUSINESS_OBJECTIVE_SEQ

Sequences

This table uses no sequences.