Project ID in the LSTProjectCenter differs from that in the EPG_RPT_CapacityPlanner

Overview

You may wish to match projects from the LSTProjectCenter and the EPG_RPT_CapacityPlanner by joining the two tables using the Project ID field. You may find that the Project IDs assigned to projects under the "ID" column in the LSTProjectCenter are different from the Project IDs assigned to projects under the "ProjectID" column in the EPG_RPT_CapacityPlanner. This article clarifies this difference and provides information on how you can match the two tables. 

Information

Please note that this behavior is intended and is not an issue. The EPG_RPT_CapacityPlanner ID is meant to be different from the LSTProjectCenter. If you wish to join the two tables, you can use a SQL query using EPG_RPT_Projects as the mapping, similar to the one below:

SELECT t0.[Project Name], t1.[Project Name],t2.Title
FROM [EPG_RPT_CapacityPlanner] t0
INNER JOIN EPG_RPT_Projects t1
ON t0.projectid = t1.projectid
INNER JOIN LSTProjectCenter t2
ON CAST(
RIGHT(t1.PROJECT_EXT_UID, CHARINDEX('.', REVERSE(t1.PROJECT_EXT_UID)) -1) AS int) = t2.ID

Back to top