Share this page

# PGM_PROGRAM_TYPES

This table stores program types and program setting information.

In this topic:

## Foreign keys

This table does not have any foreign keys.

## Column descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PROGRAM_TYPE_ID | NOT NULL | NUMBER | System-generated ID for program type
VERSION | NOT NULL | NUMBER |
PROGRAM_TYPE_NAME | NULLABLE | VARCHAR2 (1) | Name of the program type
DESCRIPTION | NULLABLE | VARCHAR2 (650) | Description of the program type
ENABLED_FLAG | NULLABLE | VARCHAR2 (1) | Flags whether the program type is enabled
PROG_TYPE_SETTINGS_KEY | NULLABLE | VARCHAR2 (32) | System-generated version for the program type. This column must not be updated manually.
PROGRAM_REQUEST_TYPE_ID | NULLABLE | NUMBER | Request ID of the program type
CREATED_BY | NOT NULL | NUMBER | Creator of the program type
CREATION_DATE | NOT NULL | DATE | Creation date of the program type
LAST_UPDATED_BY | NOT NULL | NUMBER | User that last updated the program type
LAST_UPDATE_DATE | NOT NULL | DATE | Date when the program type is last updated
ISSUE_REQUEST_TYPE_ID | NULLABLE | NUMBER | ID of issue request type
RISK_REQUEST_TYPE_ID | NULLABLE | NUMBER | ID of risk request type
RISK_REQUEST_TYPE_NAME | NULLABLE | VARCHAR2 (255) | Name of risk request type
PROGRAM_REQUEST_TYPE_NAME | NULLABLE | VARCHAR2 (255) | Request name of the program type
ISSUE_REQUEST_TYPE_NAME | NULLABLE | VARCHAR2 (255) | Name of issue request type
PROGRAM_TYPE_EDIT_ACCESS_ID | NULLABLE | NUMBER | Stores edit access information for the program type entity. It references securable_entity_id of the itg_securable_entities table.
PROGRAM_TYPE_USAGE_ID | NULLABLE | NUMBER | Stores usage access information for the program type. It references securable_entity_id of the itg_securable_entities table.

## Indexes

This table has no indexes.

## Sequences

Sequence Name | Sequence Type
--- | ---
PGM_PROGRAM_TYPES_S | PROGRAM_TYPE_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: