PFM_PORTFOLIO_MILESTONE

This table stores portfolio milestones information.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

PORTFOLIO_MILESTONE_ID

NOT NULL

NUMBER

Identifier for the milestone

PORTFOLIO_MILESTONE_NAME

NOT NULL

VARCHAR2

Name of portfolio milestone

PORTFOLIO_ID

NOT NULL

NUMBER

Identifier for the portfolio

STATUS_CODE

NOT NULL

NUMBER

Code number of the portfolio milestone status

TYPE

NOT NULL

NUMBER

Type of the portfolio milestone

PLANNED_DATE

NOT NULL

DATE

Planned finish date of the portfolio

milestone

CREATED_BY

NOT NULL

NUMBER

Creator of the portfolio milestone

CREATION_DATE NOT NULL DATE Date when the portfolio milestone was created
LAST_UPDATED_BY NOT NULL NUMBER User who last updated the portfolio milestone
LAST_UPDATE_DATE NOT NULL DATE Date when the portfolio milestone was last updated

Indexes

This table does not have any indexes.

Sequences

Sequence Name

Sequence Type

PFM_PORTFOLIO_MILESTONES_S

PORTFOLIO_MILESTONE_ID