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.