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