PGM_PROGRAMS

This table stores the PPM Center Program entity information. This table was previously named PM_PROJECTS_CONTAINERS.

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

ITG_SECURABLE_ENTITIES

SECURABLE_ENTITY_ID

PROGRAM_ACCESS_ID

ITG_SECURABLE_ENTITIES

SECURABLE_ENTITY_ID

PROGRAM_COST_ACCESS_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PROGRAM_ID

NOT NULL

NUMBER

System-generated identifier

ENTITY_TYPE_CODE

NOT NULL

VARCHAR2(255)

Identifies type of the entity. The only valid value is PROGRAM

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column must not be updated manually
PROGRAM_TYPE_ID NULLABLE NUMBER ID of the program type where the program belongs
PGM_REQUEST_ID NULLABLE NUMBER Request ID of the program
DISPLAY_STATUS NULLABLE VARCHAR2 (255) Status of the program
OVERRIDE_DATE NULLABLE DATE Until date of the program overridden health
OVERRIDE_DESCRIPTION NULLABLE VARCHAR2 (750) Description of the program overridden health

PARENT_PROJECTS_CONTAINER_ID

NULLABLE

NUMBER

This field is deprecated and will be removed.

CONTAINER_NAME

NULLABLE

VARCHAR2(255)

Defines name of the entity

DEPTH

NULLABLE

NUMBER

This field is deprecated and will be removed.

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

DESCRIPTION

NULLABLE

VARCHAR2(4000)

Defines description of the entity

USER_DATA1-20

NULLABLE

VARCHAR2(255)

User data segment

VISIBLE_USER_DATA1-20

NULLABLE

VARCHAR2(255)

User data segment

STATUS_NOTES

NULLABLE

VARCHAR2(4000)

Provides notes for the status of the program

BENEFIT

NULLABLE

VARCHAR2(4000)

Provides benefits of the program

STATE

NULLABLE

NUMBER

Indicates status of the program

PRIORITY

NULLABLE

NUMBER

Indicates priority of the program

PROG_SETTINGS_KEY

NULLABLE

VARCHAR2(32)

Defines key in the ITG_SETTINGS_CONTAINERS table

ISSUES_HEALTH

NULLABLE

VARCHAR2(10)

Indicates issue health of the program

RISK_HEALTH

NULLABLE

VARCHAR2(10)

Indicates risk health of the program

SCOPE_CHANGE_HEALTH

NULLABLE

VARCHAR2(10)

Indicates scope change health of the program

PROGRAM_ACCESS_ID

NULLABLE

NUMBER

Defines access rights to the program. FK to ITG_SECURABLE_ENTITIES

PROGRAM_COST_ACCESS_ID

NULLABLE

NUMBER

Defines access rights to the cost information in the program. FK to ITG_SECURABLE_ENTITIES

CHILD_SEQ

NULLABLE

NUMBER

Internal value. Indicates index of the entity in the parent list

FINANCIAL_SUMMARY_ID

NULLABLE

NUMBER

ID of the program's financial summary

SCORE

NULLABLE

NUMBER

Score for program

OVERALL_HEALTH

NULLABLE

VARCHAR2(10)

Health for program

DISCOUNT_RATE

NULLABLE

NUMBER

Discount rate for program

NPV

NULLABLE

NUMBER

Net Present Value for program

TNR

NULLABLE

NUMBER

Total nominal return for program

ROLLUPABLE

NOT NULL

VARCHAR2(1)

Flag to indicate if this program can participate in a portfolio. The value is true if this program can be added to a portfolio.

Indexes

Index Name

Index Type

Sequence

Column Name

FKAE480BB5716474FD_I

NONUNIQUE

1

PARENT_PROJECTS_CONTAINER_ID

FKAE480BB5AA3D749_I

NONUNIQUE

1

PROGRAM_COST_ACCESS_ID

FKAE480BB5FF702AE_I

NONUNIQUE

1

PROGRAM_ACCESS_ID

PM_PROJECTS_CONTAINERS_N1

NONUNIQUE

1

PROG_SETTINGS_KEY

PM_PROJECTS_CONTAINERS_N2

NONUNIQUE

1

CONTAINER_NAME

PM_PROJECTS_CONTAINERS_N2

NONUNIQUE

2

ENTITY_TYPE_CODE

SYS_C005200292

UNIQUE

1

CONTAINER_NAME

SYS_C005201556

UNIQUE

1

PROGRAM_ID

Sequences

This table uses no sequences.