Share this page

# KCRT_FG_PFM_PROJECT

This table stores Portfolio Management projects.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KPMO_BUSINESS_OBJECTIVES_NLS | BUSINESS_OBJECTIVE_ID | PRJ_BUSINESS_OBJECTIVE_ID
PPM_FISCAL_PERIODS_NLS | FISCAL_PERIOD_ID | PRJ_PLAN_FINISH_PERIOD_ID
PPM_FISCAL_PERIODS_NLS | FISCAL_PERIOD_ID | PRJ_PLAN_START_PERIOD_ID
PM_PROJECTS | PROJECT_ID | PRJ_PROJECT_ID
KNTA_USERS | USER_ID | PRJ_PROJECT_MANAGER_USER_ID
RSC_STAFFING_PROFILES | STAFFING_PROFILE_ID | PRJ_STAFF_PROF_ID
KCRT_REQUESTS | REQUEST_ID | REQUEST_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | REQUEST_TYPE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
REQUEST_ID | NOT NULL | NUMBER | Request ID of Portfolio Management projects
REQUEST_TYPE_ID | NOT NULL | NUMBER | Request type ID
PROJECT_NAME | NOT NULL | VARCHAR2(300) | Project name
PROJECT_HEALTH_CODE | NULLABLE | VARCHAR2(30) | Project health info code
PROJECT_HEALTH_MEANING | NULLABLE | VARCHAR2(80) | Project health info meaning
PRJ_BUSINESS_UNIT_CODE | NULLABLE | VARCHAR2(30) | Business unit code of the project
PRJ_BUSINESS_UNIT_MEANING | NULLABLE | VARCHAR2(80) | Business unit meaning of the project
PRJ_BUSINESS_OBJECTIVE_ID | NULLABLE | NUMBER | Business objective ID of the project
PRJ_BUSINESS_OBJECTIVE_NAME | NULLABLE | VARCHAR2(80) | Business objective name of the project
PRJ_PROJECT_CLASS_CODE | NULLABLE | VARCHAR2(30) | Project class code of the project
PRJ_PROJECT_CLASS_MEANING | NULLABLE | VARCHAR2(80) | Project class meaning of the project
PRJ_ASSET_CLASS_CODE | NULLABLE | VARCHAR2(30) | Asset class code of the project
PRJ_ASSET_CLASS_MEANING | NULLABLE | VARCHAR2(80) | Asset class meaning of the project
PRJ_PROJECT_MANAGER_USER_ID | NULLABLE | VARCHAR2(4000) | Project manager for Portfolio Management project
PRJ_PROJECT_MANAGER_USERNAME | NULLABLE | VARCHAR2(4000) | Project manager username for Portfolio Management project
PRJ_PROJECT_ID | NULLABLE | NUMBER | Project ID for Portfolio Management project
PRJ_PROJECT_NAME | NULLABLE | VARCHAR2(300) | Project name for Portfolio Management project
PRJ_PROJECT_URL | NULLABLE | VARCHAR2(250) | Project URL for Portfolio Management project
PRJ_STAFF_PROF_ID | NULLABLE | NUMBER | Staffing profile ID of the project
PRJ_STAFF_PROF_NAME | NULLABLE | VARCHAR2(300) | Staffing profile name of the project
PRJ_RETURN_ON_INVESTMENT | NULLABLE | NUMBER | ROI of the project
PRJ_NET_PRESENT_VALUE | NULLABLE | NUMBER | NPV of the project
PRJ_CUSTOM_FIELD_VALUE | NULLABLE | NUMBER | Financial metric of the project
PRJ_VALUE_RATING | NULLABLE | NUMBER | Score for score domain "Value"
PRJ_RISK_RATING | NULLABLE | NUMBER | Score for score domain "Risk"
PRJ_TOTAL_SCORE | NULLABLE | NUMBER | Total score
PRJ_DISCOUNT_RATE | NULLABLE | NUMBER | Discount rate of the project
PRJ_PLAN_START_PERIOD_ID | NULLABLE | NUMBER | Period ID of the planned start date for the project
PRJ_PLAN_FINISH_PERIOD_ID | NULLABLE | NUMBER | Period ID of the planned finish date for the project
PRJ_PLAN_START_PERIOD_NAME | NULLABLE | VARCHAR2(100) | Period name of the planned start date for the project
PRJ_PLAN_FINISH_PERIOD_NAME | NULLABLE | VARCHAR2(100) | Period name of the planned finish date for the project
PRJ_DEPENDENCIES_CODE | NULLABLE | VARCHAR2(500) | Dependency code for Portfolio Management project
PRJ_DEPENDENCIES_MEANING | NULLABLE | VARCHAR2(2000) | Dependency meaning for Portfolio Management project
PRJ_PHASE_CODE | NULLABLE | VARCHAR2(40) | Project phase code for Portfolio Management project
PRJ_PHASE_MEANING | NULLABLE | VARCHAR2(150) | Project phase meaning for Portfolio Management project
PRJ_BENEFIT_MANAGER_USER_ID | NULLABLE | VARCHAR2(4000) | Benefit Manager ID for the project
PRJ_BENEFIT_MANAGER_USERNAME | NULLABLE | VARCHAR2(4000) | Benefit manager name for the project
PRJ_FINANCIAL_SUMMARY_NAME | NULLABLE | VARCHAR2(1500) | Financial summary name
PRJ_FINANCIAL_SUMMARY_ID | NULLABLE | NUMBER | Financial summary ID
PRJ_PORTFOLIO_ID | NULLABLE | NUMBER | Portfolio ID for the project. Note: This column is deprecated in version 2023.
PRJ_PORTFOLIO_NAME | NULLABLE | VARCHAR2(1500) | Portfolio name for the project Note: This column is deprecated in version 2023.
PRJ_PROGRAM_ID | NULLABLE | VARCHAR2(4000) | IDs of the programs containing this project
PRJ_PROGRAM_NAME | NULLABLE | VARCHAR2(4000) | Names of the programs containing this project

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KCRT_FG_PFM_PROJECT_N1 | NONUNIQUE | 1 | PRJ_BUSINESS_OBJECTIVE_ID
KCRT_FG_PFM_PROJECT_U1 | UNIQUE | 1 | REQUEST_ID
KCRT_FG_PFM_PROJECT_U2 | UNIQUE | 1 | PRJ_FINANCIAL_SUMMARY_ID
KCRT_FG_PFM_PROJECT_U3 | UNIQUE | 1 | PRJ_STAFF_PROF_ID

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