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