Share this page

# KCRT_FG_PFM_PROGRAM_INT

This table is used for importing PFM programs into the KCRT_FG_PFM_PROGRAM table.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PFM_PROGRAM_INTERFACE_ID | NULLABLE | NUMBER | System-generated identifier
GROUP_ID | NOT NULL | NUMBER | DB transaction group ID
TRANSACTION_ID | NOT NULL | NUMBER | Transaction ID
PARENT_TRANSACTION_ID | NOT NULL | NUMBER | Parent transaction ID
PROCESS_PHASE | NULLABLE | NUMBER | Processing phase
PROCESS_STATUS | NULLABLE | NUMBER | Processing status
REQUEST_ID | NULLABLE | NUMBER | Request ID for the program
REQUEST_TYPE_ID | NULLABLE | NUMBER | Request type ID
PROGRAM_NAME | NULLABLE | VARCHAR2 (300) | Name of the program
PROGRAM_HEALTH_CODE | NULLABLE | VARCHAR2 (30) | Program health information code
PROGRAM_HEALTH_MEANING | NULLABLE | VARCHAR2 (80) | Project health information meaning
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 start 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 start 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

## 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: