Share this page
RPT_DIM_REQUESTS
This table holds request information derived from PPM tables. All the fields are derived from PPM request tables.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
SOURCE_ENTITY_TYPE |
NULLABLE |
VARCHAR2(20) |
The type of this request. Proposal, Project, Asset or Other |
|
LIFECYCLE_ID |
NULLABLE |
NUMBER |
This is the PFM entity's (proposal, project, or asset) lifecycle Id. This ID is referring to PPM's PFM_LIFECYCLE_PARENT_ENTITY table. |
|
STAFFING_PROFILE_ID |
NULLABLE |
NUMBER |
ID of staffing profile this entity is attached to |
|
SOURCE_ENTITY_ID |
NULLABLE |
NUMBER |
The request ID of this entity |
|
SPAWNED_PROJECT_ID |
NULLABLE |
NUMBER |
ID of the project that was spawned by this request. This ID refers to PPM's PM_PROJECTS table. |
|
SOURCE_ENTITY_NAME |
NULLABLE |
VARCHAR2(300) |
Name of this entity. If proposal, it is proposal name, if project, it is project's name and so on... |
|
SOURCE_ENTITY_HEALTH_MEANING |
NULLABLE |
VARCHAR2(80) |
Source entity's health meaning obtained from lookup table |
|
SOURCE_ENTITY_HEALTH_CODE |
NULLABLE |
VARCHAR2(30) |
Source entity's health code |
|
SOURCE_ENTITY_MANAGER_ID |
NULLABLE |
VARCHAR2(4000) |
User ID of the source entity's manager |
|
SOURCE_BENEFIT_MANAGER_ID |
NULLABLE |
VARCHAR2(4000) |
User ID of the source entity's benefit manager. |
|
SOURCE_ENTITY_FIN_SUMMARY_ID |
NULLABLE |
NUMBER |
ID of financial summary that is attached to this entity |
|
SOURCE_ENTITY_FIN_SUMMARY_NAME |
NULLABLE |
VARCHAR2(1500) |
Name of financial summary that is attached to this entity |
|
ENTITY_PROJECT_CLASS_MEANING |
NULLABLE |
VARCHAR2(80) |
Project's class meaning derived from lookups |
|
ENTITY_PROJECT_CLASS_CODE |
NULLABLE |
VARCHAR2(30) |
Project's class code |
|
ENTITY_ASSET_CLASS_MEANING |
NULLABLE |
VARCHAR2(80) |
Asset's class meaning derived from lookups |
|
ENTITY_ASSET_CLASS_CODE |
NULLABLE |
VARCHAR2(30) |
Asset's class code |
|
BUSINESS_OBJECTIVE_NAME |
NULLABLE |
VARCHAR2(80) |
Business objective name of this entity |
|
BUSINESS_OBJECTIVE_ID |
NULLABLE |
NUMBER |
Business objective ID of this entity |
|
BUSINESS_UNIT |
NULLABLE |
VARCHAR2(80) |
Business unit of this entity derived from lookups |
|
BUSINESS_UNIT_CODE |
NULLABLE |
VARCHAR2(30) |
Business unit code of this entity |
|
ENTITY_REGION |
NULLABLE |
VARCHAR2(100) |
Name of the region this entity belongs to |
|
ENTITY_REGION_ID |
NULLABLE |
NUMBER |
ID of the region this entity belongs to |
|
RETURN_ON_INVESTMENT |
NULLABLE |
NUMBER |
ROI of this request |
|
NET_PRESENT_VALUE |
NULLABLE |
NUMBER |
NPV of this request |
|
CUSTOM_FIELD_VALUE |
NULLABLE |
NUMBER |
Financial metric for this entity |
|
TOTAL_SCORE |
NULLABLE |
NUMBER |
Total score of this entity |
|
VALUE_RATING |
NULLABLE |
NUMBER |
The score for score domain "Value" |
|
RISK_RATING |
NULLABLE |
NUMBER |
The score for score domain "Risk" |
|
DISCOUNT_RATE |
NULLABLE |
NUMBER |
Discount rate for this entity |
|
REQUEST_ID |
NOT NULL |
NUMBER |
Unique identifier for this request |
|
REQUEST_TYPE_ID |
NULLABLE |
NUMBER |
The type of this request |
|
REQUEST_TYPE_NAME |
NULLABLE |
VARCHAR2(80) |
Name of this request type |
|
ENTITY_STATUS |
NULLABLE |
VARCHAR2(80) |
Status of this entity |
|
PRIORITY |
NULLABLE |
VARCHAR2(150) |
Priority of this entity derived from lookups table |
|
DEPARTMENT |
NULLABLE |
VARCHAR2(150) |
Department of this entity derived from lookups table |
|
APPLICATION |
NULLABLE |
VARCHAR2(150) |
Application of this entity derived from lookups table |
|
WORKFLOW_NAME |
NULLABLE |
VARCHAR2(150) |
Name of the workflow associated with this entity |
|
DESCRIPTION |
NULLABLE |
VARCHAR2(3000) |
Description given to this request |
|
ACTIVE_WORKFLOW_STEP_NAME |
NULLABLE |
VARCHAR2(2000) |
Name of the active workflow step |
|
CREATED_BY |
NULLABLE |
VARCHAR2(200) |
Identifier for the user who created the record |
|
CREATION_DATE |
NULLABLE |
DATE |
Date record was created |
|
CONTACT_NAME |
NULLABLE |
VARCHAR2(200) |
The full name of the contact person for this request |
|
CONTACT_PHONE |
NULLABLE |
VARCHAR2(30) |
The phone number for this contact person |
|
CONTACT_EMAIL |
NULLABLE |
VARCHAR2(80) |
The email for this contact person |
|
ASSIGNED_TO |
NULLABLE |
VARCHAR2(200) |
User ID that this request is assigned to |
|
USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
|
VISIBLE_USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
| DIRECT_PORTFOLIO_ID | NULLABLE | NUMBER | ID of the portfolio this request directly belongs to |
| DIRECT_PORTFOLIO_NAME | NULLABLE | VARCHAR2(200) | Name of the portfolio this request directly belongs to |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
RPT_DIM_REQUESTS_N1 |
NONUNIQUE |
1 |
SOURCE_ENTITY_ID |
|
RPT_DIM_REQUESTS_N2 |
NONUNIQUE |
1 |
SOURCE_ENTITY_TYPE |
|
RPT_DIM_REQUEST_PK |
UNIQUE |
1 |
REQUEST_ID |
Sequences
This table uses no sequences.
