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.