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

PRJ_PORTFOLIO_NAME

NULLABLE

VARCHAR2(1500)

Portfolio name for the project

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.