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.
