Forum Stats

  • 3,767,936 Users
  • 2,252,732 Discussions
  • 7,874,385 Comments

Discussions

Which Table in HCM Cloud has User Entity backgroud SQL

User_FE73T
User_FE73T Member Posts: 1 Red Ribbon

Which Table in HCM Cloud has background SQL for User Entities .

Tagged:

Answers

  • Pranav_HCM
    Pranav_HCM Member Posts: 7 Green Ribbon

    Hello,


    Commonly used table for User entity details are :

    ff_dbi_groups_vl dbg

    ,ff_dbi_usages dbu

    ,ff_database_items fdi

    ,ff_user_entities ue

    ,ff_routes rt


    The joins between the table are as :

    dbg.dbi_group_id = dbu.dbi_group_id

    and dbu.dbi_id = fdi.database_item_id

    and fdi.user_entity_id = ue.user_entity_id

    and ue.route_id = rt.route_id