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 |
| PGM_PORTFOLIO_NAME | NULLABLE | VARCHAR2 (1500) | Portfolio name of the program |
| 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.
