Share this page

# 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.

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: