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

Ivan Parra

select ue.base_user_entity_name, route.text from FF_USER_ENTITIES_B ue, FF_ROUTES_B route

where ue.base_user_entity_name = 'PAY_EXTRACT_RUN_RESULT_VALUES_UE'

and route.route_id = ue.route_id