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.