Share this page

# KCRT_FG_PFM_PROPOSAL_INT

Table for importing PFM proposals into KCRT_FG_PFM_PROPOSAL.

Table A-6. KCRT_FG_PFM_PROPOSAL_INT interface table
Column | Usage | Data Type | Description
--- | --- | --- | ---
PFM_PROPOSAL_INTERFACE_ID | I | NUMBER | System-generated unique identifier for the proposal.
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 for details.
PROCESS_STATUS | I | NUMBER | Indicates the current disposition of the record. See Process State Information for details.
REQUEST_ID | I | NUMBER | Identifies the request. This is normally left blank and is derived from the KCRT_REQUESTS_S sequence.
REQUEST_TYPE_ID | I | NUMBER | Identifies the request type. This is normally left blank and is derived from REQUEST_TYPE_NAME.
PROPOSAL_NAME | I | VARCHAR2 | Name of the proposal.
PROP_BUSINESS_UNIT_CODE | I | VARCHAR2 | Indicates the business unit code for proposal.
PROP_BUSINESS_UNIT_MEANING | I | VARCHAR2 | Indicates the business unit meaning for proposal.
PROP_BUSINESS_OBJECTIVE_ID | I | NUMBER | Unique identifier for the proposed business objective.
PROP_BUSINESS_OBJECTIVE_NAME | I | VARCHAR2 | Name of the proposed business objective.
PROP_PROJECT_CLASS_CODE | I | VARCHAR2 | Indicates the project class code for proposal.
PROP_PROJECT_CLASS_MEANING | I | VARCHAR2 | Indicates the project class meaning for proposal.
PROP_ASSET_CLASS_CODE | I | VARCHAR2 | Asset class code for proposal.
PROP_ASSET_CLASS_MEANING | I | VARCHAR2 | Asset class meaning for proposal.
PROP_PROJECT_MANAGER_USER_ID | I | NUMBER | Identifies the USER_ID (from KNTA_USERS) for the project manager.
PROP_PROJECT_MANAGER_USERNAME | I | VARCHAR2 | Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction.
PROP_PROJECT_TEMPLATE_ID | I | NUMBER | Unique identifier for the proposed project template.
PROP_PROJECT_TEMPLATE_NAME | I | VARCHAR2 | Name of the proposed project template.
PROP_STAFF_PROF_ID | I | NUMBER | Unique identifier of the staff profile associated with the proposal.
PROP_STAFF_PROF_NAME | I | VARCHAR2 | Name of the staff profile associated with the proposal.
PROP_RETURN_ON_INVESTMENT | I | NUMBER | Indicates the ROI for a proposal.
PROP_NET_PRESENT_VALUE | I | NUMBER | Indicates the NPV for a proposal.
PROP_CUSTOM_FIELD_VALUE | I | NUMBER | Indicates the financial metric for a proposal.
PROP_VALUE_RATING | I | NUMBER | Indicates the score for score domain of "Value".
PROP_RISK_RATING | I | NUMBER | indicates the score for score domain of "Risk".
PROP_TOTAL_SCORE | I | NUMBER | Indicates the total score for a proposal.
PROP_DISCOUNT_RATE | I | NUMBER | Indicates the discount rate for a proposal.
PROP_PLAN_START_PERIOD_ID | I | NUMBER | The period ID of the Planned Start Date for the proposal.
PROP_PLAN_FINISH_PERIOD_ID | I | NUMBER | The period ID of the Planned Finish Date for the proposal.
PROP_PLAN_START_PERIOD_NAME | I | NUMBER | The period name of the Planned Start Date for the proposal.
PROP_PLAN_START_PERIOD_NAME | I | VARCHAR2 | The period name of the Planned Start Date for the proposal.
PROP_PLAN_FINISH_PERIOD_NAME | I | VARCHAR2 | The period name of the Planned Finish Date for the proposal
PROP_PROJECT_PLAN_ID | I | NUMBER | Unique identifier for the proposed project plan.
PROP_PROJECT_PLAN_NAME | I | VARCHAR2 | Name of the proposed project plan.

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: