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.
