Share this page

# KCRT_FG_PFM_PROGRAM

This table stores Portfolio Management programs.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
REQUEST_ID | NOT NULL | NUBERB | Request ID of the Portfolio Management program
REQUEST_TYPE_ID | NOT NULL | NUMBER | Request type ID of the program
PROGRAM_NAME | NOT NULL | VARCHAR2 (300) | Name of the program
PROGRAM_HEALTH_CODE | NULLABLE | VARCHAR2 (30) | Health code of the program
PROGRAM_HEALTH_MEANING | NULLABLE | VARCHAR2 (80) | Health meaning of the program
PGM_PROGRAM_MANAGER_USER_ID | NULLABLE | VARCHAR2 (4000) | Program manager ID of the program
PGM_PROGRAM_MANAGER_USERNAME | NULLABLE | VARCHAR2 (4000) | Program manager name of the program
PGM_PROGRAM_ID | NULLABLE | NUMBER | ID of the PFM program
PGM_PROGRAM_NAME | NULLABLE | VARCHAR2 (300) | Name of the PFM program
PGM_PROGRAM_URL | NULLABLE | VARCHAR2 (250) | URL of the PFM program
PGM_PLAN_START_PERIOD_ID | NULLABLE | NUMBER | Period ID of the planned started date of the program
PGM_PLAN_FINISH_PERIOD_ID | NULLABLE | NUMBER | Period ID of the planned finish date of the program
PGM_PLAN_START_PERIOD_NAME | NULLABLE | VARCHAR2 (100) | Period name of the planned started date of the program
PGM_PLAN_FINISH_PERIOD_NAME | NULLABLE | VARCHAR2 (100) | Period name of the planned finish date of the program
PGM_ACTUAL_START_DATE | NULLABLE | DATE | Actual start date of the program
PGM_ACTUAL_FINISH_DATE | NULLABLE | DATE | Actual finish date of the program
PGM_SCORE | NULLABLE | NUMBER | Score of the program
PGM_PRIORITY | NULLABLE | NUMBER | Priority of the program
PGM_PORTFOLIO_ID | NULLABLE | NUMBER | Portfolio ID of the program Note: This column is deprecated in version 2023.
PGM_PORTFOLIO_NAME | NULLABLE | VARCHAR2 (1500) | Portfolio name of the program Note: This column is deprecated in version 2023.
PGM_DESCRIPTION | NULLABLE | VARCHAR2 (4000) | Description of the program
PGM_BENEFIT | NULLABLE | VARCHAR2 (4000) |
PGM_STATUS_NOTES | NULLABLE | VARCHAR2 (4000) | Status notes of the program
PGM_PHASE_CODE | NULLABLE | VARCHAR2 (40) | Phase code of the program
PGM_PHASE_MEANING | NULLABLE | VARCHAR2 (150) | Phase meaning of the program

## Indexes

This table has no indexes.

## Sequences

This table uses no sequences.

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: