KCRT_FG_PFM_ASSET_INT

PFM_ASSET_INTERFACE_ID

I

NUMBER

System-generated identifier.

GROUP_ID

I/O

NUMBER

Groups all the records that should be processed at the same time.

Use only one GROUP_ID for each batch of imported users when running the User Open Interface report.

Derived from the KNTA_INTERFACE_GROUPS_S sequence.

This value should be the same as the parent's GROUP_ID in KCRT_REQUEST_INT.

TRANSACTION_ID

I/O

NUMBER

Uniquely identifies each transaction.

If left blank, the value is generated by the system.

PARENT_TRANSACTION_ID

I/O

NUMBER

Provides the transaction ID (from KCRT_REQUESTS_INT) of the parent table being imported.

PROCESS_PHASE

I

NUMBER

Indicates the current stage of the record as it is being processed.

See Process State Information.

PROCESS_STATUS

I

NUMBER

Indicates the current disposition of the record.

See Process State Information.

REQUEST_ID

I

NUMBER

Indicates the request ID of the PFM asset.

REQUEST_TYPE_ID

I

NUMBER

Identifies the request type.

This is normally left blank and is derived from REQUEST_TYPE_NAME.

ASSET_NAME

I

VARCHAR2

Indicates the name of the asset.

ASSET_HEALTH_CODE

I

VARCHAR2

Indicates the asset health information code generated by the system.

ASSET_HEALTH_MEANING

I

VARCHAR2

Indicates the asset health information meaning generated by the system

ASSET_BUSINESS_UNIT_CODE

I

VARCHAR2

Indicates the business unit code for asset.

ASSET_BUSINESS_UNIT_MEANING

I

VARCHAR2

Indicates the business unit Meaning for asset.

ASSET_BUSINESS_OBJECTIVE_ID

I

NUMBER

Indicates the business objective ID for asset.

ASSET_BUSINESS_OBJECTIVE_NAME

I

VARCHAR2

Indicates the business objective name for asset.

ASSET_PROJECT_CLASS_CODE

I

VARCHAR2

Indicates the project class code for asset.

ASSET_PROJECT_CLASS_MEANING

I

VARCHAR2

Indicates the project class meaning for asset.

ASSET_ASSET_CLASS_CODE

I

VARCHAR2

Indicates the asset class code for asset.

ASSET_ASSET_CLASS_MEANING

I

VARCHAR2

Indicates the asset class meaning for asset.

ASSET_PROJECT_PLAN_ID

I

NUMBER

Indicates the unique identifier of the project plan.

ASSET_PROJECT_PLAN_NAME

I

VARCHAR2

Indicates the name of the project plan.

ASSET_PROJECT_PLAN_URL

I

VARCHAR2

Indicates the Web address or URL associated with the project plan.

ASSET_STAFF_PROF_ID

I

NUMBER

Indicates Uniquely identifies the staff profile associated with the asset.

ASSET_STAFF_PROF_NAME

I

VARCHAR2

Indicates the name of the staff profile associated with the asset.

ASSET_RETURN_ON_INVESTMENT

I

NUMBER

Indicates the calculated value of the return on investment (ROI) of the asset.

ASSET_NET_PRESENT_VALUE

I

NUMBER

Indicates the NPV for asset.

ASSET_CUSTOM_FIELD_VALUE

I

NUMBER

Indicates the custom financial metric value for asset.

ASSET_VALUE_RATING

I

NUMBER

Indicates the value for score of score domain "Value".

ASSET_RISK_RATING

I

NUMBER

Indicates the value for score of score domain "Risk".

ASSET_TOTAL_SCORE

I

NUMBER

Indicates the total score for asset.

ASSET_DISCOUNT_RATE

I

NUMBER

Indicates the discount rate for asset.