Share this page

# KCRT_FG_PFM_ASSET_INT

The KCRT_PFM_ASSET_INT interface table is used to store asset information.

Table A-4. KCRT_FG_PFM_ASSET_INT interface table
Column | Usage | Data Type | Description
--- | --- | --- | ---
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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: