KCRT_FG_PFM_PROPOSAL_INT

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.