Forum Stats

  • 3,836,963 Users
  • 2,262,207 Discussions
  • 7,900,157 Comments

Discussions

HFM Review Levels in Database

user11963953
user11963953 Member Posts: 10 Blue Ribbon
edited Jan 28, 2021 4:01PM in Financial Consolidation

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

Answers

  • Jeo123
    Jeo123 Member Posts: 515 Gold Badge

    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.

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