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.