KCRT_FG_PFM_PROJECT
This table stores Portfolio Management projects.
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 |
---|---|---|---|
REQUEST_ID |
NOT NULL |
NUMBER |
Request ID of Portfolio Management projects |
REQUEST_TYPE_ID |
NOT NULL |
NUMBER |
Request type ID |
PROJECT_NAME |
NOT NULL |
VARCHAR2(300) |
Project name |
PROJECT_HEALTH_CODE |
NULLABLE |
VARCHAR2(30) |
Project health info code |
PROJECT_HEALTH_MEANING |
NULLABLE |
VARCHAR2(80) |
Project health info meaning |
PRJ_BUSINESS_UNIT_CODE |
NULLABLE |
VARCHAR2(30) |
Business unit code of the project |
PRJ_BUSINESS_UNIT_MEANING |
NULLABLE |
VARCHAR2(80) |
Business unit meaning of the project |
PRJ_BUSINESS_OBJECTIVE_ID |
NULLABLE |
NUMBER |
Business objective ID of the project |
PRJ_BUSINESS_OBJECTIVE_NAME |
NULLABLE |
VARCHAR2(80) |
Business objective name of the project |
PRJ_PROJECT_CLASS_CODE |
NULLABLE |
VARCHAR2(30) |
Project class code of the project |
PRJ_PROJECT_CLASS_MEANING |
NULLABLE |
VARCHAR2(80) |
Project class meaning of the project |
PRJ_ASSET_CLASS_CODE |
NULLABLE |
VARCHAR2(30) |
Asset class code of the project |
PRJ_ASSET_CLASS_MEANING |
NULLABLE |
VARCHAR2(80) |
Asset class meaning of the project |
PRJ_PROJECT_MANAGER_USER_ID |
NULLABLE |
VARCHAR2(4000) |
Project manager for Portfolio Management project |
PRJ_PROJECT_MANAGER_USERNAME |
NULLABLE |
VARCHAR2(4000) |
Project manager username for Portfolio Management project |
PRJ_PROJECT_ID |
NULLABLE |
NUMBER |
Project ID for Portfolio Management project |
PRJ_PROJECT_NAME |
NULLABLE |
VARCHAR2(300) |
Project name for Portfolio Management project |
PRJ_PROJECT_URL |
NULLABLE |
VARCHAR2(250) |
Project URL for Portfolio Management project |
PRJ_STAFF_PROF_ID |
NULLABLE |
NUMBER |
Staffing profile ID of the project |
PRJ_STAFF_PROF_NAME |
NULLABLE |
VARCHAR2(300) |
Staffing profile name of the project |
PRJ_RETURN_ON_INVESTMENT |
NULLABLE |
NUMBER |
ROI of the project |
PRJ_NET_PRESENT_VALUE |
NULLABLE |
NUMBER |
NPV of the project |
PRJ_CUSTOM_FIELD_VALUE |
NULLABLE |
NUMBER |
Financial metric of the project |
PRJ_VALUE_RATING |
NULLABLE |
NUMBER |
Score for score domain "Value" |
PRJ_RISK_RATING |
NULLABLE |
NUMBER |
Score for score domain "Risk" |
PRJ_TOTAL_SCORE |
NULLABLE |
NUMBER |
Total score |
PRJ_DISCOUNT_RATE |
NULLABLE |
NUMBER |
Discount rate of the project |
PRJ_PLAN_START_PERIOD_ID |
NULLABLE |
NUMBER |
Period ID of the planned start date for the project |
PRJ_PLAN_FINISH_PERIOD_ID |
NULLABLE |
NUMBER |
Period ID of the planned finish date for the project |
PRJ_PLAN_START_PERIOD_NAME |
NULLABLE |
VARCHAR2(100) |
Period name of the planned start date for the project |
PRJ_PLAN_FINISH_PERIOD_NAME |
NULLABLE |
VARCHAR2(100) |
Period name of the planned finish date for the project |
PRJ_DEPENDENCIES_CODE |
NULLABLE |
VARCHAR2(500) |
Dependency code for Portfolio Management project |
PRJ_DEPENDENCIES_MEANING |
NULLABLE |
VARCHAR2(2000) |
Dependency meaning for Portfolio Management project |
PRJ_PHASE_CODE |
NULLABLE |
VARCHAR2(40) |
Project phase code for Portfolio Management project |
PRJ_PHASE_MEANING |
NULLABLE |
VARCHAR2(150) |
Project phase meaning for Portfolio Management project |
PRJ_BENEFIT_MANAGER_USER_ID |
NULLABLE |
VARCHAR2(4000) |
Benefit Manager ID for the project |
PRJ_BENEFIT_MANAGER_USERNAME |
NULLABLE |
VARCHAR2(4000) |
Benefit manager name for the project |
PRJ_FINANCIAL_SUMMARY_NAME |
NULLABLE |
VARCHAR2(1500) |
Financial summary name |
PRJ_FINANCIAL_SUMMARY_ID |
NULLABLE |
NUMBER |
Financial summary ID |
PRJ_PORTFOLIO_ID |
NULLABLE |
NUMBER |
Portfolio ID for the project |
PRJ_PORTFOLIO_NAME |
NULLABLE |
VARCHAR2(1500) |
Portfolio name for the project |
PRJ_PROGRAM_ID |
NULLABLE |
VARCHAR2(4000) |
Ids of the programs containing this project |
PRJ_PROGRAM_NAME |
NULLABLE |
VARCHAR2(4000) |
Names of the programs containing this project |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KCRT_FG_PFM_PROJECT_N1 |
NONUNIQUE |
1 |
PRJ_BUSINESS_OBJECTIVE_ID |
KCRT_FG_PFM_PROJECT_U1 |
UNIQUE |
1 |
REQUEST_ID |
KCRT_FG_PFM_PROJECT_U2 |
UNIQUE |
1 |
PRJ_FINANCIAL_SUMMARY_ID |
KCRT_FG_PFM_PROJECT_U3 |
UNIQUE |
1 |
PRJ_STAFF_PROF_ID |
Sequences
This table uses no sequences.