Which Table in HCM Cloud has User Entity backgroud SQL

User_FE73T

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

Pranav_HCM

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