Which FAW table stores indirect Reportees data?

Question

I am looking for a table/column in FAW that stores the data for indirect reportees of a manager.

dwc_manager_dn_dh_tbl table stores the data for direct reportees only (i.e., where manager type is LINE_MANAGER)

I want to see where the other manager type, for instance, Global Directory Manager of a person is being fetched in FAW. (The below extract is from OTBI where the other manager types are also being fetched along with Line Manager).

Please help if anybody knows.

Raghavendra Raghunath-Oracle · Answer

Hi @Dinky Dudeja import this dv into your instance. Modify the viz filter to point to the manager for whom you need to see the directs and indirects. I have 3 flavours of the requirements that you have asked. You can choose the relevant one

Raghu

Manager Hierarchy.dva

Dinky Dudeja · Answer

Hi Subha,

Thanks for the update.

I looked out for 'Manager Type' in the subject areas (mainly Workforce Core) in FAW but could not find any relevant field and when I fetched the manager data (i.e., Manager Name, ID etc.) in FAW and compared it with the OTBI data, I noticed that only the Line Manager (or Reports_To manager) of an employee is getting picked up and there is no data for other Manager types in FAW. That's the reason I was looking for a Manager Type field in the backend tables to confirm my observation.

Some of the tables relevant to manager information in the data lineage sheet does have a Manager_Type column but the value is only LINE_MANAGER.

Please let me know if you know a way of how I can get this data in FAW.

Thank you,

Dinky

Subha_Tripathy-Oracle · Answer

Hi @Dinky Dudeja

Thank you for visiting and posting in Fusion Analytics Warehouse(FAW) Product Community Page.

Please refer the data lineage guide spreadsheet for HCM which list all HCM tables and corresponding FAW ones:

https://docs.oracle.com/en/cloud/saas/analytics/23r4/fahia/chapter-data-lineage.html#GUID-69B6BE1A-183B-4F76-B211-7A9295AA1D02

Or else  you can create DV report and use the physical SQL from execution log to find corresponding tables.

Thanks

Subha