Somebody know how are related projects in "pm_project" table and in "sn_align_core_project" table?

[jordimsant]

I have noticed that, when I use SPM pro, I can go from the project in the Strategic Planning Workspace (and therefore sn_align_core_project table) to its associated project in Project Workspace (and therefore pm_project table). However, I have not been capable to find which field is relating both tables such that when I click in SPW takes me always to the same project in PW. Does anybody know which is this relation?

[psyherin]

Hi @jordimsant ,

The mapping is done via integrations. Navigate to Strategic Planning > Integrations and look at the related list "Table maps".

Regards

[Richard Kiss]

Hi @jordimsant ,

The relation is stored in the field Execution item (execution_entity_item) on the sn_align_core_project table (actually it is on the sn_align_core_planning_item table). There is no reference to the execution item to the alignment item.