KCRT_FG_PFM_PROPOSAL_INT

This table is used for importing PFM proposals into the KCRT_FG_PFM_PROPOSAL table.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KPMO_BUSINESS_OBJECTIVES_NLS

BUSINESS_OBJECTIVE_ID

PROP_BUSINESS_OBJECTIVE_ID

PPM_FISCAL_PERIODS_NLS

FISCAL_PERIOD_ID

PROP_PLAN_FINISH_PERIOD_ID

PPM_FISCAL_PERIODS_NLS

FISCAL_PERIOD_ID

PROP_PLAN_START_PERIOD_ID

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_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PFM_PROPOSAL_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. This is usually request transaction ID.

PROCESS_PHASE

NULLABLE

NUMBER

Processing phase

PROCESS_STATUS

NULLABLE

NUMBER

Processing status.

REQUEST_ID

NULLABLE

NUMBER

Request ID for proposal

REQUEST_TYPE_ID

NULLABLE

NUMBER

Request Type ID

PROPOSAL_NAME

NULLABLE

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_PROJECT_TYPE_ID

NULLABLE

NUMBER

Project type ID for proposal

PROP_PROJECT_TYPE_NAME

NULLABLE

VARCHAR2(100)

Project type name 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

Net present value (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_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)

Benefit manager id

PROP_BENEFIT_MANAGER_USERNAME

NULLABLE

VARCHAR2(4000)

Benefit manager name

PROP_DEPENDENCIES_CODE

NULLABLE

VARCHAR2(500)

Dependency code

PROP_DEPENDENCIES_MEANING

NULLABLE

VARCHAR2(2000)

Dependency meaning

PROP_APPROVED_SNAPSHOT_ID

NULLABLE

NUMBER

Approved snapshot ID

PROP_APPROVED_SNAPSHOT_NAME

NULLABLE

VARCHAR2(1500)

Approved snapshot name

PROP_FINANCIAL_SUMMARY_ID

NULLABLE

NUMBER

Financial summary ID

PROP_FINANCIAL_SUMMARY_NAME

NULLABLE

VARCHAR2(1500)

Financial summary name

PROP_PORTFOLIO_ID

NULLABLE

NUMBER

Portfolio ID

PROP_PORTFOLIO_NAME

NULLABLE

VARCHAR2(1500)

Portfolio name

PROP_PROGRAM_ID

NULLABLE

VARCHAR2(4000)

Program ID

PROP_PROGRAM_NAME

NULLABLE

VARCHAR2(4000)

Program name

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_PFM_PROPOSAL_INT_N1

NONUNIQUE

1

GROUP_ID

KCRT_FG_PFM_PROPOSAL_INT_N1

NONUNIQUE

2

TRANSACTION_ID

KCRT_FG_PFM_PROPOSAL_INT_N2

NONUNIQUE

1

REQUEST_ID

Sequences

This table uses no sequences.