KCRT_FG_PFM_ASSET_INT
This table stores information for importing Portfolio Management assets into the KCRT_FG_PFM_ASSET table.
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 |
---|---|---|---|
PFM_ASSET_INTERFACE_ID |
NULLABLE |
NUMBER |
System-generated identifier |
GROUP_ID |
NOT NULL |
NUMBER |
DB Transaction group ID |
TRANSACTION_ID |
NOT NULL |
NUMBER |
Transaction ID |
PARENT_TRANSACTION_ID |
NOT NULL |
NUMBER |
Parent transaction ID. This is usually request transaction ID. |
PROCESS_PHASE |
NULLABLE |
NUMBER |
Processing phase |
PROCESS_STATUS |
NULLABLE |
NUMBER |
Processing status. |
REQUEST_ID |
NULLABLE |
NUMBER |
Request ID of the PFM asset |
REQUEST_TYPE_ID |
NULLABLE |
NUMBER |
Request type ID |
ASSET_NAME |
NULLABLE |
VARCHAR2(300) |
Name of 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_BENEFIT_MANAGER_USER_ID |
NULLABLE |
VARCHAR2(4000) |
Benefit manager 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 name for the asset |
ASSET_FINANCIAL_SUMMARY_ID |
NULLABLE |
NUMBER |
Financial summary ID the asset |
ASSET_PROJECT_MANAGER_USER_ID |
NULLABLE |
VARCHAR2(4000) |
Project manager user ID for the asset |
ASSET_PROJECT_MANAGER_USERNAME |
NULLABLE |
VARCHAR2(4000) |
Project manager user name for the asset |
ASSET_REGION_ID |
NULLABLE |
NUMBER |
Region ID for the asset |
ASSET_REGION_NAME |
NULLABLE |
VARCHAR2(1500) |
Region name for the asset |
ASSET_DEPENDENCIES_CODE |
NULLABLE |
VARCHAR2(500) |
Dependency code for the asset |
ASSET_DEPENDENCIES_MEANING |
NULLABLE |
VARCHAR2(2000) |
Meaning of the dependencies for the asset |
ASSET_PORTFOLIO_ID |
NULLABLE |
NUMBER |
Unique identifier of the asset portfolio |
ASSET_PORTFOLIO_NAME |
NULLABLE |
VARCHAR2(1500) |
Asset portfolio name |
ASSET_PROGRAM_ID |
NULLABLE |
VARCHAR2(4000) |
Unique identifier of the asset program |
ASSET_PROGRAM_NAME |
NULLABLE |
VARCHAR2(4000) |
Asset programe name |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KCRT_FG_PFM_ASSET_INT_N1 |
NONUNIQUE |
1 |
GROUP_ID |
KCRT_FG_PFM_ASSET_INT_N1 |
NONUNIQUE |
2 |
TRANSACTION_ID |
KCRT_FG_PFM_ASSET_INT_N2 |
NONUNIQUE |
1 |
REQUEST_ID |
Sequences
This table uses no sequences.