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 |