Which CPMS table holds data of Subjective Assessment & Subjective Assessment Explanation (Comments)?

[Former Member]

Hi SSM experts,

We are leveraging the Subjective Assessment & Subject Assessment Explanation features in Strategy Management for reporting purpose.

Does anyone know which relational database table holding the data for Subjective Assessment & Explanation?

I guess it must be staying in one of the CPMS tables, however I cannot locate the right table.

Regards,

Ken

[Former Member · Accepted solution]

Hi Ken, the subjective assessment status and text resides in the CPMS_NODE_* tables

I have attached the tables for reference.

[Former Member · Accepted solution]

Thanks Les for your input.

The values of Subjective Assessment and Subjective Assessment Explanation are stored in

CPMS_NODE_Vals tables.

However, you will need to access CPMS_STRAT_HIER table to pull the node details instead of going from CPMS_NODE_LIB table.

A snapshot of schema is attached.