RPT_DIM_PROGRAMS_MV

This is a materialized view on top of PPM's PGM_PROGRAMS, PFM_PORTFOLIOS, and PFM_PORTFOLIO_CONTENTS tables.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

PROGRAM_ID

NOT NULL

NUMBER

ID of the program derived from PGM_PROGRAMS table

PROGRAM_NAME

NULLABLE

VARCHAR2(255)

Name of the program

FINANCIAL_SUMMARY_ID

NULLABLE

NUMBER

ID of a financial summary associated with this program derived from PGM_PROGRAMS table.

PORTFOLIO_ID NULLABLE NUMBER ID of the portfolio this program belongs to
PORTFOLIO_NAME NULLABLE VARCHAR2(200) Name of the portfolio this program belongs to

USER_DATA1-20

NULLABLE

VARCHAR2(255)

User data segment

VISIBLE_USER_DATA1-20

NULLABLE

VARCHAR2(255)

User data segment

REQUEST_ID NOT NULL NUMBER ID of the program request
PROGRAM_TYPE_ID NULLABLE NUMBER ID of the program type
PROGRAM_TYPE_NAME NULLABLE VARCHAR2 (255) Name of the program type
DISPLAY_STATUS NULLABLE VARCHAR2 (255) Status of the program
OVERALL_HEALTH NULLABLE VARCHAR2 (10) The program overall health
RISK_HEALTH NULLABLE VARCHAR2 (10) Risk health of the program
ISSUES_HEALTH NULLABLE VARCHAR2 (10) Issue health of the program
SCOPE_CHANGE_HEALTH NULLABLE VARCHAR2 (10) Scope change health of the program

Indexes

Index Name

Index Type

Sequence

Column Name

PKC_PGM_PROGRAMS1

UNIQUE

1

PROGRAM_ID

RPT_DIM_PROGRAMS_MV_N5

NONUNIQUE

1

PROGRAM_NAME

RPT_DIM_PROGRAMS_MV_N3 NONUNIQUE 1 PORTFOLIO_ID

Sequences

This table uses no sequences.