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.