PFM_PORTFOLIOS

This table stores PFM Portfolios.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

FM_FINANCIAL_SUMMARY

FINANCIAL_SUMMARY_ID

FINANCIAL_SUMMARY_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

PFM_PORTFOLIOS

PORTFOLIO_ID

PARENT_PORTFOLIO_ID

ITG_SECURABLE_ENTITIES

SECURABLE_ENTITY_ID

SECURABLE_ENTITY_ID
PFM_PORTFOLIO_TYPES SETTINGS_CONTAINER_ID PF_SETTINGS_ID
ITG_SETTINGS_CONTAINERS PORTFOLIO_TYPE_ID PORTFOLIO_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PORTFOLIO_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

VERSION

NOT NULL

NUMBER

System-generated version, used for hibernate version control.

NAME

NOT NULL

VARCHAR2(200)

Name of the portfolio

PARENT_PORTFOLIO_ID

NULLABLE

NUMBER

ID of the parent portfolio

FINANCIAL_SUMMARY_ID

NOT NULL

NUMBER

ID of the portfolio's financial summary

SECURABLE_ENTITY_ID

NOT NULL

NUMBER

ID of the portfolio's security entity
STRATEGIC_THEMES_TYPE NULLABLE VARCHAR2(10 CHAR)

The type of strategic themes the portfolio uses:

  • GLOBAL: globally defined strategic themes
  • INHERIT: strategic themes inherited from the parent portfolio
  • PORTFOLIO: strategic themes created by the portfolio
PORTFOLIO_TYPE_ID NULL NUMBER(19,0) Primary key in table PFM_PORTFOLIO_TYPES
PF_SETTINGS_ID NULL NUMBER(19,0) Primary key in table ITG_SETTINGS_CONTAINERS

Indexes

Index Name

Index Type

Sequence

Column Name

PFM_PORTFOLIOS_N1

NONUNIQUE

1

PARENT_PORTFOLIO_ID

PFM_PORTFOLIOS_N2

NONUNIQUE

1

FINANCIAL_SUMMARY_ID

PFM_PORTFOLIOS_PK

UNIQUE

1

PORTFOLIO_ID

PFM_PORTFOLIOS_U1

UNIQUE

1

NAME
PFM_PORTFOLIOS_N3 NONUNIQUE 3 PF_SETTINGS_ID
PFM_PORTFOLIOS_N4 NONUNIQUE 4 PORTFOLIO_TYPE_ID

Sequences

Sequence Name

Sequence Type

PFM_PORTFOLIOS_S

PORTFOLIO_ID