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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: