Share this page

# PM_MSP_LINK_REQUESTS

This table stores the ID of the project for each user that clicked the "Open Work Plan in Microsoft Project" button on the work plan page. There is at most one record per user, and that record will be updated every time the user clicks the button on the work plan page.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
PM_PROJECTS | PROJECT_ID | PROJECT_ID
KNTA_USERS | USER_ID | USER_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
MSP_LINK_REQUEST_ID | NOT NULL | NUMBER | System-generated identifier
USER_ID | NOT NULL | NUMBER | ID of Identifier for the user who clicked the "Open Work Plan in Microsoft Project"
PROJECT_ID | NOT NULL | NUMBER | ID of the project that the user was looking at when clicking the "Open Work Plan in Microsoft Project"
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
VERSION | NOT NULL | NUMBER | System-generated version

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FK_PM_MLR_PROJECT_I | NONUNIQUE | 1 | PROJECT_ID
FK_PM_MLR_USER_I | NONUNIQUE | 1 | USER_ID
SYS_C005201890 | UNIQUE | 1 | MSP_LINK_REQUEST_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
PM_MSP_LINK_REQUESTS_S | MSP_LINK_REQUEST_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: