KCRT_FG_PFM_ASSET

This table stores PFM asset.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KPMO_BUSINESS_OBJECTIVES_NLS

BUSINESS_OBJECTIVE_ID

ASSET_BUSINESS_OBJECTIVE_ID

PM_PROJECTS

PROJECT_ID

ASSET_PROJECT_ID

RSC_STAFFING_PROFILES

STAFFING_PROFILE_ID

ASSET_STAFF_PROF_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 the PFM asset

REQUEST_TYPE_ID

NOT NULL

NUMBER

Request type ID

ASSET_NAME

NOT NULL

VARCHAR2(300)

Name for the Asset

ASSET_HEALTH_CODE

NULLABLE

VARCHAR2(30)

Health information for asset

ASSET_HEALTH_MEANING

NULLABLE

VARCHAR2(80)

Health meaning for asset

ASSET_BUSINESS_UNIT_CODE

NULLABLE

VARCHAR2(30)

Business unit code for asset

ASSET_BUSINESS_UNIT_MEANING

NULLABLE

VARCHAR2(80)

Business unit Meaning for asset

ASSET_BUSINESS_OBJECTIVE_ID

NULLABLE

NUMBER

Business objective ID for asset

ASSET_BUSINESS_OBJECTIVE_NAME

NULLABLE

VARCHAR2(80)

Business objective name for asset

ASSET_PROJECT_CLASS_CODE

NULLABLE

VARCHAR2(30)

Project class code for asset

ASSET_PROJECT_CLASS_MEANING

NULLABLE

VARCHAR2(80)

Project class meaning for asset

ASSET_ASSET_CLASS_CODE

NULLABLE

VARCHAR2(30)

Asset class code for asset

ASSET_ASSET_CLASS_MEANING

NULLABLE

VARCHAR2(80)

Asset class meaning for asset

ASSET_PROJECT_ID

NULLABLE

NUMBER

Project ID for asset

ASSET_PROJECT_NAME

NULLABLE

VARCHAR2(300)

Project name for asset

ASSET_PROJECT_URL

NULLABLE

VARCHAR2(250)

Project URL for asset

ASSET_STAFF_PROF_ID

NULLABLE

NUMBER

Staffing profile ID for asset

ASSET_STAFF_PROF_NAME

NULLABLE

VARCHAR2(300)

Staffing profile name for asset

ASSET_RETURN_ON_INVESTMENT

NULLABLE

NUMBER

ROI for asset

ASSET_NET_PRESENT_VALUE

NULLABLE

NUMBER

NPV for asset

ASSET_CUSTOM_FIELD_VALUE

NULLABLE

NUMBER

Custom financial metric value for asset

ASSET_VALUE_RATING

NULLABLE

NUMBER

Value for score of score domain "Value"

ASSET_RISK_RATING

NULLABLE

NUMBER

Value for score of score domain "Risk"

ASSET_TOTAL_SCORE

NULLABLE

NUMBER

Total score for asset

ASSET_DISCOUNT_RATE

NULLABLE

NUMBER

Discount rate for asset

ASSET_DEPENDENCIES_CODE

NULLABLE

VARCHAR2(500)

Asset dependency code for asset

ASSET_DEPENDENCIES_MEANING

NULLABLE

VARCHAR2(2000)

Asset dependency meaning for asset

ASSET_PROJECT_MANAGER_USER_ID

NULLABLE

VARCHAR2(4000)

User ID for asset project manager

ASSET_PROJECT_MANAGER_USERNAME

NULLABLE

VARCHAR2(4000)

User name for asset project manager

ASSET_REGION_ID

NULLABLE

NUMBER

Region ID for asset

ASSET_REGION_NAME

NULLABLE

VARCHAR2(1500)

Region name for asset

ASSET_BENEFIT_MANAGER_USER_ID

NULLABLE

VARCHAR2(4000)

Benefit manager user ID for the asset

ASSET_BENEFIT_MANAGER_USERNAME

NULLABLE

VARCHAR2(4000)

Benefit manager name for the asset

ASSET_FINANCIAL_SUMMARY_NAME

NULLABLE

VARCHAR2(1500)

Financial summary ID for the asset

ASSET_FINANCIAL_SUMMARY_ID

NULLABLE

NUMBER

Financial summary name for the asset

ASSET_PORTFOLIO_ID

NULLABLE

NUMBER

Portfolio ID for the asset

ASSET_PORTFOLIO_NAME

NULLABLE

VARCHAR2(1500)

Portfolio name for the asset

ASSET_PROGRAM_ID

NULLABLE

VARCHAR2(4000)

Ids of the programs containing this asset

ASSET_PROGRAM_NAME

NULLABLE

VARCHAR2(4000)

Names of the programs containing this asset

Indexes

This table uses no indexes.

Sequences

This table uses no sequences.