KCRT_FG_PFM_PROPOSAL
This table stores PFM proposals.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
PM_PROJECTS |
PROJECT_ID |
PROP_PROJECT_ID |
KNTA_USERS |
USER_ID |
PROP_PROJECT_MANAGER_USER_ID |
RSC_STAFFING_PROFILES |
STAFFING_PROFILE_ID |
PROP_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 for proposal |
REQUEST_TYPE_ID |
NOT NULL |
NUMBER |
Request Type ID |
PROPOSAL_NAME |
NOT NULL |
VARCHAR2(300) |
Proposal name |
PROP_BUSINESS_UNIT_CODE |
NULLABLE |
VARCHAR2(30) |
Business unit code for proposal |
PROP_BUSINESS_UNIT_MEANING |
NULLABLE |
VARCHAR2(80) |
Business unit meaning for proposal |
PROP_BUSINESS_OBJECTIVE_ID |
NULLABLE |
NUMBER |
Business objective ID for proposal |
PROP_BUSINESS_OBJECTIVE_NAME |
NULLABLE |
VARCHAR2(80) |
Business objective name for proposal |
PROP_PROJECT_CLASS_CODE |
NULLABLE |
VARCHAR2(30) |
Project class code for proposal |
PROP_PROJECT_CLASS_MEANING |
NULLABLE |
VARCHAR2(80) |
Project class meaning for proposal |
PROP_ASSET_CLASS_CODE |
NULLABLE |
VARCHAR2(30) |
Asset class code for proposal |
PROP_ASSET_CLASS_MEANING |
NULLABLE |
VARCHAR2(80) |
Asset class meaning for proposal |
PROP_PROJECT_MANAGER_USER_ID |
NULLABLE |
VARCHAR2(4000) |
Project manager for proposal |
PROP_PROJECT_MANAGER_USERNAME |
NULLABLE |
VARCHAR2(4000) |
Project manager username for proposal |
PROP_STAFF_PROF_ID |
NULLABLE |
NUMBER |
Staffing profile ID for proposal |
PROP_STAFF_PROF_NAME |
NULLABLE |
VARCHAR2(300) |
Staffing profile name for proposal |
PROP_RETURN_ON_INVESTMENT |
NULLABLE |
NUMBER |
ROI for proposal |
PROP_NET_PRESENT_VALUE |
NULLABLE |
NUMBER |
NPV for proposal |
PROP_CUSTOM_FIELD_VALUE |
NULLABLE |
NUMBER |
Financial metric for proposal |
PROP_VALUE_RATING |
NULLABLE |
NUMBER |
Score for score domain of "Value". |
PROP_RISK_RATING |
NULLABLE |
NUMBER |
Score for score domain of "Risk". |
PROP_TOTAL_SCORE |
NULLABLE |
NUMBER |
Total score for proposal |
PROP_DISCOUNT_RATE |
NULLABLE |
NUMBER |
Discount rate for proposal |
PROP_PLAN_START_PERIOD_ID |
NULLABLE |
NUMBER |
Period ID of the planned start date for the proposal |
PROP_PLAN_FINISH_PERIOD_ID |
NULLABLE |
NUMBER |
Period ID of the planned finish date for the proposal |
PROP_PLAN_START_PERIOD_NAME |
NULLABLE |
VARCHAR2(100) |
Period name of the planned start date for the proposal |
PROP_PLAN_FINISH_PERIOD_NAME |
NULLABLE |
VARCHAR2(100) |
Period name of the planned finish date for the proposal |
PROP_PROJECT_ID |
NULLABLE |
NUMBER |
Project ID for proposal |
PROP_PROJECT_NAME |
NULLABLE |
VARCHAR2(300) |
Project name for proposal |
PROP_DEPENDENCIES_CODE |
NULLABLE |
VARCHAR2(500) |
Dependency code for proposal |
PROP_DEPENDENCIES_MEANING |
NULLABLE |
VARCHAR2(2000) |
Dependency meaning for proposal |
PROP_PROJECT_TYPE_ID |
NULLABLE |
NUMBER |
Project type ID for proposal |
PROP_PROJECT_TYPE_NAME |
NULLABLE |
VARCHAR2(1500) |
Project type name for proposal |
PROP_REGION_ID |
NULLABLE |
NUMBER |
Region ID for proposal |
PROP_REGION_NAME |
NULLABLE |
VARCHAR2(1500) |
Region name for proposal |
PROP_BENEFIT_MANAGER_USER_ID |
NULLABLE |
VARCHAR2(4000) |
Name of the proposal's benefit manager |
PROP_BENEFIT_MANAGER_USERNAME |
NULLABLE |
VARCHAR2(4000) |
ID of the proposal's benefit manager |
PROP_FINANCIAL_SUMMARY_NAME |
NULLABLE |
VARCHAR2(1500) |
Name of the proposal's financial summary |
PROP_FINANCIAL_SUMMARY_ID |
NULLABLE |
NUMBER |
ID of the proposal's financial summary |
PROP_APPROVED_SNAPSHOT_ID |
NULLABLE |
NUMBER |
ID of the financial summary snapshot taken at the time when the proposal is approved |
PROP_APPROVED_SNAPSHOT_NAME |
NULLABLE |
VARCHAR2(1500) |
Name of the financial summary snapshot taken at the time when the proposal is approved |
PROP_PORTFOLIO_ID |
NULLABLE |
NUMBER |
ID of the portfolio to which the proposal is linked |
PROP_PORTFOLIO_NAME |
NULLABLE |
VARCHAR2(1500) |
Name of the portfolio to which the proposal is linked. |
PROP_PROGRAM_ID |
NULLABLE |
VARCHAR2(4000) |
IDs of the program containing this proposal |
PROP_PROGRAM_NAME |
NULLABLE |
VARCHAR2(4000) |
Names of the programs containing this proposal |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KCRT_FG_PFM_PROPOSAL_N1 |
NONUNIQUE |
1 |
PROP_BUSINESS_OBJECTIVE_ID |
KCRT_FG_PFM_PROPOSAL_U3 |
NONUNIQUE |
1 |
PROP_STAFF_PROF_ID |
Sequences
This table uses no sequences.