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.