Share this page
KCRT_FG_PFM_PROJECT_INT
This table is used for importing PFM projects into the KCRT_FG_PFM_PROJECT table.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KPMO_BUSINESS_OBJECTIVES_NLS |
BUSINESS_OBJECTIVE_ID |
PRJ_BUSINESS_OBJECTIVE_ID |
|
PPM_FISCAL_PERIODS_NLS |
FISCAL_PERIOD_ID |
PRJ_PLAN_FINISH_PERIOD_ID |
|
PPM_FISCAL_PERIODS_NLS |
FISCAL_PERIOD_ID |
PRJ_PLAN_START_PERIOD_ID |
|
PM_PROJECTS |
PROJECT_ID |
PRJ_PROJECT_ID |
|
KNTA_USERS |
USER_ID |
PRJ_PROJECT_MANAGER_USER_ID |
|
RSC_STAFFING_PROFILES |
STAFFING_PROFILE_ID |
PRJ_STAFF_PROF_ID |
|
KCRT_REQUESTS |
REQUEST_ID |
REQUEST_ID |
|
KCRT_REQUEST_TYPES_NLS |
REQUEST_TYPE_ID |
REQUEST_TYPE_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
PFM_PROJECT_INTERFACE_ID |
NULLABLE |
NUMBER |
System-generated identifier |
|
GROUP_ID |
NOT NULL |
NUMBER |
DB Transaction group ID. |
|
TRANSACTION_ID |
NOT NULL |
NUMBER |
Transaction ID |
|
PARENT_TRANSACTION_ID |
NOT NULL |
NUMBER |
Parent transaction ID. This is usually request transaction ID. |
|
PROCESS_PHASE |
NULLABLE |
NUMBER |
Processing phase |
|
PROCESS_STATUS |
NULLABLE |
NUMBER |
Processing status. |
|
REQUEST_ID |
NULLABLE |
NUMBER |
Request ID for PFM Project |
|
REQUEST_TYPE_ID |
NULLABLE |
NUMBER |
Request Type ID |
|
PROJECT_NAME |
NULLABLE |
VARCHAR2(300) |
Project name |
|
PROJECT_HEALTH_CODE |
NULLABLE |
VARCHAR2(30) |
Project health information code, derived from PRJ_CALCULATED_HEALTH_CODE and PRJ_OVERRIDDEN_HEALTH_CODE. |
|
PROJECT_HEALTH_MEANING |
NULLABLE |
VARCHAR2(80) |
Project health information meaning, derived from PRJ_CALCULATED_HEALTH_MEANING and PRJ_OVERRIDDEN_HEALTH_MEANING. |
|
PRJ_BUSINESS_UNIT_CODE |
NULLABLE |
VARCHAR2(30) |
Business unit code for project |
|
PRJ_BUSINESS_UNIT_MEANING |
NULLABLE |
VARCHAR2(80) |
Business unit meaning for project |
|
PRJ_BUSINESS_OBJECTIVE_ID |
NULLABLE |
NUMBER |
Business objective ID for project |
|
PRJ_BUSINESS_OBJECTIVE_NAME |
NULLABLE |
VARCHAR2(80) |
Business objective name for project. |
|
PRJ_PROJECT_CLASS_CODE |
NULLABLE |
VARCHAR2(30) |
Project class code for project |
|
PRJ_PROJECT_CLASS_MEANING |
NULLABLE |
VARCHAR2(80) |
Project class meaning for project |
|
PRJ_ASSET_CLASS_CODE |
NULLABLE |
VARCHAR2(30) |
Asset class code for project |
|
PRJ_ASSET_CLASS_MEANING |
NULLABLE |
VARCHAR2(80) |
Asset class meaning for project |
|
PRJ_PROJECT_MANAGER_USER_ID |
NULLABLE |
VARCHAR2(4000) |
Project manager for PFM project |
|
PRJ_PROJECT_MANAGER_USERNAME |
NULLABLE |
VARCHAR2(4000) |
Project manager username for PFM project |
|
PRJ_PROJECT_ID |
NULLABLE |
NUMBER |
Project ID for PFM project |
|
PRJ_PROJECT_NAME |
NULLABLE |
VARCHAR2(300) |
Project name for PFM project |
|
PRJ_PROJECT_URL |
NULLABLE |
VARCHAR2(250) |
Project URL for PFM project |
|
PRJ_STAFF_PROF_ID |
NULLABLE |
NUMBER |
Staffing profile ID for project |
|
PRJ_STAFF_PROF_NAME |
NULLABLE |
VARCHAR2(100) |
Staffing profile name for project |
|
PRJ_RETURN_ON_INVESTMENT |
NULLABLE |
NUMBER |
ROI for project |
|
PRJ_NET_PRESENT_VALUE |
NULLABLE |
NUMBER |
NPV for project |
|
PRJ_CUSTOM_FIELD_VALUE |
NULLABLE |
NUMBER |
Financial metric for project |
|
PRJ_VALUE_RATING |
NULLABLE |
NUMBER |
The score for score domain "Value" |
|
PRJ_RISK_RATING |
NULLABLE |
NUMBER |
This score for score domain "Risk" |
|
PRJ_TOTAL_SCORE |
NULLABLE |
NUMBER |
Total score |
|
PRJ_DISCOUNT_RATE |
NULLABLE |
NUMBER |
Discount rate for project |
|
PRJ_PLAN_START_PERIOD_ID |
NULLABLE |
NUMBER |
The period id of the Planned Start Date for the project |
|
PRJ_PLAN_FINISH_PERIOD_ID |
NULLABLE |
NUMBER |
The period id of the Planned Finish Date for the project |
|
PRJ_PLAN_START_PERIOD_NAME |
NULLABLE |
VARCHAR2(100) |
The period name of the Planned Start Date for the project |
|
PRJ_PLAN_FINISH_PERIOD_NAME |
NULLABLE |
VARCHAR2(100) |
The period name of the Planned Finish Date for the project |
|
PRJ_PHASE_CODE |
NULLABLE |
VARCHAR2(40) |
Project phase code for PFM project |
|
PRJ_PHASE_MEANING |
NULLABLE |
VARCHAR2(150) |
Project phase meaning for PFM project |
|
PRJ_BENEFIT_MANAGER_USER_ID |
NULLABLE |
VARCHAR2(4000) |
Benefit manger ID |
|
PRJ_BENEFIT_MANAGER_USERNAME |
NULLABLE |
VARCHAR2(4000) |
Benefit manager name |
|
PRJ_DEPENDENCIES_CODE |
NULLABLE |
VARCHAR2(500) |
|
|
PRJ_DEPENDENCIES_MEANING |
NULLABLE |
VARCHAR2(2000) |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
KCRT_FG_PFM_PROJECT_INT_N1 |
NONUNIQUE |
1 |
GROUP_ID |
|
KCRT_FG_PFM_PROJECT_INT_N1 |
NONUNIQUE |
2 |
TRANSACTION_ID |
|
KCRT_FG_PFM_PROJECT_INT_N2 |
NONUNIQUE |
1 |
REQUEST_ID |
Sequences
This table does not use any Sequences.
