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.