KCRT_FG_PFM_PROJECT_INT

PFM_PROJECT_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 for details.

PROCESS_STATUS

I

NUMBER

Indicates the current disposition of the record.

See LDAP Authentication 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.

PROJECT_NAME

I

VARCHAR2

Indicates the name of the project.

PROJECT_HEALTH_CODE

I

VARCHAR2

Identifies the project health information code. Derived from PRJ_CALCULATED_HEALTH_CODE and PRJ_OVERRIDDEN_HEALTH_CODE.

PROJECT_HEALTH_MEANING

I

VARCHAR2

Identifies the project health information meaning. Derived from PRJ_CALCULATED_HEALTH_MEANING and PRJ_OVERRIDDEN_HEALTH_CODE.

PRJ_BUSINESS_UNIT_CODE

I

VARCHAR2

Indicates the business unit code for project.

PRJ_BUSINESS_UNIT_MEANING

I

VARCHAR2

Indicates the business unit meaning for project.

PRJ_BUSINESS_OBJECTIVE_ID

I

NUMBER

Indicates the business objective ID for project.

PRJ_BUSINESS_OBJECTIVE_NAME

I

VARCHAR2

Indicates the business objective name for project.

PRJ_PROJECT_CLASS_CODE

I

VARCHAR2

Indicates the project class code for project.

PRJ_PROJECT_CLASS_MEANING

I

VARCHAR2

Indicates the project class meaning for project.

PRJ_ASSET_CLASS_CODE

I

VARCHAR2

Asset class code for project.

PRJ_ASSET_CLASS_MEANING

I

VARCHAR2

Asset class meaning for project.

PRJ_PROJECT_MANAGER_USER_ID

I

NUMBER

Code that uniquely identifies the user that is the project manager.

PRJ_PROJECT_MANAGER_USERNAME

I

VARCHAR2

Username of the project manager.

PRJ_PROJECT_PLAN_ID

I

NUMBER

Unique identifier for the project plan.

PRJ_PROJECT_PLAN_NAME

I

VARCHAR2

Name of the project plan.

PRJ_PROJECT_PLAN_URL

I

VARCHAR2

Web address or URL associated with the project plan.

PRJ_STAFF_PROF_ID

I

NUMBER

Unique identifier of the staff profile associated with the PFM project.

PRJ_STAFF_PROF_NAME

I

VARCHAR2

Name of the staff profile associated with the PFM project.

PRJ_RETURN_ON_INVESTMENT

I

NUMBER

Calculated value indicating the return on investment (ROI) of the PFM project.

PRJ_NET_PRESENT_VALUE

I

NUMBER

NPV for project.

PRJ_CUSTOM_FIELD_VALUE

I

NUMBER

Financial metric for project.

PRJ_VALUE_RATING

I

NUMBER

The score for score domain "Value".

PRJ_RISK_RATING

I

NUMBER

This score for score domain "Risk".

PRJ_TOTAL_SCORE

I

NUMBER

Total score.

PRJ_DISCOUNT_RATE

I

NUMBER

Discount rate for project.