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.