Share this page

# DIM_REQUESTS

This table stores all the information of a request.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
DIM_PERSON | ASSIGNED_TO_USER_ID | PK_PERSON_ID
DIM_CONTACTS | CONTACT_ID | PK_ CONTACT_ID

## Column Descriptions

Column Name | Null? | Data Type | Description | SCD2
--- | --- | --- | --- | ---
PK_REQUESTS_ID | Nullable | INT | System-generated identifier | No
MD_BUSINESS_KEY | Nullable | VARCHAR (1000) | Primary key that is mapped to one or more source columns | No
MD_ENTERPRISE_KEY | Nullable | INT | Unique identifier for entity | No
REQUEST_NUMBER | Nullable | VARCHAR (30) | Indicates the sequential request number identifier that the user sees. Value is retrieved from the REQUEST_ID. | No
REQUEST_TYPE_ID | Nullable | INT | Identifier that denotes what type of request this record is | Yes
REQUEST_TYPE_NAME | Nullable | VARCHAR (80) | Indicates the request type name of this request | Yes
REQUEST_SUBTYPE_ID | Nullable | INT | Identifier that denotes what type of sub-request this record is, if provided. | Yes
REQUEST_SUBTYPE_NAME | Nullable | VARCHAR (80) | Indicates the request subtype name of this request | Yes
REQUEST_DESCRIPTION | Nullable | VARCHAR (400) | Short description of the selected request | No
RELEASE_DATE | Nullable | DATE | Date wherein this request was released | No
REQUEST_STATUS_ID | Nullable | INT | Identifier for the current request status | No
REQUEST_STATUS_NAME | Nullable | VARCHAR (80) | Indicates the request status name of this request | No
WORKFLOW_ID | Nullable | INT | Identifier for the workflow associated with this record | No
WORKFLOW_NAME | Nullable | VARCHAR (150) | Indicates the workflow name of this request | No
DEPARTMENT_CODE | Nullable | VARCHAR (30) | Lookup code for `DEPARTMENT` | Yes
DEPARTMENR_NAME | Nullable | VARCHAR (150) | Indicates the department name related to this request | Yes
PRIORITY_CODE | Nullable | VARCHAR (30) | Lookup code for `PRIORITY` | No
PRIORITY_NAME | Nullable | VARCHAR (150) | Indicates the priority name related to this request | No
APPLICATION | Nullable | VARCHAR (30) | Lookup code for `APPLICATION` | Yes
APPLICATION_NAME | Nullable | VARCHAR (150) | Indicates the application name related to this request | Yes
ASSIGNED_TO_USER_ID | Nullable | INT | Identifier for the user wherein this request was assigned to | Yes
ASSIGNED_TO_USER_ BUSINESS_KEY | Nullable | VARCHAR (1000) | Foreign key that is mapped to DIM_PERSON | Yes
ASSIGNED_TO_USER_ ENTERPRISE_KEY | Nullable | INT | Unique identifier for foreign key | Yes
ASSIGNED_TO_USER_ NAME | Nullable | VARCHAR (200) | Indicates the user name of this request assign to | Yes
ASSIGNED_TO_GROUP_ID | Nullable | INT | Identifier for the security group wherein this request was assigned to | Yes
ASSIGNED_TO_GROUP_ NAME | Nullable | VARCHAR (150) | Indicates the group name of this request assign to | Yes
PROJECT_CODE | Nullable | VARCHAR (30) | Indicates the project code related to request. Lookup code for `REQUEST_GROUP` | No
PROJECT_CODE_NAME | Nullable | VARCHAR (150) | Indicates the project code name related to request | No
CONTACT_ID | Nullable | INT | Identifier for the contacts associated with this record | No
CONTACT_BUSINESS_KEY | Nullable | VARCHAR (1000) | Foreign key that is mapped to DIM_CONTACTS | No
CONTACT_ENTERPRISE_ KEY | Nullable | INT | Unique identifier for foreign key | No
CONTACT_NAME | Nullable | VARCHAR (200) | Indicates the contact name related to request | No
STATUS_CODE | Nullable | VARCHAR (30) | Lookup code for `WF_ PARENT_STATUS` | No
STATUS_NAME | Nullable | VARCHAR (150) | Indicates the status name of this request | No
USER_DATA_SET_ CONTEXT_ID | Nullable | INT | Parameter set context identifier for the user data fields | Yes
USER_DATA1-20 | Nullable | VARCHAR (200) | User data segment | No
VISIBLE_USER_DATA1-20 | Nullable | VARCHAR (200) | User data segment | No
PERCENT_COMPLETE | Nullable | NUMERIC | Percentage of completion of this request (100 if the request is closed) | No
MD_BATCH_ID | Nullable | INT | ID of data batch | No
MD_PROCESS_ID | Nullable | INT | ID of ETL process running on a specific task | No
MD_SOURCE_INSTANCE_ ID | Nullable | INT | Content pack ID of source instance | No
MD_CREATEDDATE | Nullable | DATETIME | Date of the record being inserted | No
MD_DELETEDDATE | Nullable | DATETIME | Date of the record being deleted | No
MD_LASTMODDATE | Nullable | DATETIME | Date of the record being updated | No
MD_TRANSLASTIND | Nullable | VARCHAR (1) | Flags whether it is the latest record after updated by SCD2 | No
MD_TRANSENDDATE | Nullable | DATETIME | End date of the record being effective | No
MD_ACTIVESTATUSIND | Nullable | VARCHAR (1) | Flags whether or not the old record is deleted | No
MD_HASH_CODE_SCD1 | Nullable | VARCHAR (40) | (Only for dimension table) Hash code that is generated by SCD1 columns | No
MD_HASH_CODE_SCD2 | Nullable | VARCHAR (40) | (Only for dimension table) Hash code that is generated by SCD2 columns | No

## Projections

This table uses no projections.

## Sequences

Sequence Name | Sequence Type
--- | ---
REQUESTS_ENTERPRISE_XREF_SEQ | MD_ENTERPRISE_KEY
REQUESTS_KEY_LOOKUP_SEQ | PK_ REQUESTS_ID
PERSON_ENTERPRISE_XREF_SEQ | PERSON_ENTERPRISE_KEY
PERSON_KEY_LOOKUP_SEQ | PERSON_ID
CONTACTS_ENTERPRISE_XREF_SEQ | CONTACT_ENTERPRISE_KEY
CONTACTS_KEY_LOOKUP_SEQ | CONTACT_ID

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: