When you save a Microsoft Project file into Clarity, after the various tables/fields have been updated through the interface, the actual
.mpp file is saved into the table PRDOCUMENT table.
The following queries can be used to identify which projects have been updated in Microsoft Project and that have the .MPP file stored in the database.
(SELECT * FROM PRDOCUMENT WHERE PRRECORDID = <project_numeric_id>) to check a specific project.
(SELECT * FROM PRDOCUMENT) to get a full list of projects that have an MPP file stored in the database.
Where the <project_numberic_id> is the internal 5XXXXXX number designated to the specific project. This can be gotten from:
select id from inv_investments where name='<project name>' and object_type = 'PROJECT'
Keywords: ClarityKB, Microsoft Project, MSP, Prdocument, MPP