PFM_PORTFOLIO_CONTENTS
This table stores the relationships between portfolios and their contents (i.e. sub portfolios, linked programs and linked lifecycle entities). The contents are represented by their financial summary IDs since the contents and their financial summaries have 1 to 1 relationship.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
FM_FINANCIAL_SUMMARY |
FINANCIAL_SUMMARY_ID |
FINANCIAL_SUMMARY_ID |
PFM_PORTFOLIOS |
PORTFOLIO_ID |
PORTFOLIO_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
PORTFOLIO_ID |
NOT NULL |
NUMBER |
ID of the parent portfolio |
FINANCIAL_SUMMARY_ID |
NOT NULL |
NUMBER |
Financial summary ID of the child portfolio, linked program, or linked lifecycle entity. |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
PFM_CONTENTS_PK |
UNIQUE |
1 |
PORTFOLIO_ID |
PFM_CONTENTS_PK |
UNIQUE |
2 |
FINANCIAL_SUMMARY_ID |
Sequences
This table uses no sequences.