Share this page

# KCRT_FG_PFM_PROPOSAL

This table stores PFM proposals.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
PM_PROJECTS | PROJECT_ID | PROP_PROJECT_ID
KNTA_USERS | USER_ID | PROP_PROJECT_MANAGER_USER_ID
RSC_STAFFING_PROFILES | STAFFING_PROFILE_ID | PROP_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 for proposal
REQUEST_TYPE_ID | NOT NULL | NUMBER | Request Type ID
PROPOSAL_NAME | NOT NULL | VARCHAR2(300) | Proposal name
PROP_BUSINESS_UNIT_CODE | NULLABLE | VARCHAR2(30) | Business unit code for proposal
PROP_BUSINESS_UNIT_MEANING | NULLABLE | VARCHAR2(80) | Business unit meaning for proposal
PROP_BUSINESS_OBJECTIVE_ID | NULLABLE | NUMBER | Business objective ID for proposal
PROP_BUSINESS_OBJECTIVE_NAME | NULLABLE | VARCHAR2(80) | Business objective name for proposal
PROP_PROJECT_CLASS_CODE | NULLABLE | VARCHAR2(30) | Project class code for proposal
PROP_PROJECT_CLASS_MEANING | NULLABLE | VARCHAR2(80) | Project class meaning for proposal
PROP_ASSET_CLASS_CODE | NULLABLE | VARCHAR2(30) | Asset class code for proposal
PROP_ASSET_CLASS_MEANING | NULLABLE | VARCHAR2(80) | Asset class meaning for proposal
PROP_PROJECT_MANAGER_USER_ID | NULLABLE | VARCHAR2(4000) | Project manager for proposal
PROP_PROJECT_MANAGER_USERNAME | NULLABLE | VARCHAR2(4000) | Project manager username for proposal
PROP_STAFF_PROF_ID | NULLABLE | NUMBER | Staffing profile ID for proposal
PROP_STAFF_PROF_NAME | NULLABLE | VARCHAR2(300) | Staffing profile name for proposal
PROP_RETURN_ON_INVESTMENT | NULLABLE | NUMBER | ROI for proposal
PROP_NET_PRESENT_VALUE | NULLABLE | NUMBER | NPV for proposal
PROP_CUSTOM_FIELD_VALUE | NULLABLE | NUMBER | Financial metric for proposal
PROP_VALUE_RATING | NULLABLE | NUMBER | Score for score domain of "Value".
PROP_RISK_RATING | NULLABLE | NUMBER | Score for score domain of "Risk".
PROP_TOTAL_SCORE | NULLABLE | NUMBER | Total score for proposal
PROP_DISCOUNT_RATE | NULLABLE | NUMBER | Discount rate for proposal
PROP_PLAN_START_PERIOD_ID | NULLABLE | NUMBER | Period ID of the planned start date for the proposal
PROP_PLAN_FINISH_PERIOD_ID | NULLABLE | NUMBER | Period ID of the planned finish date for the proposal
PROP_PLAN_START_PERIOD_NAME | NULLABLE | VARCHAR2(100) | Period name of the planned start date for the proposal
PROP_PLAN_FINISH_PERIOD_NAME | NULLABLE | VARCHAR2(100) | Period name of the planned finish date for the proposal
PROP_PROJECT_ID | NULLABLE | NUMBER | Project ID for proposal
PROP_PROJECT_NAME | NULLABLE | VARCHAR2(300) | Project name for proposal
PROP_DEPENDENCIES_CODE | NULLABLE | VARCHAR2(500) | Dependency code for proposal
PROP_DEPENDENCIES_MEANING | NULLABLE | VARCHAR2(2000) | Dependency meaning for proposal
PROP_PROJECT_TYPE_ID | NULLABLE | NUMBER | Project type ID for proposal
PROP_PROJECT_TYPE_NAME | NULLABLE | VARCHAR2(1500) | Project type name for proposal
PROP_REGION_ID | NULLABLE | NUMBER | Region ID for proposal
PROP_REGION_NAME | NULLABLE | VARCHAR2(1500) | Region name for proposal
PROP_BENEFIT_MANAGER_USER_ID | NULLABLE | VARCHAR2(4000) | Name of the proposal's benefit manager
PROP_BENEFIT_MANAGER_USERNAME | NULLABLE | VARCHAR2(4000) | ID of the proposal's benefit manager
PROP_FINANCIAL_SUMMARY_NAME | NULLABLE | VARCHAR2(1500) | Name of the proposal's financial summary
PROP_FINANCIAL_SUMMARY_ID | NULLABLE | NUMBER | ID of the proposal's financial summary
PROP_APPROVED_SNAPSHOT_ID | NULLABLE | NUMBER | ID of the financial summary snapshot taken at the time when the proposal is approved
PROP_APPROVED_SNAPSHOT_NAME | NULLABLE | VARCHAR2(1500) | Name of the financial summary snapshot taken at the time when the proposal is approved
PROP_PORTFOLIO_ID | NULLABLE | NUMBER | ID of the portfolio to which the proposal is linked
PROP_PORTFOLIO_NAME | NULLABLE | VARCHAR2(1500) | Name of the portfolio to which the proposal is linked.
PROP_PROGRAM_ID | NULLABLE | VARCHAR2(4000) | IDs of the program containing this proposal
PROP_PROGRAM_NAME | NULLABLE | VARCHAR2(4000) | Names of the programs containing this proposal

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KCRT_FG_PFM_PROPOSAL_N1 | NONUNIQUE | 1 | PROP_BUSINESS_OBJECTIVE_ID
KCRT_FG_PFM_PROPOSAL_U3 | NONUNIQUE | 1 | PROP_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: