HFM Review Levels in Database

user11963953

Hallo everyone

where in the DB (which table(s)) are the review/Submission levels stores (i need to know on what evel is an entity for Year,Period, Scenario)

Thank you in advance

Jeo123

It's generally not recommended to go through the database level to get this type of information.

The current status is in the <Appname>_PFLOW_<SCENKEY>_<YEAR>, e.g. COMMA_PFLOW_1_2021. The process flow history is stored in the PFLOWH equivalent table.

Entities will all be referenced by their ID number, not their membername. You'll also need to convert the Submission Phase from a number to the more familiar text version.

So it's all there, but it's not really user friendly.

User_3U6DA

Prior to 11.1.2.4 it was in just one table called <AppName> PFLOW and it could grow quite large.